Dear All
I have excel sheet containing ledger and its adjustments and attachment of ledger and oustanding statetment of one customer in pdf.
Now We want to calculate age wise oustanding as as pdf attached aps472os.pdf format. I have achived ledger which you will find in
ledger sheet of excel ledgeros.xls.
Now take example of credit note crn/12-13-VC/0300 document is adjusted with invoice INV/9365/4VC document so the o/s of credit note docuement will be zero as well as invoice document 9365 will have balance zero and this is for all documents in ledger.
Finally balance o/s will remain as per aps472os.pdf report.
How to achive in qlikview Please Gude me.
Thanks in advance
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
