adjustments

 

An adjustment is used to remove or add products to inventory for various reasons. An example of when adjustments are required would be for incorrect receiving.

 

The following procedures are outlined in the Adjustments document:

Create an Adjustment

  1. In General>Warehouses, select Adjustments.
  2. In the Warehouse Adjustments main index, click to create a new adjustment record.
  3. In the New Record dialog box, enter the date in the Trans Date field that the adjustment will take place.
  4. From Warehouse No, select the required warehouse where the product being adjusted is stored, and then click 'OK'.
  5. In the Warehouse Adjustments screen, click to add a new adjustment product.
  6. The Product Inventory selection screen will display all current products available for adjustment as of the date entered in the dialog box.
  7.  

     

  8. Select the product to be adjusted. From Trans Code, select the type of adjustment transaction. Available options are:
    1. Inventory Variance Credit - will reduce the inventory quantity by the units entered.

    2. Inventory Various Debit - will increase the inventory quantity by the units entered.

  9. In the Units Entered field, enter the number of inventory units to be adjusted.

  10. Click 'OK' and the Warehouse Adjustments screen will appear with fields populated.

 

 

  1. Trans Code displays the type of adjustment transaction selected.
  2. Product Type displays the type of product. Derived types will be Field Products, Medication, or Vaccinations.
  3. Product No displays the code for the product that is being adjusted.
  4. Product Name displays the name of the product.
  5. Inventory Units displays the number of units to be adjusted.
  6. Price is the value of the adjustment based on the selected costing method, Average Cost or FIFO.
  7. Unit Price is the average cost of the product being adjusted calculated based on Price / Inventory Units.
  8. Lot No is a unique identification number for the product, and is generally used for medications and vaccinations.
  9. Location No indicates the location where the product is stored.
  10. Ref No is a unique reference number used to identify the adjustment line. Ref No is optional and be manually entered or can be generated by the system if the registry switch is turned on.
  1. Event Date displays the date the adjustment was created, and can be modified if required.
  2. Expiration Date will default based on the product selected, and is optionally defined on medications and vaccinations.
  3. Time displays the time that the adjustment can take place, and can be modified if required. Enter the Time that the adjustment can take place.
  4. In the Comments field, enter any additional information related to the adjustment record.
  5. Selecting the Void flag will cancel the adjustment transaction.

Post an Adjustment

The posting process locks the adjustment to prevent edits, and creates the journal transaction to record the liability. The UnPost option unlocks the adjustment and reverses the journal transactions.

 

  1. In the Warehouse Adjustments index, select the required product and right-click to select 'Post'.

Journal Transaction

The posting process creates the journal transaction. The journal will credit or debit warehouse inventory and credit or debit adjustment expense.

 

DEBIT/CREDIT Warehouse Overhead Inventory Adjustments
CREDIT/DEBIT Warehouse Inventory