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: 2020.11.13 and newer
...
| Filter Items | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cost Type | Used to select one or more Cost Types to include. This is a multi-select standard lookup that is not required to return results. It defaults to all Cost Types. This should be Valuation Type and only include options for Item or Lot, by default non-Sales Inventory Items would be 'Item' not Lot so we do not need the NON-INV.
The lookup contains the values "NON-INV', "Item" and "Lot". | ||||||||||||||||
| Include |
This lookup contains the value "Voids". Change this option to read 'Voided Cost Layers' also, we could remove the 'Layer Costing Status' parameter and add the option here called 'Lots closed for costing" Default to both being unchecked. | ||||||||||||||||
| Item |
The lookup contains a list of all Items in the Items master file. | ||||||||||||||||
| Item Class |
The lookup contains a list of all Item Classes. | ||||||||||||||||
| Layer Costing Status | Used to select the layer costing status to include in the results. This is a single-select standard lookup that is not required to return results. It defaults to "Open". Remove parameter and move option to Include
This lookup contains the values in the LayerCostingStatus Enumeration Class. | ||||||||||||||||
| Lot Owner |
The lookup contains a list of all Lot Owners. | ||||||||||||||||
| Search |
| ||||||||||||||||
| Site |
The lookup contains a list of all active Sites. | ||||||||||||||||
| Trans Date |
| ||||||||||||||||
| Saved Search OptionsSearches |
|
...
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||||
| Excel |
| ||||||||||||||||
| Favorites |
| ||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| Quick Column Filter |
| ||||||||||||||||
| Refresh |
| ||||||||||||||||
| Saved Column Layouts |
| ||||||||||||||||
| Search Options |
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
| Checkbox |
| ||||||||||||||||
| Actual |
Database Field: ERPx_IMLotCostHistory.Cost | ||||||||||||||||
| Batch Comment |
Database Field: ERPx_IMProductionLot.LotComment | ||||||||||||||||
| Batch Date |
Database Field: ERPx_IMProductionLot.DateProduced | ||||||||||||||||
| 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 | ||||||||||||||||
| Cost Group |
Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK | ||||||||||||||||
| Cost Type | Identifies whether the cost of the item is evaluated using the item or the lot. This can be edited from the 'Valuation Method' property on the 'Properties' tab of the Item Record View.
Database Fields: ERPx_IMItem.ValuationMethodEN | ||||||||||||||||
| Cost UOM |
Database Fields: ERPx_IMItem.CostUOMSK | ||||||||||||||||
| Costing 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 |
Database Field: ERPx_IMProductionLot.CountryOfOrigin | ||||||||||||||||
| Days Since Received |
| ||||||||||||||||
| Effective | 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 edited. Database Field: ERPx_IMLotCostHistory.EffectiveDate | ||||||||||||||||
| Inventory Balance Sheet Account |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK | ||||||||||||||||
| ItemID: Description |
Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription | ||||||||||||||||
| Label Code |
Database Field: ERPx_IMProductionLot.LabelCode | ||||||||||||||||
| Market |
Database Field: ERPx_IMLotCostHistory.MarketCost | ||||||||||||||||
| Owner |
Database Field: ERPx_IMLotOwner.OwnerName | ||||||||||||||||
| Outside Purchase |
Database Field: ERPx_IMProductionLot.IsOutsidePurchase | ||||||||||||||||
Production Batch |
Database Field: ERPx_IMProductionLot.ProductionLotID | ||||||||||||||||
| Production Site |
Database Fields: ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK | ||||||||||||||||
| 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. 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 |
Database Fields: ERPx_MFSite.SiteID, ERPx_IMLotBalance.SiteSK | ||||||||||||||||
| Site Name |
Database Fields: ERPx_MFSite.SiteName, ERPx_IMLotBalance.SiteSK | ||||||||||||||||
| Source | Displays the source of the update event. This field is automatically assigned based on how the costs were assigned and is not editable. ERPx_IMLotCostHistory.LotCostTypeEN | ||||||||||||||||
| Standard |
Database Field: ERPx_IMLotCostHistory.StandardCost | ||||||||||||||||
| Traded |
Database Field: ERPx_IMProductionLot.Traded | ||||||||||||||||
| Updated |
Database Field: ERPx_IMLotCostHistory.LastUpdated | ||||||||||||||||
| Updated By |
Database Field: ERPx_IMLotCostHistory.LastUser | ||||||||||||||||
| Vendor Purchased From |
Database Field: ERPx_IMProductionLot.PurchasedFrom | ||||||||||||||||
| Warehouse Lot |
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK |
...