You’re offline. This is a read only version of the page.
Sorry new to GP, anyone have a way to get a list by customer , show year to date sale , and last year to date sales
so if it's may 16, 2017 , I want to see jan 1st 2017 to may 16th 2017 , then next to it jan 1st 2016 to may 16th 2017
*This post is locked for comments
Hi Jenn,
Your suggestion was posted in the Dynamics365 General section.. which I don't think the dev team that's looking for Dynamics GP suggetions will ever look at..
You should move your suggestion to the proper place in the suggestion site if you want it to be considered.
I've added this to suggested ideas as its something that would be really useful:
You can vote for this idea here:
https://experience.dynamics.com/ideas/idea/?ideaid=963eb621-1830-eb11-8441-0003ff68e66e
Thanks
Hi Cameron1,
I wonder if you could get this list in SmartList or SmartViewer?
There is a Total Sales report you can run, just modify the columns you need, thn filter out the year(s) you want. SmartList can run this pretty quick, but if you want the columns to be a bit fancier, I would suggest SmartViewer.
Hi Cameron,
Welcome to the GP Community.
I would start with this view and adapt it to my needs. victoriayudin.com/.../sql-view-for-sop-sales-by-customer-by-month
You will want the view to call the SQL server system date so the data can be generated dynamically.
Regards,
Kirk
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (