Sage 300

Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…

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…

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…

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…

Hi everyone, We just upgrade an old Sage 300 ERP v2012 to a new server with Sage 300 2022 Update. Not a problem. But a custom application IT create with VB that use Crystal reports is not working, apparently for some crystal runtime engine conflict…

Hello SageCity, I am struggling to get to the bottom of a strange issue. It happens in SAGE 300 version 2019 when printing reports. The details are: 1) A user starts a report from SAGE, 2) The report program prompts for parameters, 3) User fills…

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

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 trying to print an invoice, in retail POS, but I am getting the error above.

Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…

Hi everyone, A customer change its PC - we have all programs ate server and we run workstation setup - and suddenly a custom crystal report we create from scratch doesn't work !!!! Error...."The remaining text doesn't not appear to be part of formula…

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 all, I am trying to amend popor01.rpt on crystal report. but on open the report, then preview it, I get the error as attached. I have not add any fields yet. Any way how to solve this? Thank you

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?

We are currently running Sage 300 version 2021. We are looking at buying a Crystal Reports license. What would be the recommended Business Objects (Crystal reports) to buy ? I would have preferred the 2021 version of Crystal Reports but l am not sure…

Anyone had any experience/success passing more than one email address from Sage 300's new Multiple Contacts module to PrintBoss? I assume we'd assign the email addresses in a subreport. Concatenating and delimiting the would be tricky, unless PrintBoss…

Hi, I'm using SAGE 300 Premium (Version 2018) and SAP Crystal Reports 2013. I'm working on a Crystal report and using the following table linkings: OEAUDH linking to OEINVH (Linking field- ORDNUMBER, Join- Inner Join) OEAUDH linking to OECRDH (Linking…

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…

This is one of those crystal oddities. I have a custom report that works fine in preview mode. When printer destination is set to printer, the admin user can run it ok, but all the other users can't run it. The report fails before it prompts for the first…

I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?

Hi Citiers, I have searched around and and followed all the tips found here there there with no uck. I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error. We got an Windows Server…

Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…

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…