Hi All,
how can i query a customer account receivable balance,
example:
Customer A have a balance of 5000 as of 28/08/2016, now he/she have invoice dated 29/08/2016 amount of 2000 and the invoice is already process and debited to customer as AR, now when i generate the query dated to 29/08/2016, the display balance of Customer A is 7000 and also in payment example in the next day 30/08/2016 his payment arrive and process in incoming payment so the balance of customer A has credited amount of 2000 or the invoice amount, so when i generate query the balance of customer A is back to 5000. can any one help me regarding with my concern,
Thanks a lot guys,