Page Comparison

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 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

...

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.

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

The lookup contains the values "NON-INV', "Item" and "Lot".

Include

Insert excerpt

	Inq - Include
	Inq - Include
nopanel	true

This is a multi-select standard lookup that is not required to return results. If defaults to blank.

This lookup contains the value "Voids".

Item

Insert excerpt

	Inq - Item
	Inq - Item
nopanel	true

This is a multi-select standard lookup that is required to return results. If defaults as blank.

Insert excerpt

	Def - Item ID
	Def - Item ID
nopanel	true

The lookup contains a list of all Items in the Items master file.

Item Class

Insert excerpt

	Inq - Item Class
	Inq - Item Class
nopanel	true

This is a multi-select standard lookup that is required to return results. If defaults as blank.

Insert excerpt

	Def - Item Class
	Def - Item Class
nopanel	true

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

This lookup contains the values in the LayerCostingStatus Enumeration Class.

Lot Owner

Insert excerpt

	Inq - Lot Owner
	Inq - Lot Owner
nopanel	true

This is a multi-select standard lookup that is required to return results. It defaults to all Lot Owners.

Insert excerpt

	Def - Lot - Owner
	Def - Lot - Owner
nopanel	true

The lookup contains a list of all Lot Owners.

Search

Insert excerpt

	Inq - Search
	Inq - Search
nopanel	true

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

Insert excerpt

	Inq - Site
	Inq - Site
nopanel	true

This is a multi-select standard lookup that is required to return results. It defaults as blank.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

The lookup contains a list of all active Sites.

Transaction Date

Insert excerpt

	Inq - Transaction Date
	Inq - Transaction Date
nopanel	true

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

Insert excerpt

	Search Options for Kendo - Global
	Search Options for Kendo - Global
nopanel	true

→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.

...

This Inventory Balance Sheet' field Accounts Recrod GLAccountAccountNumberGLAccount.Description, ERPx_InventoryActSKItem ID & Item Description The 'Item ID' field is not editable. The Item Description Item Description property Item

Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSK

Production This can be edited from the 'Production Batch Site' field on the Properties tab of the Production Batch Record MFSiteSiteIDMFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK

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

→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

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

Refresh

Insert excerpt

	Refresh - Global
	Refresh - Global
nopanel	true

Fields

Description

Actual

Insert excerpt

	Actual Cost
	Actual Cost
nopanel	true

This can This field cannot be edited from once the 'Actual Cost' field is applied on the Mass Update dialog box launched from the Update Costs List View. This can also be edited clicking the Update Costs From BOM toolbar icon on the Update Costs List View.

Database Field: ERPx_IMLotCostHistory.Cost

Batch Comment

Insert excerpt

	Batch Comment
	Batch Comment
nopanel	true

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

Insert excerpt

	Production Batch Date
	Production Batch Date
nopanel	true

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

Insert excerpt

	Cost Group
	Cost Group
nopanel	true

This can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View.

Insert excerpt

	Def - Cost Group
	Def - Cost Group
nopanel	true

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

Insert excerpt

	UOM - Cost
	UOM - Cost
nopanel	true

This can be edited from the 'Cost UOM' property on the 'Properties' tab of the Item Record View.

Insert excerpt

	Def - UOM
	Def - UOM
nopanel	true

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

Insert excerpt

	Country of Origin
	Country of Origin
nopanel	true

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

Insert excerpt

	Days Since Received
	Days Since Received
nopanel	true

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 or ERPx_MPBOMCostHistory.EffectiveDate

Inventory Balance Sheet Account

Insert excerpt

	GL Account - Inventory Balance SheetGL Account - Inventory Balance Sheet
	GL Account - Inventory Balance Sheet
nopanel	true

This can be edited from the 'Inventory Balance Sheet' field on the 'Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK

ItemID: Description

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

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.

Insert excerpt

	Def - Item ID
	Def - Item ID
nopanel	true

Database Fields: ERPx_

IMItem.

ItemID, ERPx_

IMItem.

ItemID: Description

ItemDescription

Label Code

Insert excerpt

Item ID & Item Description

Label Code
	Label Code
nopanel	true

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

Insert excerpt

Def - Item ID

nopanel

true

Label Code

Market

	Market Cost
	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

Insert excerpt

	Owner - Inventory Lot
	Owner - Inventory Lot
nopanel	true

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.

Insert excerpt

	Def - Lot - Owner
	Def - Lot - Owner
nopanel	true

nopanel	true

Database Field: ERPx_IMLotOwner.OwnerName

Outside Purchase

Insert excerpt

	Outside Purchase
	Outside Purchase
nopanel	true

This can be edited from the 'Outside Purchase' field on the 'Properties' tab of the Production Batch Record View.

Database Field: ERPx_IMLotOwnerIMProductionLot.OwnerNameIsOutsidePurchase

Outside Purchase

Production Batch

Insert excerpt

	Production Batch
	Production Batch
nopanel	true

Clicking on the link opens the Production Batch Record View. This can be edited from the 'Production Batch' field on the 'Properties' tab of the Production Batch Record View.

Insert excerpt

	Def - Lot - Production Batch
	Def - Lot - Production Batch
nopanel	true

Database Field: ERPx_IMProductionLot.ProductionLotID

Production Site

Insert excerpt

	Batch Site
	Batch Site
nopanel	true

This can be edited from the 'Production Batch Site

nopanel

true

' field on the 'Properties' tab of the Production Batch Record View. --THIS IS NOT CURRENTLY HAPPENING...

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_

Reason Code

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

This comes from the 'Site' field on the 'Home' tab of the Transaction Record ViewView that created the Inventory Lot. This is not editable after the transaction has been saved.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_MFSite.SiteID, ERPx_IMTransactionHeaderIMLotBalance.SiteSK

Site Name

Insert excerpt

	Site
	Site
nopanel	true

This comes from the 'Site' field on the 'Home' tab of the Transaction

Record View

Record View that created the Inventory Lot. This is not editable after the transaction has been saved.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName,

ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.SiteSK

Source

Standard

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

Insert excerpt

	Standard Cost
	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

Insert excerpt

	Traded
	Traded
nopanel	true

Displays "Yes" if the 'Traded' field has been set to "Yes" on the Production Batch Record or blank if the field has been set to "No".

This can be edited from the 'Traded' field on the 'Properties' tab of the Production Batch

record view

Record View.

Database Field: ERPx_IMProductionLot.Traded

Updated

Updated By

Vendor Purchased From

Warehouse Lot

Insert excerpt

	Warehouse Lot
	Warehouse Lot
nopanel	true

This value defaults from the 'Warehouse Lot' value specified on the Transaction Record View that created the Inventory Lot. This can be edited from the 'Warehouse Lot' field on the Warehouse Lots List View.

Insert excerpt

	Def - Lot - Warehouse Lot
	Def - Lot - Warehouse Lot
nopanel	true

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

...

Version	Old Version 4	New Version 5
Changes made by	Janice Dannenberg	Janice Dannenberg
Saved on	Sept 01, 2020	Sept 01, 2020

Versions Compared

Key