The Inventory Adjustment Transaction Record View allows users to record the receipt of inventory purchased and received. The The Inventory Receipt Transaction Record View allows users to record the receipt of inventory purchased from an outside entity. This transaction allows multiple items received into a single site to be recorded. Before the transaction is posted, it will updated the available lot balance of the item(s) The 'Include open Receipt transactions in Available balances' preference will determine whether Available balances are updated before the transaction is posted. Once the transaction is posted, it will update the on-hand On Hand lot balance of the item(s).
Software Version: 2020 2021.xx05.xx 21 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||||
Help | GL Date
| GL Date |
|
The drop-down displays all active Insert excerpt New - RV Header New - RV Header nopanel true
Receipt type transaction classes configured in the system.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Save
Save & Close
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Home Tab
Fields | Description | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Corrected From | Displays the Transaction ID of the source transaction the correction is being made from. This is a text box that defaults to the source transaction. This field is not visible unless the transaction is the result of a correction. It is only required on transactions that are being corrected. This field is auto populated by the system and is not editable.
Database Fields: ERPx_IMTransactionHeader.TransactionID, ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK | ||||||||||||||||||||||||||||||||||||||||
Date |
Database Field: ERPx_IMTransactionHeader.TransactionDate | ||||||||||||||||||||||||||||||||||||||||
Reason CodePurchase Order | Reason Code Reason Code |
The lookup contains the values configured for Adjustment reason codes in the Reason Codes Master File (Company > Setup > Reason Codes). the transaction is in a Status of 'New'. Database Field: ERPx_MFNoteTypeReasonCode.ReasonCode, ERPx_IMTransactionHeader.ReasonCodeSKPONumber | |||||||||||||||||||||||||||||||||||||||
Reference |
| . If not, the message "...[TBD]... | " will be displayed on Save. This field is always editable while the transaction is in a Status of 'New'. Database Field: ERPx_IMTransactionHeader.Reference | ||||||||||||||||||||||||||||||||||||||
Site |
The lookup contains a list of all the 'Active' Inventory Sites. Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.SiteSK | ||||||||||||||||||||||||||||||||||||||||
Status |
Database Fields: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK |
Properties Tab
Fields | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Auto-Create New Lots |
This lookup contains the values in the IMAutoCreateNewLots Enumeration Class. Database Field: ERPx_IMTransactionHeader.AutoCreateLotsEN | ||||||||
Corrected From | Displays the Transaction ID of the source transaction that was corrected. This is a non-editable text box that is not required. It is only displayed on the corrected transaction and is never editable. Database Fields: ERPx_IMTransactionHeader.TransactionID, ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK | ||||||||
Created By |
Database Field: ERPx_IMTransactionHeader.CreatedBy | ||||||||
Created DateIdentifies the Created Date & Time of the record. |
Database Field: ERPx_IMTransactionHeader.CreatedDate | ||||||||
GL Date |
Database Field: ERPx_IMTransactionHeader.GLDate | ||||||||
Last User |
Database Field: ERPx_IMTransactionHeader.LastUser | ||||||||
Last Updated | Displays the date and time when the transaction was updated the most recently. This Database Field: ERPx_IMTransactionHeader.LastUpdated | ||||||||
Negative Available Balances |
This lookup contains the values in the IMAllowNegativeAvailableBalances Enumeration Class.
Database Field: ERPx_IMTransactionHeader.NegativeBalancesEN | ||||||||
Void Date |
Database Field: ERPx_IMTransactionHeader.VoidDate | ||||||||
Voided By |
Database Field: ERPx_IMTransactionHeader.VoidedBy |
Attributes Tab
...
Page Detail
Items Grid
...
Fields | Description | |
---|---|---|
Attributes |
|
|
The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Inventory). | ||
Available |
|
|
value is only |
editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Inventory → Transactions hyperlink). | ||
Value |
|
|
Page Detail
Items Grid
Toolbar Icons | Description | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide | |||||||||||||||||||||||||||||
Insert excerpt | Mass Update - Global | Mass Update
| Mass Update |
| |||||||||||||||||||||||||
nopanel | true |
| |||||||||||||||||||||||||||
Delete |
| ||||||||||||||||||||||||||||
Excel |
| Quick Filter | Quick Filter | ||||||||||||||||||||||||||
nopanel | true | Saved Column Layouts | |||||||||||||||||||||||||||
Insert excerpt |
| - GlobalColumn Layouts for Framework
| - Global
| ||||||||||||||||||||||||||
Find Lots |
| View
| View
| ||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||
CheckboxGroup By Show/Hide |
| ||||||||||||||||||||||||||||
Item: DescriptionMass Update |
| Item ID & Item Description | Item ID & Item Description | ||||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||||
Insert excerpt | Def - Item ID | Def - Item ID | |||||||||||||||||||||||||||
nopanel | true | Lot Tracked | |||||||||||||||||||||||||||
Insert excerpt | Lot Tracked | Lot Tracked | |||||||||||||||||||||||||||
nopanel | true | Production Batch | |||||||||||||||||||||||||||
Insert excerpt | Production Batch | Production Batch | |||||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||||
Insert excerpt | Def - Production Batch | Def - Production Batch | |||||||||||||||||||||||||||
nopanel | true | Owner | |||||||||||||||||||||||||||
Insert excerpt | Owner - Item | Owner - Item
This toolbar icon is always enabled. | |||||||||||||||||||||||||||
New |
| ||||||||||||||||||||||||||||
Quick Column Filter |
| ||||||||||||||||||||||||||||
Saved Layouts |
| ||||||||||||||||||||||||||||
View |
| ||||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||
Checkbox |
| ||||||||||||||||||||||||||||
Item: Description |
| standard load on demand lookup that is required to save a line item. It defaults | from the 'Default Owner' preference on the Inventory Preferences page. This field is editable until a line item has been savedas blank and is always editable while the transaction is in a Status of 'New'.
| Owner
| Owner
The lookup | displays all 'Active' Lot Owners in the Lot Owners Master File.Database Field: contains a list of all active Items in the Item Master File.
Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSK | |||||||||||||||||||||||
Reason CodeLot Tracked | Code Reason Code | Reason Code | nopanel | true |
The lookup contains the following options:
It displays as "Yes" if the line item is a lot tracked item. It displays as blank if the item is not a lot tracked item. This field is for informational use only and cannot be edited. Database Fields: ERPx_MFNoteTypeReasonCodeIMItem.ReasonCodeTrackMethodEN, ERPx_IMTransactionDetail.ReasonCodeSKItemSK | ||||||||||||||||||||||||
Production Batch | Units - Inventory
| Units - Inventory |
| numeric text box that is only required | . This field defaults to 0 and is always editable while the transaction is in a Status of 'New'. This field is editable only if the item is managed by Units Only or Units or Weight. Unlike other inventory transactions, Adjustment transactions treat all items as variable weight and require whole units property is not enforced. Adjustment transactions also allow users to set units as positive and weight as negative and vice versa. Units can be entered with 5 decimals regardless of the 'Units Decimals' property configured in the 'Properties' tab for the selected Item on the Item Record View. To maintain consistency, units that are saved using a different UOM than the 'Default Inventory Unit UOM' will be converted and stored in the default Inventory Unit UOM. Unit UOM | ||||||||||||||||||||||||
Insert excerpt | UOM - Units | UOM - Unitsto save a line item on a transaction in 'Approved' or greater status if the item selected is Lot Tracked. It defaults as blank and is only editable if the selected item is Lot Tracked and the transaction is in a Status of 'New'. This field must be <= 50 characters.
Database Fields: ERPx_IMProductionLot.ProductionLotID, ERPx_IMTransactionDetail.ItemSK | |||||||||||||||||||||||||||
Owner |
The lookup contains a list of all Lot Owners. Database Field: ERPx_IMLotOwner.OwnerName | ||||||||||||||||||||||||||||
Units |
This lookup contains all 'Active' Unit UOMs on the selected Item's UOM Schedule. Insert excerpt | Def - UOM | Def - UOM | nopanel | true | Database Field: ERPx_IMTransactionDetail. | Warehouse Lot |
Warehouse Lot | Warehouse Lot | nopanel | true |
Database Field: ERPx_IMTransactionDetail.TransactionUnits | |||||||||||||||||
Unit UOM |
The transaction will validate the Warehouse Lot based on the following: it will default from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item Record View for the selected Item. If enabled, this field will be editable while the transaction is in a Status of 'New'. This lookup contains all 'Active' Unit UOMs on the selected Item's UOM Schedule.
Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionUnitsUOMSK | ||||||||||||||||||||||||||||
Warehouse Lot |
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK | ||||||||||||||||||||||||||||
Weight |
Database Field: ERPx_IMTransactionDetail.TransactionWeight | ||||||||||||||||||||||||||||
Weight UOM |
This lookup contains all 'Active' Weight UOMs on the selected Item's UOM Schedule.
Database FieldFields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionWeightUOMSK |
Related Topics
- Inventory Transactions User Guides
- Lot Adjustment Transaction Record View
- Item Balances List View HelpItem
- Lot Balances List View HelpReceipt Help
- Production Transaction Record View
- Transaction History - Item HelpInquiry
- Transaction History - Lot HelpInquiry
- Transfer HelpTransfer Receipt HelpTransaction Record View
- Void/Correct Transactions Help
...