Sage 100

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…

Why does every user need to be notified about the license expiring in 40days? Can I restrict who is notified about the expiry? It makes it look like we don't pay our bill when it's usually Sage failing to renew on its' own! It's annoying enough that I…

Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously. I want to be able to show a sales person, for…

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…

Several months ago I cleaned up the Purchases Clearing Report. It was current and accurate. I ran it yesterday and there are old (anywhere from 1-13 years old) completed purchase orders showing on the report. Most of them are showing as a scenario where…

Hello Team, Could you clarify, is it possible to download the trial version of Sage 100 cloud?

Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence? Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on…

Hello Team, Could you please help me with the following questions? 1) Is it possible to integrate data from Sage 100 via web API? 2) Does Sage 100 have a cloud version? or it is just an On-Premise version?

I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…

Since the default customer price level is only 1character, I'm considering making a UDF and then having SO and SOI reference that column to populate the price instead of the default column. I haven't played with Custom Office since I haven't really…

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…

Sage 100c Advanced SQL 2018 6.00.5.0 So I think this is happening because of me... Before last year, when we pulled orders on paper, we would take the sales order and move it to invoicing, then key punch all of the backorders on the Sales Order Invoice…

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…

Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…

Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?

Sage 100c 2019 Standard. When I print a custom payroll crystal report I receive an error message that reads: Error in File PR BPA CUSTOM 6352-15868-(107A04E2-6BCF-4F92-A9D7-89536928089E).rpt Failed to retrieve data from the database. Details:…

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…

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.

Under AR there is an EXPLORE folder. When I choose Customer History Invoices View on my PC , you will see two folders. Open invoices and customer payments folders and it populates data in the grid. when i log into a different users pc and i open the same…

We just changed from perpetual to subscription and I received the emails with the activation keys and unlocking keys. Where do you apply the new Activation keys?

Hello everyone, Is there anyone who would be kind enough to provide us with a tutorial to link Sage 100c (Cloud) v3 to PHP? Thank you.

I just became aware of Sage 100C. We currently use Sage 100 2015. I am trying to figure out if Sage 100C is a new product or an upgrade from Sage 100 2016/2017. If it's a new product what is the selling point as opposed to the regular Sage 100? I…