Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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 have a custom crystal report from Sage 300 2012 and am getting it to work with Sage 300 2020. If I run the report with print destination set to preview, it prompts me for the date range and works properly. If I have the print destination set to Printer…
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…
With the switch to remote this client's users are connecting via Citrix from home. Things are working in general. However, when we run a Crystal Report from the Sage desktop or a report that we have customized (the AR Aging report) and that Crystal report…
Crystal Reports 2016 Support Pack 2
I am using variables to do subtotals of values carried forward from a subreport. I have set up the following formulas:
Initiation formula:
BDG START - whileprintingrecords; currencyvar bdgfrpd; bdgfrpd := 0 FASSOU…
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…
when attempting to add a new crystal report to Sage300 Report Manager, receive a warning message in a Report Manager Popup Window that says "unable to load report". what does this mean?
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…
For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter.
Does anybody built a report on this using…
Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages .
As soon they click on export button the following error is received. generally user tends to run 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.
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…
We have Sage 300c installed and the Web Screens are accessible.
However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…
Hi,
How do I reprint a completed Purchase Order (PO)? Every time I try to reprint PO from module Purchase Orders -> P/O Forms -> Purchase Orders, I get a blank page.
I opened the .rpt from crystal report, the database is POPORN which is not an existing…
I want to create several reports to capture user data entry statistics. E.g. I want a count of how many AP invoices a person entered in a given day across all companies in a system. There are over 6 for this client. I am planning to write a crystal report…
I have searched the knowledgebase and i have not seen the answer.
The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok.
I get this error whenever I click "Print" and when Excel tries to run the report…
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.
Hello,
Not sure if that's the right place to ask. If not then please re-direct me to the right discussion :)
I'm creating a Crystal Report to use in PO module, and when I run it, memo fields (like PO Line Description) contain strings like {\rtf1\ansi…
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…
Hi,
I am trying to make a Crystal Report that shows all the invoices and credit memos in Order Entry. Right now, I tried using OEINVH, but I don't see Credit Memos.
Is there a way I can make a Sales Report that shows All Invoices with Credit memos…
I have created some reports in Crystal reports 2008 which work fine when opened directly from Crystal reports.
Unfortunately the client would like to be able to open these reports from any workstation that has access to Sage, so must be able to open…
Trying to change the form in Sage 2016 so that it uses a ODBC report instead of a datapipe report.
The client is on Sage 2016 PU1.
Changed the oerpt.ini file by commenting the sections on OEINV01 that points to datapipe, however when trying to run…
I am building a custom crystal report off the AP Invoice Table. When I grab the APIBH.DATEINVC file, it shows 20,110,101.00. I want to convert it to 1/1/2011. I tried using the following formula:
date({APIBH.DATEINVC}) but it does not work. Any suggestions…