Sage 300

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

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

I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…

[sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

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?

Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not using…

Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) We want to separately show the segment description in a field on the invoice for the style and the colour. I have tried a little sub report for style connected…

I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?

Greetings, I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message. Has anyone…

Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…

Hi, Can I add the user name who is printing the form on the form? Thank you!

I am using Crystal Reports 2008 to edit the Sage 300 Certified Payroll report (UP71A/ENG/upcprj1.rpt). When I open the file in Crystal, it first gives the error message, "The saved data will be discarded since one or more formulas failed to compile."…

I am trying to figure out if there is a way to print Order Entry Forms twice. 1. The first time it would print, it will print normally. 2. The second time, it would print the form without any prices. Is this possible to do using the crystal reports…

Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…

Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…

Hi, I am trying to add the company address from the Company Profile in Common Services module on the AP checks. How could I link this tab to the crystal AP form? Is there another a better way of doing this? Thanks

Does Sage 300 ERP 2014 support Crystal Reports 2013?

A client running 2012 with PU 3 installed is reporting an issue whereby remote users (terminal services) click on the report icon deployed on the 300 desktop for all users and sometimes the report will not open. They see in the lower left corner of the…