Skip to Content
0
Former Member
Aug 29, 2016 at 03:14 AM

SAP Business One Customer Account Balance Query

4570 Views

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,