Sage 300

Hi, One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2? They need to run FR, but encounters the following errors: Description: PrintReport…

Hi all, my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column. When opening it on old version of Office…

Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…

We tested this feature a couple of weeks ago (financial reports) and it worked fine, we could run all financial reports. Now, after we went live, it stops working with the "Error in running connectcomaddin" in macro. I got it to work 2 days ago and…

Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

I have left the pay codes and taxes blank at this time. Any ideas where to look for my error (s) ?

Accpac 2016, PU1, Excel 2016 32 bit. Excel add-on for financial report writer IS added to Excel. Excel is part of Office 365 on the workstation.. When you run the print financial statements function, Excel comes up and it appears to run through all…

Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…

Have a question about Excel conditionally formatting within the Financial Reporter. I have a FR report with different columns for each division......is it possible to format that column either red or green depending on if that division is showing a…

Hi We have a client running 6.1 Sage ERP 300 with SP 4 installed. They are using Excel 2013 32 bit which PU2 says makes compatible but when we run we get an error saying it cant open excel as excel. I ran a repair on excel in control panel. Ran…

We have a customer on v6, moving to 2014 soon. In the meantime, a workstation using the system now has Excel 2013 on it and the financial reporter won't run. My guess is that it is an incompatibility issue. The customer is asking what versions are supported…