Inventory adjustment


From this page, you can adjust the system stock of an item based on its physical count. On a day to day basis, physical count of inventory may increase or decrease due to stock received or wastage, stock movement etc.  Such adjustments can be entered via this page.


In Just Billing Application you can also create bin locations and maintain bin wise stock allocation among the Bin locations with respect to branch which is also explained below.  


1. How to update stock by using Adjustment type ?


1. Navigate page to Menu > Transactions > Inventory adjustments

2. Select Adjustment type

3. Enter quantity of the product for which inventory needs to be updated

4. If you wanted to update inventory for multiple products update the quantity of the products for which inventory needs to be updated.

5. Save, Inventory is updated and then current stock is updated based on quantity entered.  


(Figure 1 - Adjustment - Physical Count-IN)


Adjustment Type :  In Just Billing application you can define various types of Adjustments (see figure 1):


Lets say current stock of an item = 100.

  • Physical Count -In : If you select Adjustment Type = Physical Count -IN, and enter the quantity =10, current stock =  100 + 10 = 110
  • Physical Count -Out : If you select Adjustment Type = Physical Count -OUT, and enter the quantity =10, current stock =  100 -10 = 90
  • Spoilt : If you select Adjustment Type = Spoilt, and enter quantity = 10, current stock = 100 -10 = 90
  • Initial Stock - If you select adjustment type Initial stock = Initial stock, and enter the quantity = 100 current stock = 100
  • Over shipments : If you select adjustment type over shipments = over shipments, and enter the quantity = 10, Current stock = 100 + 10 = 110
  • Incorrect receiving : If you select adjustment type Incorrect receiving = Incorrect receiving, and enter the quantity = 10, Current stock = 100 - 10 = 90
  • Breakage : If you select adjustment type Breakage = Breakage, and enter the quantity = 10, Current stock = 100 - 10 = 90
  • Wastage : If you select adjustment type Wastage = Wastage, and enter the quantity = 10, Current stock = 100 - 10 = 90
  • Theft : If you select adjustment type Theft = Theft, and enter the quantity = 10, Current stock = 100 - 10 = 90
  • Loss : If you select adjustment type Loss = Loss, and enter the quantity = 10, Current stock = 100 - 10 = 90
  • Others Stock In : If you select adjustment type Others Stock In = Others Stock In, and enter the quantity = 10, Current stock = 100 + 10 = 110
  • Others Stock Out : If you select adjustment type Others Stock out = Others Stock out, and enter the quantity = 10, Current stock = 100 - 10 = 90


(Figure 2 - Adjust types)


2. How to add inventory for the products managed by Serial numbers ?


From Menu> Transactions > Inventory Adjustments page:


  • Select an adjustment type from the drop down, for example Other Stock-In. (see figure 3)
  • Select product(s) for which you want to do inventory adjustment . You can select many products as well.  
  • Enter the quantity to be adjusted, for example 4, Then it will open Stock-In page where you can add serial number and other details of the product. (see figure 4)
  • In Add serial page you need to enter mandatory following details like serial number and admission date. Serial number : Enter serial number of the product, Admission date : Select the date when it was admitted in to your store.  (see figure 4)
  • You can also add other details of the product like Expiration date : Select Expiry date of the product, Warranty start date : Warranty start date of the product and Warranty End date : Select Warranty end date of the product.
  • Similarly add details for other units of the same product till Total needed and total created are equal and then save .
  • Then Proceed, Product Inventory is added with serial numbers.

                                               

(Figure 3 - Product selection for Adjustment Screen)


(Figure 4 - Product quantity entry for Adjustment Screen)


3. How to add inventory for the products managed by Batch numbers ?


From Menu> Transactions > Inventory Adjustments page:


  • Select an adjustment type from the drop down, for example Other Stock-In. (see figure 5)
  • Select product(s) for which you want to do inventory adjustment . You can select many products as well.  
  • A “batch number” is a unique identifying number (or set of letters and numbers) assigned to one product batch which can be used to identify each individual finished product made in that batch. When you assign batch numbers and put them on the products, you can just look at the product label and know immediately from which batch that particular item came.
  • Enter the quantity to be adjusted, Then it will open Stock-In page where you can add batch number and other details of the product.  (see figure 6)
  • For example 20 where 5 units are from one batch and other 15 units are from other batch.
  • In Add Batch number page you need to enter mandatory following details like Batch number and admission date. Batch number : Enter batch number of the product, Lot size : How many units of product are from this batch and Admission date : Select the date when it was admitted in to your store.  (see figure 7)
  • You can also add other details of the product like Manufacturing date : Select date of manufacture of the product. Expiration date : Select Expiry date of the product.
  • Similarly add details for other batch of the same product till Total needed and total created are equal and then save .
  • Then Proceed, Product Inventory is added with batch numbers are updated.  



 

(Figure 5 - Product adjustment typeScreen)


(Figure 6 - Product quantity entry for Adjustment Screen)


(Figure 7 - Add Product Batch and Lot quantity)


4. How to add stock in Bin locations ?


1. Navigate page to Menu > Transactions > Inventory adjustments

2. Select Adjustment type.

3. Select Bin location.

3. Enter quantity of the product for which inventory needs to be updated.

4. If you wanted to update inventory for multiple products update the quantity of the products for which inventory needs to be updated.

5. Save, Inventory is updated and then current stock is updated based on quantity entered in to selected bin location.


(Figure 8 - Bin wise stock quantity entry )


(Figure 9 - Bin location wise stock quantity entry screen )


(Figure 10 - Bin location stock updated screen )


(Figure 11 - Save Inventory add quantity  )


5. How to allocate stock from one bin to other bin location ?


1. Navigate page to Menu > Transactions > Inventory adjustments

2. Select Stock Allocation.

3. Select Bin location from which you wanted to transfer stock from left side where you see From Bin location.

4.  Select Bin location to which you are transferring stock from right side where you see To Bin location.

5. Enter quantity of the product for which inventory needs to be transferred From location to To bin location.

6. If you wanted to transfer inventory for multiple products update the quantity of the products for which transfer needs to be updated.

7. Save, Inventory is updated in receiver bin location and then current stock is updated in senders bin location based on quantity entered in respective selected bin locations.  


(Figure 12 - Bin wise stock allocation and transfer )


(Figure 13 - Bin wise stock allocation and transfer )


(Figure 14 - Bin wise stock allocation and transfer )


(Figure 15 - Bin wise stock allocation and transfer )