• Safe to convert Sage 100 Premium to Temporal Tables in MS SQL?

    Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…
  • 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…
  • 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…
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • Intelligence stopped refreshing data when changing Period or Year. Any ideas how to fix it?

    Sage intelligence has stopped refreshing when I change the Period or Year. I have formulas linked to a Year and Period so that changing either cell with the Year or Period changes the data to that time frame. It worked fine in a previous report version…
  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…
  • 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…
  • 100E - Sage 100 - Object Interface Course

    Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…
  • Read & Write data in Sage100 using Business Object Interface

    Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…
  • 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…
  • 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…
  • 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!
  • "the lock information was not found"

    When I try to open a sales order I get the following error dialog "the lock information was not found" This is from Sales Order Entry on Sage 100 2019 Premium.
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • 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:…
  • Sales Order History files not created?

    Hello, We had something strange happen once last week, and now once again today. We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…
  • 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…
  • 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…
  • 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…
  • Abnormally High/Rapidly increasing Fragmentation Levels?

    Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…
  • Lines showing in Sales order History Detail, but not in sales order Detail?

    Hello, We are having stomething strange going on where 11 lines from an order are showing up in both the "Detail" and "History Detail" tables, but 3 are missing from the "Detail" table and are in the "History Detail" table. Any ideas? Apart from straight…
  • Purge Utility vs SQL Deletion: AR History

    Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…
  • Information on tables not listed in "File layouts and program information" ?

    Hello, Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…
  • 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…
  • How do I use crystal reports for sage to connect with sage Premium 100 so I can create my own reports?

    We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…