Stock Take by Web Spreadsheet
This article explain, how do adjustment using web spreadsheet. It will readjust current product inventory with new inventory quantity that you have input. With this way, it will make stock take easier if there were only a few items that you need to readjust and synchronize our system with your physical inventory. Let me explain it by an example case.
In my inventory i have 7 Bottles of Coca-cola, 5 boxes of coca-cola, 5 bottles of Fanta Grape Flavor, 7 bottles of Fanta Orange Flavor, 2 bottles of Fanta Strawberry-flavor , and 10 Chocolate Milk. After i check my inventory in the store(physical store) i accidentally discover 3 of my Chocolate milk are expired, and 2 of my coca-cola bottles are missing, and i only have 2 boxes left of coca-cola, and i have in total 6 bottles of Fanta Strawberry Flavor. It has a different number with the system. So, what i need to do now? Well let's follow these step.
Step 1. Go to adjustment menu and then click on Stock Take by Web Spreadsheet
after you click it, you will be redirected to this page.
Step 2. After that fill the form with current number of you physical inventory
In this case, i have in total 7 Chocolate Milk, 5 bottles of coca-cola, 2 Boxes of coca-cola, and 6 bottles of Fanta Strawberry-Flavor, and the rest are just fine.
I need to fill the form like this:
Step 3. After you click confirm adjustment a report will be created
It will be located in archive so you can track the history that you have changes.
Watch video for stock take by web spreadsheet
Articles in this Section
- Inventory Adjustment
- Stock Take By Csv File
- Stock Take by Web Spreadsheet
- Inventory Adjustment with Replace Quantity