Open Forum

Expand all | Collapse all

Date Filter

  • 1.  Date Filter

    GOLD CONTRIBUTOR
    Posted 23 days ago
    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
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Date Filter

    TOP CONTRIBUTOR
    Posted 23 days ago
    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
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Date Filter

    GOLD CONTRIBUTOR
    Posted 23 days ago
    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
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Date Filter

    TOP CONTRIBUTOR
    Posted 22 days ago
    You can also ( for a current year) use P1..P10   etc

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

    Conference-BCNAVUG_200x200


  • 5.  RE: Date Filter

    GOLD CONTRIBUTOR
    Posted 21 days ago
    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
    ------------------------------

    Conference-BCNAVUG_200x200


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