Sage 300

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 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…

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

When exporting one of the custom crystal reports we suddenly get the below error message: Deskto has stopped working. When l went to the windows Event log to check what is the issue l get the below error log: - System …

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…

Is there any information regarding Crystal Reports and how it is integrated with Sage 300? My understanding is that Sage 300 includes a Crystal Reports runtime (or something like that) and uses it for any reporting-related tasks. If so, does Sage provide…

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…

Hello all Citiers, I am working on an upgrade of server and SAGE 300. The server is Windows Server 2019 and SAGE 300 is Premium 2019 . The install of SAGE was OK although i had an issue with SAGE .NET libraries installation. This is now fixed. The…

Our client upgraded from Sage 300 2014 PU5 to Sage 300 2019 PU1. We had developed a specialized invoice form for OE for them. After the upgrade everything is out of alignment. Any ideas why? Sam

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…

Is there a way to determine which Invoices are listed as OE Pending from a database level whether it be looking at the OEINVH or some other table as I am trying to build a Crystal Report based off these Pending Invoices.

On Windows Server 2012 R2, after installing Sage 300 2017 and Crystal Reports Pro 2016, some Crystal Reports dlls (such as u2lcapw.dll) are not accessible from Crystal Reports Designer, so custom reports don't run in the Designer. The dlls were installed…

We got this error while installing Sage 300 15.1 R2. the error came up while the Crystal reports runtime was being installed. The way we fixed it was to manually Download Microsoft C++ Redistributable Package for x86 platforms . and install it. Our…

Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…

I am doing pwFormatDate(ORDDATE) = CurrentDate -1 to obtain yesterdays date and then trying to filter on this date for yesterdays orders. But I need to convert this date back to a Sage date to do the filter. Is there a function that converts back to Sage…

Hi - currently running Sage ACCPAC ERP v6, but upgrading to 2014 in the next month or so. I currently have and use Crystal Reports 2008 (12.7.0.1983) to modify and create new reports. I assume I will need a newer version for the 2014 product - but…

I picked a report from my clients Sage 300 2012 system and transferred it to my local machine for modifications. I have Sage 300 2014 and Crystal Reports 11. The report renders blank when I want to test it. Does anybody have an idea why this happens…

Recently upgraded to 2014 300 Advanced Version 6.0 functionality for exporting a previewed report to Excel included a dialog box where column sizing could be based on header, details, or other choices. That dialog no longer appears and the exported…

We have a number of Custom reports that require some user paramaters to be inputted for selection criteria. these reports was originaly written in crystal 8 and accpac 5.4 over the years the reports has been updated without an issue and even the change…

Hi, i have few client fail to print GL Transaction Listing Report and it show the message below. This is standard report without any modification and getting this error. The remaining text does not appear to be part of the formula. Details: errorKind…

Sage 300 Prem 2012, PU1 SQL 2012 R2 App & TS servers Windows 2012 R2 A client is reporting an issue with random bolding of text on invoices in OE, on custom and all standard rpt files. This does not occur with other reports. Interestingly this…