About The Quantity Not Sync With Physical Stocks
0
Good morning, do you still remember about the old problem where the product quantity in SMA is not same with the quantity in rack/physical. Here is what i found,
- Every product purchased have a "quantity_balance" in database right ?
- The "quantity_balance" is for the quantity of product left when sold right ?
Lets say i purchased of "Product A" for 10 pcs and if i sold 5 pcs thats mean the "quantity_balance" will become 5 right ?
If what i said is correct, i found something strange. Im not sure if it is behave like that or a bug or whatever it is. There is a setting where we can input/scan a product on pos page if it is the same product we increase the quantity/add a new one with the same product. So it will look like this
Product A 1
Product A 1
Instead of
Product A 2
Here is the scenario, lets say from above i purchased 10 pcs of "Product A" if i sold it by using
Product A 2 => the "quantity_balance" in database become "8". That is correct because 10-2 = 8.
But if i use
Product A 1
Product A 1
The "quantity_balance" in database become "9".
0
Hello,
I didn't understand the different between A 1 and A 2
Are you saying, the same item is add to purchase as multiple rows. If yes that should work fine.
Can you please explain the names so that I can test. Just let me know the the different in Product A 1 & Product A 2 If you can give me step that would be great.
Thank you
0
Yeah, sorry about my poor explanation. Lets say i purchased "MILK" 10 PCs. In pos mode we have like
Product Qty
MILK 1
or
Product Qty
MILK 2
If i do it like that, i see on database the "quantity_balance" for milk is correct. For example 10 - 2 is 8. But i use "Add new item to cart" like this
Product Qty
MILK 1
MILK 1
The "quantity_balance" in database should be 8 right ? But when i checked it, the "quantity_balance" is 9.
0
Im not saying about purchasing, its about selling the product in POS mode. I just checked the purchase table inside database and there is "quantity_balance" thats for the product quantity after it being sold right ?
I forgot to tell you, i tested it on prev version 3.4.44. I havent updated it to new version yet, just wanted to let you know. The accounting method i choose was "AVG COST"
0
Hello, Thank you for the details. I will check it in this week's update and let you know, if I have any question or feedback.
Instantly elevate your business, earn more money, attract more clients, and deliver exceptional digital experiences. Tecdiary is the leading independent provider of inventory & e-commerce solutions for digital experiences. What sets our solution apart for partners is our modular, flexible architecture and customizable licensing model. With Tecdiary, partners are free to build, customize, and extend the platform to create amazing digital experiences for your individual clients or to support your own packaged solution.
We use Cookies
We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.