EH
Asked
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,
1. Every product purchased have a "quantity_balance" in database right ?
2. 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".
1. Every product purchased have a "quantity_balance" in database right ?
2. 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".
- MSAnsweredHello,
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 - EHAnsweredYeah, 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. - EHAnsweredIm 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" - MSAnsweredHello, 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.
- Login to Reply