I'm preparing a Z report, in that i have to capture the customer balances for a particular date. But the problem is all the open line items in BSID are moving to BSAD after done the payment against to these line items. In this situation balance amount is changing in the report. what is the way to capture the O/S as on a particular date?
ex: Customer X O/s as on 01.01.09 is 1000
Later on i've made the paymnet 500 as on 03.01.09
if i run the report as on 01.01.09 now the balance is appearing as 500 which is nor correct.
can anyone provide me the table logic for this issue?