Versions Compared

Version Old Version 34 New Version 35
Changes made by

Emma Greenwood

Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of this inquiry is to display each transaction that affects the inventory On Hand balance of an itembalances. From this inquiry, users may open the corresponding inventory transaction Record View or Sales Order Record View. This inquiry displays transactions that have been posted. This inquiry can be accessed from both the Inquiries page or from the Item Balances Inquiry List View by selecting a one or more line item(s) and clicking "View Item History" toolbar icon.

(lightbulb) This inquiry also contains columns for each Attribute that is set up for the 'Items' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Item attributes are not included in the help documentation.

Software Version: 2021.05.21 and newer

...

This is a date range control that allows users to select a single date or a range of dates. This is not
Filter ItemsDescription
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Include

Insert excerpt
Inq - Include - Inv
Inq - Include - Inv
nopaneltrue
 This is a multi-select standard lookup that is not required to return results. It defaults to "Beginning Balances".

This lookup contains the values "Voids" and "Beginning Balances".

Item

Insert excerpt
Inq - Item
Inq - Item
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Item ID
Def - Item ID
nopaneltrue

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

Item Class

Insert excerpt
Inq - Item Class
Inq - Item Class
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Item Class
Def - Item Class
nopaneltrue

The lookup contains a list of all Item Classes.

Lot Owner

Insert excerpt
Inq - Lot Owner
Inq - Lot Owner
nopaneltrue
 This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Owner
Def - Owner
nopaneltrue

The lookup contains a list of all Lot Owners.

Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • 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

Insert excerpt
Inq - Site
Inq - Site
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

The lookup contains a list of all active Sites.

Trans Class

Insert excerpt
Inq - Transaction Class
Inq - Transaction Class
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

The lookup contains a list of all Transaction Classes, SO Shipment and SO Return.

Trans Date

Insert excerpt
Inq - Transaction
Date Control Text Box
Inq - Transaction Date
nopaneltrue
Date Control Text Box
nopaneltrue
 This is required to return results and defaults with a date range of the past 30 days.

Trans Type

Insert excerpt
Inq - Transaction Type
Inq - Transaction Type
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

The lookup contains a list of all Inventory Transaction Types configured for the company.

Saved Searches

Insert excerptSearch Options for Framework 3.0 - GlobalSearch Options for Framework 3.0 - Globalnopaneltrue
  

Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0Help - Global 3.0
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue
 

  • RV: Item - Opens the Item Record View, in a new tab, for a selected Item. 
  • RV Order - Opens the Sales Order Record View, in a new tab, for a selected record with a Transaction Type of: SO Shipment or SO Return.
  • RV: Shipment Details - Opens the Shipment Record View, in a new tab, for a selected record with a Transaction Type of: SO Shipment, Transfer, or Transfer Receipt.
  • RV: Transaction - Opens the appropriate inventory transaction record view, in a new tab, for a selected record with a Transaction Type of: Adjustment, Production, Receipt, Transfer, or Transfer Receipt.
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
RefreshPrint
Insert excerpt
Refresh
Print -
Global
LV 3.0
Refresh
Print -
Global
LV 3.0
nopaneltrue
Saved LayoutsRefresh

Insert excerpt

Column Layouts for Framework 3.0

Refresh - Global

Column Layouts for Framework

3.0
Refresh - Global

nopaneltrueSearch Options Insert excerptSearch Options - Inquiry Grid 3.0Search Options - Inquiry Grid

3.0
nopaneltrue

ViewSaved Layouts
Insert excerpt
View - Inquiry Grid
Column Layouts for Framework 3.0
View - Inquiry Grid
- Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
 Search Options
  • Order - Opens the Sales Order Record View, in a new tab, for a selected record with a Transaction Type of: SO Shipment or SO Return.
  • Transaction - Opens the appropriate inventory transaction record view, in a new tab, for a selected record with a Transaction Type of: Adjustment, Production, Receipt, Transfer, or Transfer Receipt.
  • Shipment Details - Opens the Shipment Record View, in a new tab, for a selected record with a Transaction Type of: SO Shipment, Transfer, or Transfer Receipt.
    • Item - Opens the Item Master File Record View, in a new tab, for a selected record. 
    Insert excerpt
    Search Options - Inquiry Grid 3.0
    Search Options - Inquiry Grid 3.0
    nopaneltrue
    FieldsDescriptionBOL

    Displays the BOL ID entered on the transaction. This field is specific to SO Shipments and Inventory Transfers. This can be edited from the 'BOL' field on the 'Shipments Tab of the Sales Order Record View (for SO Shipments) or the 'Home' tab of the Transfer Transaction Record View (for Transfers) while the transactions are in a Status of New.

    Database Field: ERPh_IMTransactionHeader.BOL

    Corrected From

    Displays the Transaction ID of the source transaction that was corrected. This field only displays a value if the transaction has been corrected. This is not editable.

    Database Field: ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK

    Cost GroupDisplays the cost group attached to the item. This can be edited from the 'Cost Group' property on the 'Properties' tab of the Item Record View.GL DateDef - Cost Group

    Insert excerpt

    Def - Cost Group

    GL Date
    GL Date
    nopaneltrue

    Database Field: ERPx_IMCostGroup.CostGroupID

    DateDisplays the date of the inventory transaction.

    This can be edited from the 'GL Date' field on the '

    Shipments Tab of the Sales Order Record View (for SO Shipments), from the  'Date' field on the 'Home'

    Properties' tab of the Transaction Record View

    for Adjustment, Production and Receipt transactions while the transaction is in a Status of New, and from the 'Transferred On' field on the 'Home' tab of the Transaction Record View for a Transfer transactions

    while the transaction is in a Status of New.

      

    Database Field: ERPh_IMTransactionHeader.

    TransactionDate

    GLDate

    Item Attribute ClassDescription

    Insert excerpt
    Item

    Attribute Class

    Description
    Item

    Attribute Class

    Description
    nopaneltrue

    This can be edited from the 'Item Attribute Class' selected on the Properties tab of the Item Record View.

    Database Fields: ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK

    Item ID

    Insert excerpt

    Def

    Item ID -

    Attribute Class

    LV

    Def

    Item ID -

    Attribute Class

    LV
    nopaneltrue

    Database Fields: ERPx

    _MFAttributeClass.ClassDescription, ERPX

    _IMItem.

    AttributeClassSK

    ItemID, ERPh_IMTransactionDetail.ItemSK

    Item: Description

    Insert excerpt
    Item ID & Item Description
    Item ID & Item Description
    nopaneltrue
    The 'Item ID' field is not editable. The Item Description can be edited from the 'Item Description' property on the 'Properties' tab of the Item Record View.

    Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK

    GL DatePO #

    Insert excerpt
    GL DateGL Datenopaneltrue This can
    Purchase Order
    Purchase Order
    nopaneltrue

    Database Field: ERPh_IMTransactionHeader.POHeaderSk 

    Quantity

    Displays the unit or weight quantity of the item, in the default reporting UOM. This can be edited from the 'Units' field or 'Weight' field of a line item on the Items grid of the Transaction Record View while the transaction is in a Status of New. This can also be edited from the 'GL DateUnits' field or 'Weight' field of a line item on the 'Properties' tab Items grid of the Transaction Record Sales Order Record View while the transaction is in a Status of New. Once the transaction is no longer in a Status of New, this cannot be edited.

    Database Field: Fields: ERPh_IMTransactionDetail.EffectOnInventoryUnits or ERPh_IMTransactionHeaderDisplays the unit quantity or weight quantity of the item in the default reporting UOM. IMTransactionDetail.GLDate

    Quantity

    EffectOnInventoryWeight

    Note: For companies that want unposted Sales Orders to update the On Hand balances as soon as they are marked as Shipped, they can set the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference to "Yes".

    Reference

    Insert excerpt
    Reference
    Reference
    nopaneltrue
    This can be edited from the 'Units' field or 'WeightReference' field of a line item on the Items grid the 'Home' tab of the Transaction Record View while the transaction is in a Status of New. This can also be edited .

    Database Field: ERPh_IMTransactionHeader.Reference

    Site ID

    Displays the Site ID for the Site where the transaction occurred. This comes from the 'UnitsSite' field or on the 'WeightHome' field tab of a line item on the Items grid of the Sales Order Record View while the transaction is in a Status of New. Once the transaction is no longer in a Status of New, this cannot be edited.

    Database Fields: ERPh_IMTransactionDetail.EffectOnInventoryUnits or ERPh_IMTransactionDetail.EffectOnInventoryWeight

    Note: For companies that want unposted Sales Orders to update the On Hand balances as soon as they are marked as Shipped, they can set the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference to "Yes".

    Reference

    Insert excerptReferenceReferencenopaneltruethe Transaction Record View. This is not editable after the transaction has been saved.

    Insert excerpt
    Def - Site
    Def - Site
    nopaneltrue

    Database Fields: ERPx_MFSite.SiteID, ERPh_IMTransactionHeader.SiteSK

    Status

    Insert excerpt
    Status
    Status
    nopaneltrue
      

    Insert excerpt
    Def - Status
    Def - Status
    nopaneltrue
     The Statuses that apply to transaction in this List View include:

    Insert excerpt
    Def - Status - Posted
    Def - Status - Posted
    nopaneltrue

    Insert excerpt
    Def - Status - Void
    Def - Status - Void
    nopaneltrue

    Insert excerpt
    Def - Status - Replaced
    Def - Status - Replaced
    nopaneltrue

    Database Fields: ERPx_APTransactionStatus.StatusName, ERPh_IMTransactionHeader.TransactionStatusSK

    Trans Date

    Insert excerpt
    Doc Date
    Doc Date
    nopaneltrue
     This can be edited from the '

    Reference

    GL Date' field on the 'Shipments Tab of the Sales Order Record View (for SO Shipments), from the 'Date' field on the 'Home' tab of the Transaction

    Record View

    Record View for Adjustment, Production and Receipt transactions while the transaction is in a Status of New

    .

    Database Field: ERPh_IMTransactionHeader.Reference

    SiteDisplays the Site ID for the Site where the transaction occurred. This comes from the 'Site

    , and from the 'Transferred On' field on the 'Home' tab of the Transaction Record View

    . This is not editable after the transaction has been saved. Insert excerptDef - SiteDef - SitenopaneltrueDatabase Fields: ERPx_MFSite.SiteID, 

    for a Transfer transactions while the transaction is in a Status of New.  

    Database Field: ERPh_IMTransactionHeader.

    SiteSK

    TransactionDate

    Transaction ID

    Insert excerpt
    Transaction ID
    Transaction ID
    nopaneltrue
    This value is system generated when the transaction is created and is not editable.

    Insert excerpt
    Def - Transaction ID
    Def - Transaction ID
    nopaneltrue

    Database Field: ERPh_IMTransactionHeader.TransactionID

    Transaction Type

    Insert excerpt
    Transaction Type
    Transaction Type
    nopaneltrue
    This comes from the 'Transaction Type' property on the 'Properties' tab of the Transaction Class Record View for the associated transaction. This is not editable after the Transaction Class has been saved.

    Insert excerpt
    Def - Transaction Types
    Def - Transaction Types
    nopaneltrue

    (lightbulb) The SO Shipment and SO Return transaction types only displays when the corresponding invoice is posted.

    Database Field: ERPx_IMTransactionType.TransactionTypeDescription, ERPh_IMTransactionHeader.TransactionTypeSK

    Units UOM

    Insert excerpt
    UOM - Default IM Units
    UOM - Default IM Units
    nopaneltrue
     This field can be edited from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item Record View.

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPh_IMTransactionDetail.EffectOnInventoryUnitsUOMSK

    Units

    Insert excerpt
    Units - On HandLV
    Units - On HandLV
    nopaneltrue
    This can be edited from the 'Units' field of the line item in the Items grid on the Transaction Record View while the transaction is in a Status of New.

    Database Field: ERPh_IMTransactionDetail.EffectOnInventoryUnits

    UOM

    Insert excerpt
    UOM - Default Reporting
    UOM - Default Reporting
    nopaneltrue
     This can be edited from the 'Default Reporting UOM' property on the 'Properties' tab of the Item Record View.

    Database Field: ERPx_IMItem.DefaultReportingUOMSK

    UOM Schedule

    Insert excerpt
    UOM - Schedule
    UOM - Schedule
    nopaneltrue
    This field comes from the 'UOM Schedule' property on the 'Properties' tab of the Item Record View and is not editable.

    Database Fields: ERPx_IMItem.UOMScheduleSK, ERPh_IMTransactionDetail.ItemSK

    Void Date

    Displays the date the transaction was voided. This field comes from the 'Void/Correct GL Date' field for a transaction line on the Transaction More Actions Record View and is not editable after the void action has been processed.

    Database Fields: ERPh_IMTransactionHeader.VoidDate

    Weight

    Insert excerpt
    Weight - On HandLV
    Weight - On HandLV
    nopaneltrue
    This can be edited from the 'Weight' field of the line item in the Items grid on the Transaction Record View while the transaction is in a Status of New.

    Database Field: ERPh_IMTransactionDetail.EffectOnInventoryWeight

    Weight UOM

    Insert excerpt
    UOM - Default IM Weight
    UOM - Default IM Weight
    nopaneltrue
    This field can be edited from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item record view.

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPh_IMTransactionDetail.EffectOnInventoryWeightUOMSK

    Related Topics

    Understanding Inventory Balances

    ...