Sage 100

 View Only
  • 1.  **Suppress 0 ship-qty lines on S/O Invoice form**

    Posted 01-03-2018 11:42
    **Suppress 0 ship-qty lines on S/O Invoice form** This seems like such a basic thing but I can't seem to get it to work. All's we want is to suppress any 0 ship-qty lines (i.e., QtyBO = QtyOrd) on the S/O Invoice form. So we've additionally incorporated 'or QtyBO = QtyOrd' into the section suppression formula, but the problem occurs when line #1 is a suppressed line. Had something [similar to this with the PO form](https://90minds-com.socialcast.com/messages/36523055?ref=stream) in Aug.


  • 2.  RE: **Suppress 0 ship-qty lines on S/O Invoice form**

    Posted 01-03-2018 12:16
    Appears I have a **resolution**; put our additional suppression at the beginning of the existing formula, rather than the end. Working formula: formula = **{SO_InvoiceWrk.QuantityBackOrdered} = {SO_InvoiceWrk.QuantityOrdered} or _** {SO_InvoiceWrk.ItemType} in array ("""", ""4"") or {@AllowExpandedItemCodes} = ""N"" or _ PreviousValue({@InvoiceNoLineNo}) = {@InvoiceNoLineNo} Non-working formula _**apparently it's choking on the @InvoiceNoLineNo expression portion**_: formula = {SO_InvoiceWrk.ItemType} in array ("""", ""4"") or {@AllowExpandedItemCodes} = ""N"" or _ PreviousValue({@InvoiceNoLineNo}) = {@InvoiceNoLineNo} **or {SO_InvoiceWrk.QuantityBackOrdered} = {SO_InvoiceWrk.QuantityOrdered}** Orig/existing formula: formula = {SO_InvoiceWrk.ItemType} in array ("""", ""4"") or {@AllowExpandedItemCodes} = ""N"" or _ PreviousValue({@InvoiceNoLineNo}) = {@InvoiceNoLineNo}