• Information Assistant RDP connection does not allow users to print via local printers

    Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…
  • Crystal error when running reports

    Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…
  • SAGE random pdf export cannot be opened

    Hello, We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…
  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • SQL Table for batch history? AKA Batches not located in GL_CompanyActiveBatch?

    Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…
  • How to you link the SY_RoleSecurity table to the SY_Tasks table

    I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…
  • Error #11: CI_UpdateDetailToIM.pvc

    Can you help with this error? Error #11: Record not found or Duplicate key on write Program CI_UpdateDetailToIM.pvc Line 1605 Object Method UpdateDetailToIM Object Text SO_SalesJournal_upd
  • Sage 100 Premium - Connection to Crystal Reports

    We run just the Financials in our SQL version of Sage 100. Recently, none of my canned reports will run. The error: "The database login failed. Logon failed. Details [Database Vendor Code: 6]...Unable to connect: incorrect log on parameters..." This…
  • AP Period End Printing

    I'm not sure if this is the right forum, but I am having issues with my period end reports printing when I process through AP. In the AP module, I click PE processing, then enter a date of the last date in the month I am closing. I keep the "print PE…
  • PO Printing received the following message:

    PO Printing received the following message: Unable to preview PO_OpenPurchaseOrder.rpt. Index was outside the bounds of the array
  • Printing Reports taking abnormally long time since switching to workstations from Terminal Server.

    Since moving my client from a Server 2008 Terminal Server to individual workstations, printing reports of any kind are now taking over 5-10 mins to print 5 pages. This includes just running print preview. I'm currently running Mas 100 ERP version 5…
  • Some users suddenly can't print sales orders

    2014 Sage 100 3 out of 7 workstations today can't print sales orders. Message is "Unable to print salesorder.rpt. A generic error occurred in GDI + Any ideas? Rebooted server and workstations. Nothing new installed. everything fine prior to today…
  • Database login failed...issue with system.data.dll

    We are utilizing Sage ERP 100 premium 5.10.40. I have one workstation that keeps getting the following error any time they try to print or run a report: "The database login failed. Could not load file or assembly 'System.data.dll' or one of its dependencies…