Sage 100

 View Only
Expand all | Collapse all

v2015 - client has a canned comment code (/C99) th

  • 1.  v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:30
    v2015 - client has a canned comment code (/C99) that they want to suppress from S/O and S/O invoice printing. Do I do that by modifying the suppression criteria on the section where the Comment Text appears? If so, can someone tell me how to modify?


  • 2.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:39
    Item type = 4 and ItemCode =""/C99


  • 3.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:40
    I think it should be OR.


  • 4.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:40
    For the comment section, using Crystal syntax, the conditional suppression would be - never mind @WayneSchulz beat me to it...


  • 5.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:41
    Why @SteveIwanowski ? wouldn't that suppress ALL comments?


  • 6.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:43
    If it's AND, it'll only suppress if it's /C99. We want everything but /C99, right?


  • 7.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:44
    No, Barbara said they want to suppress /C99 from printing.


  • 8.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:45
    I don't think you have to have the item type in there anymore... since they now require the / to be in there. formula =*Existing Formula* and {SO_SalesOrderWrk.ItemCode} = ""/c99"" Note: if the item and the comment are in different sections, you will want to suppress both sections in case they comment on the /c99 code as well.


  • 9.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:46
    **With Basic Syntax, because all of those have existing formulas


  • 10.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:48
    why not just remove all /C99 records in the selection criteria and be done with it?


  • 11.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:55
    @BrettLyder, I tried the selection criteria, but it didn't work for me. They want to only suppress /C99. How do I modify this canned suppression criteria on the section: If {SO_SalesOrderWrk.ItemType} = ""4"" then Formula = False ElseIf {SO_SalesOrderWrk.ItemType} <> ""4"" AND _ Left({SO_SalesOrderWrk.CommentText},255) <>"""" Then formula = False Else Formula = True End If


  • 12.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:57
    If {SO_SalesOrderWrk.ItemType} = ""4"" AND {SO_SalesOrderWrk.ItemCode}<>""/C99"" then


  • 13.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:58
    I did record. I'll try group.


  • 14.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 11:58
    @BarbaraGoldstein if you put {ItemCode}<>""/C99"" in the GROUP SELECTION it should only give you non-C99 lines. Did you use group or record?


  • 15.  RE: v2015 - client has a canned comment code (/C99) th

    Posted 10-14-2015 12:02
    Group selection got me what I want. Thanks @BrettLyder (and everyone else!)