Update Costs Inquiry List View

Owned by Emma Greenwood
Last updated: Nov 23, 2022 by Tom Williams
7 min read

The Update Costs inquiry is used to review Item and/or Lot costs. From here users can updated costs and drill down to cost history.

(lightbulb) This inquiry also contains columns for each Attribute that is set up for the 'Items' attribute type and the 'Production Batches' attribute type. Additionally, this inquiry also contains columns for each Lot Certification with a certification 'Type' of "Item & Site". Item attributes, Production Batch attributes and Lot Certifications are not automatically included in the default view. Because these attributes and lot certifications are user defined, they are not included in the help documentation.

Software Version: 2022.06.16 and newer

Page Header

Search OptionsDescription
Auto Hide FiltersA 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.
  • When checked, each time the 'Refresh' button is clicked, the search options will be hidden, allowing for more rows of data to be visible on the page. This behavior is ideal for users that have entered their search parameters and want to see the results in full-screen. 
  • When unchecked, the search options will not be hidden when the 'Refresh' button is clicked. This behavior is ideal for users that need to run several searches with different search parameters.

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 OpenA non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.
  • When checked, each time the page is opened, the search is run using the default parameters (or a 'Saved Search' if one was set as your default for the page) so the grid will be populated with data .  
  • When unchecked, the search is NOT run when the page opens and no data will be present until the 'Refresh' button is clicked. 

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.

GL Period Activity

Used to limit the list of Lots that are returned in the inquiry, to only those that had either a beginning balance or activity within the GL Period specified.

If entered, this must be the format of [GL Period]-[GL Year] (e.g., 05-2022).

Include

Provided a way to limit the list of Lots that are returned. The lookup contains the following values:

  • Lots with any balance - selected by default
  • Lots with Available Balance
  • Lot Status - Closed
  • Costing Status - Open
  • Costing Status - Closed
Item

Used to select one or more Items. This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.

Item IDs are the unique identifier for Items. 

The lookup contains a list of all Items in the Items master file.

Lot Owner

Used to select one or more inventory Owners. This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.

Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots.

The lookup contains a list of all Lot Owners.

Saved SearchesDisplays 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: 

 

  • 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

Used to select one or more Sites. This is a multi-select lookup that defaults to blank (All) and is not required. Selecting nothing assumes you want all records returned.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances.

The lookup contains a list of all active Sites.

Page Detail

Toolbar IconsDescription
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. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

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. 
Mass Update

Opens the mass update dialog, which allows to mass update the following properties: 

  • Lot Properties
    • Costing Status
  • Set Base Costs
    • Update Method:
    • Actual Cost:
    • Market Cost:
    • Standard Cost:
    • Reason Code:
  • Add Cost Layers 
    • Effective Date:
    • Actual Cost:
    • Market Cost:
    • Standard Cost:
    • Reason Code:
  • Update Costs from Other Costs
    • Effective Date:
    • Source Cost:
    • Destination Cost:
    • Cost Update Method:
    • Amount:
  • Post Costs to GL
    • Post Costs Through GL Period:
    • Post Costs to GL:
    • Update PO Receipts Costs:


More Actions

 Displays a drop down menu of related actions. The list of options includes: 

  • IQ: Cost History: opens the cost history for the selected record.
  • IQ: Lot History: opens the Lot History for the selected record. 
  • LV: Warehouse Lot
  • RV: Production Batch

——————————————

  • Update Costs from BOM: opens the Update Costs from BOM page
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. 

(lightbulb) This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.

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.
FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Actual Cost - Base

The Actual Base Cost reflects the 'Base Cost' assigned within the Actual cost type. The Actual base cost is added to the Actual layer cost(s) to compute total Actual cost. This is a calculated field that can only be edited by adding/editing an 'Actual Base Cost'.

Database Fields: ERPx_IMLotCostHistory.Cost where ERPx_IMLotCostHistory.LotCostTypeEN = 3

Actual Cost - Layers

An Actual Cost Layer reflects the 'Layer Cost' assigned within the Actual cost type. The Actual layer cost(s) are added to the Actual base cost to compute total Actual cost. This is a calculated field that can only be edited by adding/editing an 'Actual Cost Layer'.

Database Fields: ERPx_IMLotCostHistory.Cost where ERPx_IMLotCostHistory.LotCostTypeEN = 2

Actual Cost Rate

The Actual Cost Rate refers to the 'Rate' applied to the Inventory for determining the extended 'Actual Cost'. For a single Lot, it is the 'Rate' that is multiplied by the quantity to compute the 'Actual Cost' value of the Lot. For multiple Items and/or Lots it is the calculated value from dividing the sum of the extended 'Actual Costs' by the sum of the quantity. This is a calculated field that can only be edited by adding/editing an 'Actula Cost Layer' or adding/updating an 'Actual Base Cost'. 

Base Source

Identifies whether the Base cost was assigned manually, from a transaction, or from a Bill of Material.

What data field stores this value and how is it set?

Batch Comment

Displays the batch comment assigned to the corresponding Production Batch. This is not required and is always editable from the 'Batch Comment' field on the Properties tab of the Production Batch record view.

Database Field: ERPx_IMProductionLot.LotComment

Batch Date

The Batch Date identifies the date the Production Batch, for the Item, was initially created. This is the date used to determine the age of the batch and it stays attached to the Lot, even if it is transferred to another Site. This will be blank and/or disabled for all non-Lot Tracked items on screens that include a Production Batch field. This can be edited from the 'Batch Date' field on the Properties tab of the Production Batch Record View. 

Database Field: ERPx_IMProductionLot.DateProduced

Batch Site ID

Identifies the Site where the Production Batch was born, created, or initially received. This is required and is always editable from the 'Batch Site ID' field on the Properties tab of the Production Batch Record View. 

Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_IMProductionLot.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.