Bulk Inventory Adjustment Through Import

Things to know:

-Adjustments in FIFO mode

If you are using FIFO mode, (first in first out) when you reduce inventory, the app will deduct the quantity from the oldest bucket first

Example:  You have two buckets.  The oldest bucket has 3 in it and the next one has 4 in it.   You tell the system to reduce inventory by 4

The system will deduct and eliminate the oldest bucket, and then take one from the second bucket.  You will be left with one bucket that has 3 left.

-Adjustments with average costing

The inventory total(s) will just go up or down since there are no buckets

-Adjusting the per-unit value.

If you have already received inventory for that product, Versa will know what the product cost and per-unit value is.   Putting that into the spreadsheet is optional.  If the new inventory you are putting in is a different value than what is there, you would need to enter that into the spreadsheet. (question below)

If there is already some inventory at one cost but you need to add new inventory at a different cost, cost entered will only affect new inventory entered.

If your current inventory is 0, then you need to tell Versa what your per-unit value is for what you are adding. 

To increase your inventory: 

First of 2 ways

This shows how to increase the inventory of part P9X1 from 10 to 20 using the physical_qty (the amount you actually do have in stock) column.  Doing it this way, you LEAVE ADJUSTMENT_QUANTITY BLANK.

You would use this if you just want to put in what you just counted.  Your end result will be 20

Second of two ways

The next example is by using the adjustment quantity.  This is where you would enter the variance between what the system thinks you have and what you actually have. 

Using the same example, we need to adjust the inventory from 10 to 20, so we put 10 in the Adjustment Quantity. 

THE QOH HAS TO BE BLANK IF YOU ARE USING ADJUSTMENT QUANTITY

Reducing Inventory-Physical Qty

Lets use the same example, but we are going to reduce the inventory by 5.

Versa says we have 10.

Using the physical qty column, put in the actual number you do have in stock, even if its less.  The result will be 5

LEAVE THE ADJUSTMENT QUANTITY BLANK

Reducing Inventory-Adjustment Quantity

Again, this is where you would enter the variance between what the system thinks you have and what you actually have. 

Using the same example, we need to adjust the inventory to only 5 so we put -5 in the Adjustment Quantity. 

THE QOH and the PHYSICAL QTY HAS TO BE BLANK IF YOU ARE USING ADJUSTMENT QUANTITY

Adjusting the same product across different warehouses.

You can use whichever of the above methods you like.  Your file will contain what the system has for your current inventory and a second (or 3^rd or 4^th….) line for each additional warehouse.

In the example below there are two warehouses that have P9X1  The WHS warehouse and the FAC warehouse.  As you can see we are using the adjustment quantity to do this adjustment.

Adjusting the per-unit Value

This shows an example of adding 10 items to P9X1 at the per-unit value of 5.5 using physical quanitiy.  This price will be only for these 10 items and not anything currently in the system.