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. 

Per-unit value only affects inventory being adjusted. If inventory is adjusted up, then the new inventory will have the per-unit value.  If inventory is adjusted down, inventory value is deducted based on per-unit value. Existing inventory is not affected by the per-unit value and it can have a different per-unit value.

 

 

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.

part_number	facility_code	qoh	physical_qty	adjustment_quantity
P9X1	WHS	10	20	LEAVE 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. 

part_number	facility_code	qoh	physical_qty	adjustment_quantity
P9X1	WHS	LEAVE BLANK	LEAVE   BLANK	10

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

part_number	facility_code	qoh	physical_qty	adjustment_quantity
P9X1	WHS	10	5	LEAVE 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

part_number	facility_code	qoh	physical_qty	adjustment_quantity
P9X1	WHS	LEAVE BLANK	LEAVE   BLANK	-5

 

 

 

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.

 

part_number	facility_code	qoh	physical_qty	adjustment_quantity
P9X1	WHS	LEAVE BLANK	LEAVE   BLANK	-5
P9X1	FAC	LEAVE BLANK	LEAVE   BLANK	10

 

 

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.  

 

 

part_number	facility_code	qoh	physical_qty	adjustment_quantity	uom	per_unit_value	inventory_date	balancing_gl_account_name
P9X1	WHS		10		EA	5.5	2/5/2021