Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

how do I select sales by class id for a certain dollar amount

Posted on 23 May 2011 14:22:18 by Microsoft Employee

We are on SL version 7.0 SP1.  How do I create a select criteria to show only customer class id that have an amount over a certain dollar to appear on the report?  This would be for the current fiscal year and prior fiscal year.  When I use the Sales Analysis by Class 08.720.00  with the arhist.ytdsales > "x" it still gives me all the sales instead of those that exceed "x"

Is there another report that will show in a user friendly format a comparison of prior year sales and current year sales in a side by side column format instead of the "stacked" format?

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans