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
Page Header
Search
| 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 definition has not yet been defined. The lookup contains the values "NON-INV', "Item" and "Lot". |
| Include | Used to specify the type of balances or items/lots to include. This is a multi-select standard lookup that is not required to return results. It defaults to blank. 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Item: Description Lookup'. This is a multi-select standard lookup that is not required to return results. It defaults as blank.Item IDs are the unique identifier for Items. The lookup contains a list of all Items in the Items master file. |
| Item Class | Used to select one or more Item Classes. This is a multi-select standard lookup that is not required to return results. It defaults as blank. Item Classes are used to identify default values that will be applied to new Inventory Items and to group Items together for reporting purposes. 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 The definition has not yet been defined. This lookup contains the values in the LayerCostingStatus Enumeration Class. |
| Lot Owner | Used to select one or more inventory Owners. This is a multi-select standard lookup that is not required to return results. It defaults as blank. Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots. The lookup contains a list of all Lot Owners. |
| Search | A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). Refer to this FAQ for advanced search options. The Search field can be used to search across the following fields:
|
| Site | Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This is a multi-select standard lookup that is not required to return results. It defaults as blank. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. The lookup contains a list of all active Sites. |
| Trans Date | Used to select the date the transaction was created. This is a date range control that allows users to select a single date or a range of dates. This is not required to return results and defaults with a date range of the past 30 days. Change label to 'Cost Layer Effective Date' |
| Saved Searches |
Refer to this FAQ for advanced search options. |
Page Detail
| Toolbar Icons | Description |
|---|---|
| Column Filter Show/Hide |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Excel |  Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Help |  Opens the online WIKI help page for the current page. |
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
| Refresh |
|
| Saved Layouts |  Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Search Options |  Toggles between displaying and hiding the Search Options portion of the page. |
| Fields | Description |
| Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
| Actual | Error rendering macro 'excerpt-include' : No link could be created for 'Actual Cost'. This field cannot be edited once the 'Actual Cost' field is applied on the Mass Update dialog box launched from the Update Costs List View. The Actual Cost reflects the cost that will post to the General Ledger for Items with a 'Costing Method' of "Active". For some items this may be set from a default or "standard" cost rate and for other items this may reflect that actual amount paid to purchase or incurred to produce the product. For each individual LotSK, this is calculated as the [Actual Base Cost Rate] + sum of all the [Actual Cost Layer Rates]. Database Field: ERPx_IMLotCostHistory.Cost |
| Batch Comment | Displays the batch comment assigned to the corresponding Production Batch. This can be edited from the 'Batch Comment' property on the 'Properties' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot.LotComment |
| Batch Date | Displays the date when the production batch was produced. This can be edited from the 'Batch Date' field on the 'Properties' tab of the Production Batch Record View. 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 | Identifies the unique identifier of the Cost Group associated with the item. This can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View. Cost Groups are used to associate items that share the same cost model. 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. The definition has not yet been defined. Database Fields: ERPx_IMItem.ValuationMethodEN |
| Cost UOM | Identifies the unit of measure the item's cost is stated in terms of. This is the value assigned in the "Cost UOM" property on the Item Record View. This can be edited from the 'Cost UOM' property on the 'Properties' tab of the Item Record View. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. 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 | Displays the name of the Country that the Production Batch originated in. The value is stored in the 'Country of Origin' Tab on the Production Batch Record View. If no 'Country of Origin' has been assigned, this will be blank, if there is only one 'Country of Origin' assigned to the Production Batch then the name of that country will be displayed. If there is more than one country assigned on the 'Country of Origin' Tab then this will indicate "Multiple". 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 Since Received | Displays the number of days since the lot's received date. It is calculated as [Current Date - Received Date] and is never editable by a user. This is not stored in the database. |
| 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 | The GL Account that is used for the following Costing journal entries: This only applies to the 'Actual' cost of Items with a Costing Method of "Active".
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK |
| ItemID: Description | Identifies the Item, displayed as Item ID: Item Description. 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. Item IDs are the unique identifier for Items. Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription |
| Label Code | Displays the label code assigned to the production batch. This can be edited from the 'Label Code' field on the 'Properties' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot.LabelCode |
| Market | Error rendering macro 'excerpt-include' : No link could be created for 'Market Cost'. This field cannot be edited once the 'Market Cost' field is applied on the Mass Update dialog box launched from the Update Costs List View. Database Field: ERPx_IMLotCostHistory.MarketCost |
| Owner | Identifies the Lot Owner of the Inventory Lot. 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 New. Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots. Database Field: ERPx_IMLotOwner.OwnerName |
| Outside Purchase | Displays whether or not the Production Batch came from an outside purchase. This can be edited from the 'Outside Purchase' field on the 'Properties' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot.IsOutsidePurchase |
Production Batch | Identifies the Production Batch ID of the Lot. This can be edited from the 'Production Batch' field on the 'Properties' tab of the Production Batch Record View. Error rendering macro 'excerpt-include' : No link could be created for 'Def - Lot - Production Batch'. Database Field: ERPx_IMProductionLot.ProductionLotID |
| Production Site | Identifies the Site where the Production Batch was born, created, or initially received. This can be edited from the 'Production Batch Site' field on the 'Properties' tab of the Production Batch Record View. 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 | Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This comes from the 'Site' field on the 'Home' tab of the Transaction Record View that created the Inventory Lot. This is not editable after the transaction has been saved. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. Database Fields: ERPx_MFSite.SiteID, ERPx_IMLotBalance.SiteSK |
| Site Name | Identifies the name of the Site (Warehouse) that the transaction, shipment, receipt, item, or lot is associated with. This comes from the 'Site' field on the 'Home' tab of the Transaction Record View that created the Inventory Lot. This is not editable after the transaction has been saved. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Standard Cost'. This field cannot be edited once the 'Standard Cost' field is applied on the Mass Update dialog box launched from the Update Costs List View. Database Field: ERPx_IMLotCostHistory.StandardCost |
| Traded | Specifies if the Production Batch has been traded. This can be edited from the 'Traded' field on the 'Properties' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot.Traded |
| Updated | Identifies the Last Updated Date of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMLotCostHistory.LastUpdated |
| Updated By | Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMLotCostHistory.LastUser |
| Vendor Purchased From | Displays the vendor purchased from as entered on the lot's Production Batch. This can be edited from the 'Vendor Purchased From' field on the 'Properties' tab of the Production Batch Record View. Database Field: ERPx_IMProductionLot.PurchasedFrom |
| Warehouse Lot | Identifies the Warehouse Lot to which the selected item or inventory lot belongs. This can be edited from the 'Warehouse Lot' field on the Warehouse Lots List View. Error rendering macro 'excerpt-include' : No link could be created for 'Def - Lot - Warehouse Lot'. Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK |
