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
(50.246.228.233)
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: 3654
Loc: Toronto ON, Canada
(65.95.204.147)
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 (), 171 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14567 Topics
71092 Posts

Max Online: 1148 @ 11/22/25 01:55 AM
November
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