How to get User ID to print on a new order or invoice?
Question asked by Art Crowley - October 31, 2014 at 9:38 AM
You have given us the audit trails report.  How do we get the User ID printed on an order or invoice?  Basically the same thing as the CreatedBy on a purchase order.

1 Reply

Reply to Thread
Mark Culos Replied
October 31, 2014 at 1:39 PM
Employee Post
You will need to link the id table in the Primary data view on id.ID to respectively ord.SalesRep and invoice.SalesRep.
This approach is going directly to the transaction tables where the salesperson can be set manually.  If you are using the audit table, the user ID recorded is the person logged into Atrex, not necessarily the salesperson listed on the transaction.

Reply to Thread