The Update Costs inquiry is used to review Item and/or Lot costs. From here users can updated costs and drill down to cost history.

This inquiry also contains columns for each Attribute that is set up for the 'Items' attribute type and the 'Production Batches' attribute type. Additionally, this inquiry also contains columns for each Lot Certification with a certification 'Type' of "Item & Site". Item attributes, Production Batch attributes and Lot Certifications are not automatically included in the default view. Because these attributes and lot certifications are user defined, they are not included in the help documentation.

Software Version: 2022.06.16 and newer

Table of Contents

type	flat

Page Header

Search

...

The Update Costs inquiry is used to review Item and/or Lot costs. From here users can updated costs and drill down to cost history.

This inquiry also contains columns for each Attribute that is set up for the 'Items' attribute type, 'Production Batches' attribute type, and the 'Warehouse Lots' attribute type. Additionally, this inquiry also contains columns for each Lot Certification with a certification 'Type' of "Item & Site". Attributes and Lot Certifications are not automatically included in the default view. Because these attributes and lot certifications are user defined, they are not included in the help documentation.

Software Version: 2024.12.16 and newer

Table of Contents

type	flat

Page Header

Search

Search Options

Description

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

GL Period Activity

Used to limit the list of Lots that are returned in the inquiry, to only those that had either a beginning balance or activity within the GL Period specified.

If entered, this must be the format of [GL Period]-[GL Year] (e.g., 05-2022).

Include

Provided a way to limit the list of Lots that are returned. The lookup contains the following values:

Lots with any balance - selected by default
Lots with Available Balance
Lot Status - Closed
Costing Status - Open
Costing Status - Closed

Item

Insert excerpt

	Inq - Item
	Inq - Item
nopanel	true

This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.

Insert excerpt

	Def - Item ID
	Def - Item ID
nopanel	true

The lookup contains a list of all Items in the Items master file.

Lot Owner

Insert excerpt

	Inq - Lot Owner
	Inq - Lot Owner
nopanel	true

This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.

Insert excerpt

	Def - Owner
	Def - Owner
nopanel	true

The lookup contains a list of all Lot Owners.

Saved Searches

Insert excerpt

	Search Options for Framework 3.0 - Global
	Search Options for Framework 3.0 - Global
nopanel	true

Search

Insert excerpt

	Search - Search Options
	Search - Search Options
nopanel	true

Attr: [Attribute Value]
Item: [Item ID] or [Item Description]
Owner: [Lot Owner]
Batch: [Production Batch]
Site: [Site ID] or [Site Name]
WLot: [Warehouse Lot]

Site

Insert excerpt

	Inq - Site
	Inq - Site
nopanel	true

This is a multi-select lookup that defaults to blank (All)

and is

and is not required. Selecting nothing assumes you

want all records returned.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

The lookup contains a list of all active Sites.

Page Detail

Def - Item ID

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

Def - Item ID

Lot Owner

Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

The lookup contains a list of all Items in the Items master file.

Inq - Lot Owner

Favorites

Insert excerpt

Inq - Lot Owner

Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.Def - Owner

Group By Show/Hide

Insert excerpt

Def - Owner

Saved Searches

Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

The lookup contains a list of all Lot Owners.

Help

Insert excerpt

Search Options for Framework

	Help - Global 3.0
	Help - Global

Search Options for Framework

3.0

- Global


nopanel	true

SearchSearch - Search Options

Mass Update

Insert excerpt

Search - Search Options

Toolbar IconsDescriptionColumn Filter Show/Hide Insert excerptColumn Filter Show/Hide - GlobalColumn Filter Show/Hide - GlobalnopaneltrueExcel Insert excerptExcel - LV 3.0Excel - LV 3.0nopaneltrueFavorites Insert excerptFavorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGroup By Show/Hide Insert excerptGroup By Show/Hide - GlobalGroup By Show/Hide - GlobalnopaneltrueHelp Insert excerptHelp - Global 3.0Help

Mass Update - Global 3.0
	Mass Update - Global 3.0
nopanel	true

Attr: [Attribute Value]
Item: [Item ID] or [Item Description]
Owner: [Lot Owner]
Batch: [Production Batch]
Site: [Site ID] or [Site Name]
WLot: [Warehouse Lot]

Site Insert excerptInq - SiteInq - Sitenopaneltrue This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.
Insert excerptDef - SiteDef - Sitenopaneltrue

The lookup contains a list of all active Sites.

Page Detail

Lot Properties
- Costing Status
Set Base Costs
- Update Method:
- Actual Cost:
- Market Cost:
- Reason Code:
Add Cost Layers
- Effective Date:
- Actual Cost:
- Market Cost:
- Reason Code:
Update Costs from Other Costs
- Effective Date:
- Source Cost:
- Destination Cost:
- Cost Update Method:
- Amount:
Post Costs to GL
- Post Costs Through GL Period:
- Post Costs to GL:

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

IQ: Cost History: opens the cost history for the selected record.
IQ: Item History: opens the Item History for the selected record.
IQ: Lot History: opens the Lot History for the selected record.
LV: Warehouse Lot
RV: Production Batch

——————————————

Update Costs from BOM: opens the Update Costs from BOM page

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Mass Update

Saved Layouts

Insert excerpt

Mass Update - Global

	Column Layouts for Framework 3.0

Mass Update

- Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Add Cost Layers
- Effective Date:
- Actual Cost:
- Market Cost:
- Standard Cost:
- Reason Code:
Set Base Costs
- Update Method:
- Actual Cost:
- Market Cost:
- Standard Cost:
- Reason Code:
Update Costs from Other Costs
- Effective Date:
- Source Cost:
- Destination Cost:
- Cost Update Method:
- Amount:
Post Costs to GL
- Post Costs Through Date:
- Post Costs to GL:
- Update PO Receipts Costs:

More Actions Insert excerptMore Actions - Global 3.0More Actions - Global 3.0nopaneltrue

IQ: Cost History: opens the cost history for the selected record.
IQ: Lot History: opens the Lot History for the selected record.

——————————————

Update Costs from BOM: opens the Update Costs from BOM page

Quick Column Filter Insert excerptQuick Column FilterQuick Column FilternopaneltrueRefresh Insert excerptRefresh - Global 3.0Refresh - Global 3.0nopaneltrueSaved Layouts Insert excerptColumn Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - GlobalnopaneltrueSearch Options Insert excerptSearch Options - Inquiry Grid 3.0Search Options - Inquiry Grid 3.0nopaneltrueFieldsDescriptionCheckbox Insert excerptCheckboxCheckboxnopaneltrueActual Cost - Base Insert excerptDef - Cost - Actual BaseDef - Cost - Actual Basenopaneltrue This is a calculated field that can only be edited by adding/editing an 'Actual Base Cost'.Actual Cost - Layers Insert excerptDef - Cost - Actual LayersDef - Cost - Actual Layersnopaneltrue This is a calculated field that can only be edited by adding/editing an 'Actual Cost Layer'.Actual Cost Rate Insert excerptDef - Cost Rate - ActualDef - Cost Rate - Actualnopaneltrue This is a calculated field that can only be edited by adding/editing an 'Actula Cost Layer' or adding/updating an 'Actual Base Cost'.

Database Field: ERPx_IMLotCostHistory.Cost

Base SourceIdentifies whether the Base cost was assigned manually, from a transaction, or from a Bill of Material.Batch Comment Insert excerptBatch CommentBatch Commentnopaneltrue This is not required and is always editable from the 'Batch Comment' field on the Properties tab of the Production Batch record view.

Database Field: ERPx_IMProductionLot.LotComment

Batch Date Insert excerptBatch DateBatch Datenopaneltrue This can be edited from the 'Batch Date' field on the Properties tab of the Production Batch Record View.

Database Field: ERPx_IMProductionLot.DateProduced

Batch Site ID Insert excerptBatch SiteBatch Sitenopaneltrue This is required and is always editable from the 'Batch Site ID' field on the Properties tab of the Production Batch Record View.

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK

BOM ID

Displays the BOM ID of the Bill of Material record. Clicking on the link opens the corresponding Bill of Materials Record View. This field is only populated if the lot costs have been retrieved from a BOM record. This is not editable.

Database Fields: ERPx_MPBOM.BOMID, ERPx_IMProductionLot.BaseCostBOMSK

Born on Date

Identifies the date that a new Lot record was born. This is not used for product aging but just a way to know when the Lot was created. For example, if a Transfer transaction was physically received on 3/24, and it resulted in one or more new Inventory Lot s, those new Lot's 'Born on Date' would be 3/21 even if they had different Production 'Batch Dates'.

Cost Group Description Insert excerptCost Group IDCost Group IDnopaneltrue This is not required and can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View. Insert excerptDef - Cost GroupDef - Cost Groupnopaneltrue

Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK

Cost UOM Insert excerptUOM - CostUOM - Costnopaneltrue This is required for Costing and can be edited from the 'Cost UOM' property on the 'Advanced Properties' tab of the Item Record View.
Insert excerptDef - UOMDef - UOMnopaneltrue

Database Fields: ERPx_IMItem.CostUOMSK

Costing MethodIdentifies how the cost of the item is determined for posting to the General Ledger. valued. This is a required and can be edited from the 'Costing Method' property on the 'Advanced Properties

Search Options

Insert excerpt

	Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Actual Cost - Base

Insert excerpt

	Def - Cost - Actual Base
	Def - Cost - Actual Base
nopanel	true

This is a calculated field that can only be edited by adding/editing an 'Actual Base Cost'.

Database Fields: ERPx_IMLotCostHistory.Cost where ERPx_IMLotCostHistory.LotCostTypeEN = 3

Actual Cost - Layers

Insert excerpt

	Def - Cost - Actual Layers
	Def - Cost - Actual Layers
nopanel	true

This is a calculated field that can only be edited by adding/editing an 'Actual Cost Layer'.

Database Fields: ERPx_IMLotCostHistory.Cost where ERPx_IMLotCostHistory.LotCostTypeEN = 2

Actual Cost Rate

Insert excerpt

	Def - Cost Rate - Actual
	Def - Cost Rate - Actual
nopanel	true

This is a calculated field that can only be edited by adding/editing an 'Actula Cost Layer' or adding/updating an 'Actual Base Cost'.

Base Source

Identifies whether the Base cost was assigned manually, from a transaction, or from a Bill of Material.

What data field stores this value and how is it set?

Batch Comment

Insert excerpt

	Batch Comment
	Batch Comment
nopanel	true

This is not required and is always editable from the 'Batch Comment' field on the Properties tab of the Production Batch record view.

Database Field: ERPx_IMProductionLot.LotComment

Batch Date

Insert excerpt

	Def - Batch Date
	Def - Batch Date
nopanel	true

This can be edited from the 'Batch Date' field on the Properties tab of the Production Batch Record View.

Database Field: ERPx_IMProductionLot.DateProduced

Batch Site ID

Insert excerpt

	Batch Site
	Batch Site
nopanel	true

This is required and is always editable from the 'Batch Site ID' field on the Properties tab of the Production Batch Record View.

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK

BOM ID

Displays the BOM ID of the Bill of Material record. Clicking on the link opens the corresponding Bill of Materials Record View. This field is only populated if the lot costs have been retrieved from a BOM record. This is not editable.

Database Fields: ERPx_MPBOM.BOMID, ERPx_IMProductionLot.BaseCostBOMSK

Born on Date

Insert excerpt

	Def - Born on Date
	Def - Born on Date
nopanel	true

This is a system assigned value that is not editable.

Database Field: ERPx_IMLotBalance.BornOnDate

Cost Group Description

Insert excerpt

	Cost Group Description
	Cost Group Description
nopanel	true

This is not required and can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View.

Insert excerpt

	Def - Cost Group
	Def - Cost Group
nopanel	true

Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK

Cost UOM

Insert excerpt

	UOM - Cost
	UOM - Cost
nopanel	true

This is required for Costing and can be edited from the 'Cost UOM' property on the 'Advanced Properties' tab of the Item Record View.

Insert excerpt

	Def - UOM
	Def - UOM
nopanel	true

Database Fields: ERPx_IMItem.CostUOMSK

Costing Method

Identifies which cost bucket is used to post to the General Ledger. This is a required and can be edited from the 'Costing Method' property on the 'Advanced Properties' tab of the Item Record View.

Database Fields: ERPx_IMItem.ValuationMethodEN

Costing Status

Insert excerpt

	Def - Lot Costing Status
	Def - Lot Costing Status
nopanel	true

This can be edited from the 'Costing Status' property on the Mass Update dialog.

Database Fields: ERPx_IMLotBalance.LayerCostingStatusEN

Country of Origin

Insert excerpt

	Country of Origin
	Country of Origin
nopanel	true

This can be edited from the 'Country of Origin' field on the 'Properties' tab of the Production Batch Record View.

Database Field: ERPx_IMProductionLot.CountryOfOrigin

Days Old

Displays the calculated age (in days) of the Production Batch. It is calculated as the (Current Date) - [Batch Date]. This can be edited by changing the 'Batch Date' field on the Properties tab of the Production Batch record view. This is not stored in the database.

This is a calculated field that is not stored in the database.

Days Until Expiration

Insert excerpt

	Days Until Expiration
	Days Until Expiration
nopanel	true

This is a calculated field that is not stored in the database.

Expiration Date

Insert excerpt

	Batch Expiration Date
	Batch Expiration Date
nopanel	true

This is editable from the Production Batch Record View.

Database Field: ERPx_IMProductionLot.ExpirationDate

Inventory Balance Sheet Account

Insert excerpt

	GL Account - Inventory Balance Sheet
	GL Account - Inventory Balance Sheet
nopanel	true

This can be edited from the 'Inventory Balance Sheet' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.

ValuationMethodENCosting Status

Displays whether the layer costing is Open or Closed. This can be edited from the 'Layer Costing Status' property on the Mass Update dialog box launched from the Lot Balances List View.

Database Fields: ERPx_IMLotBalance.LayerCostingStatusEN

Country of Origin Insert excerptCountry of OriginCountry of Originnopaneltrue This can be edited from the 'Country of Origin' field on

InventoryActSK

Is Lot Expired

A Yes/No field to identify if a Lot is expired.

This will display as "Yes" For Lots with a 'Batch Expiration Date' that is <= the current date.
This will display as "No" for Lots without a 'Batch Expiration Date' or for Lots with a 'Batch Expiration Date' that is >= the current date.

This is a calculated field that is not stored in the database.

Item: Description

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

The 'Item ID' and/or the 'Item Description' can be edited from the 'Properties' tab of the

Production Batch

Item Record View.

Database Field

Insert excerpt

	Def - Item ID
	Def - Item ID
nopanel	true

Database Fields: ERPx_

IMProductionLot.CountryOfOriginDays OldDisplays the calculated age (in days) of the Production Batch. It is calculated as the (Current Date) - [Batch Date]. This can be edited by changing the 'Batch Date' field on the Properties tab of the Production Batch record view. This is not stored in the database.Days Until ExpirationDays Until Expiration

IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK

Item Class ID

Insert excerpt

Days Until Expiration

Def - Item Class
	Def - Item Class
nopanel	true

Expiration DateBatch Expiration Date

Database Fields: ERPx_IMItemClass.ID, ERPx_IMItem.ItemClassSk

Last Effective Actual Cost Change

Insert excerpt

Batch Expiration Date

Inventory Balance Sheet Account

Def - Last Effective Actual Cost Change
	Def - Last Effective Actual Cost Change
nopanel	true

Database Field: ERPx_IMProductionLot.ExpirationDate

GL Account - Inventory Balance Sheet

This can only be changed by adding an Actual Cost or adding/removing an Actual Cost Layer.

Last Effective Market Cost Change

Insert excerpt

GL Account - Inventory Balance Sheet

Def - Last Effective Market Cost Change
	Def - Last Effective Market Cost Change
nopanel	true

This

This can

be edited from the 'Inventory Balance Sheet' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK

Is Lot Expired

Identifies if a Lot is expired.

This will display as "Yes" For Lots with a 'Batch Expiration Date' that is <= the current date.
This will display as blank for Lots without a 'Batch Expiration Date' or for Lots with a 'Batch Expiration Date' that is >= the current date.

Item: Description Insert excerptItem ID & Item DescriptionItem ID & Item Descriptionnopaneltrue The 'Item ID' field is not editable. The Item Description can be edited from the 'Item Description' property on the 'Properties' tab of the Item Record View.
Insert excerptDef - Item IDDef - Item IDnopaneltrue

Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK

Last Effective Cost ChangeMarket Cost - Base

only be changed by adding a Market Cost or adding/removing a Market Cost Layer.

LotSK

Identified the SK value of the Lot that is stored in the Database. This is for information only; it is not editable.

Database Fields: ERPx_IMLotBalance.LotSK

Lot Status

Insert excerpt

	Def - Lot Status
	Def - Lot Status
nopanel	true

Database Fields: ERPx_IMLotBalance.LotStatusEN

Market Cost - Base

Insert excerpt

	Def - Cost - Market Base
	Def - Cost - Market Base
nopanel	true

This is a calculated field that can only be edited by adding/editing a 'Market Base Cost'.

Database Fields: ERPx_IMLotCostHistory.MarketCost where ERPx_IMLotCostHistory.LotCostTypeEN = 3

Market Cost - Layers

Insert excerpt

	Def - Cost - Market Layers
	Def - Cost - Market Layers
nopanel	true

This is a calculated field that can only be edited by adding/editing a 'Market Cost Layer'.

Database Fields: ERPx_IMLotCostHistory.MarketCost where ERPx_IMLotCostHistory.LotCostTypeEN = 2

Market Cost Rate

Insert excerpt

	Def - Cost Rate - Market

Base


	Def - Cost Rate - Market

Base

nopanel

true

	true

This is a calculated field that can only be edited by adding/editing a 'Market Cost Layer' or adding/updating a 'Market Base Cost'.

On Hand As Of

Identifies the date that the On Hand Balances are being displayed as of. This column is only populated when the inquiry is run with a value in the "GL Period Activity" Search Option Parameter, and it will be the ending date of the GL Period Specified. This is a calculated field that

can only be edited by adding/editing a 'Market Base Cost'.Market Cost - LayersDef - Cost - Market Layers

is not stored in the database.

On Hand Units

Insert excerpt

Def - Cost - Market Layers

Units - On Hand
	Units - On Hand
nopanel	true

This column is

a calculated field that can only be edited by adding/editing a 'Market Cost Layer'.Market Cost RateDef - Cost Rate - Market

only populated when the inquiry is run with a value in the "GL Period Activity" Search Option Parameter.

If the item's 'Manage Items By' value is set to:

"Units Only" or "Units and Weight", this field will be populated.
"Weight Only", this field will be blank

On Hand Weight

Insert excerpt

Def - Cost Rate - Market

Weight - On Hand
	Weight - On Hand
nopanel	true

This column is only populated when the inquiry is run with a value in the "GL Period Activity" Search Option Parameter.

If the item's 'Manage Items By' value is set to:

"Units Only" or "Units and Weight", this field will be populated.
"Weight Only", this field will be blank

Owner

Insert excerpt

	Owner - Inventory Lot
	Owner - Inventory Lot
nopanel	true

This cannot be edited, ownership for an existing Lot can only be changed via a Transfer Transaction.

Insert excerpt

	Def - Owner
	Def - Owner
nopanel	true

Database Field: ERPx_IMLotOwner.OwnerName

Production Batch

Insert excerpt

	Production Batch
	Production Batch
nopanel	true

This

This can be edited from the 'Production Batch' field on the Properties tab of the Production Batch Record View.

Insert excerpt

	Def - Production Batch
	Def - Production Batch
nopanel	true

Insert excerpt

	Def - Inventory Lot
	Def - Inventory Lot
nopanel	true

Database Field: ERPx_IMProductionLot.ProductionLotID

Received From

Identifies the name of the Vendor, Fisherman, or Grower that the product was received from. If there is only one 'Received From' identified on the Production Batch, the name will be displayed. If there is more than one 'Received from' identified on the Production Batch, the word "Multiple" will be displayed. This can be edited from the 'Rec. From' header field on the Inventory Receipt record view before the transaction is posted or from the Production Batch Record View at any time.

Database Field:

ERPh

ERPx_

IMTransactionHeader

IMReceivedFrom.ReceivedFrom, ERPx_IMProductionLot.ProductionLotSK, ERPx_IMLotBalance.LotSK

Site ID

Displays the Site ID for the Site where the inventory balances are stored. This is always editable from the Sites Record View.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteID,

ERPh

ERPh_IMTransactionHeader.SiteSK

Site Name

Displays the Site Name for the Site where the inventory balances are stored. This is always editable from the Sites Record View.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_IMLotBalance.SiteSK

Standard Cost - Base

Storage Begin Date

Insert excerpt

	Def -

Cost - Standard Base

Storage Begin Date
	Def -

Cost - Standard Base

Storage Begin Date
nopanel	true

This

is a calculated field that

can only be edited

by adding/editing a 'Standard Base Cost'.Standard Cost - Layers

on the Warehouse Lot List View.

Database Fields: ERPx_IMWarehouseLot.DtorageRenewalDate

Storage Renewal Day

Insert excerpt

	Def -

Cost - Standard Layers

Storage Renewal Day
	Def -

Cost - Standard Layers

Storage Renewal Day
nopanel	true

This

is a calculated field that

can only be edited by

adding/editing a 'Standard Cost Layer'.Standard Cost RateDef - Cost Rate - Standard

editing the 'Storage Begin Date' on the Warehouse Lot List View

Database Fields: ERPx_IMWarehouseLot.DtorageRenewalDay

Unit UOM

Insert excerpt

Def - Cost Rate - Standard

Storage Begin Date

UOM - Default IM Units
	UOM - Default IM Units
nopanel	true

This is a calculated field that is not stored in the database. It can only be edited by adding/editing a 'Standard Cost Layer' or adding/updating a 'Base Cost'.

This column is only populated when the inquiry is run with a value in the "GL Period Activity" Search Option Parameter.

If the item's 'Manage Items By' value is set to:

"Units Only" or "Units and Weight", this field will be populated.
"Weight Only", this field will be blank

Insert excerpt

	Def -

Storage Begin Date

UOM
	Def -

Storage Begin Date

UOM
nopanel	true

This can only be edited on the Warehouse Lot List View.

Database Fields: ERPx_

IMWarehouseLot.DtorageRenewalDateStorage Renewal Day Insert excerptDef - Storage Renewal DayDef - Storage Renewal Daynopaneltrue This can only be edited by editing the 'Storage Begin Date' on the Warehouse Lot List ViewDatabase Fields: ERPx_IMWarehouseLot.DtorageRenewalDay

IMUOM.UOMName, ERPx_IMItem.DefaultIMUnitUOMSK

UOM Schedule

Insert excerpt

	UOM - Schedule
	UOM - Schedule
nopanel	true

This field comes from the 'UOM Schedule' property on the 'Properties' tab of the Item Record View and is not editable from here.

Database Fields: ERPx_IMItem.UOMScheduleSK, ERPh_IMTransactionDetail.ItemSK

Warehouse Lot

Insert excerpt

	Warehouse Lot
	Warehouse

Lot

Lot
nopanel	true

This can be edited from the 'Warehouse Lot' field on the Warehouse Lots List View.

Insert excerpt

	Def - Warehouse Lot
	Def - Warehouse Lot
nopanel	true

Insert excerpt

	Def - Inventory Lot
	Def - Inventory Lot
nopanel	true

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

Weight UOM

Insert excerpt

	UOM - Default IM Weight
	UOM - Default IM Weight
nopanel	true

This

is not editable from the inquiry.
Insert excerptDef - Warehouse LotDef - Warehouse Lotnopaneltrue

column is only populated when the inquiry is run with a value in the "GL Period Activity" Search Option Parameter.

If the item's 'Manage Items By' value is set to:

"Weight Only" or "Units and Weight", this field will be populated.
"Units Only", this field will be blank.

Insert excerpt

	Def -

Inventory Lot

UOM
	Def -

Inventory Lot

UOM
nopanel	true

Database Fields: ERPx_

IMWarehouseLot

IMUOM.

WarehouseLotID

UOMName, ERPx_

IMLotBalance

IMItem.

WarehouseLotSK

DefaultIMWeightUOMSK

Version	Old Version 1	New Version Current
Changes made by	Tom Williams	Emma Greenwood
Saved on	Jul 06, 2022	Dec 16, 2024

Versions Compared

Key

Page Header

Search

Page Header

Search

Page Detail

Page Detail

Related Topics

Page Definitions

Technical Details

Page Comparison

Versions Compared

Key

Page Header

Search

Page Header

Search

Page Detail

Page Detail

Related Topics

Page Definitions

Technical Details