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 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, 'Production Batches' attribute type, and the 'Warehouse Lots' attribute type. Additionally, this inquiry also contains columns for each Lot Certification with a certification 'Type' of "Item & Site". Item attributes, Production Batch attributes . 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: 20202024.xx12.xx 16 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".

...

type	flat

Page Header

Search

Filter Items

Description

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

Costing Method

A multi-select lookup to limit the results to Lots containing Items based on the Item's 'Costing Method'. This defaults to blank (All) and if left blank, all Costing Methods will be included. The lookup contains options for:

Active
Exclude from Costing
Passive

Costing Status

A single-select lookup to limit the results to Lots that are either Open or Closed for Costing. This defaults to 'Open' but can be changed to 'Closed'.

This lookup contains the values in the LayerCostingStatus Enumeration Class.

Effective Date

Insert excerpt

	Date Control Text Box
	Date Control Text Box
nopanel	true

This is used to limit the Cost Layers based on their Effective Data. This defaults to "last 30 Days" but can be changed.

Include

A single-select lookup to allow the user to include voided cost history records in the grid.

Item

Insert excerpt

Inq -

	Item ID & Item Description

Inq -

	Item ID & Item Description
nopanel	true

This

This is

a multi

a multi-select

standard

lookup

that is required

to

return results. If defaults as blank

limit the results to Lots for one or more associated Items. This defaults to blank (All) and if left blank, all Items will be included.

Insert excerpt

	Def - Item ID
	Def - Item ID
nopanel	true

The lookup contains a list

of all Items in the Items master file

of all Items displayed as [Item ID]: [Item Description].

Item Class

Insert excerpt

	Inq - Item Class
	Inq - Item Class
nopanel	true

This

This is

a multi

a multi-select

standard

lookup

that is required

to

return results. If defaults as blank.

limit the results to Lots containing Items based on the Item's 'Item Class'. This defaults to blank (All) and if left blank, all Item Classes will be included.

Insert excerpt

	Def - Item Class
	Def - Item Class
nopanel	true

The lookup contains a list of all Item Classes displayed as [Item Class ID]: [Item Class Description].

Lot Owner

Insert excerpt

Def

	Inq -

Item Class

Lot Owner

Def

	Inq -

Item Class

Lot Owner
nopanel	true

The lookup contains a list of all Item Classes.

Layer Costing StatusUsed to select one or more Cost Types to include. This

This is a multi-select

standard

lookup

that is required to return results. It defaults to all Cost Types

to limit the results to Lots that are assigned to one or more owners. This defaults to blank (All) and if left blank, all Owners will be included.

Insert excerpt

	Def -

Not Defined

Owner
	Def -

Not DefinedLot Owner

Owner
nopanel	true

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

Inq - Lot Owner

The lookup contains a list of all Lot Owners.

Reason Code

Insert excerpt

Inq - Lot Owner

Reason Code - Cost Layer
	Reason Code - Cost Layer
nopanel	true

This is

a multi

a multi-select

standard

lookup

that is required

to

return results. It defaults to all Lot Owners

limit the results to Cost Layers containing the Reason Code(s) selected. This defaults to blank (All) and if left blank, all Cost Layers will be selected regardless of the Reason Code.

Insert excerpt

	Def -

Lot - Owner

Reason Code
	Def -

Lot - Owner

Reason Code
nopanel	true

The lookup contains a list

of all Lot Owners.

of all the 'Lot Cost Adjustment' Reason Codes.

Saved Searches

Insert excerpt

	Search Options for Framework 3.0 - Global
	Search Options for Framework 3.0 - Global
nopanel	true

Search

Insert excerpt

Inq

	Search - Search Options

Inq

	Search - Search Options
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.

Attr: [Attribute Value]
Item: [Item ID] or [Item Description]
Owner: [Lot Owner]
Batch: [Production Batch]
Site: [Site ID] or [Site Name]
WLot: [Warehouse Lot]

Site

Insert excerpt

Inq -

	Site ID & Name

Inq -

	Site ID & Name
nopanel	true

This

This is a multi-select

standard

lookup

that is required

to

return results. It defaults as blank

limit the results to Lots that are in one or more Sites. This defaults to blank (All) and if left blank, all Sites will be included.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

The lookup contains a list of all active

Sites.Transaction Date

Sites displayed as [Site ID]: [Site Name].

Page Detail

Inq - Transaction Date

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

Inq - Transaction Date

Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
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

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

Grid Options for Kendo

	Favorites Add/Remove - Global

Grid Options for Kendo

	Favorites Add/Remove - 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

Toolbar Icons

Description

Excel

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Excel - LV

Insert excerpt

Excel - LV

Help - Global 3.0
	Help - Global 3.0
nopanel	true

FavoritesQuick Column FilterFavorites Add/Remove - Global

Insert excerpt

Favorites Add/Remove - Global

Quick Column Filter
	Quick Column Filter
nopanel	true

Grid LayoutRefresh

Insert excerpt

Grid Layout for Kendo

	Refresh - Global

Grid Layout for Kendo

3.0
	Refresh - Global 3.0
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. HelpSaved Layouts

Insert excerpt

Help

	Column Layouts for Framework 3.0 - Global

Help

	Column Layouts for Framework 3.0 - Global
nopanel	true

RefreshSearch OptionsRefresh - Global

Insert excerpt

Refresh - Global

Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

ViewOpens the Shipment Details Record View, which displays shipment details for the selected transaction.

FieldsDescriptionBOL

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

Corrected From

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

Cost GroupDisplays the cost group attached to the item. This can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record ViewCheckbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Actual Cost Rate

Identifies the cost rate assigned to the Actual Cost Layer. This can only be edited by adding/editing an 'Actual Cost Layer' or adding/updating an 'Actual Cost Base'.

Insert excerpt

	Def - Cost

Group

Rate - Actual
	Def - Cost

Group

Rate - Actual
nopanel	true

Database Field: ERPx_

IMCostGroup.CostGroupIDDateDisplays the date of the inventory transaction. This can be edited from the 'Date

IMLotCostHistory.Cost

Batch Comment

Insert excerpt

	Batch Comment
	Batch Comment
nopanel	true

This is not required and is always editable from the 'Batch Comment' field on the

'Home'

Properties tab of the

Transaction Record View for Adjustment, Production and Receipt transactions while the transaction is in a Status of New.

Production Batch record view.

Database Field: ERPx_IMProductionLot.LotComment

Batch Date

Insert excerpt

	Def - Batch Date
	Def - Batch Date
nopanel	true

This can be edited from the '

Transferred On

Batch Date' field on the

'Home'

Properties tab of the

Transaction

Production Batch Record View

for a Transfer transactions while the transaction is in a Status of New.

.

Database Field: ERPx_

IMTransactionHeader

IMProductionLot.

TransactionDateItem Attribute Class

DateProduced

Batch Site IDItem Attribute Class

Insert excerpt

Item Attribute Class

Batch Site
	Batch Site
nopanel	true

This

can be edited

is required and is always editable from the '

Item Attribute Class' selected

Batch Site ID' field on the Properties tab of the

Item

Production Batch Record View.

Insert excerptDef - Attribute ClassDef - Attribute Classnopaneltrue

Database Fields: ERPx_

MFAttributeClass

MFSite.

ClassDescription

SiteID,

ERPX

ERPx_

IMItem

MFSite.

AttributeClassSK

SiteName, ERPx_

IMTransactionDetail

IMProductionLot.

ItemSK
Item Insert excerptItem ID & Item DescriptionItem ID & Item Descriptionnopaneltrue 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.

ManufactureSiteSK

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

Born on Date

Insert excerpt

	Def -

Item ID

Born on Date
	Def -

Item ID

Born on Date
nopanel	true

This is a system assigned value that is not editable.

Database Fields: ERPx_

IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSKGL Date

IMLotBalance.BornOnDate

Cost Group Description

GL Date

Insert excerpt

GL Date

Cost Group Description
	Cost Group Description
nopanel	true

This is not required and can be edited from the 'GL DateCost Group' field property on the 'Properties' tab of the Transaction Item Record View while the transaction is in a Status of New. .

Insert excerpt

	Def - Cost Group
	Def - Cost Group
nopanel	true

Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_

IMTransactionHeader.GLDate

Owner

IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK

Cost UOM

Insert excerpt

Owner

	UOM -

Inventory Lot

Cost

Owner

	UOM -

Inventory Lot

Cost
nopanel	true

This is required for Costing and can be edited from the 'OwnerCost UOM' field property on the Items grid 'Advanced Properties' tab of the Transaction Item Record View while the transaction is in a Status of New.

Insert excerpt

	Def -

Lot - Owner

UOM
	Def -

Lot - Owner

UOM
nopanel	true

Database FieldFields: ERPx_IMLotOwnerIMItem.OwnerNameCostUOMSK

Production Batch

Insert excerptProduction BatchProduction Batchnopaneltrue Clicking on the link opens the Production Batch Record ViewCosting Method

Identifies the Costing Method assigned to the Item ID. This can only be edited from the '

Production Batch

Costing Method'

field

property on the 'Advanced Properties' tab of the

Production Batch Record View.
Insert excerptDef - Lot - Production BatchDef - Lot - Production Batchnopaneltrue

Database Field: ERPx_IMProductionLot.ProductionLotID

Production Batch Date Insert excerptProduction Batch DateProduction Batch Datenopaneltrue

Item Record View.

Database Fields: ERPx_IMLotBalance.ItemSK, ERPx_IMItem.ValuationMethodEN

Costing Status

Displays whether cost changes can be made to the Lot. If the Costing Status is "Open" then cost changes can be made. If the Costing Status is "Closed" then cost changes cannot be made to the Lot.

This can be edited from the '

Batch Date' field on the Properties tab of the Production Batch Record View.

Database Field: ERPx_IMProductionLot.DateProduced

Production Batch Site

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

Production Batch Site

Insert excerpt

Production Batch Site

Country of Origin
	Country of Origin
nopanel	true

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

Database Fields:ERPx_MFSite.SiteID, Field: ERPx_MFSite.SiteName, ERPx_IMProductionLot.ManufactureSiteSKCountryOfOrigin

QuantityDisplays the unit quantity or weight quantity of the item in the default reporting UOMDays Old

Displays the calculated age (in days) of the Production Batch. It is calculated as the (Current Date) - [Batch Date]. This can be edited

from

by changing the '

Units' field or 'Weight

Batch Date' 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

Reference

Properties tab of the Production Batch record view. This is not stored in the database.

This is a calculated field that is not stored in the database.

Days Until ExpirationReference

Insert excerpt

Reference

Days Until Expiration
	Days Until Expiration
nopanel	true

This can be edited from the 'Reference' field of the 'Home' tab of the Transaction Record View while the transaction is in a Status of New

This is a calculated field that is not stored in the database.

Effective Date

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_

IMTransactionHeader

IMLotCostHistory.

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

EffectiveDate

Expiration DateDef - Site

Insert excerpt

Def - Site

Batch Expiration Date
	Batch Expiration Date
nopanel	true

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

Status

This is editable from the Production Batch Record View.

Database Field: ERPx_IMProductionLot.ExpirationDate

Inventory Balance Sheet AccountTransaction Insert excerptTransaction IDTransaction IDnopaneltrue Clicking on the link opens the Transaction Record View for the associated record. This value is system generated when the transaction is created and is not editable.
Insert excerptDef - Transaction IDDef - Transaction ID

Status

Insert excerpt

Status

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

For inventory transactions, this This can be edited from the 'StatusInventory Balance Sheet' field on the 'HomeGL Accounts' tab of the Adjustment, Production, Receipt and Transfer Record View and represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'. For sales transactions, SO Shipments and SO Returns will only ever display if the transaction has been Posted.
Insert excerptDef - StatusDef - Statusnopaneltrue The Statuses that apply to transactions in this inquiry include: Insert excerptDef - Status - OpenDef - Status - Opennopaneltrue Open transactions are transactions in a status of New or Approved. Insert excerptDef - Status - PostedDef - Status - Postednopaneltrue Posted transactions are transactions in a status of Ready to Post or Posted. Insert excerptDef - Status - VoidDef - Status - Voidnopaneltrue

Database Fields: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK

Traded

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

Item Record View.

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

Is Lot Expired

A Yes/No field to identify if a Lot is expired.

This will display as "Yes" For Lots with a 'Batch Expiration Date' that is <= the current date.
This will display as "No" for Lots without a 'Batch Expiration Date' or for Lots with a 'Batch Expiration Date' that is >= the current date.

This is a calculated field that is not stored in the database.

Item: Description

Insert excerpt

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

The 'Item ID' and/or the 'Item Description' can be edited from 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.ItemDescription, ERPh_IMTransactionDetail.ItemSK

Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

Database Field: ERPx_

IMTransactionHeader

IMLotCostHistory.

TransactionID
Transaction Class

LastUpdated

Last Updated ByTransaction Class

Insert excerpt

Transaction Class

Last Updated By
	Last Updated By
nopanel	true

This comes from the 'Transaction Class' property on the 'Properties' tab of the Transaction Class Record View for the associated transaction. This is not editable after the Transaction Class has been saved.

Database Field: ERPx_IMLotCostHistory.LastUser

Market Cost Rate

Identifies the cost rate assigned to the Market Cost Layer. This can only be edited by adding/editing a 'Market Cost Layer' or adding/updating a 'Market Cost Base'.

Insert excerpt

	Def -

Transaction Class

Cost Rate -

General

Market
	Def -

Transaction Class

Cost Rate -

General

Market
nopanel	true

Database Field: ERPX_IMTransactionClass.TransactionClassID, ERPx_IMTransactionHeaderIMLotCostHistory.TransactionClassSKMarketCost

Transaction TypeOwner

Transaction Type

Insert excerpt

Transaction Type

Owner - Inventory Lot
	Owner - Inventory Lot
nopanel	true

This comes from the 'Transaction Type' property on the 'Properties' tab of the Transaction Class Record View for the associated transaction. This is not editable after the Transaction Class has been saved. This cannot be edited, ownership for an existing Lot can only be changed via a Transfer Transaction.

Insert excerpt

	Def -

Transaction Types

Owner
	Def -

Transaction Types

nopanel
Owner

true

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

Units UOM

	true

Database Field: ERPx_IMLotOwner.OwnerName

Production Batch

UOM - Default IM Units

Insert excerpt

UOM - Default IM Units

Production Batch
	Production Batch
nopanel	true

This

field

can be edited from the '

Inventory Unit UOM' property

Production Batch' field on the

'

Properties

'

tab of the

Item

Production Batch Record View.

Insert excerpt

	Def - Production Batch
	Def - Production Batch
nopanel	true

Insert excerpt

	Def -

UOM

Inventory Lot
	Def -

UOM

Inventory Lot
nopanel	true

Database Field: ERPx_

IMTransactionDetail.EffectOnInventoryUnitsUOMSKUnits

IMProductionLot.ProductionLotID

Reason Code

Insert excerpt

	Reason Code - Cost Layer
	Reason Code - Cost Layer
nopanel	true

This can only be assigned when adding/editing a Cost Layer or adding/updating a Base Cost.

Insert excerpt

Units

	Def -

On Hand

Reason Code

Units

	Def -

On Hand

Reason Code
nopanel	true

This

Database Fields: ERPx_MFNoteTypeReasonCode.ReasonCode, ERPx_IMLotCostHistory.ReasonCodeSK

Received From

Identifies the name of the Vendor, Fisherman, or Grower that the product was received from. If there is only one 'Received From' identified on the Production Batch, the name will be displayed. If there is more than one 'Received from' identified on the Production Batch, the word "Multiple" will be displayed. This can be edited from the '

Units

Rec. From' header field

of the line item in the Items grid on the Transaction Record View while the transaction is in a Status of New.

Database Field: ERPx_IMTransactionDetail.EffectOnInventoryUnits

UOM

on the Inventory Receipt record view before the transaction is posted or from the Production Batch Record View at any time.

Database Fields: ERPx_IMLotBalance.ProductionLotSk, ERPx_IMReceivedFrom.ReceivedFrom

Site ID

Displays the Site ID for the Site where the inventory balances are stored. This is always editable from the Sites Record View.

Insert excerpt

UOM

	Def -

Default Reporting

Site

UOM

	Def -

Default Reporting'Default Reporting UOM' property on the 'Properties' tab of the Item Record View.

Database Field: ERPX_IMItem.DefaultReportingUOMSK

UOM Schedule

Site
nopanel	true

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteID,

This can be edited from the

ERPh_IMTransactionHeader.SiteSK

Site NameDisplays the date the transaction was voided. This field comes from the 'Void/Correct GL Date' field for a transaction line on the Transaction More Actions Record View and is not editable after the void action has been processed

Displays the Site Name for the Site where the inventory balances are stored. This is always editable from the Sites Record View.

Insert excerpt

UOM

	Def -

Schedule

Site

UOM

	Def -

Schedule

Site
nopanel	true

This field comes from the 'UOM Schedule' property on the 'Properties' tab of the Item Record View and is not editable.

Database Fields: ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.ItemSK

Void Date

Database Fields: ERPx_MFSite.SiteName, ERPx_IMLotBalance.SiteSK

Source

Identifies how the Cost Layer was added. This is automatically assigned based on how the costs were assigned and is not editable. The options include:

BOM
Inherited
Item Default - Base
Manual - Base
Manual - Layer
Transaction Base
Transaction Layer

ERPx_IMLotCostHistory.LotCostTypeEN

Source Transaction

Identifies the Cost Distribution transaction that added the Cost History record.

Database Fields: ERPx_IMTransactionHeader.VoidDate

Warehouse Lot

IMLotBalance.LotSK, ERPx_IMLotCostHistory.SourceTransaction

Storage Begin Date

Insert excerpt

Warehouse LotWarehouse Lotnopaneltrue 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.

	Def - Storage Begin Date
	Def - Storage Begin Date
nopanel	true

This can only be edited on the Warehouse Lot List View.

Database Fields: ERPx_IMWarehouseLot.StorageRenewalDate

Storage Renewal Day

Insert excerpt

	Def -

Lot - Warehouse Lot

Storage Renewal Day
	Def -

Lot - Warehouse Lot

Storage Renewal Day
nopanel	true

This can only be edited by editing the 'Storage Begin Date' on the Warehouse Lot List View

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

Weight

StorageRenewalDay

UOM Schedule

Insert excerpt

Weight

	UOM -

On Hand

Schedule

Weight

	UOM -

On Hand

Schedule
nopanel	true

This

can be edited

field comes from the '

Weight' field of the line item in the Items grid on the Transaction Record View while the transaction is in a Status of New.

Database Field: ERPx_IMTransactionDetail.EffectOnInventoryWeight

Weight UOM

UOM Schedule' property on the 'Properties' tab of the Item Record View and is not editable from here.

Database Fields: ERPx_IMItem.UOMScheduleSK, ERPh_IMTransactionDetail.ItemSK

Warehouse LotUOM - Default IM Weight

Insert excerpt

UOM - Default IM Weight

Warehouse Lot
	Warehouse Lot
nopanel	true

This

field

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

Warehouse Lot
	Def - Warehouse Lot
nopanel	true

Insert excerpt

	Def - Inventory Lot
	Def -

UOM

Inventory Lot
nopanel	true

Database

Field

Fields: ERPx_

IMTransactionDetail.EffectOnInventoryWeightUOMSK

IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

VoidedIdentifies whether the Cost History record was voided.

Version	Old Version 1	New Version Current
Changes made by	Janice Dannenberg	Emma Greenwood
Saved on	Aug 24, 2020	Dec 16, 2024

Versions Compared

Key

Page Header

Filters

Page Header

Search

Page Detail

Header Toolbar

Related Topics

Page Definitions

Technical Details

Page Comparison

Versions Compared

Key

Page Header

Filters

Page Header

Search

Page Detail

Header Toolbar

Related Topics

Page Definitions

Technical Details