Inventory Adjustments

Overview

Inventory Adjustment entries can be used to increase and decrease the quantities of inventory items.

Create a New Item Journal

Open the App Launcher. Search for Item Journals.

Click on New.

Select Inventory Adjustment for the Record Type and click on Next.

Fill in the following fields:

1. Enter the To Warehouse.

2. Enter the To Bin.

3. Enter the Posting Date of the adjustment.

4. Select Add Adjustment Lines to enter Item Line information.

   

5. Enter the Item to adjust.

6. Enter the Unit of Measure to adjust.

7. Enter the Quantity. If you want to increase the inventory, enter a positive number in the Quantity field. If you want to decrease the inventory, enter a negative number in the Quantity field.

8. Enter a Reason.

   1. Reason values can be customized.

When complete, click Save.

Enter Lot Numbers for Lot Tracked Items

If the item(s) is Lot Tracked, select the red Enter Lots button to enter lot numbers individually or select the Enter Lots button in the header.

Select Add Tracking Lines to enter Lot numbers and the quantity.  

The sign of the Quantity of the Tracking Lines must match with the Quantity on the Item Journal Line.

Save the Item Journal Line.

Post the Item Journal

Click on Post to post the Item Journal.

By default, all item adjustments will be posted to Account Inventory Adjustment defined on the Company Setup.

If you want to post the Item Adjustments to different GL Accounts based on Reasons, you can add a formula field to the GL Entry table to read the Reason value from the Item Journal Line, then you can run a report to group Inventory Adjustment GL Entries by Reasons.