Sage 100

 View Only
  • 1.  2014 Premium. Just moved Sage 100 to a new server

    Posted 11-30-2017 12:03
    2014 Premium. Just moved Sage 100 to a new server. The forms, such as the SO Invoice don't show up on the list. If I type in the custom form name the report appears and prints as it should. For example, i have a invoice form code ""INVOICE"". This invoice has the company logo and several changes from the STANDARD. I only see STANDARD on the drop down list but if I type in INVOICE and print an invoice the custom form prints fine. How do I get the custom forms back on the drop down menu?


  • 2.  RE: 2014 Premium. Just moved Sage 100 to a new server

    Posted 11-30-2017 12:13
    Those values are listed in the SY_ReportSetting table. Can you check and see if your data didn't come over?


  • 3.  RE: 2014 Premium. Just moved Sage 100 to a new server

    Posted 11-30-2017 12:19
    I've had this twice. One time was fixed by restoring the Providex.xxx files, the second was fixed by this SYZCON process: 1. From the Sage 100 ERP Desktop, click File menu, select Run 2. For the Program field enter the following command and press the Enter key: SYZCON 3. Click OK 4. At the prompt type the following: PRINT %SYS_SS'CreateTable(""table"",""COMPANY:xxx"") 1. Note: Replace table with the name of the table the lookup is using. Replace xxx with the company code affected 5. Press the Enter key 6. Repeat this process for each table and company code where this issue appears


  • 4.  RE: 2014 Premium. Just moved Sage 100 to a new server

    Posted 11-30-2017 12:26
    Got it. Thanks to both of you. I copied over the Providex.??? data dictionary files from the previous server and everything is back to normal.