Collapse AllExpand All

5.1.  Adjustment Transaction

To make a miscellaneous Adjustment to the Quantity on Hand for an Item, select the "Adjustment Transaction" option. The following screen will appear:

Enter Adjustment Transaction

Note

Use the Adjustment transaction utility to handle Inventory adjustments not covered by another transaction type—for example, Receipt from Purchasing, Receipt from Manufacturing, Scrap, etc. For a complete list of Inventory transaction Types, see Section 1, “ Inventory Transaction Types”.

When creating an Adjustment transaction, you are presented with the following options:

Transaction Date

Specify the date you want the transaction to be posted to the General Ledger. The current day's date will display by default.

Item Number

Enter the Item Number of the Item you want to create an Adjustment transaction for.

UOM

Inventory Unit of Measure.

Site

Specify the Site where the Adjustment transaction should be recorded. If an Item is located in more than one Site, be sure to specify the correct Site for the Adjustment.

Adjustment Qty.

The number entered will adjust the Quantity on Hand for the specified Item. Field accepts positive and negative numbers. To enter a negative number, simply prefix the number with a minus symbol.

Relative

Select to make a relative adjustment to the Item's Quantity on Hand. The "Before" value, which represents current Quantity on Hand, will increase or decrease relative to the number entered in the "Adjustment Qty." field. The new Quantity on Hand value will appear beneath the "After" heading. Non-netable Quantity on Hand is not included in these values.

Absolute

Select to make an absolute adjustment to the Item's Quantity on Hand. The "Before" value, which represents current Quantity on Hand, will be changed to the new value entered in the "Adjustment Qty." field. This absolutely new Quantity on Hand value will appear beneath the "After" heading. Non-netable Quantity on Hand is not included in these values.

Document #

Creates a user-defined reference for the Adjustment transaction. The Document reference will be posted with the General Ledger (G/L) transaction record when the Adjustment is generated. This field may be used for internal tracking and auditing purposes.

Adjust Value

The Cost tab will be visible only if Average Costing is enabled on the Configure Inventory screen. The Cost tab will be enabled only if Average Costing is the Cost Method selected for the Item Site being adjusted. If Adjust Value is checked then the transaction will affect the value of perpetual inventory using the following Costs:

Calculated

Use the average cost calculation to determine perpetual Inventory value and distribute costs for this transaction.

Manual

Use the total cost entered to determine perpetual Inventory value and distribute costs for this transaction.

To enter Notes related to the Adjustment transaction, select the "Notes" tab. The following screen will appear:

Adjustment Transaction Notes

When entering Notes related to an Adjustment Transaction, you are presented with the following options:

Notes

This is a scrolling text field with word-wrapping for entering Notes related to the adjustment.