Inventory Adjustment |
The Inventory Adjustment screen allows you to manually change incorrect On Hand inventory quantities for your products. After you make your adjustment, you can use the Inventory Inquiry screen to view your adjusted inventory amounts for the product. The Inventory Adjustment Report will allow you to track the adjustments that have been made. For more information, see the Inventory Adjustment Report page.
General Ledger Inventory Adjustments generate a posting to your default Inventory Change account, set in your G/L Control Table. The cost field that will be used to calculate the posting amount is specified in your Company Master, under the Pricing/Costing tab in the "Inventory Adjustment Cost Column (C1 to C7)" field. In situations where the adjustment should post to a different General Ledger account, the G/L Account can be changed during the adjustment process. This change can affect individual products in the adjustment or the adjustment as a whole. For more information on changing the General Ledger account, see the Changing the Adjustment G/L Account page.
To make an Inventory Adjustment follow the easy steps below. The inventory amounts will be updated as soon as the adjustment is saved and a posting will be generated to the appropriate General Ledger account(s).
1.Select Inventory > Inventory Adjustment.
2.Enter the date that you want the adjustment to take effect using the drop down menu in the Date field. If you want the adjustment to take effect at a future date, enter that date in the field, but be aware that your inventory will not reflect this adjustment until that selected date.
3.Enter your system initials in the Initials field and press Tab.
4.Enter the reference code for the warehouse that you want to adjust in the Warehouse field and press Tab, or use the to search for the correct warehouse.
5.In the Type section, select Inventory Adjusted or Inventory Physical. An Inventory Adjusted change will add or subtract from your current inventory amount. An Inventory Physical change will override and replace the Current On-Hand quantity.
6.Now in the window below, enter the reference code for the product that you would like to adjust in the Product field and press Tab, or use the to search for the correct product. Assembly items cannot be adjusted.
7.The row will display the product's current inventory for On Hand and Committed quantities in the selected warehouse. In the Adjust Quantity field: for Inventory Adjusted enter the quantity that you want to add or subtract from the Current On-Hand quantity for Inventory Physical enter the quantity that you want to replace the Current On-Hand quantity
8.You can adjust as many products as necessary. When you have completed your adjustments, click the Save button in the bottom toolbar. An example of a completed Inventory Adjusted entry is shown below. Click on any field for more information.
|