Sage 100

 View Only

The JT_TransactionWrk Crystal Dictionary is wrong

  • 1.  The JT_TransactionWrk Crystal Dictionary is wrong

    Posted 08-20-2013 12:37
    The JT_TransactionWrk Crystal Dictionary is wrong for the APInvoiceNo field - it is only set for 7 characters instead of 10 and therefore truncates the invoice number on your report. Here is the fix: Go to File/Run Type in SYZCON At the prompt-> type %s$=$$ and press <ENTER> At the prompt-> type dd and press <ENTER> At the Table Name, type in JT_TransactionWrk Go to tab 2. Data Elements In the Data Elements box on the left, scroll down until you find the field APInvoiceNo and double click on it Change the length of the field to 10 (for 4.50 or 20 for 2013 and up) and click ok Click Update File Click ok Click exit type BYE and press <ENTER>