Can't seem to find what table has the information for the outstanding invoices and partially paid invoices. Can someone help? Looks like the data dictionary might be dated on this site as it pertains to Version 2011.
What dictionary did you use?
Try this one:
- The bPrePaid column in the tSalOrdr table tells you if an order has already been paid or not.
- And in the tUsrPrf2 table, the bHidePaidS column enables the option to hide whether a sales invoice is paid or not. It is a Boolean data type so you can set it to false.
Thank you I will give that a try. I was under the impression the data was on titrec table not tSalOrdr.