• upgrade to Sage 100 Premium (SQL) problem with missing NULL values

    Hello, We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…
  • User is unable to print from Sage 2022

    A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • 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…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • 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…
  • 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…
  • 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…
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • 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!
  • querying summarized bill of materials

    For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…
  • 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…
  • Sy_ActivityLog not showing CompanyCode field.

    Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…