• Data conversion error 15 (caused by SQL triggers)

    Posting this to help others in the same situation. The client system had a 3rd party modification to their SQL databases (by FYISoft / Renovo), adding table level SQL triggers that became broken with the migration (since the new SQL instance didn't have…
  • Sage ERP 100 Premium - SQL Run Time Usage Question

    Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL. We have read where the SQL server…
  • What fields need to be identical to generate a new SequenceNo?

    Hi, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used. Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…
  • Location of UserUpdatedKey/UserCreatedKey and How SequenceNo is picked?

    Hi, I am looking at our backend tables and I am trying to determine what user did what. In our worktickets I see UserCreatedKey and UserUpdatedKey but I cannot find a table that links those to the employees table. I read that they might be stored…
  • Error message while migrating from 2017 premium to 2021 premium

    During the migration process, the following error appears. Parallel Migration Wizard - InstallShield Wizard Error execute: Select ServerProperty('ProductVersion') As Product Version. After clicking on the OK button. This error appears: SQL Server…
  • Can you install SSRS on the same server as Sage as it uses (I believe) Crystal Reports?

    We were needing to have Microsoft reporting services (SSRS) on the same server as Sage 100, but as sage uses the sql database, and has (I believe?) Crystal Reports built in, would there be any issue installing the SQL Server Reporting Services onto the…
  • 42S02: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name 'dbo.sysextendedarticlesview

    Sage Premium version 2020 Reinitialize Datafiles utility I get the above message/problem when trying to reinitialize any AP or AR data files. I don't get the message when reinitializing IM, PO and SO files. So when this message pops up I have to…
  • Versions of SQL listed in Premium SPM specifications

    The current SPM for v2020 (and v2021) both list compatibility with SQL 2017 CU "20 and earlier"... ...yet the current CU# is 23. https://docs.microsoft.com/en-us/troubleshoot/sql/general/determine-version-edition-update-level Is there a compatibility…
  • Rebuild Key Log

    Hope my Monday doesn't bite me. I rebuilt some key files over the weekend. A couple samples from the common info key rebuild log Illegal characters have been found in the key. The record was not copied. The key read was P18569351 . Illegal characters…
  • Unable print _Manual check and payment register_databace connector error

    Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!
  • SQL Data Warehouse from Sage 100 2018 ProvideX tables

    I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day. Pulling FULL tables…
  • database entry for what user has a sales order open?

    Is there any record made to the database when a user has a sales order open? IE, Sage 100c SQL knows when a user has an order open, since another user cannot also open the same order... but is that information written to the DB or is it only a flag within…
  • non MAS database on MAS server? (Sage 100c SQL)

    Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.
  • 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…
  • Sage 100 Premium Data Location

    Asking for friend who just moved to Sage 100 Premium from Advanced and he has a question. "I need to figure out how to get all of my SQL data (logs and data) to reside on the D: drive instead of the C: drive. If I make a backup company the C drive starts…
  • Unable to create or copy company in Sage 100 Premium version 2018. Databases are not added and 42000 Modify File Failed errors occur

    Good evening. I have tried to create new companies and activate them in Sage 100 Premium. Currently creating a new company does not add a new database. Attempting to activate the company also fails Attempting to copy a company to a new company…
  • manuell structure database

    Hi; Please someone can help me ; i need a manuell of structure database SAGE 100 ; thnks!
  • MAS 90 Providex to SQL Conversion / Archive Reporting purposes

    FormerMember
    FormerMember
    Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…
  • Business Desktop has already been started for this workstation every time we start Sage 100 2018

    We have been using Sage since 2012; we started with MAS90 4.5. Starting with Sage 100c 2018 it seems that a pvxwin32 is left running on the workstation and on the server for every session we start. Every morning when we open the Launcher we get told that…
  • File Layouts info

    Hello, Just a basic question, I'm reading the file layout for SAGE 100 and most the file/table layout has following options on the top of the section. Most of the options are self explanatory but is there any document on SAGE 100 that will explain all…
  • Is Sage 100c 2018 compatible with Microsoft SQL 2017?

    FormerMember
    FormerMember
    We want to upgrade our version of Sage 2017 to 2018 and at the same time start using SQL for our database. With that, we would need to purchase a license of Microsoft SQL. The documentation states that Sage 2018 is only compatible with SQL 2017, however…
  • MS SQL 2016 SP2

    We are currently running Sage100c Premium v5.40.2 with MS SQL 2014. We would like to upgrade to MS SQL 2016 SP2. Will this present any issues or should we be okay?
  • If a company code is deleted, can the same company code be used again?

    Have a situation where a company code exists and the client wants to copy the company to a new company code (no problem). Question is, the client wants to re-use the existing company code for a new company. If I delete the company, can I recreate…
  • 42000 Modify File failed (SQL 2016, Sage 100c 2017 Premium v5.4.2)

    FYI... something new with SQL 2016. A new "feature" for setting a default database size broke certain functionality in Sage 100. I was getting an error 42000 Modify File failed, when creating a copy company (or activating a module in a new company code…
  • What's the latest build of SQL Server that you're safely using with Sage 100 Premium?

    Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…