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.

Please help.

Views: 204

Replies to This Discussion

Hello Jason

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.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service