Versions Compared

Key

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

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
typeflat

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete - RV Header
Delete - RV Header
nopaneltrue
 This toolbar icon is enabled when the transaction status is 'New'

HelpGL Date
Insert excerpt
GL Date
Help - Global
Help - Global
nopaneltrue
New

Insert excerpt
New - RV Header
New - RV Header
nopaneltrue
The drop-down displays all active

Adjustment

Receipt type transaction classes configured in the system.

Notes
Insert excerpt
Notes - Global
Notes - Global
nopaneltrue
Print
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue
Process Correction 
Insert excerpt
Process Correction - RV Header
Process Correction - RV Header
nopaneltrue

Save

Save & Close

Insert excerpt
Save/Save & Close - RV Header 3.0
Save/Save & Close - RV Header 3.0
nopaneltrue

Home Tab 

FieldsDescription
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.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Fields: ERPx_IMTransactionHeader.TransactionID, ERPx_IMTransactionHeader.CorrectedFromTransactionHeaderSK

Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
This is a date picker that is required. If missing, the message "Transaction Date is required" will be displayed on Save. It defaults to the current date, formatted from the users 'Date Format' preference. This field is always editable while the transaction is in a Status of 'New'. 

Database Field: ERPx_IMTransactionHeader.TransactionDate

Reason CodePurchase Order

Reason Code

Insert excerpt
Reason Code
Purchase Order
Purchase Order
nopaneltrue
This is a
single-select standard lookup text box that is not required. It defaults as blank. If entered, this field must be <= 100 characters. This field is always editable while the transaction is in a Status of 'New'. This value will auto populate the 'Reason Code' field in the grid section when actual balances have been entered.
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

Insert excerpt
Reference
Reference
nopaneltrue
This is a text box that is not required. It defaults as blank. If entered, this field must be <= 100 characters

. 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

Insert excerpt
Site Name
Site Name
nopaneltrue
This is a single-select standard lookup that is required. If missing, the message "Site is required." will be displayed on Save. This defaults as blank and is not editable after initial Save. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

The lookup contains a list of all the 'Active' Inventory Sites.

Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.SiteSK

Status
Insert excerpt
Status
Status
nopaneltrue
This is a single-select standard lookup that defaults as 'New' and is required. 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 Fields: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK

Properties Tab

FieldsDescription
Auto-Create New Lots

Insert excerpt
Auto Create New Lots
Auto Create New Lots
nopaneltrue
This is a single-select load on demand lookup that is required. It defaults from the 'Auto-Create New Lots' property in the 'Properties' tab of the associated Transaction Class Record View. This field is always editable while the transaction is in a Status of 'New'. If set to "Not Allowed" and the transaction would result in the creation of a new inventory lot, the message "Lots would be created when Auto-Create Lots is Not Allowed" will be displayed on Save.

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

Insert excerpt
Created By
Created By
nopaneltrue
This is a non-editable text box that is required.

Database Field: ERPx_IMTransactionHeader.CreatedBy

Created DateIdentifies the Created Date & Time of the record.

Insert excerpt
Created By
Created By
nopaneltrue
This is a system assigned value and is never editable by a user.  This is a non-editable text box that is required.

Database Field: ERPx_IMTransactionHeader.CreatedDate

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
This is a date picker that is required. It defaults from the 'Date' field on the 'Home' tab and is always editable while the transaction is in a Status of 'New'. This field must be on or after the 'Date' field on the 'Home' tab of the Adjustment Receipt Record View. Else, the message "The GL date must occur on or after the Transaction Date" will be displayed on Save. Additionally, if the GL Date is not within an open Fiscal Period for Inventory, the message "The Fiscal Period is not open. The GL Date must be in a Fiscal Period that is open for Inventory." will be displayed on Save for statuses of 'Approved' or greater.

Database Field: ERPx_IMTransactionHeader.GLDate

Last User

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
 This is a non-editable text box that is required.

Database Field: ERPx_IMTransactionHeader.LastUser

Last Updated

Displays the date and time when the transaction was updated the most recently. This

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
 This is a system assigned value and is never editable by a user.  This is a non-editable text box that is required.

Database Field: ERPx_IMTransactionHeader.LastUpdated

Negative Available Balances

Insert excerpt
Negative Available Balances
Negative Available Balances
nopaneltrue
This is a single-select load on demand lookup that is required. It defaults from the 'Negative Available Balances' property in the 'Properties' tab of the associated Transaction Class Record View. This field is always editable while the transaction is in a Status of 'New'. If set to "Not Allowed" and the transaction would result in an inventory lot with a negative available balance, the message "Lot balances would be negative when set to Not Allowed" will be displayed on Save.

This lookup contains the values in the IMAllowNegativeAvailableBalances Enumeration Class.

(lightbulb) If Sales Order allocation preferences are set to either “Available Only” or “Available and On Hand” and a Sales order has been allocated prior to a user updating the Inventory “Negative Available Balances” property, it is possible to draw the lots negative.   

(lightbulb) A message will be displayed to the user if lot balances are negative and a new transaction is created which would impact those balances positively, however the overall balances would still be negative.  For example, if the lot balance is -10 Cases and an Adjustment a Receipt transaction adds 5 Cases, the overall lot balance would still be negative. The following options are possible workarounds: 

  •  Change the Adjustment Receipt transaction's "Negative Available Balances" property to "Allowed"
  •  Change the Adjustment Receipt transaction to result in a zero or greater inventory balance.
  •  Use Cycle Count feature to change inventory balance to zero or greater.

Database Field: ERPx_IMTransactionHeader.NegativeBalancesEN

Void Date

Insert excerpt
Void Date
Void Date
nopaneltrue
This is a non-editable text box that is not required.

Database Field: ERPx_IMTransactionHeader.VoidDate

Voided By

Insert excerpt
Voided By
Voided By
nopaneltrue
 This is a non-editable text box that is not required.

Database Field: ERPx_IMTransactionHeader.VoidedBy

Attributes Tab

...

Page Detail

Items Grid

...

Column Filter Show/Hide - Global
FieldsDescription
Attributes

Insert excerpt

Column Filter Show/Hide - Global

Attribute - Attribute
Attribute - Attribute
nopaneltrue

DeleteDelete - RV Grid 3.0

 The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Inventory). 

Available

Insert excerpt

Delete - RV Grid 3.0

Attribute - Available
Attribute - Available
nopaneltrue
 This

toolbar icon

value is only

enabled when the transaction is in a Status of 'New'. Excel Insert excerptExcel - RV Header 3.0Excel - RV Header 3.0nopaneltrueFind LotsFind Lots - RV Grid 3.0

editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Inventory → Transactions hyperlink). 

Value

Insert excerpt

Find Lots - RV Grid 3.0

Attribute - Value
Attribute - Value
nopaneltrue

Group By

Page Detail

Items Grid

Mass Update
  • Production Batch Certifications
  • Production Batch Attributes
  • Production Batch Properties (Batch Class, Batch Date, Country of Origin, Expiration Date, Outside Purchase, Batch Date, Production Batch Site, Project, Quality Test Class, Status, and Traded)
  • Transaction (Warehouse Lot)

This toolbar icon is always enabled.

NewQuick FilterColumn Layouts for Framework - GlobalColumn Layouts for Framework - GlobalViewView View This is a single-select load on demand lookup that is required to save a line item. It defaults as blank and is always editable while the transaction is in a Status of 'New'.

The lookup contains a list of all active Items in the Items Master File.

(lightbulb) Selecting the Item will default the 'Inventory Units UOM' and 'Inventory Weight UOM' fields based on the Item properties, as specified on the Items Record View.

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

This is a non-editable text box that is not required. This value defaults from the 'Lot Tracked' field in the 'Properties' tab of the Item Record View. 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_IMItem.TrackMethodEN, ERPx_IMTransactionDetail.ItemSK

This is a text box that is only required to 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.

Database Fields: ERPx_IMProductionLot.ProductionLotID, ERPx_IMTransactionDetail.ItemSK

Owner - Item standard from the 'Default Owner' preference on the Inventory Preferences page. This field is editable until a line item has been saved Owner Owner displays all 'Active' Lot Owners in the Lot Owners Master File.Database Field: This is a single-select standard lookup that is required to save the transaction in a Status of 'Approved' or greater if the "Require Reason Codes for all Adjustment lines" property is set to "Yes" on the Inventory Preferences page. If missing and required, the message "Reason Codes are required for all Adjustment transaction lines" will be displayed when the Process Adjustment button is clicked. This field defaults from the 'Reason
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Mass Update - Global
Insert excerpt
Group By Column Filter Show/Hide - GlobalGroup By
Column Filter Show/Hide - Global
nopaneltrue
Mass Update
- Global
nopaneltrue
nopaneltrue
Delete

Insert excerpt
New - multi blank rows Delete - RV Grid 3.0New
Delete - multi blank rows - RV Grid 3.0
nopaneltrue
This  This toolbar icon is only enabled when the transaction status is in a Status of 'New'

Excel
Insert excerpt
Quick FilterQuick Filter
nopaneltrue
Saved Column Layouts
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Find Lots
Insert excerpt
Find Lots - RV Grid 3.0
Find Lots - RV Grid 3.0
nopaneltrue
FieldsDescription
CheckboxGroup By Show/Hide
Insert excerpt
CheckboxCheckboxGroup By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Item: DescriptionMass Update

Insert excerpt

Item ID & Item DescriptionItem ID & Item Description
nopaneltrue
Insert excerpt
Def - Item IDDef - Item ID
nopaneltrue
Lot Tracked
Insert excerpt
Lot TrackedLot Tracked
nopaneltrue
Production Batch
Insert excerpt
Production BatchProduction Batch
nopaneltrue
Insert excerpt
Def - Production BatchDef - Production Batch
nopaneltrue
Owner
Insert excerpt
Owner - Item

Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • Production Batch Certifications
  • Production Batch Attributes
  • Production Batch Properties (Batch Class, Batch Date, Country of Origin, Expiration Date, Outside Purchase, Batch Date, Production Batch Site, Project, Quality Test Class, Status, and Traded)
  • Transaction (Warehouse Lot) - Please note this field may only be updated if the Status of the transaction is 'New'. Else the message "Warehouse Lot may only be updated for transactions in the status of New." will be displayed on Save.

This toolbar icon is always enabled.

New

Insert excerpt
New - Blank Row - RV Grid 3.0
New - Blank Row - RV Grid 3.0
nopaneltrue
This toolbar icon is only enabled when the transaction status is New. 

Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
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
 

  • Item - Opens the Item Master File Record View, in a new tab, for a selected record. 
  • Production Batch - Opens the Production Batch Record View, in a new tab, filtered for the selected record's Production Batch.
  • Warehouse Lot - Opens the Warehouse Lot List View, in a new tab, filtered for the selected record's Warehouse Lot. 
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Item: Description

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
This is a single-select

load on demand lookup that is required to save a line item. It defaults

as blank and is always editable while the transaction is in a Status of 'New'.

Insert excerpt
Def -

Item ID
Def -

Item ID
nopaneltrue

The lookup

contains a list of all active Items in the Item Master File.

(lightbulb) Selecting an Item will default the 'Inventory Unit UOM' and 'Inventory Weight UOM' properties specified on the Item Record View.

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

Reason CodeLot Tracked

Code

Insert excerpt
Reason CodeReason Code
nopaneltrue
Lot Tracked
Lot Tracked
nopaneltrue
This is a non-editable text box that is not required. This value defaults from the 'Lot Tracked' field in the '
HomeProperties' tab of this the Item Record View. This field is always editable while the transaction is in a Status of 'New'.

The lookup contains the following options:

  • Cycle Count
  • Dump And Destroy
  • Variable Item Correction

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

UnitsProduction BatchUnits - Inventory

Insert excerpt

Units - Inventory

Production Batch
Production Batch
nopaneltrue
This is a

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.

Database Field: ERPx_IMTransactionDetail.

Unit UOM Insert excerptUOM - UnitsUOM - Units

to 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.

Insert excerpt
Def - Production Batch
Def - Production Batch
nopaneltrue

Database Fields: ERPx_IMProductionLot.ProductionLotID, ERPx_IMTransactionDetail.ItemSK

Owner

Insert excerpt
Owner - Item
Owner - Item
nopaneltrue
This is a single-select standard lookup that is required. It defaults from the 'Default Owner' preference on the Inventory Preferences page. This field is editable until a line item has been saved.

Insert excerpt
Def - Owner
Def - Owner
nopaneltrue

The lookup contains a list of all Lot Owners.

Database Field: ERPx_IMLotOwner.OwnerName

Units

Insert excerpt
Units - Inventory
Units - Inventory
nopaneltrue
This is a single-select standard lookup numeric text box that is sometimes required to save a line item on transactions with .This field is required and editable only if the item is managed by Units Only or Units or Weight. This field defaults to 0 and is always editable while the transaction is in a Status of 'Approved' or greaterNew'. This field can be both positive or negative. This field will be disabled if the item is managed by Weight Only. If enabled, it will default from the 'Default Inventory Unit UOMdisplay the number of decimals set for the selected item on the 'Unit Decimals' 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.

Insert excerptDef - UOMDef - UOMnopaneltrue

Database Field: ERPx_IMTransactionDetail.

Warehouse Lot

Insert excerptWarehouse LotWarehouse Lotnopaneltrue 

Insert excerpt
Def - Units- Inventory Calculations
Def - Units- Inventory Calculations
nopaneltrue

(lightbulb) 'Units' and 'Unit UOM' fields will always display as the values entered by the user. However for consistency, Units that are saved using a UOM that is different than the 'Inventory Unit UOM' will be converted and subsequently stored in the default Inventory Unit UOM.

Database Field: ERPx_IMTransactionDetail.TransactionUnits

Unit UOM

Insert excerpt
UOM - Units
UOM - Units
nopaneltrue
This is a single-select standard lookup that is sometimes required to save a line item on transactions with a Status of 'Approved' or greater. It is required when the 'Site' field on the transaction is set to warehouse lot tracked and is not required when the 'Site' field on the transaction is set to not warehouse lot tracked. If required and blank, the message "" will be displayed on Save of Statuses that is required to save a line item on transactions with a Status of 'Approved' or greater. This field defaults as blank and will be disabled if the 'Site' field on the transaction is not warehouse lot trackeditem is managed by Weight Only. If enabled, this field is editable via the Mass Update Dialog while the transaction is in a Status of 'New'. 

The transaction will validate the Warehouse Lot based on the following:

  • If the selected Site is warehouse lot tracked and allows multiple items, the transaction will allow multiple items to be coded to the same warehouse lot and will create the warehouse lot with the default item selection of 'All'
  • If the selected Site is warehouse lot tracked and allows multiple items and the warehouse lot ID entered for an item on the transaction already exists, the transaction will verify the warehouse lot is either set to 'All' or the specific item is selected.
  • If the selected Site is warehouse lot tracked and only allows single items, the transaction will restrict multiple items from being coded to the same warehouse lot and it will create the warehouse lot for the first item code on the transaction and will prompt an error for the next item trying to save to the same warehouse lot
  • If the selected Site is warehouse lot tracked and only allows single item and the warehouse lot ID entered for an item on the transaction already exists, the transaction will verify the warehouse lot is either set to 'All' or the specific item is selected.
  • If the selected site is not warehouse lot tracked, no warehouse lots can be entered.

    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.

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionUnitsUOMSK

    Warehouse Lot

    Insert excerpt
    Warehouse Lot
    Warehouse Lot
    nopaneltrue
     This is a single-select standard lookup that is sometimes required to save a line item on transactions with a Status of 'Approved' or greater. It is required when the 'Site', identified on the transaction header, is a warehouse lot tracked Site and is disabled when it is not. If required and blank, the message "Warehouse Lot is required for Warehouse Lot Tracked sites when Approving or Posting." will be displayed on Save of Statuses of 'Approved' or greater. This field defaults as blank and will be disabled if the 'Site' field on the transaction is not warehouse lot tracked. If enabled, this field is editable via the Mass Update Dialog while the transaction is in a Status of 'New'. This field must be <= 50 characters.

    Insert excerpt
    Def - Warehouse Lot - Inventory Site Validations
    Def - Warehouse Lot - Inventory Site Validations
    nopaneltrue

    Insert excerpt
    Def - Warehouse Lot
    Def - Warehouse Lot
    nopaneltrue

    Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

    Weight

    Insert excerpt
    Weight - Inventory
    Weight - Inventory
    nopaneltrue
    This is a numeric text box that is sometimes required. This field is required and editable only if the item is managed by Weight Only or Units or Weight Only. 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 Weight 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 transaction also allow users to set units as positive and weight as negative and vice versa. Weight can be entered with 5 decimals regardless of can be both positive or negative. Once an item has been selected, this field will display with the number of decimals set for the 'Weight Decimals' property configured on the 'Properties' tab for the selected Item on of the Item Record View. To maintain
    Insert excerpt
    Def - Weight - Inventory Calculations
    Def - Weight - Inventory Calculations
    nopaneltrue

    (lightbulb) 'Weight' and 'Weight UOM' fields will always display as the values entered by the user. However for consistency, weight that is saved using a UOM different UOM than the 'Default Inventory Weight UOM' will be converted and subsequently stored in the default Inventory Weight UOM.

    Database Field: ERPx_IMTransactionDetail.TransactionWeight

    Weight UOM

    Insert excerpt
    UOM - Weight
    UOM - Weight
    nopaneltrue
    This is a single-select standard lookup that is required to save a line item on transactions with a Status of 'Approved' or greater. This field will be disabled if the item is managed by Units Only. If enabled, it will default from the 'Default Inventory Weight 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' Weight UOMs on the selected Item's UOM Schedule.

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database FieldFieldsERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionWeightUOMSK


    Related Topics

    ...