here is the output of the report, the payment is used to settle 4 invoices, but the record is also 4 times, however the other invoice is used to settle one invoice hence it is getting printed once, how to avoid this?
in fetch method i have written the following code
public boolean fetch()
vendtrans vendtrans_2, vendtrans_3;
int64 payment_recid, invoice_recid;
ret = true;
qrun = new QueryRun(element);
vendtrans_2 = qrun.get(tablenum(vendtrans));
while select * from vendsettlement_2 where vendsettlement_2.TransRecId == vendtrans_2.RecId
select * from vendtrans_3 where vendtrans_3.RecId == vendsettlement_2.OffsetRecid;
Is this NAV? Looks more like AX.
Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
© 1995-2013 Dynamics User Group, all rights reserved.