The Cost The Cost History Inquiry details all layer costs assigned to Inventory Tracked Items. The purpose of the inquiry is to display how the current cost is calculated.
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 automatically included in the default view. However, because these attributes and lot certifications are user defined, they are not included in the help documentation.
Software Version: 2022.06.16 and newer
...
Filter Items | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Auto Hide Filters |
| ||||||||||||||||
Auto Refresh on Open |
| ||||||||||||||||
Costing Method | A multi-select lookup to limit the results to Lots containing Items based on the Item's 'Costing Method'. This defaults to blank (All) and if left blank, all Costing Methods will be included. The lookup contains options for:
This should be based on what we do with the same data on the Update Costs inquiry. The lookup contains the values "NON-INV', "Item" and "Lot". | ||||||||||||||||
Costing Status | A single-select lookup to limit the results to Lots that are either Open or Closed for Costing. This defaults to 'Open' but can be changed to 'Closed'. Is this intended to be a single select lookup and not a multi-select lookup? This lookup contains the values in the LayerCostingStatus Enumeration Class. | ||||||||||||||||
Effective Date |
Change label to 'Cost Layer Effective Date' | ||||||||||||||||
Include | |||||||||||||||||
Item |
The lookup contains a list of all Items displayed as [Item ID]: [Item Description]. | ||||||||||||||||
Item Class |
| ||||||||||||||||
Lot Owner |
The lookup contains a list of all Lot Owners. | ||||||||||||||||
Reason Code |
| ||||||||||||||||
Saved Searches |
| ||||||||||||||||
Search |
| ||||||||||||||||
Site |
The lookup contains a list of all active Sites displayed as [Site ID]: [Site Name]. |
Page Detail
Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||||||||||||||||||
Quick Column Filter |
| ||||||||||||||||||||||||||||||||||||||||
Refresh |
| ||||||||||||||||||||||||||||||||||||||||
Saved Layouts |
| ||||||||||||||||||||||||||||||||||||||||
Search Options |
| ||||||||||||||||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||||||||||||||
Checkbox | excerpt-include
| Actual | |||||||||||||||||||||||||||||||||||||||
Actual Cost Rate | Actual Cost | ||||||||||||||||||||||||||||||||||||||||
nopanel | true | Identifies the cost rate assigned to the Actual Cost Layer. This can only be edited by adding/editing an 'Actual Cost Layer' or adding/updating an 'Actual Cost Base'.
Database Field: ERPx | _IMLotCostHistory.CostBatch Comment _IMLotCostHistory.Cost | ||||||||||||||||||||||||||||||||||||||
Batch Comment |
Database Field: ERPx_IMProductionLot.LotComment | ||||||||||||||||||||||||||||||||||||||||
Batch Date |
| Comment
| Comment
| CommentDate' | property field on the | 'Properties | ' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot. | LotCommentDateProduced | |||||||||||||||||||||||||||||||||
Batch DateSite ID |
| Production
| Date
| Production
| Date
| can be edited is required and is always editable from the 'Batch | DateSite ID' field on the | 'Properties | ' tab of the Production Batch Record View. Database | Field:Fields:ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot. | DateProducedManufactureSiteSK | ||||||||||||||||||||||||||||||
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 |
What data field stores this value and how is it set? | ||||||||||||||||||||||||||||||||||||||||
Cost Group | Description |
| ID
| ID
Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK | |||||||||||||||||||||||||||||||||||||
Cost UOM |
| Cost Type | Identifies whether the cost of the item is evaluated using the item or the lot. This
| Valuation MethodCost UOM' property on the 'Advanced Properties' tab of the Item Record View.
| zNot Defined
| zNot Defined
Database Fields: ERPx_IMItem. | ValuationMethodENCostUOMSK | Cost UOM | |||||||||||||||||||||||||||||||||
Insert excerpt | UOM - Cost | UOM - Cost | |||||||||||||||||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||||||||||||||||
Costing Method | Identifies which cost bucket is used to post to the General Ledger. This is a required and can be edited from the ' Cost UOMCosting Method' property on the 'Advanced Properties' tab of the Item Record View. Insert excerpt | | Def - UOM | Def - UOM | nopanel | true||||||||||||||||||||||||||||||||||||
Costing Status | Displays whether | the layer costing is Open or Closed. cost changes can be made to the Lot. If the Costing Status is "Open" then cost changes can be made. If the Costing Status is "Closed" then cost changes cannot be made to the Lot. 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 |
| OriginOrigin' 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.record view. This is not stored in the database. This is a calculated field that is not stored in the database. | |||||||||||||||||||||||||||||||||||||
Days Until Expiration |
| Since Received
| Since Received
| It This is | calculated as [Current Date - Received Date] and is never editable by a user. This is a calculated field that is not stored in the database. | ||||||||||||||||||||||||||||||||||||
Effective Date | Displays the Effective date of the cost update event. If the cost event was manually set, then this field cannot be edited once the 'Effective Date' field is applied on the Mass Update dialog box launched from the Update Costs List View. If the cost was updated from BOM, then this field comes 'Effective' field on | the 'Cost Inputs' tab of the Bill of Materials Record View and cannot be editedthe 'Cost Inputs' tab of the Bill of Materials Record View and cannot be edited. Database Field: ERPx_IMLotCostHistory.EffectiveDate | |||||||||||||||||||||||||||||||||||||||
Expiration Date |
Database Field: ERPx_ | IMLotCostHistoryIMProductionLot. | EffectiveDate ExpirationDate | ||||||||||||||||||||||||||||||||||||||
Inventory Balance Sheet Account |
Database Fields: ERPx_GLAccount | .AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSKItemID.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK | |||||||||||||||||||||||||||||||||||||||
Is Lot Expired | A Yes/No field to identify if a Lot is expired.
This is a calculated field that is not stored in the database. | ||||||||||||||||||||||||||||||||||||||||
Item: Description |
| field is not editable. The Item Description can be edited from and/or the 'Item Description' | property on the 'Properties' tab of the Item Record View.|||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Item ID | Def - Item ID | |||||||||||||||||||||||||||||||||||||||
nopanel | true | Label Code | |||||||||||||||||||||||||||||||||||||||
Insert excerpt | Label Code | Label Code | |||||||||||||||||||||||||||||||||||||||
nopanel | true | can be edited from the 'Properties' tab of the | Production Batch Item Record View. |
Database | FieldFields: ERPx_ | IMProductionLot.LabelCodeIMItem.ItemID, ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK | |||||||||||||||||||||||||||||||||||
Last Updated |
Database Field: ERPx_IMLotCostHistory.LastUpdated | ||||||||||||||||||||||||||||||||||||||||
Last Updated By |
Database Field: ERPx_IMLotCostHistory.LastUser | ||||||||||||||||||||||||||||||||||||||||
Market | |||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Cost Rate | Market Cost | |||||||||||||||||||||||||||||||||||||||
nopanel | true | Identifies the cost rate assigned to the Market Cost Layer. This can only be edited by adding/editing a 'Market Cost Layer' or adding/updating a 'Market Cost Base'.
Database Field: ERPx_IMLotCostHistory.MarketCost | |||||||||||||||||||||||||||||||||||||||
Owner |
| This can be edited from the 'Owner' field on the Items grid of the Transaction Record View while the transaction is in a Status of NewThis cannot be edited, ownership for an existing Lot can only be changed via a Transfer Transaction.
Database Field: ERPx_IMLotOwner.OwnerName | |||||||||||||||||||||||||||||||||||||||
Outside Purchase Production Batch | Outside Purchase
| Outside Purchase |
| Outside PurchaseProduction Batch' field on the | 'Properties | ' Production Batch | tab of the Production Batch Record View. |
| This can be edited from the 'Production Batch' field on the 'Properties' tab of the Production Batch Record View.
| - Production Batch
| - Production Batch
Database Field: ERPx_IMProductionLot.ProductionLotID | ||||||||||||||||||||||||||||||
Reason Code | Batch Site
| Batch Site |
| be edited from the 'Production Batch Site' field on the 'Properties' tab of the Production Batch Record View. Reason Code | Displays the reason code selected when the layer costs were updated. This field cannot be edited once the 'Reason' field is applied on the Mass Update dialog box launched from the Update Costs List View.only be assigned when adding/editing a Cost Layer or adding/updating a Base Cost.
Database Fields: ERPx_MFNoteTypeReasonCode.ReasonCode, ERPx_IMLotCostHistory.ReasonCodeSK | ||||||||||||||||||||||||||||||||||||
Received | Displays the date the lot's items were received as determined by the production batch. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMLotBalance.CreatedDate | Site | |||||||||||||||||||||||||||||||||||||||
Insert excerpt | Site ID | Site ID | |||||||||||||||||||||||||||||||||||||||
nopanel | true | 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_IMTransactionHeader.ReceivedFrom | ||||||||||||||||||||||||||||||||||||||
Site | Displays the Site ID for the Site where the inventory balances are stored. This is always editable from the Sites Record View.
Database Fields: ERPx_MFSite.SiteID, | ERPx_IMLotBalanceERPx_MFSite.SiteID, ERPh_IMTransactionHeader.SiteSK | |||||||||||||||||||||||||||||||||||||||
Site Name | |||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Displays the Site Name | Site Name | |||||||||||||||||||||||||||||||||||||||
nopanel | true | for the Site where the inventory balances are stored. This is always editable from the Sites Record View.
Database Fields: ERPx_MFSite.SiteName, ERPx_IMLotBalance.SiteSK | |||||||||||||||||||||||||||||||||||||||
Source | Displays the source of the update eventIdentifies how the Cost Layer was added. This field is automatically assigned based on how the costs were assigned and is not editable. The options include:
ERPx_IMLotCostHistory.LotCostTypeEN | ||||||||||||||||||||||||||||||||||||||||
Standard Cost Rate | Identifies the cost rate assigned to the Standard Cost Layer. This can only be edited by adding/editing a 'Standard Cost Layer' or adding/updating a 'Standard Cost Base'.
Database Field: ERPx_IMLotCostHistory.StandardCost | ||||||||||||||||||||||||||||||||||||||||
Storage Begin Date |
Database Fields: ERPx_IMWarehouseLot.DtorageRenewalDate | ||||||||||||||||||||||||||||||||||||||||
Storage Renewal Day |
Database Fields: ERPx_IMWarehouseLot.DtorageRenewalDay | ||||||||||||||||||||||||||||||||||||||||
UOM Schedule |
Database Fields: ERPx_IMItem.UOMScheduleSK, ERPh_IMTransactionDetail.ItemSK | ||||||||||||||||||||||||||||||||||||||||
Warehouse Lot |
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK |
...