• 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…
  • VI job does not import Serial Numbers

    I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…
  • VI Ghost “The”

    I have a csv file I am importing into an associated item table from a DSD enhancement. The original file, the csv file, and the data in a text file all have just the item code, ex “2000-Black-S” in the files shows “2000-Black-S The” as trying to import…
  • Sage 100 Standard and Customer Import

    We bought Sage 100 STANDARD and need to import Customer data so that we can create jobs and record time. There is no obvious way to import a CSV of Customer data. The online help says to GO TO CONTACTS. There is no CONTACTS option. Specifically I went…
  • VI Help - Not returning any data

    We are trying to setup a VI export job to bring out 10 fields from the AP_PaymentHistoryWrk table. We do see data in the AP Payment History report which uses this table so I'm not sure why the VI export is blank. The job is setup as follows: …
  • 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…