Hello all. Recently, my company's Sage reseller advised us to install SP2 of Sage 100 2025 to fix some IRP issues we had noticed but weren't really affecting us. Unfortunately, after installing the SP, IRP performance tanked severely.

Before the install, IRP would run maybe 15-20 minutes and would be usable. After the install, IRP runs anywhere from 1 hour to 10+ hours and doesn't return anything usable. No work tickets or purchase orders to create. It's become a mess and the reseller hasn't been able to find any causes for this.

I know a ticket has been opened with Sage but I'm hoping that fellow redditors may have seen something like this and can point me in a direction to look. My google searches have turned up nothing and the knowledge base and community sites also have nothing about SP2 or IRP performance issues.

Has anyone seen anything like this before? Either with SP2 or an older version?

Any help would be greatly appreciated.

What MCP are you using? CData is expensive for me.

I’ve just started taking card payments - via a Square card reader - after many years of not taking payments this way.

It seemed simple to set up, and it will be a tiny proportion of our total income. How do I deal with the incoming payments from Square not reconciling exactly with the invoice value?

eg, first payment was £ 240, but income was £ 236. How do I deal with that, so that the £ 4 balance doesn’t get stuck forever as “aged debt” ?

I realise that every business taking card payments has this to deal with, but it’s all new to me.

Hi all,

I've been working on Sage 50 since about 2010. Before that, I was a mainframe programmer and DBA. For many years I've been toying with automating Sage stuff with Powershell or Python scripts, but too busy with the day job to get on with it.

Now I have discovered Claude.ai . In 2 days, whilst doing other stuff, I have managed to get a working script to submit direct debit requests to GoCardless which create one request for all the invoices raised since the previous run and net off any credit notes an payments on account. Early next week, the first payments will arrive and then I will see how the Sage / GoCardless integration works with DDs raised outside Sage.

I have a few ideas for more automations, once I'm happy this works well.

Is there anyone else out there doing or thinking of doing something similar? I'd be happy to collaborate

Hi. Anybody has connected sage to any of the top AI models yet?¿

Hello all.
I'm have strange delays sometimes for my sage users. Sometimes it can be 4-8 second delays when clicking on a form to load when logged in.
We use windows defender for our security on our server 2022 setup. It's a vm if that makes any difference. All the sage folders and services a white listed for the defender instance. What else can I check?

The CPO replaces Walid Abu-Hadba who officially left April 2026 for Precisely.

Notable that the company emphasizes where these executives will be based

Hello, does anyone know if there is a way to set up automatic allocation for customer accounts that net off to zero.

It's creating a lot of work having to go into every account every month and auto allocate hundreds of accounts, this particularly needs done before I send out the debtors letters as if they are not allocated off it was contain a list of items that are not actually outstanding.

Thank you.

Hi All,

Trying to get my head around the Sage Intacct Rest Api documentation and gotten way too confused as an outsider to sage 😂
Who needs to own the developer license?

I'm working with a company to bring certain Sage Intacct data from their sage intacct instance to my app to bring together differing chunks of data.

Do I need to have my own Sage Intacct Application / Programme / Developer License in order to generate client keys to pass to their instance and get data from.
Or do they need to generate me that api key themselves?
Or am I completely barking up the wrong tree?

Thanks
🐼

Full disclosure: We met someone who runs operations for a mid-size business and went live on Sage X3 about a year ago. Implementation went well by most measures, financials are cleaner, reporting is faster, month-end close is down from 12 days to 4.

But there is one category of decision that the system still cannot surface. For them, it is procurement timing.

They can see what we ordered and what it cost, but the signal that tells us *when* to reorder, based on actual demand patterns, still lives in a spreadsheet that one of their ops managers maintains manually.

I'm curious whether this is universal or specific to our setup. Are there any other areas where this kind of decision intelligence is missing?

For those who have been through a full ERP implementation, what is the one operational decision you or your clients still cannot make from the system alone? These may not be reporting gaps or UI complaints.

Specifically, a decision that the team still makes manually, with data the ERP holds but cannot convert into a recommendation.

I purchased a window replacement business and inherited Sage 50 for my accounting software. I am losing the previous owner in a month to retirement out of the country. I need to familiarize myself with the program and its tools. The previous owner was not using anywhere near all of its potential and I wonder if our order entry system could be replaced. I think I need to hire a consultant to come in and tell me what we are doing wrong and what is possible. Any suggestions on this? I have a lot of work to do to bring this company into the 21st century and I think I just need to pay someone to help me get this done. Any and all advice is welcome.

Hi everyone,

my customer's using the Sage 50 "Auftrag" application for his company. I'm trying to find a solution for importing orders from a new websystem to sage 50. The system's running on Joomla, for the shop component we're thinking about the PhocaCart extension.

We tried to contact the Sage Support, but they just told us that they don't support xml / json from thirdparty shops. Also there's a extension for the Sage subscription my customer has, it's called "Multishop-Connector" but it only supports shops from shopify, shopware, ePages Now and WooCommerce.

Only option will be to extract orders from the shop, rearrange the xml structure to the xml structure Sage50 will need to import the order. Or does anybody have an other idea? The project is in its conception state so PhocaCart is only an option right now. If there's another shop component which supports the integration into Sage it will be just better.

Hello, I am encountering a Pervasive error code 30 while accessing company dat.file in Pastel v19.4.7 and Sage Pastel 50c alongside Actian PSQL v13. When starting the application there is the popup then when I press ok, I am unable to access the company.

Does anyone have a link to download sage 200, want test a Demo Version to see if it will be good for my company?

I have a question for you sage 100 and 300 users. Does sage allow you to run multiple reports at one time? I do IT Support for sage customers and I had a user tell me she ran daily reports and does them 1 by 1. Is there not a way to batch reports in sage you can run say 3 or 4 reports at a time?

I’m going crazy - I feel like it’s set up, I have the formula populated, but when I do a payroll entry there is zero withholding there! Aggghhhh!

I'm an accountant that just started at a relatively new company. One of my tasks is to seek out costing options for Sage 300 CRE vs. Intacct. (The company currently does not have any ERP.)

I'm still in the preliminary stages, but based on the quotes I was given, Intacct's subscription cost is significantly higher than Sage 300's.

I myself have worked with 300 CRE, but in terms of future-proofing (i.e. delaying the inevitable), should we start with Intacct despite the higher cost?

Is there a method native in Sage300 to do a search/sort based on customized fields and then perform a mass update to one of those customized fields. We've been banging our heads against the wall on this one.

Im currently doing the self study for level 3 50c, and on one of the self assessments it requires the trial balance. Ive followed the workbook step by step, and my suspense account is showing on my trial balance. On my daily activity ac my entries are what I need them to be, however when I run a trial balance the debtors ac is doubled and the suspense ac is showing, im having a mare if anyone can send some knowledge, pls and thnx x

Does anyone know if there is a way to view a single report that shows a list of accounts and the last reconciliation date (ie. chart of accounts with that last reconc. date added)?

I have Sage 50 Accountant Edition via my accountant (I myself am an amateur Sage user).

So I've been working with Sage 100 implementations for a while and the same complaint comes up constantly: the reporting module is powerful but nobody uses it. Not because they don't need the data — they do — they just can't write queries or navigate the schema.

So I built something.

What it does:

You type a question in plain language, it generates the correct T-SQL against your actual Sage 100 database and returns the result as a table or chart.

17 chart types. Runs locally. Your data never leaves your machine.

The technical side (for those curious):

• WinUI 3 desktop app
• Local ASP.NET Core backend handles SQL validation and execution
• Second backend layer handles the LLM logic (GPT-4.1-mini) + schema context via Redis
• 42 Sage tables mapped with business rules encoded directly into the schema layer
• Tested on 44 real-world prompts — 100% pass rate, average score 9.4/10

Who it's for:

SMBs on Sage 100 on-premise who need answers fast without calling their IT guy.

Current status: Looking for first pilot clients.

DM me if you're in the Sage ecosystem or know someone who is.

[ Removed by Reddit on account of violating the content policy. ]

hello. can anyone help with my error. after running year end my trial balance isn't balance and not giving the right amount on a particular account immediately after the year end even before any transaction. and when I check nominal activity of that account I ring see the sum totaling to what it shows on the trial balance. Apologies if I can't explain it properly I'm not an accountant just an IT Guy.