The Cost History Inquiry details all layer costs assigned to lots. The purpose of the inquiry is to display how the current cost is calculated.
This list view also contains columns for each Attribute that is set up for the 'Items' attribute type and the 'Production Batches' attribute type. Additionally, this list view 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.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Filters
...
The Cost History Inquiry details all layer costs assigned to lots. The purpose of the inquiry is to display how the current cost is calculated.
This list view also contains columns for each Attribute that is set up for the 'Items' attribute type and the 'Production Batches' attribute type. Additionally, this list view 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.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Filters
| Filter Items | Description | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cost Type | Used to select one or more Cost Types to include. This is a multi-select standard lookup that is required to return results. It defaults to all Cost Types.
The lookup contains the values "NON-INV', "Item" and "Lot". | ||||||||||||||||||||||
| Include |
This lookup contains the value "Voids". | ||||||||||||||||||||||
| Item |
If defaults as blank.
The lookup contains the values "NON-INV', "Item" and "Lot".Includea list of all Items in the Items master file. | ||||||||||||||||||||||
| Item Class |
This lookup contains the value "Voids". as blank.
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 as blank.
This lookup contains the values in the LayerCostingStatus Enumeration Class. | ||||||||||||||||||||||
| Lot Owner |
The lookup contains a list of all Lot Owners. | ||||||||||||||||||||||
| Search |
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 as blank. Insert excerpt | | Def - Not Defined | Def - Not Defined | |||||||||||||||||
| nopanel | true | ||||||||||||||||||||||
| Site |
This is a multi-select standard lookup that is required to return results. It defaults as blank.
The lookup contains a list of all active Sites. | ||||||||||||||||||||||
| Transaction Date |
The lookup contains a list of all Lot Owners. Search This is a date picker that allows users to select a single date or a range of dates. This is required to return results and defaults as blank. | ||||||||||||||||||||||
| Saved Filters | Inq - Search
| Inq - Search |
| This is a text box that is not required to return results. It defaults as blank and can be used to search Item ID, Item Description, Site ID, Site Name, Warehouse Lot, Production Batch, Owner or Attribute Values. Please refer to the How to Search in NorthScope FAQ for advanced search options.Site→Tom, this is the excerpt I created as a placeholder that we can update and also add a link to another page as you suggested. |
Header Toolbar
| Toolbar Icons | Description | |
|---|---|---|
| Excel |
|
|
|
|
|
| Favorites |
|
|
The lookup contains a list of all active Sites.
Transaction Date| Grid Layout |
|
|
Saved Filters
| →Tom, this is the excerpt I created as a placeholder that we can update and also add a link to another page as you suggested. | |||||||||
| Help |
| ||||||||
| Refresh |
|
| Toolbar Icons | Description | Excel | |||
|---|---|---|---|---|---|
| Insert excerpt | Excel - LV | Excel - LV | |||
| nopanel | true | Favorites | |||
| Insert excerpt | Favorites Add/Remove - Global | Favorites Add/Remove - Global | |||
| nopanel | true | Grid Layout | |||
| Insert excerpt | Column Layouts for Kendo - Global | Column Layouts for Kendo - Global | |||
| nopanel | true | Help | |||
| Insert excerpt | Help - Global | Help - Global | |||
| nopanel | true | Refresh | |||
| Insert excerpt | Refresh - Global | Refresh - Global | |||
| nopanel | true | ||||
| Fields | Description | ||||
| Actual | Batch Comment | Batch Date | |||
| Insert excerpt | Production Batch Date | Production Batch Date | |||
| nopanel | true | BOM ID | Cost Group | Displays the cost group attached to the item.
|
Header Toolbar
| ||||||||||||||||||
| Fields | Description | |||||||||||||||||
| 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. This field is a hyperlink, which opens the corresponding BOM record. This field is only populated, if the lot costs have been retrieved from a BOM record. | |||||||||||||||||
| Cost Group |
Database Fields: ERPx_IMCostGroup.CostGroupID, 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 |
| GroupUOM' property on the 'Properties' tab of the Item Record View. | ||||||||||||||||
| Insert excerpt | Def - Cost Group | Def - Cost Group | nopanel | trueDatabase | FieldFields: ERPx_ | IMCostGroup.CostGroupIDCost Type | Cost UOMIMItem.CostUOMSK | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Costing Status | ||||||||||||||||||
| Country of Origin | ||||||||||||||||||
| Days Since Received | ||||||||||||||||||
| Effective | ||||||||||||||||||
| Inventory Balance Sheet Account | ||||||||||||||||||
| ItemID: Description |
Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSK | |||||||||||||||||
| Label Code | ||||||||||||||||||
| Market | ||||||||||||||||||
| Owner |
Database Field: ERPx_IMLotOwner.OwnerName | |||||||||||||||||
| Outside Purchase | ||||||||||||||||||
Production Batch |
Database Field: ERPx_IMProductionLot.ProductionLotID | |||||||||||||||||
| Production Site |
Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK | |||||||||||||||||
| Reason Code | ||||||||||||||||||
| Received | ||||||||||||||||||
| Site |
Database Fields: ERPx_MFSite.SiteName, ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.SiteSK | |||||||||||||||||
| Site Name |
Database Fields: ERPx_MFSite.SiteName, ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.SiteSK | |||||||||||||||||
| Source | ||||||||||||||||||
| Standard | ||||||||||||||||||
| Traded |
Database Field: ERPx_IMProductionLot.Traded | |||||||||||||||||
| Updated | ||||||||||||||||||
| Updated By | ||||||||||||||||||
| Vendor Purchased From | ||||||||||||||||||
| Warehouse Lot |
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK |
...