baan999
11th June 2011, 15:44
I am developing query / report from tfacp200 table.
selection from tfacp200 type,doc.no,doc.dt and tpay = 1 and amount.
record is appearing correctly. Invoice booked status.
now the invoice is linked and paid . and only unpaid/unlink document details require to define in query.
how to define??
selection from tfacp200 type,doc.no,doc.dt and tpay = 1 and amount.
record is appearing correctly. Invoice booked status.
now the invoice is linked and paid . and only unpaid/unlink document details require to define in query.
how to define??