Please solve the problem, this is very important data, they are very necessary! What do you need to fix this bug?
There are 2 functions that show the quantity and amount in stock on the date: SEPARATE SECTION and FILTER FIELD.
The same fields Quantity and Amount are displayed. But the values in them, firstly, are different, and secondly, they are incorrect.
Section TOTAL QUANTITY IN STOCK AT DATE: Screen 1
1. When displaying balances to check for the current time (at the moment), the quantity and amount do not match.
2. The amount is more like the sum of the retail prices of goods, but also does not match.
3. I checked the change in the number of goods after each movement in the warehouse - it works correctly.
Section WAREHOUSES, filter SHOW TOTAL VALUES: Screen 2
1. The balances and their sum at the moment are the same.
2. I checked the balances after each operation in the Journal and found a BUG. The rest are changed incorrectly. Example:
Quantity on the date 2022-11-11 18:16 - 1267 pieces, which corresponds to the current balances in the Quantity column. Screenshot 3
The last operation was at 2022-11-11 18:14:00.
Operation Sale - 4 pcs. Screenshot 4
It is logical that before this operation, the balance should be 1267 + 4 = 1271 pieces.
BUT! Balances on 2022-11-11 18:13 - 1270 pcs. Screenshot 5
One item missing.
Correct the mistake. Make the report work correctly.
Maxim Dmitry Igor Maxim