/
IM Cost Distribution Record View

IM Cost Distribution Record View

Sept 19, 2025

The purpose of this page is to distribute the cost of a single line item to one or more Lots.

Software Version: 2025.09.17 and newer

[ 1 Header Toolbar ] [ 1.1 Home Tab ] [ 1.2 Filters Tab ] [ 2 Transactions Grid ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Header Toolbar

Toolbar Icons

Description

Toolbar Icons

Description

Help

More Actions

  • RV: Journal Details - Opens the record view of the Journal Details.

  • RV: Source Transaction - Opens the Transaction Record View of the source AP Invoice or Credit Memo.

Save

Save & Close

Void

Home Tab

Fields

Description

Amount

Identifies the Amount (extended amount) of the transaction line item that is being distributed to one or more Lots. This is a non-editable text box that is required. This defaults from the 'Amount' of the transaction line item, is required, and is never editable.

Database Field: ERPx_IMCostDistribution.AmountToDistribute

Distributed Amt. 

The [Distributed Amt.] must equal the [Amount] to approve or post else the message "Distribution ID: [DistributionID] - You must fully distribute the Amount." will appear on Save.

Database Field: ERPx_IMCostDistribution.DistributedAmount

Distributed To

This is a single select lookup that is required. It defaults from the 'Distributed To' of the transaction line item and is editable when in a status of New. The options that apply to transactions in this Record View include the following values from the MFDistributionType Enumeration Class:

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ToMFDistributionTypeEN

Doc Date

 This is a non-editable text box that shows the 'Doc Date' of the source transaction. This is required.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionDate

Effective Date

Identifies the date that the cost will be applied to the Lot(s). This is a non-editable, computed value that is not stored in the database. It conditionally defaults based on the 'Distributed To' value. If the 'Distributed To' value is:

  • "Inventory Purchase" then this will default to "N/A".

  • "Additional Landed Cost" then this will default to "N/A".

  • "Additional Transaction Cost" then this will come from the 'Distribution Transaction Date' signifying that the Layer Cost will be applied on that date. 

  • "Add Layer" then this will come from the 'Distribution Transaction Date' signifying that the Layer Cost will be applied on that date. 

GL Date

 This is a non-editable text box that shows the 'GL Date' of the source transaction. This is required.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.GLDate

Lot Cost Amt.

 

Database Field: ERPx_IMCostDistribution.LotCostAmount

Reason Code

This is a single select lookup that defaults to blank, is not required, and is always editable when the record is in a status of New. The lookup contains all the 'Lot Cost Adjustment' Reason Codes. 

Database Field: ERPx_IMCostDistribution.ReasonCodeSK, ERPx_MFNoteTypeReasonCode.ReasonCode

Status

 This is a single-select lookup that is required. It defaults as "New" and is always editable until the transaction is Posted.

The statuses that apply to transactions in this Record View include:

Database Field: ERPx_IMCostDistribution.DistributionStatusSK

Undistributed Amt.

 

Database Field: ERPx_IMCostDistribution.RemainingAmount

Variance Amt.

Database Field: ERPx_IMCostDistribution.VarianceAmount

Filters Tab

Fields

Description

Date

 

This is required to return results and is always editable. this conditionally defaults based on the 'Distributed To' value. If the 'Distributed To' value is:

  • "Inventory Purchase" then this will default to "Last 30 days" 

  • "Additional Landed Cost" then this will default to "Last 30 days"

  • "Additional Transaction Cost" then this will default to the source transaction's 'Doc Date'

  • "Add Layer" then this will default to the source transaction's 'Doc Date'

Search

  • Item: [Item ID] or [Item Description]

  • Attr: [Attribute Value]

  • Batch: [Production Batch]

  • WLot: [Warehouse Lot] 

  • Owner: [Lot Owner]

  • Site: [Site ID] or [Site Name]

Site

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

The lookup contains a list of all active Sites.

Trans Type

This is a multi-select standard lookup that is not required to return results. This defaults based on the 'Distributed To' value. If the 'Distributed To' value is:

  • "Inventory Purchase" then this will default to Receipt but can be changed to Adjustment, Transfer Receipt, or Production Output

  • "Additional Landed Cost" then this will default to Production Output and Receipt but can be changed to Adjustment, Transfer Receipt.

  • "Additional Transaction Cost" then this will default to Transfer Receipt but can be changed to any or all of the other options.

  • "Add Layer" then this will default to All and can be set to any option.

The lookup contains the following options:

  • Adjustment

  • Production Output

  • Receipt

  • Transfer Receipt