Sage 100

 View Only

  • 1.  Crystal suppression formula for CC payment info

    Posted 07-29-2019 13:13
      |   view attached
    Client request:

    Goal:

    To have something similar to the following statement printed on all $0 invoices that have been paid for with a credit card. 

    INVOICE PAID IN FULL
    Paid with card ending in <:ast4UnencryptedCreitCardNos>  

     Specs:

    • If InvoiceBalance = 0 and PaymentType = MC, V, or AMEX then print the above
    • We would like it placed slightly under the last line item
      • It is not desirable to have it placed in the Page Footer, to the left of the sub-total, total, etc group as customers do not scroll down far enough to see that!  We have tried just entering in comments in the message lines and it did not work!!  LOL! 

    My solution:  in GF3 (Header Seq) add the following suppression criteria:
    {@InvoiceBalance} <> 0 and not ({SO_InvoiceWrk.PaymentType} in ["V","MC","AMEX"])

    It displays when the invoice was paid by CC (great!), but the problem is that it also displays when the invoice balance is $0 but it wasn't paid by CC.  Where is my logic faulty?  (see attachment)

    Thanks!

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: Crystal suppression formula for CC payment info

    Posted 07-29-2019 13:23
    Your suppression method will fail if either is not true.  You need to do a NOT if both are true: NOT(  {@InvoiceBalance} = 0 and {SO_InvoiceWrk.PaymentType} in ["V","MC","AMEX"])



    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------



  • 3.  RE: Crystal suppression formula for CC payment info

    Posted 07-29-2019 15:06
    This is they syntax Crystal liked:  NOT({@InvoiceBalance} = 0) and({SO_InvoiceWrk.PaymentType} in ["V","MC","AMEX"]), but it doesn't give me the desired results when the invoice balance = 0 and it wasn't paid with a CC.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 4.  RE: Crystal suppression formula for CC payment info

    Posted 07-29-2019 15:36

    The plan (made with Ken) is to discuss it when the testing is complete, in a manner that does not interfere with the upcoming end-of-month

     

    Jeff

     

     



    ------Original Message------

    This is they syntax Crystal liked:  NOT({@InvoiceBalance} = 0) and({SO_InvoiceWrk.PaymentType} in ["V","MC","AMEX"]), but it doesn't give me the desired results when the invoice balance = 0 and it wasn't paid with a CC.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 5.  RE: Crystal suppression formula for CC payment info

    Posted 07-29-2019 15:37
    (please ignore the previous email - thanks)

    Jeff

    PS - happy to continue to help with the crystal logic if you wish

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 6.  RE: Crystal suppression formula for CC payment info

    Posted 07-29-2019 13:25
    Look at the Sage forms... they also reference {SO_InvoiceWrk.CreditCardPaymentBalanceAmt}, which should be the amount paid by Paya / APS...

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



Related Content