Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...
I am trying to run AR Aging reports in SAP by customer and also by invoice, what is the best method to do this? My current attempts have bben made using S_ALR_87012178 and S_ALR_87012168. Any suggestions would be much appreciated.