Sage 300

V2024 logged Sage 300 as Administrator, when run any reports, we get above error, even when firewall is off. Everything else in Sage in fine. Please help.

Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…

I am attempting to create an On-Time Shipping Report. I want to add a parameter to only show items shipped during a certain date range. I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records. Any…

When using Sage 300 webscreens, is there a way to run Intelligence reporting with installing Sage 300 desktop version.

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

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?

I am trying to create a SQL stored procedure with a date range parameter to be used in a Sage Intelligence report. One old procedure uses the following: CREATE PROCEDURE [dbo].[TJWEEK] -- Add the parameters for the stored procedure here @S_Date…

I am new to Sage300 so i'll apologies in advance. I am trying 2 things to work on sage300 (2021). 1) I am trying to get department name on FR View dynamically. I have tried following but did not work for me. =IF(ISNA(IF(FR("ReportAs")="Separate",FRSDESC…

We have created a Financial Statements SAGE Intelligence Report Template that has default Distribution Instructions attached to it. For one particular user, it seems that these Distribution Instructions intermittently do not load with the template for…

Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error.... Automation error The object involved has disconnected from its client. This only seems to happen for specific user. When logged…

Is there a way to link the year in the parameters sheet to the year selected when the report is initially generated? Thanks.

I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.

Hello, I am new to using Sage 300 and I have a problem with printing. When I select any of the Print Destination options and check Data Integrity, a log file should be printed (or opened in another window for Print Preview). However, the check is performed…

We are using Sage300c 2020 web screen, when we print a report we are able to see it on-screen {Preview}. But, unable to print to printer or export

Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…

I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…

I am consolidating 3 companies company 1 current year is 2019 company 2 current year is 2019 company 3 current year is 2020 (does have different fiscal year end - am not consolidating on a single worksheet) When I run the statements i only see…

My client runs Sage 300 Advanced version 2018. They are on ALF Model. The ALF Licenses came together with Connector 6.4A and Designer 6.4A activations and I have already activated them. For the client to start using the module what do I need to procure…

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on. Windows Server 2016 with SQL Server 2014.

Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…

I'm having an issue when running the missing accounts tool. On one report I've built, the tool will only show missing balance sheet accounts even though I know for certain there are missing income statement accounts. I even went so far as to build one…

When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…

Hi, I'm using Sage 300 2018 PU 2, when running Sage Intelligence Cloud got this error You Are Not Authorized to view this page. I have given admin and a user with Financial Report and WEB Api access through the sage desktop. But still having this error…

In Intelligence Reporting module, whenever I try to open any app (ex. Report Viewer, Report Manager, etc) I always get an error message that says "ActiveX component can't create object" and it just doesn't work. It used to work with Sage 300 version 6…