Hello,
I have created a custom report to show aged vendor payables by project. Everything is working well, except that it is pulling all of the vendor invoices, not just the unpaid ones.
I am not completely familiar with the database table and field structure and after searching through the DataDict.pdf that I have, I am unable to find the "paid" flag field. I am assuming there is one that I can use to filter my results and remove the paid invoices. I am currently working with the titrec, titluip, titlu and tproject tables, so may need to reference another table or use something a bit different.
Any help or direction at all would be greatly helpful.
Thanks