
Hi! I'm trying to replace the Transaction type numbers with words that my users can understand. For example,
GL20000.Series = 3 AND GL20000.ORTRXTYP = 1 is a 'Sales Invoice'
I've got the names I need for GL, RM, PM, and Inventory (Series 2-5; thanks to Victoria Yudin for that!) but I still need the transaction type names for Payroll and Project modules. Can anyone out there provide them, please, or point me at the correct website to get them?
Thanks in advance for your help on this!
*This post is locked for comments
I have the same question (0)I think you'd be better off looking at the sourcdoc column as the transaction type. Payroll transactions are populating the ORTRXTYP column with 0. The sourcedoc value, however, is a much more understandable UPRCC (US payroll computer check).