Sage 100

 View Only

  • 1.  Error when adding Cost Code Description to Job Billing Invoice

    Posted 10-22-2019 20:17
    Edited by Barbara Goldstein 10-22-2019 20:25
      |   view attached
    v2018.7
    I'm trying to add the Cost Code Description to the Job Billing invoice form in the Details A section, but when I print invoices, I get the attached message.

    The field is in the invoice template.  I also tried adding the Cost Code Master table to the invoice and add the field from there, but get the same error.

    Anyone else run into this?

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


  • 2.  RE: Error when adding Cost Code Description to Job Billing Invoice

    Posted 10-23-2019 08:38
    Barbara -

    Have you preview from within Crystal (I know no data will come up)?  Sometimes you can get better error messages in there, even if there is no data.


    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 3.  RE: Error when adding Cost Code Description to Job Billing Invoice

    Posted 10-23-2019 11:23
    I did a Verify Database from within the report and got more info, but I don't know what the formula is associated with.  This is a 2014 to 2018 upgrade and I'm creating the form from scratch.


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

    Original Message


  • 4.  RE: Error when adding Cost Code Description to Job Billing Invoice

    Posted 10-23-2019 11:29
    Has to do with formatting - try commenting it out and see if it works.  Just be in that line and click on the Comment button up top "//"

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: Error when adding Cost Code Description to Job Billing Invoice

    Posted 10-23-2019 11:43
    Figured it out - I was putting the field in the report, then clicking on a numeric field to apply formatting.  I re-added the report and just manually adjusted the font size and no error.  I hadn't realized the extent of the formatting that gets copied.  Thanks Beth, for getting me on the right track!

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

    Original Message


Related Content