How To Adjust Inventory

Adjustment transactions are a direct change to Inventory quantities and costs and are typically done to adjust for differences between quantities on hand as shown in the program versus a physical count. These transactions do not track any Vendor information or usage. This information does not post to the General Ledger.

Inventory Adjustment Entry

NAVIGATION: INVENTORY ACTIVITIES menu > Adjustment Entry

  1. Transaction Number is assigned by the program, leave blank.  Press TAB.
  2. Document Number is optional but can be used for your internal tracking purposes.  Press TAB.
  3. Select or enter the appropriate Transaction Date.
    1. This is the date all of the inventory transactions will be entered into inventory history.  
    2. You may back date a transaction to correct past mistakes.  
    3. Warning, it is usually best not to back date to a date that is before a Reset for Physical Count has been run.  Press TAB.
  4. Select or enter the Warehouse Code that this transaction will affect. Adjustments for different warehouses must be entered in separate transactions.
  5. The Entry Description is optional.  Tab through or enter a description and press TAB.  You will be taken to the first line of your transaction entry. At this time the header information will save and the Transaction Number will be filled in.
  6. Enter or select the Item Number to adjust and press TAB.
  7. Enter the Quantity to adjust.
    1. This Quantity is for the stocking units (also known as the Sell or Use Units).
    2. Do not enter the purchase or shipping from vendor units.  
    3. A positive quantity will increase the current inventory and the value.  
    4. A negative quantity will decrease the inventory quantities and value.
    5. EXAMPLE:  Paper towels have a current quantity of 18 rolls in warehouse 1.  A physical count only finds 12 rolls.  Enter -6 to decrease the amount on hand to the correct amount.  Press TAB.
  8. Unit Cost will pre-fill with the cost from the Inventory Item Master, Last Cost.  Press TAB to accept this cost or enter a revised cost as this time.  
  9. A revised Unit Cost, when posted with a positive quantity, will update the Last Cost to the new value.  
  10. Posting a negative quantity will not update the Last Cost.
    1. NOTE:  Do not enter a negative Unit Cost as this should always be a positive amount.  Never enter zero in the Unit Cost field.
  11. Enter the Inventory G/L account for the G/L Adjustment Account.  This field is mandatory.
    1. NOTE:  This transaction does not post to the general ledger, the general ledger account is only for reference.
  13. Your entry will drop down and be saved to the grid below and you will now be on line 2.  You may continue to enter other adjustment lines for the same warehouse.  
  14. When done, press SAVE at the top of the screen or press F2.

Inventory Adjustment Edit List

NAVIGATION: INVENTORY ACTIVITIES menu > Adjustment Edit List

  1. Press PREVIEW or PRINT and review the edit list.
  2. To save the report as a PDF file, click EXPORT > PDF.  Name/save the file.

Post Adjustment Transactions

NAVIGATION: INVENTORY ACTIVITIES menu > Post Adjustments

  1. Select the Warehouse or leave it blank to post all entries
  2. Press POST and PRINT the Transaction Report when the posting has finished.

1/2022

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388