Method Community

 

Filtering specific items

Last post 01-08-2014 12:23 PM by Method_Greg. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-08-2014 8:37 AM

    • JWS
    • Top 150 Contributor
    • Joined on 09-13-2013
    • Posts 40

    Filtering specific items

    Hello,

    I currently filter certain items from the items list on a Sales ORder.

    I would like for the print version of the sales order to only print some of the items.

    For example: There are discounts that appply to some of the Sales Orders that I want to show on the screen but not in a print version of the sales order.

    JWS
  • 01-08-2014 12:23 PM In reply to

    Re: Filtering specific items

    Hello,
         I believe it is possible.  I found a forum post here that explains a similar situation.  Here you can write a function for the item list and just display records that are not of a 'Discount' item type.  If you follow the instructions in the post, you will get to the Formatting Rules Editor, create a new Rule Sheet and Edit the rule sheet.  The formula will go in the Condition box.  I'm not a Report Designer expert, so I can't help you out on developing the formula, so you will have to fiddle around with it.  Remember to save it under a new name to make sure you don't override the default report.

    - Greg

    Greg Bilous
    Community Support Specialist
    Method Integration
    g.bilous@method.me
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400 ex.756
    Fax: 416.640.6027
Page 1 of 1 (2 items)