• 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…
  • Basic Authentication with SMTP - any workarounds for Sage100 v2018 users?

    Has anyone found a workaround for the Microsoft and Google authentication changes? We have Sage 100 v2018 and it looks like we will be forced to upgrade.
  • Sage 2021 PU2, PR 2.21.3 Upgrade - Have to re-add Payroll Custom Reports with PII Wrk table from 2018/2019?

    Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…
  • PR_EmployeeDocuments table is encrypted and can't access fields in Crystal Report

    v2019 Adv. Customer would like a Crystal report showing what email address is set up in Employee Maintenance/Paperless for Electronic Delivery. It may/may not be the same as the Email that is on the Employee Header. The PR_EmployeeDocuments.m4t is an…
  • The data area passed to a system call is too small

    Error when printing various reports. Sometimes a second attempt works. Sometimes I Preview the report then print it.
  • Sage FAS upgrade affects Sage 100 2016?

    FormerMember
    FormerMember
    We recently upgrade Sage fixed Assets from 2016.1 to 2019.1, today a users reported issues generating reports from Sage 100 2016, that's all the relevant changes that we have made recently. May Sage could be affected because of this?
  • Need help getting "Invoice History Printing" data in SQL database.

    Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
  • Automate Statement Printing?

    Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…
  • Trial Balance Report "Hangs" for a specific customer selected?

    Hello, We are having an issue with the AR trial balance report. If we run this report without specifying a customer, and leave the Customer Number field set to All, the report runs fine. However, we have a specific customer we want to run this report…
  • Export Report To Google Sheets

    It is possible to export a report from Sage 100 to google sheets?
  • 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…
  • 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…