Sage 100

Greetings, I'm running into a roadblock attempting to add an ODBC data source via Power BI Service via +New / Data sources page from the following URL. https://app.powerbi.com/groups/me/gateways Here are a few facts: The ODBC driver (for Sage…

I set the company background color last week and now they are all the same. In Company Maintenance on the Theme tab I tried to turn it back to standard, then change back to classic and choose a new color, but it still isn't showing the background or frame…

Hope a community member can help here. I have a few machines that are running the ARM version of windows 11. The sage pdf converter for paperless office does not include a arm version of the driver. I have reached out to both sage and amyuni (the…

We've been using F9 for a very long time, and sometime in the past couple of months it has been "working" in terms of allowing the F9 formulas in excel to work, but when one user (me) tried to do some additional F9 tasks (drill down), it only sees 2 of…

Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

I've connected a single table from Sage 100c 2021 to Excel (data model) via a silent ODBC connection with saved username/password. All works great for me, but if anyone else uses this excel workbook and tries to refresh the data it makes them log in a…

Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server. This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During…

Want to upgrade our Windows servers to 2019(from SBS 2011 and 2008 R2) and keep Sage 100 2016 for now. I have read that SQL 2008 will install but should not be used in a production environment. Wondering what is the newest version of SQL that I could…

Has anyone found a workaround for the Microsoft and Google authentication changes? We have Sage 100 v2018 and it looks like we will be forced to upgrade.

Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…

Hello everyone, We are running into an issue where at random 2-3 users a day are not able to login to SAGE. They enter their passwords and the screen flashes and the closes. I've noticed that the module date is somewhere in 2015 when I catch a glimpse…

Experts, I am trying to find out how Sage 100 (in my case Premium) obtains the (Work-)Station name shown in the Master Console. Sage "remembers" some of its settings based on that station name. We tried setting the Windows environment variable $env…

We have a Sage 100 prospect that would like to use Windows Server 2019 Essential. It is NOT on the Supported Platform Matrix. Is anyone using this? I explained to him that if the server software is not on the Matrix then his install would be unsupported…

I have seen two different upgrades affected by the *.SQL files under MAS90\VI failing to be migrated to the 2021 MAS90\VI folder during upgrades. Anyone else encountering this? The manual solution is to just copy them but I don't recall having to…

Within the application server startup, what method or argument can be used to have Sage 100 application server "Start" when it launches.

Setting up my testing environment (test => prod) and performance is unberably slow. Typing in an item code in inquiry has a multiple-second delay between key presses and seeing letters. Search-while-typing is enabled, as it is in in my live 2018 installation…

PR header and detail are chained. Same problem with each.

Hi Everyone. We have decided to setup Cancel and Reason Codes for all Sales orders and Quotes. On Sales Order Options I have changed "Retain Deleted Orders/Quotes" to Prompt. Now when I go to delete and Order/Quote I get a prompt asking do I want…

Hello, I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to…

I'm having an issue with just 1 Sage 100c Advanced v2019.2 client install to a new laptop. Workstation setup installs the "..\Sage100" directory to C:\Users\{username}\OneDrive - {company name}\Documents\Sage 100 and not to the standard C:\Users\{username…

I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

For most tables, when I create a user defined field (UDF), the history table automatically gets the same field added and the data gets copied into the history table automatically. It looks like AR_InvoiceHistoryDetail may be getting records from both…

Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan

I installed Sage 100 2018 Standard. Then installed product update 10 and Payroll 2.21. I migrated the data from the 2017 version and began to convert companies. When I get to the filing status mapping screen, there is a single line there, with none of…

Hello Even though our settings say to " Restrict Accounting date to current and one future Period," I am able to set our system-wide date to 12/31/21 in January of 2021. I am able to enter and update invoices in that future date. I do NOT want to be…