The purpose of this page is to search and view Inventory Lot information as of a specific date using filter parameters. An Inventory Lot defines the quantity of product that is unique by combination of Item, Site, Production Batch, Warehouse Lot and Owner.
This list view also contains columns for each Attribute that is set up for the 'Items' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Item attributes are not included in the help documentation.
Software Version: 2020.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Filters
...
The lookup contains a list of all Lot Owners.
...
The lookup contains a list of all Sites.
...
The lookup contains the following options:
- Inventory Lot - summary of the Item, Production Batch, Site, Warehouse Lot and Owner
- Item - summary of the Item and Site
- Item and Owner - summary of the Item, Owner and Site
- Item and Warehouse Lot - summary of the Item, Site and Warehouse Lot ID
- Item, Owner and Warehouse Lot - summary of the Item, Site, Owner and Warehouse Lot
Header Toolbar
...
The purpose of this page is to search and view Inventory Lot information as of a specific date using filter parameters. An Inventory Lot defines the quantity of product that is unique by combination of Item, Site, Production Batch, Warehouse Lot and Owner.
This list view also contains columns for each Attribute that is set up for the 'Items' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Item attributes are not included in the help documentation.
Software Version: 2020.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Filters
| Inquiry Parameters | Description | ||||||||||||||||
| As Of Date |
| ||||||||||||||||
| Lot Owner |
The lookup contains a list of all Lot Owners. | ||||||||||||||||
| Site |
The lookup contains a list of all Sites. | ||||||||||||||||
| Summarize By |
The lookup contains the following options:
|
Header Toolbar
| Toolbar Icons | Description | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Excel |
| ||||||||||||||||||||||
| Favorites |
| ||||||||||||||||||||||
| Help |
| ||||||||||||||||||||||
| Refresh |
| ||||||||||||||||||||||
| Fields | Description | ||||||||||||||||||||||
| Actual Cost | Displays the Actual Cost, which is the sum of Actual Base Cost and Actual Layer Costs, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. Database Field: ERPx_IMLotCostHistory.Cost | ||||||||||||||||||||||
| As Of Date | Identifies the cutoff transaction date to view Inventory balances that occur on and before this date. This can be edited from the 'As Of Date' in the 'Filters' tab. Database Fields: ERPx_IMTransactionHeader.TransactionDate, ERPx_SOorderHeader.OrderDate | ||||||||||||||||||||||
| Cost Group | Displays the cost group of the item. This can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View.
Database Field: ERPx_IMCostGroup.CostGroupID | ||||||||||||||||||||||
| Date Produced | Displays the date on which the Production Patch was produced. This can be edited from the 'Batch Date' field on the Properties tab of the Production Batch record view. When the 'Summarize By' inquiry parameter is set to "Item", "Item and Owner", "Item and Warehouse Lot" or "Item, Owner and Warehouse Lot", this field will be displayed as "**Not Included". Database Field: ERPx_IMProductionLot.DateProduced | ||||||||||||||||||||||
| Extended Actual Cost | Displays the Extended Actual Cost, which is the product of Actual Cost and On Hand Unit/Weight, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.
| ||||||||||||||||||||||
| Extended Lower of Cost or Market Cost | Displays either the Extended Standard Cost or the Extended Market Cost, whichever is lower. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database. | ||||||||||||||||||||||
| Extended Market Cost | Displays the Extended Market Cost, which is the product of Market Cost and On Hand Unit/Weight, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.
| ||||||||||||||||||||||
| Extended Standard Cost | Displays the Extended Standard Cost, which is the product of Standard Cost and On Hand Unit/Weight, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. Database Field: ERPx_IMLotCostHistory.Cost | ||||||||||||||||||||||
| As Of Date | Identifies the cutoff transaction date to view Inventory balances that occur on and before this date. This can be edited from the 'As Of Date' in the 'Filters' tab. Database Fields: ERPx_IMTransactionHeader.TransactionDate, ERPx_SOorderHeader.OrderDate | ||||||||||||||||||||||
| Cost Group | Displays the cost group of the item. On Hand Weight quantities. This value is not stored in the database.
| ||||||||||||||||||||||
| Item | Extended Actual
Insert excerpt | Def - Not Defined | Def - Not Defined | nopanel | true | . ←Tom, I thought this could go in the definition?Database Field: ERPx_ IMCostGroupIMItem. CostGroupID | Date Produced | ItemDescription | |||||||||||||||
| Lower of Cost or Market Cost | Displays either the Extended Actual Cost, which is the product of Actual Cost and On Hand Unit/Weight, assigned to the lotStandard Cost or the Market Cost, whichever is lower. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.
| Extended Lower of Cost or Market Cost | Displays either the Extended Standard Cost or the Extended Market Cost, whichever is lower. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.|||||||||||||||||||||
| Extended Market Cost | Displays the Extended Market Cost, which is the product of Market Cost and On Hand Unit/Weight, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.
| ||||||||||||||||||||||
| Extended Standard Cost | Displays the Extended Standard Cost, which is the product of Standard Cost and On Hand Unit/Weight, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. This can also be edited by updating On Hand Unit or On Hand Weight quantities. This value is not stored in the database.
| ||||||||||||||||||||||
| Item | | Insert excerpt | | Item ID & Item Description | Item ID & Item Description | |||||||||||||||||||
| nopanel | true | ||||||||||||||||||||||
| Market Cost | Displays the Market Cost, which is the sum of Market Base Cost and Market Layer Costs, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. Database Field: ERPx_IMLotCostHistory.MarketCost | ||||||||||||||||||||||
| On Hand Units |
| ||||||||||||||||||||||
| On Hand Weight |
| ||||||||||||||||||||||
| Owner Name |
Database Field: ERPx_IMLotOwner.OwnerName | ||||||||||||||||||||||
| Production Batch |
Database Field: ERPx_IMProductionLot.ProductionLotID | ||||||||||||||||||||||
| Site |
Database Fields: ERPx_MFSite.SiteID, ERPx_IMLotBalance.SiteSK | ||||||||||||||||||||||
| Standard Cost | Displays the Standard Cost, which is the sum of Standard Base Cost and Standard Layer Costs, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. Database Field: ERPx_IMLotCostHistory.StandardCost | ||||||||||||||||||||||
| Summarize By | Identifies how the search results are grouped. This comes from the 'Summarize By' inquiry parameter field in the 'Filters' tab. This is not stored in the database. | ||||||||||||||||||||||
| Unit UOM | Displays either the Standard Cost or the Market Cost, whichever is lower.
Database Field: ERPx ERPX_IMItem.ItemDescription | Lower of Cost or Market Cost | DefaultIMUnitUOMSK | ||||||||||||||||||||
| Warehouse Lot |
Database Field: ERPx_IMLotCostHistory.StandardCost or ERPx_IMLotCostHistory.MarketCost | Market Cost | Displays the Market Cost, which is the sum of Market Base Cost and Market Layer Costs, assigned to the lot. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List View. from the 'Warehouse Lot' field on the Warehouse Lots list view. When the 'Summarize By' inquiry parameter is set to "Item" or "Item and Owner", this field will be displayed as "**Not Included".
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK | ||||||||||||||||||||
| Weight UOM |
Database Field: ERPx_ IMLotBalance. | On Hand Units | On Hand Weight | Owner Name | Production Batch | Site | Standard Cost WeightUOMSK | ||||||||||||||||
| Year Produced | Displays the Standard Cost, year which is the sum of Standard Base Cost and Standard Layer Costs, assigned to the lotthe Production Patch was produced. This can be edited using the Mass Update dialog box on the Update Costs List View or the 'Update Costs From BOM' toolbar icon on the Update Costs List Viewfrom the 'Batch Date' field on the Properties tab of the Production Batch record view. When the 'Summarize By' inquiry parameter is set to "Item", "Item and Owner", "Item and Warehouse Lot" or "Item, Owner and Warehouse Lot", this field will be displayed as "**Not Included". | UOM - Units | |||||||||||||||||||||
| nopanel | true | Warehouse Lot | Weight UOM | ||||||||||||||||||||
| Insert excerpt | UOM - weight | UOM - weight | |||||||||||||||||||||
| nopanel | true | Year Produced Database Field: ERPx_IMLotCostHistory.StandardCost | Summarize By | Unit UOM | |||||||||||||||||||
| Insert excerpt | UOM - Units | IMProductionLot.DateProduced |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...