The purpose of this inquiry is to view posted cost items.

Software Version: 2025.09.17 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Filter Items	Description

Filter Items	Description
Auto Hide Filters
Auto Refresh on Open
Date Range	This is required to return results and defaults with a date range of the past 30 days.
Include	This is a multi-select standard lookup that is not required to return results. It defaults as Posted and includes the following values: Posted Unposted (Includes lines with a Status of New or Approved) Void
Saved Searches
Search	Distribution ID Trans Doc No PO Item: Item ID or Description

Page Detail

Toolbar Icons	Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

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, Credit Memo or Purchase Order.

Quick Column Filter

Refresh

Saved Layouts

Search Options

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

Database Field: ERPx_IMCostDistribution.DistributedAmount

Distributed To

The options that apply to transactions in this Inquiry include the following values from the MFDistributionType Enumeration Class:

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 Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.LineNumber

Lot Cost Amt.

A calculated field that displays the sum of the [Lot Cost Amt.] from each Lot. 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

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 [Amount] and the sum of the [Distributed Amt.] of all Lot. This shows how much still needs to be distributed before the line item can be posted.

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.] of all Lots.

This will always show a value when the [Amount] has not been fully distributed and/or when the [Undistributed Amt.] = $0.00 due to rounding a two-digit cost amount to a 5-digit Lot Cost Amount. This amount will post to the General Ledger 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

IM Cost Distributions Inquiry

Page Header

Search

Page Detail