We're diggin
g into an issue with discrepancies between voucher values. I noticed that if I compare the sum of VoucherEntry.amount to Voucher.balance for a given voucheronlineID, the Balance is only reflective of the sum of transactions for the storeID of the original VoucherEntry transaction. For instance, if you add up the transactions fro StoreID 241, you get what is shown in the Voucher table: 7.95. Why? Does it matter? Is the Voucher.Balance actually used anymore?
VoucherEntry
StoreID |
Date |
Amount |
241 |
8/31/2012 |
12.72 |
232 |
9/7/2012 |
-4.23 |
241 |
9/16/2012 |
-1.59 |
241 |
9/20/2012 |
-3.18 |
237 |
10/8/2012 |
-3.72 |
Voucher
StoreID |
Number |
Balance |
241 |
103582 |
7.95 |
*This post is locked for comments