Versions Compared

Key

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

Inventory Transactions are used to manage perpetual item and lot balances. The purpose of this page is to view, add, edit, remove, and post Inventory Adjustment, Production, Receipt, Transfer and Transfer Receipt Transactions.  Additionally, users can Mass Update the Status of multiple transactions at once, view Shipment Details for Transfer transactions and Void/Correct transactions.

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

Software Version: 2021.11.24 and newer

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
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.0
Help - Global 3.0
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.
More Actions

Insert excerpt
More Actions - Global
More Actions - Global
nopaneltrue

New

Insert excerpt
New - Multi-Select Trans Type - Global
New - Multi-Select Trans Type - Global
nopaneltrue

  • Adjustment: A transaction to adjust the On Hand balances of items.
  • Production: A transaction to record production, both for items consumed (Inputs) and items created (Output).
  • Receipt: A transaction to record the receipt of inventory purchased.
  • Transfer: A transaction to record the transfer of inventory items between Sites.
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
View

Insert excerpt
View - Inquiry Grid 3.0
View - Inquiry Grid 3.0
nopaneltrue

  • 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.
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
BOL

Identifies the Bill of Lading reference/ID that was entered on the corresponding Transfer transaction. If no value was entered by the user, this field is populated with the Transaction ID of the corresponding Transfer when the record is saved.  This is not required and can be edited on the 'Home' tab of the record view.  This field is always editable while the transaction is in a status of New.

Insert excerpt
Def - Bill of Lading
Def - Bill of Lading
nopaneltrue

Database Field: ERPx_IMTransactionHeader.BOL

Comment

Insert excerpt
Comment - Header
Comment - Header
nopaneltrue

Database Field: ERPx_IMTransactionHeader.Description

Corrected From

Insert excerpt
Corrected From
Corrected From
nopaneltrue
 This field only displays a value when the transaction was corrected and is never editable.  

Database Field: ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK

Created 

Insert excerpt
Created
Created
nopaneltrue
 

Database Field: ERPx_IMTransactionHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue
 

Database Field: ERPx_IMTransactionHeader.CreatedBy

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
 This is required and can be edited from the 'Properties' tab on the Transfer transaction record view.  If no value is specified, this field will be populated with the transaction date on save. 

Database Field: ERPx_IMTransactionHeader.GLDate

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_IMTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_IMTransactionHeader.LastUser

PO #

Insert excerpt
Purchase Order
Purchase Order
nopaneltrue

Database Field: ERPx_IMTransactionHeader.POHeaderSk

Received From

Identifies the name of the entity (Vendor, Fisherman, Grower, etc.) the product was received from. 

This is only required if a PO # has been entered on the transaction. This is editable when the transaction is in a Status of "New" for Receipts that are not linked to a PO #. For Receipts that are linked to a PO #, this is not editable.

Database Field: ERPx_IMTransactionHeader.ReceivedFrom

Reference

Insert excerpt
Reference
Reference
nopaneltrue
 This is not required and can be edited from the 'Home' tab on the record view while in the status of New. 

Database Field: ERPx_IMTransactionHeader.Reference

Site ID

Insert excerpt
Site ID
Site ID
nopaneltrue
 This is required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.SiteSK

Site Name

Insert excerpt
Site Name - LV
Site Name - LV
nopaneltrue

Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.SiteSK

Status

Insert excerpt
Status
Status
nopaneltrue
 This is required and can be edited from the 'Status' on the 'Home' tab of the Adjustment, Production, Receipt and Transfer Record View and represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

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

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def - Status - Ready to Post
Def - Status - Ready to Post
nopaneltrue

Database Field: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK

To Site ID

Insert excerpt
To Site ID
To Site ID
nopaneltrue
 This is required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.ToSiteSK

To Site Name

Insert excerpt
To Site Name
To Site Name
nopaneltrue
 This is required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.ToSiteSK

Trans Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 This is not required and can be edited from the 'Home' tab on the record view while in the status of New.  For Transfer type transactions this is the 'Transferred On' date. 

Database Field: ERPx_IMTransactionHeader.TransactionDate

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
 This is required and is a system assigned value based on which transaction class the user created the transaction in.  It is never editable by a user. 

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

Database Field: ERPX_IMTransactionClass.TransactionClassID,ERPx_IMTransactionHeader.TransactionClassSK

Transaction ID

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 Clicking on the link opens the corresponding transaction record view.  This is a system assigned value and is never editable by a user. 

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_IMTransactionHeader.TransactionID

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
 This is a system assigned value and is never editable by a user.  The transaction types are: Adjustment, Production, Receipt and Transfer. 

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Field: ERPx_IMTransactionType.TransactionTypeDescription, ERPx_IMTransactionHeader.TransactionTypeSK

Via Site ID

Insert excerpt
Via Site ID
Via Site ID
nopaneltrue
 This is not required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.ViaSiteSK

Via Site Name

Insert excerpt
Via Site Name
Via Site Name
nopaneltrue
 This is not required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.ViaSiteSK

...