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 each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]
Answer Question | March 31, 2012 1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL
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.
Answer Question | March 30, 2009 8:49 PM
SAP, SAP Aging Reports, SAP AR, SAP Reports