IM Cost Distributions Inquiry
A Cost Distribution refers to the act of taking an AP Expense or a Production related cost and applying it to the Base Cost or a Layer Cost of one or more Lots. Items in the Inventory Item Master File can be distributed to the cost of an 'Active' or 'Passive' inventory Item. The purpose of this inquiry is to view posted cost items.
Software Version: 2025.09.17 and newer
Page Header
Search
| Filter Items | Description |
|---|---|
| Auto Hide Filters |  A non-required text box that defaults as checked and is used to determine if the Search Options should be hidden when the Inquiry runs or is refreshed.
Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup. If you change the default setting but do not save it in a custom search, it will only remain this way while the page is opened. Refer to this FAQ for advanced search options. |
| Auto Refresh on Open |  A non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.
Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup. Refer to this FAQ for advanced search options. |
| Date Range | A text box to identify the method for selecting a date range, a specific date, or a min/max date. For help on using this control refer to the FAQ Article /wiki/spaces/HELP/pages/3108732991. This is required to return results and defaults with a date range of the past 30 days. |
| Include | Used to select one or more Items. This is a multi-select standard lookup that is not required to return results. It defaults as Posted and includes the following values:
|
| Saved Searches |  Displays the saved searches lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. Saving search options will also save the preferences for 'Auto Refresh on Open' and 'Auto Hide Filters'. The new search option can also be set as the default. Default searches can be removed by clicking the 'Set as Default' button again when the current default search is selected. Refer to this FAQ for advanced search options. |
| Search | A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). Refer to this FAQ for advanced search options. The Search field can be used to search across the following fields:
|
Page Detail
| Toolbar Icons | Description |
|---|---|
| Column Filter Show/Hide |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Excel |  Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Help |  Opens the online WIKI help page for the current page. |
| More Actions |
|
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
| Refresh |  Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options.
|
| Saved Layouts |  Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Search Options |  Toggles between displaying and hiding the Search Options portion of the page. |
| Fields | Description |
| Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
| Amount | Identifies the Extended amount of the line item. 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 | Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMCostDistributionCreatedDate |
| Created By | Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. 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 | Identifies how the $ amount was, or will be, applied to the Lot(s). The options that apply to transactions in this Inquiry include the following values from the MFDistributionType Enumeration Class: Inventory Purchase: The cost of the AP line item applies directly to the purchase cost (Base Cost) of the same Item. Only line items with an Item Type of "Inventory" and a 'Costing Method' of "Active" or "Passive" can be assigned as "Inventory Purchase", and the cost can only be distributed to Lot(s) for the same Item ID. Additional Landed Cost: The cost of the AP line item applies directly to the Landed Cost or Production Cost (Base Cost) of a Lot(s). Any inventory Item with a 'Costing Method' of "Active" or "Passive" and all non-inventory Items can be assigned as "Additional Landed Cost", and the cost can only be distributed to Lot(s) with a 'Costing Method' of "Active" or "Passive". Add Layer: The cost of the AP line item applies to an existing Lot(s). When applied, this cost creates a new cost layer with an effective date matching the source transaction GL Date. This is most commonly used for allocating monthly storage costs from a 3PL site to the applicable Lots. Any inventory item with a 'Costing Method' of "Active" or "Passive" and all non-inventory Items can be assigned as "Add Layer", and the cost can only be distributed to Lot(s) with a 'Costing Method' of "Active" or "Passive". Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ToMFDistributionTypeEN |
| Distribution ID | Identifies the unique Transaction ID for each transaction. 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. Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'. Database Field: ERPx_IMCostDistribution.DistributionID |
| Doc Date | Identifies the date of the transaction. This is the 'Doc Date' of the source AP Invoice or Credit Memo. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionDate |
| Doc No | Identifies the Doc No (document number) for the transaction. Unlike a Transaction ID that is system assigned based on the Transaction Class of the Transaction Type, this is a manually entered value. This is the 'Doc No' of the source AP Invoice or Credit Memo. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.DocNumber |
| GL Date | Identifies the date the transaction posted (or will post) to the general ledger. This is the 'GL Date' of the source AP Invoice or Credit Memo. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.GLDate |
| GL Period | Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. This is the 'GL Period' of the source AP Invoice or Credit Memo. |
| GL Year | Identifies the Fiscal Year based on the GL date on the source transaction or manual journal entry. This is the 'GL Year' of the source AP Invoice or Credit Memo. |
Item ID | Identifies the ID of the Item. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemID |
| Item Type | Identifies the type of item and its behavior in the system. Item Types fall under two main categories:
Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemTypeSK |
| Last Updated | Identifies the Last Updated Date & Time of the line item on the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMCostDistribution.LastUpdated |
| Last Updated By | Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMCostDistribution.LastUser |
Line Comment | Identifies an alternate comment/description for a line item. This is most commonly used to either identify the Vendor's Item ID or to add more clarity to a generic/bulk Item ID. 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 | Identifies an alternate item description for a line item. This is most commonly used to either identify the Vendor's Item Description or to add more clarity to a generic/bulk Item ID. 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. | Identifies the Line # for each Transaction Line Item. The Line # sets the sort of the items on grids, list views, inquiries, and reports. 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 | Identifies the GL Account the purchase line will post to. Database Fields: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionLine.AccountSK, ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description |
| Status | Identifies the Status of the transaction. 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: New: This is the default Status for all new Transactions. While in the Status of 'New' transactions are considered open and all editable fields are open for edit, no posting or approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist. Approved: Performs all the data validations required to post the transaction and applies to all Transactions. While in the Status of 'Approved' transactions are considered open but have limited fields open for edit. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned. Posted: Signifies the transaction has been posted and/or applied to a transactions (e.g. Payment Receipt). When a transaction is posted, it updates the General Ledger and/or On Hand Item Balances. While in the Status of 'Posted' transactions are considered closed and all the fields are disabled with the exception of a few fields that are always editable. Void: Signifies a previously posted transaction has been voided. This status is only available for transactions that support voiding posted records (not all transactions support this). Voided transactions remain in the database and can be viewed from history inquiries. Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type. Database Fields: ERPx_IMCostDistribution.DistributionStatusSK |
| Transaction | Identifies the unique Transaction ID for each transaction. This is the Transaction ID of the source transaction. Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionID |
Transaction Class ID | The unique identifier of the Transaction Class. This is the Transaction Class of the source transaction. Transaction Classes are used to differentiate transactions within a Transaction Type. For example, Transaction Classes of Fresh and Frozen can be setup for the Transaction Type of 'Sales Order'. Transaction Classes are used in all functional areas throughout the application. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APTransactionClass.TransactionClassDescription |
| Transaction Type | Identifies the Transaction Type for each transaction. This is the Transaction Type of the source transaction. Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type. 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 | Identifies the name of the Vendor assigned to the transaction or master file. This is set in the Vendor Record View. This is the Vendor Name of the Vendor from the source transaction. Vendor Names are used as a long description for Vendors. Database Field: ERPx_IMCostDistribution.SourceTransactionSK, ERPx_APTransactionHeader.VendorSK, ERPx_APVendor.VendorName |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.