• SY_Country code: 2 digit or 3 digit?

    We are in the middle of a parallel upgrade of our Sage MAS 90 4.5 company accounting system to Sage 100 2023 Premium. This is an upgrade that goes from 4.5 SP 7 to 4.5 SP 8 to 2018 to 2023 Premium. It appears that during the migration and conversion…
  • Questions on Advanced Architecture of SAGE 100 Accounting

    Hello everyone, I'm reaching out to the community for clarification on certain aspects of the SAGE 100 Accounting solution's architecture and communication protocols, which I haven't found detailed information on. Application Server and Database…
  • VI Error, L record AddLine() Failed. Missing or invalid header.

    I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…
  • Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • Remoteapp and mutiple version of sage

    Has anyone ran two versions of Sage 100 Accounting software using RemoteApp on a remote desktop?
  • Sage 100 2021.5 slow data entry / auto complete

    Sage 100 2021.5 running on a Hyper V Server 2019 instance, 8cores and 24gigs of RAM. The server presently serves no other funcdtions other than some very light IIS tasks. CPU and RAM usage is minimal throughout the day. Sage is connected to SQL Server…
  • Can you Convert from Sage 100 Premium to Advanced. Has anyone ever done this?

    Can you Convert from Sage 100 Premium to Advanced. Has anyone ever done this?
  • Sage 100 Premium 2021.3 company background colors stopped working

    I set the company background color last week and now they are all the same. In Company Maintenance on the Theme tab I tried to turn it back to standard, then change back to classic and choose a new color, but it still isn't showing the background or frame…
  • Purge specific records from AR Invoice History-VI or SQL?

    Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…
  • Sage 100 Premium migration failed...'KPRIMARY_SY_System' is already in the database.

    Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server. This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During…
  • Sage 100 PM WT Traveler Crystal Report - Steps Repeat

    Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…
  • Upgrading Sage 100 Premium 2019 to 2021 ending in the same default SQL instance

    I have a client using Sage 100 Premium for core accounting for 200 companies installed in the default instance. I need to upgrade for 2019 to 2021, what is the procedure to keep using the default instance on a single server? Ideas? There are multiple…
  • .docx attachments in memos causes Sage 100 to crash

    When launching an attachment that has a .docx extension from our customer memo screen, we receive a "Sage 100 has stopped working" message. This issue is happening on all our windows 10 machines that have office 2016 and above. We have tried uninstalling…
  • Sage100 Production Management Crystal Report for Work Ticket Traveler

    I am looking to add the Routing (now Template) description to my printed Work Ticket Traveler. I want it to appear in a header section of the crystal report. The routing description is now step 000000 of the route instead of its own field. How do I get…
  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
  • Is Sage Intelligence 2015 and Microsoft 365 compatible?

    I'm running Sage 100 Premium 2020 version 6.2, and have Sage 100 Premium Intelligence 2015 installed. Our IT department installed office 365 yesterday, and now I'm getting an error message in excel about the BI extension. No values in cells in my intelligence…
  • Sage 100 2021.1 slow module opening

    The slow performance within a module that I complained about last month seems to be cured by rebuilding the search index, but performance when opening a screen (eg. item inquiry) is quite a bit slower than 2018. (old thread: https://www.sagecity.com/support_communities…
  • Is it possible to export the security roles and user settings from any version of Sage but in particular from Sage Premium?

    I need to re-migrate system settings during go live after a long pilot testing period. Multiple changes have been made in the source version since the pilot began. I was wondering if I can export the security roles and user settings from the upgraded…
  • HRMS and Sage 100 coexisting on the same PC

    I know there is an order for installation that will allow HRMS and Sage 100 to peacefully co-exist on the same PC, however I am not sure what the exact order is. Also when ever we do a quarter update with HRMS, we invariably break Sage 100 (specifically…
  • Sage100 Crystal Report designer preview asking for a password

    I'm editing accounts payable checks in crystal reports. I click on "View" and then "Preview". It then has a popup that says OLE DB, and then has the following fields: Server: OURSERVER\SAGE100V2017 User ID: Mas_Reports Pasword: *blank Database:…
  • Merging files taking 2 hours or more when updating Sage 100 2019 Premium

    I recently installed Payroll 2.20.1 and the PR hot fixes to an installation of Sage 100 2019 Premium. Today I installed the Fixed Assets module and the Canadian Zip Codes to an existing installation of Sage 100 2019 Premium. In both cases the "Merging…
  • Has anyone experienced slow performance In Sage 2019 Premium running on MS Server 2019?

    When I open sales order entry it may take up to 20 seconds to open the module. I don't know what's causing the system to run slow. My environment has two MS Server 2019 instances in VMware one for SQL the other for the sage application. I don't see any…
  • Sage 100 Premium

    We have a new client that would prefer to use the Premium (SQL) version over the Providex version. We currently do not have any Premium installations. Just checking in to find out if there are any "quirky" installation/implementation issues that we should…
  • Order was removed from SO Entry, but is "Active" in sales order History?

    Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…
  • SDATA with Sage 100c 2016 Premium installed on Windows 2016 Server

    Hopefully someone here can assist as Sage Tech Support could not answer the question. Is the SData connector compatible with Sage 100c Premium (SQL) on Windows 2016 Server? If yes, what version of the adapter? (Extra love for a link to it!) …