Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Item Sales Summary Filter by SalesRep |
Author |
Message |
|
Posted : 2007-05-25 02:06:45 |
Is there a way I can call up the SalesByItemSummary report with a filter showing only certain sales reps? If not, how can I pull this information via SQL? (Just looking for tables I need to pull).
I am looking to show gross profit for each item sold by a sales rep.
Thanks,
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-25 13:08:43 |
You can't use the SalesByItemSummary report, but the SalesByItemDetail report can be filtered by sales rep like this:
sp_report SalesByItemDetail show SalesRep, Text, Blank, TxnType, Date, RefNumber, Memo, Name, Quantity, UnitPrice, Amount, RunningBalance parameters DateMacro = 'ThisMonthToDate' where SalesRep='YourRepsName' |
|
|
|
|
Posted : 2007-05-26 01:57:39 |
Thank you, it does provide me with the items sales according to the Sales Rep, but unfortunately, the SalesbyItemDetail report does not provide the Gross Margins which I need to track as our sales reps are paid commission according to this.
Thanks,
Daryl |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-26 09:47:47 |
|
|
|
|