How to view the Net Purchase Return in my Qlik View File

qlik107 — Fri, 28 Aug 2009 15:45:02 GMT

My Query is that i want to view net purchase return as you can view in uploaded Qlik view file Tristar.

Here Net Puchase Return = Purchase Return - Void Purchase Return

But here i am getting the Void purchase return also

I want to view only Net Puchase Return Bills.

The Primary key is TrnType and TrnCtrlno

In the Void Bill it is BackRefTrnType and BackRefCtrlNo.

The same problem is for other transaction also

The QlikView File is present on the Web Server with Link

http://www.4shared.com/file/128317461/b223a122/Tristar.html

pls help me out ..................

Ashish Michael

topic How to view the Net Purchase Return in my Qlik View File in QlikView