ageing report from query (1 Viewer)

james bond

New member
Local time
Today, 11:32
Joined
Mar 31, 2020
Messages
4
I have made a query whereby I am getting result as per screenshot I want to make a ageing report problem is same bill number shows different amount as there is basic amount/taxes and so on and comes in rows not in columns I want ageing report to be made so that only once opening is there with date and all are arranged as date with single invoice amount and credit and so on and it should have option from to and should show unto 30days, unto 90 days and so on as per jpg attached please please help
the sql for query is
SELECT Account_Transaction.Ledger_Code, Account_Transaction.Amount, Account_Transaction.Vou_Date, Account_Transaction.DrCr, Customer_Master.First_Name, Customer_Master.Ac_No, Ledger_Master.op_bal, Account_Transaction.amountcr, Account_Transaction.inst_no, Sum(Account_Transaction.amountcr) AS [bill amount]
FROM Customer_Master INNER JOIN (Account_Transaction INNER JOIN Ledger_Master ON Account_Transaction.Ledger_Code = Ledger_Master.lg_code) ON Customer_Master.Customer_Code = Ledger_Master.alias_code
GROUP BY Account_Transaction.Ledger_Code, Account_Transaction.Amount, Account_Transaction.Vou_Date, Account_Transaction.DrCr, Customer_Master.First_Name, Customer_Master.Ac_No, Ledger_Master.op_bal, Account_Transaction.amountcr, Account_Transaction.inst_no
HAVING (((Account_Transaction.Ledger_Code)>90))
ORDER BY Customer_Master.Ac_No;
this is for 1 party only it can be all or single
 

Attachments

  • Screenshot 2020-07-10 at 11.55.42 AM.png
    Screenshot 2020-07-10 at 11.55.42 AM.png
    46.4 KB · Views: 238
  • IMG-20200710-WA0006.jpg
    IMG-20200710-WA0006.jpg
    36.8 KB · Views: 123
  • IMG-20200710-WA0006.jpg
    IMG-20200710-WA0006.jpg
    36.8 KB · Views: 240
  • Screenshot 2020-07-10 at 11.55.42 AM.png
    Screenshot 2020-07-10 at 11.55.42 AM.png
    46.4 KB · Views: 192

bastanu

AWF VIP
Local time
Yesterday, 23:02
Joined
Apr 13, 2010
Messages
1,401
Cross-post:
 

Users who are viewing this thread

Top Bottom