Topic Options
#55629 - 11/13/17 09:43 AM Where is Sales Rep Code On Transaction History?
richlocus Offline
Marco Pharma, LLC

Registered: 09/26/17
Posts: 21
Loc: Oregon
Hello:

Cancel this request. I located it in the order header file.

I'm looking at table ICTransactionHistory_an81chaj, which is the perfect table to review product sales history, but there doesn't seem to be a sales rep code. I need to know which sales reps are doing the best job, but the Transaction History only shows data related to the customer. How can I get the sales rep responsible for the sale?

Thanks,
Rich Locus


Edited by richlocus (11/13/17 10:47 AM)
_________________________
Rich Locus
Marco Pharma, LLC

Top
#55630 - 11/13/17 11:51 AM Re: Where is Sales Rep Code On Transaction History? [Re: richlocus]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3616
Loc: Toronto ON, Canada
Hi Rich:

The other place that you can find Salesperson information and product sales history together is the Sales Analysis module. Not everyone has this module but if you plan to do a lot of analysis, it makes those types of reports easier to create and faster to run.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 64 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14475 Topics
70699 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31