• USysSecurityRights.UserRights

    Hi! I am new to supporting Sage100, as I come from the world of Syteline. I have been asked to work on an SOD report for one of the branches I serve, and I am struggling with a piece of information I cannot find defined anywhere. What are the elements…
  • VI Cross Reference Customer Email to Customer Number

    I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…
  • Office365 Excel Build 2403 removes MS Query - How to add back

    Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back. Open Excel, select "File" from the toolbar, then "Options…
  • 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…
  • 2023 SQL Premium configuration & backups

    Hello friends, We have begun working with our awesome consultant on our Sage 2023 Premium upgrade from an older Providex version of MAS. It's very exciting! We are at the point now where we need to get backups running for our new accounting system…
  • VI General Ledger Journal Entry Import - JournalComment Issues

    Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…
  • VI import to JC Trans Detail Cost Type invalid

    New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
  • Visual Integrator - Update value in CI_Item

    Can Visual Integrator update all the PriceCode values to a specific value (like an SQL Update works)? Example; I want to apply the letter "A" as the PriceCode for all records in the ci_item table. Using visual Integrator, I can export, modify the…
  • NEW COMPANY - COPY-RE-INITIALZE

    Is it possible to copy an existing company, then "cherry pick" some modules to remove all previous transactions using re-init. For example, if I wanted to keep the AR customers list only (not transactions or history), the CI_Items table and the employees…
  • Visual Integrator not importing all rows to SO_Invoice

    I'll probably rebuild this process as a BOI but.... this is just so perplexing I'd kind of at least like tug the thread and see where it leads. Environment: Sage 100c 2021 v7.05 I have an ETL process that brings the invoices in from our mobile invoicing…
  • Triggering Script when item quantity gets updated

    Hello, I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc. Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…
  • Get the Table's name that triggered a Post-Write Event

    Hello, We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables. I am seeking a way to retrieve…
  • CS ODBC service stopping after upgrading to v2023

    Upgraded from Sage 100 v2020 to v2023.1 - We are still on the 32 bit version of Sage. Uninstalled old CSODBC service and Installed it again from the v2023 directory. 3 times today the CSODBC service has hung up and needed to be restarted. Here is…
  • "[ProvideX][ODBC Driver] Internal Error"

    This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
  • Trying to skip record in VI Import if the field is 0.00

    Running Sage 100 v2016. Have a VI job that imports data that typically contains a numeric value (the field is Quantity) as well as a total unit price. The import file does not have a per unit price but it's needed. In order to get the unit price I added…
  • Detect when table gets updated

    Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…
  • System Automatically changing passwords

    I just upgraded from 2019 to 2022 Advanced. We are having problems with multiple users having their password changed by the system, this has even been happening to our company account. We get the message below. When I go to SY_USER the encrypted password…
  • PL_JournalPDFLog.M4T *** File discrepancy

    I am trying to apply the Sage 2020.1 update. During the update, when it scans for corruption it says that PL_JournalPDFLog.M4T has an ambiguous "file discrepancy" in it. The instructions say to simply Rebuild Key Files for any discrepancies, but alas…
  • 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…
  • ODBC Driver to Sage works, Linked Server fails with SQLSetConnectAttr failed

    Hello- I'm having trouble getting a linked server to our Sage instance working. The ODBC driver tests successfully, but the linked server always returns the same error- SQLSetConnectAttr failed. Confoundingly it does work on our Staging environment…
  • Shrinking AP_CheckHistoryHeader.M4T, M4T.001, M4T.002

    Sage 100 2022.1 Advanced I have a customer whose AP_CheckHistoryHeader file has grown to be very large. I suspect it may have to do with a large number of void checks being created during their process of writing checks. They manually swap between…
  • Invoice import through visual integrator not hitting ledger accounts

    I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…
  • 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…
  • Linked server connection fails but ODBC DSN always works

    I setup a 64 bit System DSN to Sage 2022. It's configured as a silent connection and the debug option always works. I'm trying to setup a linked server connection using that system DSN but it always fails. Here's the error. Cannot initialize the data…