Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Chris Soraparu]

How do I set up a date filter to show the the sales activity from all the previous months since the beginning of this year?

——————————
Chris Soraparu
Tri Star Metals LLC
Carol Stream IL
——————————

[Lewis Rosenberg]

Where are you looking to apply this filter?  If for example, you are filtering Item Ledger Entries of type SALES, you can add a POSTING DATE filter of 010119..  or 010119..t
(t=today).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
————————————————————————
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————

NAVUG/D365BC-User Group Focus
May 18-19, 2019
Denver, Colorado
——————————
——————————————-

[Chris Soraparu]

I’m trying to create a chart for sales dollar and volume by month. I set the date filter as such “cm-1y..cm” but my data points on the chart are by shipment day not  by month. So maybe I’m looking in the wrong spot to control on how the data is being displayed. I would like to the data grouped by month not by day.

——————————
Chris Soraparu
Tri Star Metals LLC
Carol Stream IL
——————————
——————————————-

[Michael Carr]

You can also ( for a current year) use P1..P10   etc

——————————
Michael Carr
VP , Finance
Philadelphia Scientific LLC
Montgomeryville PA
——————————
——————————————-

[Chris Soraparu]

Here is how I have the chart set up and it is giving me sales by date and I would like to have it by month. Is there anyway to achieve this?

——————————
Chris Soraparu
Tri Star Metals LLC
Carol Stream IL
——————————
——————————————-