The purpose of this inquiry is to display each transaction that affects inventory On Hand balances. 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: 2022.08.26 and newer

Page Header

Search

Filter ItemsDescription
Auto Hide Filters
Auto Refresh on Open
Include

 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

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

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

Item Class

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The lookup contains a list of all Item Classes.

Lot Owner

 This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The lookup contains a list of all Lot Owners.

Saved Searches
Search

  • 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

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The lookup contains a list of all active Sites.

Trans Class

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

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

Trans Date

 This is required to return results and defaults with a date range of the past 30 days.

Trans Type

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The lookup contains the following options:

  • 01: Receipt
  • 02: Production Input
  • 03: Production Output
  • 04: Transfer Outbound (1 Part)
  • 05: Transfer Receipt (1 Part)

  • 06: Transfer Outbound (2 Part)

  • 07: Transfer Receipt (2 Part)

  • 08: SO Shipment

  • 09: SO Return

  • 10: Adjustment

Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Excel
Favorites
Group By Show/Hide
Help
More Actions

 

  • 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
Print
Refresh

Saved Layouts
Search Options
FieldsDescription
BOL

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

GL Date

This can be edited from the 'GL Date' field on the 'Properties' tab of the Transaction Record View while the transaction is in a Status of New.

Database Field: ERPh_IMTransactionHeader.GLDate

Item Class ID

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

Database Field: ERPx_IMItemClass.ClassID

Item Description

Database Fields: ERPx_IMItem.ItemDescription, ERPh_IMTransactionDetail.ItemSK

Item ID

Database Fields: ERPx_IMItem.ItemID, ERPh_IMTransactionDetail.ItemSK

Item: Description

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

PO #

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 'Units' field or 'Weight' field 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

This can be edited from the 'Reference' field of the 'Home' tab of the Transaction Record View while the transaction is in a Status of New.

Database Field: ERPh_IMTransactionHeader.Reference

Site ID

Displays the Site ID for the Site where the transaction occurred. This comes from the 'Site' field on the 'Home' tab of the Transaction Record View. This is not editable after the transaction has been saved.

Database Fields: ERPx_MFSite.SiteID, ERPh_IMTransactionHeader.SiteSK

Status

  

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

Database Fields: ERPx_APTransactionStatus.StatusName, ERPh_IMTransactionHeader.TransactionStatusSK

Trans Date

 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' 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

Transaction ID

This value is system generated when the transaction is created and is not editable.

Database Field: ERPh_IMTransactionHeader.TransactionID

Transaction Type

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.

(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

 This field can be edited from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item Record View.

Database Field: ERPh_IMTransactionDetail.EffectOnInventoryUnitsUOMSK

Units

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

 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

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

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

This field can be edited from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item record view.

Database Field: ERPh_IMTransactionDetail.EffectOnInventoryWeightUOMSK

Related Topics

Understanding Inventory Balances


Page Definitions



Technical Details