Sage 300

We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…

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…

Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.

Hey Everyone, I am new to Sage 300 and crystal reports but have a decent handle on both. We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…

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…

Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan

Hi, A customer has a custom report we create from scratch for AP transactions a long time ago. After they update workstations to Windows 10 in some of them that custom report doesn't work but in others its OK. So not sure what's the issue to fix. They…

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?

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…

Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203. Any advice?

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

We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. The issue is that when we print a report - any report, it runs the database record select and then stops…

Hi All, I have problem with printing report from macro. this is my code in macro this is my parameter in the Crystal Report and this is the only parameter. But it still prompt for connection authentication and parameter Is there…

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…

HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format. for example: this is the original report…

We have a customer that has used APCHK03 for many years and then after an upgrade to Sage 300 2018, that form does not display the cheque text amount. The report itself looks OK in Crystal. Any suggestions? It is a standalone machine running Windows 10…

Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.

Hi All, Problems found when we had started doing new forms/reports for Sage 300 2019. Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…

Sage 300. I have written a report in Crystal which runs great from crystal but generates nothing when I add it to the reports Menu in SAGE. I get a bit of an hourglass but no output. It is setup for preview.. Any tips on how to troubleshoot this?

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…

Hi guys, so I am trying to add a crystal report to Sage 300 ERP however whenever I add same and run the report after entering the date range parameters, the report just freeze, wont load and also wont close when I try to close it. I've unchecked the…

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.

Hi, One of the workstation, the print preview of any reports, the screen is printing at the center in a very small pages. Attachment is here. Thanks in advance.