Sage 300

Kindly advise on how I can achieve the following results: I am creating a report Under Datamodel/sales History / Sales Analysis folder. The report is supposed to be a worksheet view showing Net sales for the month, lets say a report for today, it should…

Hi, How to keep formula excel active in financial report once the report is generated. As of know, it only show the value of the sum of two columns Thank you

I'm looking to add statistical information to my reporting and I'm wondering if anyone has found a way to make that work. If there's not a direct way to add these types of accounts does anyone have any ideas for workarounds?

I am getting an error trying to publish my Sage Intelligence report to BI in Excel The error I am getting is: Authentication failed because the remote party has closed the transport stream. Can anyone help with this?

I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300. /resized-image/__size/640x480/__key/communityserver-discussions-components…

Hi, Did anyone encountered the same error code when print Financial Statements in Sage 300 2024? After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button? Client is using Microsoft Excel…

We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…

We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…

I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

I have a client that wants to send the financial reports to a partner that does not have access to Sage 300. We would like the partner to be able to change the parameters on the Excel workbook that is e-mailed so he can take different looks at the data…

Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable? My customer change SQL Password to 64bits length… After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.

Hi We are using Sage 2017 version, Please advise how to change the report format. All report comes with the name who left our company. Our sage cannot be opened via web browser (becouse of no cloud version?) and ther are no "setting" botton on my…

I am trying to run and copy a report in Sage 300 2014 and later move the report to the Sage 300 2020 environment for testing and use. However, i keep getting the captioned error. A few months ago users were able to run reports without an issue. All of…

I have developed a new Sage Intelligence report for a client and had to create a new container. How can I export/copy the container to my clients computer? Also, how do I copy the new report that is associated with the computer.

Hi guys, I am having an issue where my PO's are not coming over in Receipt entry as well as POs are being closed after being partially received Any suggestions as what could be causing this and/or how to resolve this issue?