Skip to Content
0
Former Member
May 28, 2008 at 01:50 AM

XLR-AR Aging Report Parameters

39 Views

Hello,

I am modifying the SAP Receivables Aging XL Report template and I noticed that most parameters have not already been defined. The main problem I am encountering is how to accurately show a customer's total account balance if credit memos have been issued. If the AR DocType is defined only as Invoice, then the balance will be too high if credit memos exist. If Invoice and AR Credit memo are both selected, there is no way to properly assign open/closed DocStatus parameters- of course only OPEN invoice amounts should be shown, but all added credit memos are CLOSED.

To my knowledge, there is no way to bring in the "Balance Due" amount per invoice, which would seem to solve this problem most directly. Any suggestions? Thank you.