Total issue

Hi Tamuna ,

I would have expected your ERP system's default AR module to produce the open AR balance as of a specific date without requiring you to compile that information manually. It seems like the data you are working with consists of transaction lists rather than an open items list for AR. Typically, once collections from customers are recorded, the AR module (well, AR accountants) clears the sales and returns by matching them with the corresponding payments, resulting in a much smaller list of open (uncollected) items.

My recommendation for calculating the overdue balance is by using the open items list extracted directly from your company’s ERP's AR module. This approach will simplify the calculations significantly.

Best regards,