knockoff Invoices documents as per payment received (Ageing)

[vikasmahajan]

Dear All

Please refer my excel file  APS472-AGE.xlsx  in this excel file in have all documents in first tab in

second tab I have adjusted document and there amounts.

My requirement is arrive ageing analysis  as per adjustments done in adj tab.

Kindly help me to arrive this logic. I have attached PDF file  also as per pdf file I want to develop in qlikview.

Thanks in adv.

Vikas

[vikasmahajan]

This are adjustment i.e. 4518+216 =  5000  adjusted amt and document amt (inv/12-13/7371) is 5000 hence it is nill.

Vikas

[Jason_Michaelides]

Errr....

4518 + 216 = 4734, not 5000...!

[vikasmahajan]

Sir this is adj status

DocNo	AdjDocNo	adjDocAmt	AdjDocDt	ADJ_ADJDOCADJAMT
COL/12-13-VC/7248	INV/12-13-VC/9042	5000	31/12/2012	4571
COL/12-13-VC/7248	INV/12-13-VC/7371	5000	21/11/2012	216
COL/12-13-VC/7248	DBN/12-13-VC/0293	5000	08/03/2013	213

4571+216+213 = 5000

[vikasmahajan]

I have all invoices / credit notes /debit notes and collection in one tab in another tab i have adjusted entry

now I want to calculate o/s  means all  entry - adj entry = will be my balance (Document wise)

Hope this clear now

Thanks

Vikas

[Jason_Michaelides]

Your table above still doesn't make sense but maybe this is what you want?

[vikasmahajan]

Many many Thanks Sir  for  spending your valuable time to resolve my issue

I will check and get back you soon , I have to check with Live data.

Vikas

[vikasmahajan]

I really Thankful ! !!!!!!!!  You have spend your valuable time to resolve this issue , I will implement in live and get back you.

Vikas