Open Forum

Expand all | Collapse all

NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

  • 1.  NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    SILVER CONTRIBUTOR
    Posted Oct 07, 2019 08:04 PM
    We only want to print lines in the  Sales Shipment Report(10077) - NAV 2013 where there is wither a value in the Shipped Column or a value in the Back Ordered column.   Adding a filter in Visual Studio on Table1_Details_Group did not work.    Suggestions please.

    Expression [BackOrderedQuantity]            Integer
    Operator     >
    Value           0

    Expression [TempSalesShipLineQy]            Integer
    Operator     >
    Value           0

    Thank you!

    ------------------------------
    Paula Cook
    Advanced FLOW Engineering, Inc.
    Temecula CA
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    TOP CONTRIBUTOR
    Posted Oct 08, 2019 10:34 AM
    The filter in the report should work fine.
    Could you attach it so that we can see how the filter was added?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    SILVER CONTRIBUTOR
    Posted Oct 08, 2019 02:15 PM
    Table1_Details_Group filters


    ------------------------------
    Paula Cook
    Advanced FLOW Engineering, Inc.
    Temecula CA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    TOP CONTRIBUTOR
    Posted Oct 09, 2019 08:07 AM
    ​When you say the filter doesn't work, is it because it filters everything out? Or it doesn't filter anything?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    SILVER CONTRIBUTOR
    Posted Oct 09, 2019 10:59 AM
    Sorry about that.  I should have specified that the filter does not filter anything.

    ------------------------------
    Paula Cook
    Advanced FLOW Engineering, Inc.
    Temecula CA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    TOP CONTRIBUTOR
    Posted Oct 10, 2019 07:52 AM
    From what I see it should work, did you try changing something else on the report to make sure you have the right one and it saves correctly?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: NAV2013 - Filtering rpt 10077 to only print items shipped or items on backorder

    SILVER CONTRIBUTOR
    Posted Oct 11, 2019 05:19 PM
    Its working now!  The solution turned out to be something more than what I had originally proposed.   The filter box has a limitation on the condition  "and/or" in the filter pane.  I ended  up modifying Table1_Group3 group properties, Filters and adding the following expression

    =(Fields!BackOrderedQuantity.Value > "0") or (Fields!TempSalesShptLineQy.Value > "0")

    Happy Friday!

    ------------------------------
    Paula Cook
    Advanced FLOW Engineering, Inc.
    Temecula CA
    ------------------------------

    Conference-BCNAVUG_200x200


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