Purpose: The Adjust Inventory Quantity page provides the ability to make adjustment to an item’s quantity for an item with a specific set of attributes (location, Lot, etc). Inventory adjustments made in Rapid Inventory are synchronized immediately with QuickBooks, with the next sync cycle.

Adjust Inventory Header Data Elements:
  1. Item No: Item name
  2. Location: Item’s stocking location
  3. Lot: Item Lot number for the associated quantity.
  4. FIFO Date: The first in / first out date for this item at this location, for this quantity.
  5. Expiration Date: The expiration date associated with this lot, quantity, and location.
  6. Hold: This is the hold reason for the item and quantity at this location.
  7. UOM: Item unit of measure
  8. On Hand: Total on hand inventory for this item at this location.
  9. Available: Total available inventory for this location. Available = On hand minus on hold.
  10. Description: Item description

Adjust Quantity Data Elements:
  1. UOM: Selection for the UOM from the drop down.
  2. Current Quantity: Displays the current quantity
  3. New Quantity: This is the entry box for the adjusted quantity. By default it will show the current quantity.

Adjust Attributes Data Elements:
  1. Class: The QuickBooks class assigned for this transaction.
  2. Inventory Adjustment Ledger Item: This is the QuickBooks account assigned for inventory adjustments. Selecting ‘Use Default’ will assign the default account that was established in the Settings > Basic Settings section. You can also select a different account for special adjustment situations where you may have an additional account (COGS typicially) set up in QuickBooks.
  3. Customer: The customer name associated with the inventory adjustment that will appear in the Name field on the Audit Trail in QuickBooks.
  4. Memo: General memo field for the adjustment that will appear on the Audit Trail in QuickBooks
  5. Reference Number: This is a transaction reference number that can be any desired scheme. This will appear on the Audit Trail report in QuickBooks.
  6. Transaction Date: By default, the transaction date is set to the current date. If needed, the transaction date can be changed in this field. The transaction date entered into this field will be used as the Adjustment Date in QuickBooks.
  7. Action Buttons:

To view a tutorial illustrating the inventory adjustment process, click on the arrow below: