Share
ReportI am looking for a report that will give me all the sales by Salesman showing the profit margins
per invoice
TY
*This post is locked for comments
You’re offline. This is a read only version of the page.
I am looking for a report that will give me all the sales by Salesman showing the profit margins
per invoice
TY
*This post is locked for comments
As I do not have access to Smartlist Designer I had to export info into Excel and make my own list.
You could create a field - smartlist designer or in excel
" Sales transactions would work and Sales Line "
Profit Margin is not an available add on
You could use smartlist. Sales transactions would work and Sales Line items would be good too. Smartlist does have quantity, extended cost, extended price, unit cost, unit price and salesperson info. You might have to add a few fields (admin - smartlist). Play with it and check out all the fields available. Then you could dump it into excel and format it from there.
"Please provide the required template, and we will help accordingly.
Your feedback is highly appreciated, "
What ae you asking for? I responded to the post in regards to 'Period Sales Analysis Report' !!
Please provide the required template, and we will help accordingly.
Your feedback is highly appreciated,
deanne0917:
This report is good for an overall look but I need to drill down to the item level per invoice !!!
Another good option by deanne0917
If you have got a specific report template, share it and we can definitely provide a customize SQL script accordingly.
Your feedback is highly appreciated,
You could try the 'Period Sales Analysis Report' (Sales-Reports-Analysis)
This report gives you sales, returns, cost, gross profit, profit margin, writeoff, discounts taken, etc. You can run it in a variety of ways too!
In addition to the fact that you can create a custom report for this purpose, you can still use the Smartlist to get a quick result. Check this out How to create SOP Salesperson Report in Smartlist
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
