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

type	flat

Page Header

Filters

...

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

...

This lookup contains the value "Voids".

...

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

...

The lookup contains a list of all Item Classes.

...

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.

...

This lookup contains the values in the ?????????????? Enumeration Class.

...

The lookup contains a list of all Lot Owners.

...

The lookup contains a list of all active Sites.

...

Header Toolbar

...

Displays the BOL ID entered on the transaction. This field is specific to the Transfer transaction. This can be edited from the 'BOL' field on the 'Home' tab of the Transfer Transaction Record View while the transaction is in a Status of New.

Database Field: ERPx_IMTransactionHeader.BOL

...

Displays the Transaction ID of the source transaction that was corrected. This field only displays a value if the transaction has been corrected. This is not editable.

Database Field: ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK

...

Displays the cost group attached to 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

...

Displays the date of the inventory transaction. This can be edited from the 'Date' field on the 'Home' tab of the Transaction Record View for Adjustment, Production and Receipt transactions while the transaction is in a Status of New. This can be edited from the 'Transferred On' field on the 'Home' tab of the Transaction Record View for a Transfer transactions while the transaction is in a Status of New.

Database Field: ERPx_IMTransactionHeader.TransactionDate

...

Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPX_IMItem.AttributeClassSK, ERPx_IMTransactionDetail.ItemSK

...

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

...

Database Field: ERPx_IMTransactionHeader.GLDate

...

Database Field: ERPx_IMLotOwner.OwnerName

...

Production Batch

...

Database Field: ERPx_IMProductionLot.ProductionLotID

...

Database Field: ERPx_IMProductionLot.DateProduced

...

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSK

...

Displays the unit quantity or weight quantity of the item in the default reporting UOM. This can be edited from the 'Units' field or 'Weight' field of a line item on the Items grid of the Transaction Record View while the transaction is in a Status of New.

Database Fields: ERPx_IMTransactionDetail.EffectOnInventoryUnits or ERPx_IMTransactionDetail.EffectOnInventoryWeight

...

Database Field: ERPx_IMTransactionHeader.Reference

...

Displays the Site Name and Site ID at which the transaction affects the lot's balance. This comes from the 'Site' field on the 'Home' tab of the Transaction Record View. This is not editable after the transaction has been saved.

...

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

...

Database Fields: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK

...

Specifies if the Production Batch has been traded. 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.

Database Field: ERPx_IMProductionLot.Traded

...

Database Field: ERPx_IMTransactionHeader.TransactionID

...

Database Field: ERPX_IMTransactionClass.TransactionClassID, ERPx_IMTransactionHeader.TransactionClassSK

...

The SO Shipment and SO Return transaction types only displays when the corresponding invoice is posted.

Database Field: ERPx_IMTransactionType.TransactionTypeID, ERPx_IMTransactionType.TransactionTypeDescription, ERPx_IMTransactionHeader.TransactionTypeSK

...

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

type	flat

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.

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.

Header Toolbar

Units On HandUnits On HandUnits of line item in the on IMTransactionDetail.EffectOnInventoryUnits

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

Batch Comment

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

Cost Group

Displays the cost group attached to the item. 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

Cost Type

Cost UOM

Costing Status

Country of Origin

Days Since Received

Effective

Inventory Balance Sheet Account

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 -

UOM

Item ID
	Def -

UOM

Item ID
nopanel	true

Database

Field:

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

EffectOnInventoryUnitsUOMSK

Units

ItemSK

Label Code

Market

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

Database Field: ERPx_

UOM

IMLotOwner.OwnerName

Outside Purchase

Production Batch

UOM - Default Reporting

Insert excerpt

UOM - Default Reporting

Production Batch
	Production Batch
nopanel	true

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

Default Reporting UOM' property

Production Batch' field on the

'

Properties

'

tab of the

Item

Production Batch Record View.

Insert excerpt

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

Database Field:

ERPX

ERPx_

IMItem

IMProductionLot.

DefaultReportingUOMSK

ProductionLotID

UOM ScheduleProduction Site

UOM - Schedule

Insert excerpt

UOM - Schedule

Production Batch Site
	Production Batch Site
nopanel	true

This field comes can be edited from the 'UOM Schedule' property Production Batch Site' field on the ' Properties ' tab of the Item Production Batch Record View and is not editable.

Database Fields: ERPX_IMItem.UOMScheduleSKERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMTransactionDetail.ItemSK

Void DateDisplays the date the transaction was voided. This field

IMProductionLot.ManufactureSiteSK

Reason Code

Received
Site

Insert excerpt

	Site ID
	Site ID
nopanel	true

This comes from the '

Void/Correct GL Date

Site' field

for a transaction line

on the

Transaction More Actions

'Home' tab of the Transaction Record View

and

. This is not editable after the

void action

transaction has been

processed

saved.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.

VoidDate

SiteSK

Warehouse LotSite Name

Insert excerpt

Warehouse Lot

	Site

Warehouse Lot

	Site
nopanel	true

This

value defaults

comes from the '

Warehouse Lot

Site'

value specified on

field on the 'Home' tab of the Transaction Record View

that created the Inventory Lot

. This

can be edited from the 'Warehouse Lot' field on the Warehouse Lots List View

is not editable after the transaction has been saved.

Insert excerpt

	Def -

Lot - Warehouse Lot

Site
	Def -

Lot - Warehouse Lot

Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_

IMWarehouseLot

MFSite.

WarehouseLotID

SiteID, ERPx_

IMLotBalance.WarehouseLotSKWeight

IMTransactionHeader.SiteSK

Source
Standard
TradedWeight - On Hand

Insert excerpt

Weight - On Hand

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 '

Weight

Traded' field

of the line item in the Items grid

on the

Transaction Record View while the transaction is in a Status of New.

Properties tab of the Production Batch record view.

Database Field: ERPx_

IMTransactionDetail.EffectOnInventoryWeightWeight UOM

IMProductionLot.Traded

Updated
Updated By
Vendor Purchased From

Warehouse LotUOM - Default IM Weight

Insert excerpt

UOM - Default IM Weight

Warehouse Lot
	Warehouse Lot
nopanel	true

This field

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 '

Inventory Weight UOM' property on the 'Properties' tab of the Item record view

Warehouse Lot' field on the Warehouse Lots List View.

Insert excerpt

	Def -

UOM

Lot - Warehouse Lot
	Def - Lot -

UOM

Warehouse Lot
nopanel	true

Database

Field:

Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_

IMTransactionDetail

IMLotBalance.

EffectOnInventoryWeightUOMSK

WarehouseLotSK

Version	Old Version 1	New Version 2
Changes made by	Janice Dannenberg	Janice Dannenberg
Saved on	Aug 24, 2020	Aug 24, 2020

Versions Compared

Key

Page Header

Filters

Header Toolbar

Page Header

Filters

Header Toolbar

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Filters

Header Toolbar

Page Header

Filters

Header Toolbar

Related Topics

Page Definitions