Sage 300

Why is it impossible to print statement of accounts reports in SAGE 300 simultaneously across a number of workstations? When one of the users in a given workstation tries to print a report and their is another user who has opened this module, the error…

Hi, I'm new to SAGE, is there any function to navigate the foreign currency translation report?

We have a client who posted a check for March 15 and then reversed the same check for March 15. When we run the check register for March 15 - March 15 for all reconciliation statuses, it says that check is missing. They want to see it as reversed. Is…

Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?

Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…

ICBOM01.rpt gives connector error when processing CSV file made by ICCOMP.DLL V2020 I get no error if I suppress the sub-report so I know it is that sub-report showing BOM details Error happens on server with O365 and another server with no Office installed…

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…

We have gone to the Crystal Reports and cannot for the life of us figure our what this number represents? It didn't change when I printed the PO (as in it would roll up one for each time printed), it also did not change when I added lines or modified…

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…

I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…

Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…

How can I filter AP vendor transaction report to get actual result with GL transaction report.

I have several custom reports (crystal reports). Now I want these reports to be also accessible via web screen. Which directory should I put my reports?

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…

What causes an item to show as 'On hold' in the last column titled Status. We have looked around and can't find what causes that to happen.

After choosing job and employees, the next step is "Generate". Upon clicking that link I get a message that simply says an error has occured and for me to check the viewer. In the log viewer it reads, "Object reference not set to an instance of an object…

What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.

I need to find the details of what withdraws and deposits were outstanding at 10/31/22. The reconciliation status report seems to give me what is outstanding at this moment in time for anything processed through 10/31/22, not exactly what I need. I have…

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…

Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?

We need a simple way to query a report for on hold accounts and their outstanding payment amounts. I thought I could use some of the data provide from the AR Customer Inquiry table, but I can't seem to find what that table is called? We need - Customer…

My client is running Sage 300 Premium Edition Version 2020. They want their Balance Forward Customer Statement to have a running balance. The challenge we are encountering is that the client has done adjustments so the adjustment amounts are not factored…

Has anyone changed the Reorder report to use the Preferred vendor instead of the report just using Vendor Type 1. I realize the report is using a DataPipe and the prevendty isn't given under ICITEM for this report so it looks like I will have to build…

Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?