Stock Take by Web Spreadsheet

Customer Support DEALPOS
[Updated]

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.

Example case:
mceclip0.png
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 Spreadsheetmceclip1.png

after you click it, you will be redirected to this page.

mceclip2.png

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:

mceclip3.png

 Step 3. After you click confirm adjustment a report will be created

mceclip4.png

 It will be located in archive so you can track the history that you have changes.

mceclip5.png

 

Watch video for stock take by web spreadsheet


Was this article helpful?
1 out of 1 found this helpful

Articles in this Section

Comments

0 comments