Open Forum

Expand all | Collapse all

Date Filter

  • 1.  Date Filter

    GOLD CONTRIBUTOR
    Posted Nov 19, 2019 08:40 AM
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Date Filter

    TOP CONTRIBUTOR
    Posted Nov 19, 2019 09:00 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Date Filter

    GOLD CONTRIBUTOR
    Posted Nov 19, 2019 09:25 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Date Filter

    TOP CONTRIBUTOR
    Posted Nov 20, 2019 08:54 AM
    You can also ( for a current year) use P1..P10   etc

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

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Date Filter

    GOLD CONTRIBUTOR
    Posted Nov 21, 2019 09:24 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role