/
IM Cost Distributions List View

IM Cost Distributions List View

Sept 19, 2025

 The purpose of this page is to view undistributed cost items, distribute them to Lots, and post them.

Software Version: 2025.09.17 and newer

[ 1 Page Header ] [ 1.1 Related Topics ] [ 1.1.1 Page Definitions ] [ 1.1.2 Technical Details ]

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Edit

Excel

Favorites

Group By Show/Hide

Help

Mass Update

  • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.

More Actions

 

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

Quick Column Filter

Refresh

Saved Layouts

Void

Because there are numerous reasons to void a Cost Distribution line, voiding only removes it from the list view, it does not impact the General Ledger. Any Cost Distribution line that is voided must be evaluated and if necessary, a manual journal entry will need to be created and posted. 

Fields

Description

Checkbox

Amount

 This is required and is calculated as [Quantity] * [Price] for each transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase, and negative lines represent a purchase credit.

Database Field: ERPx_IMCostDistribution.AmountToDistribute, APTransactionLine.ExtendedAmount

Created

Database Field: ERPx_IMCostDistributionCreatedDate

Created By

Database Field: ERPx_IMCostDistribution.CreatedBy

Distributed Amt.

A calculated field that displays the sum of the [Distributed Amt.] from each Lot. The [Distributed Amt.] must equal [Amount] to approve or post else the message "Distribution ID: [DistributionID] - You must fully distribute the Amount." will appear.

Database Field: ERPx_IMCostDistribution.DistributedAmount

Distributed To

 The options that apply to transactions in this List View include:

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ToMFDistributionTypeEN

Distribution ID

 Clicking on this link opens the Cost Distribution Record View for the selected record. This is a system assigned number that is not editable by users.

Database Field: ERPx_IMCostDistribution.DistributionID

Doc Date

 This is the 'Doc Date' of the source AP Invoice or Credit Memo.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionDate

Doc No

 This is the 'Doc No' of the source AP Invoice or Credit Memo.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.DocNumber

GL Date

This is the 'GL Date' of the source AP Invoice or Credit Memo.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.GLDate

GL Period

This is the 'GL Period' of the source AP Invoice or Credit Memo.

GL Year

This is the 'GL Year' of the source AP Invoice or Credit Memo.

Item ID

 

  

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemID

Item Type

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemTypeSK

Last Updated

Database Field: ERPx_IMCostDistribution.LastUpdated

Last Updated By

Database Field: ERPx_IMCostDistribution.LastUser

Line Comment

 

This is not required and is always editable even after the transaction is posted.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_APTransactionLine.LineComment

Line Description

 This is a textbox that defaults to Item Description for the corresponding Item and is editable from the record view while in 'New' status.

Database Fields: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_APTransactionLine.LineDescription

Ln. 

Database Fields: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.LineNumber

Lot Cost Amt.

A calculated field that displays the sum of the [Lot Cost Amt.] from each Lot the cost is being distributed to. This reflects the amount that will post to the General Ledger Lot Cost.  

Database Field: ERPx_IMCostDistribution.LotCostAmount

PO Ln.

 

Identifies the Purchase Order line item that the AP Invoice/Credit Memo line item is linked to.  

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.POLineSK

Purchase GL Account

 

 This will be the account that is Credited if the source transaction is an AP Invoice or Debited if the source transaction is an AP Credit Memo.

Database Fields: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.AccountSK, ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description

Status

 This is required and can be edited from 'Mass Update' or from the transaction record view. This represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

 The Statuses that apply to transactions in this List View include:

Database Fields: ERPx_IMCostDistribution.DistributionStatusSK 

Transaction

 This is the Transaction ID of the source transaction.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionID

Transaction Class ID

 

 This is the Transaction Class of the source transaction. 

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APTransactionClass.TransactionClassDescription

Transaction Type

 This is the Transaction Type of the source transaction.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APTransactionType.TransactionName 

Undistributed Amt.

A calculated field that displays the difference between the header [Amount] and the sum of the [Distributed Amt.] from each Lot. This shows how much still needs to be distributed before the line item can be approved or posted. The [Distributed Amt.] must equal $0.00 to 'Approve' or 'Post' else the message: "Distribution ID: [DistributionID] - You must fully distribute the Amount." will appear. 

Database Field: ERPx_IMCostDistribution.RemainingAmount

Variance Amt.

A calculated field that displays the difference between the header [Amount] and the sum of the [Lot Cost Amt.] from each Lot.

This will always show a value when the [Amount] has not been fully distributed or when [Lot Cost Amt.] does not equal the [Amount] due to rounding a two-digit cost amount to a 5-digit Lot Cost Amount. This amount will post to the General Ledger, on a separate Journal Entry, using the 'Cost Distribution Variance Account' specified in the Inventory Preferences.

Database Field: ERPx_IMCostDistribution.VarianceAmount

Vendor Name

This is the Vendor Name of the Vendor from the source transaction.

Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.VendorSK, ERPx_APVendor.VendorName