Sage 300

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…

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…

Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment.. After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

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…

Where do I find stock crystal report forms? I'm using 300 v2017 and looking for the most up to date version of oeinv.rpt

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…

Customer has a new Win7 laptop and their IT folks installed the Sage 300 client 'as usual'. Users normally preview reports then prints or sends to PDF if a copy is needed. When they choose 'export' option from the preview, instead of getting the window…

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…

Greetings! If this is the right forum, I have been having a perplexing issue with printing payroll cheques using either CPCHECK4 and CPCHK4A forms - regardless of the Advice Lines per page and MaxDetails field in the Crystal Report Design tab being…

Hi ...... when my user tried to print he see's this : KUSHAL ERROR.docx

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…

When we print a customer statement in the end of every month, those amount on the bottom do not match the total amount, it always missing one day. There is no current amount show. Is there any way we can change "1-30 days" to "0-30 day"? Thanks so much…

We would like to take some of the existing reports in 300 and modify them to run for multiple databases from one company. Is this possible without writing a whole new report? We do have a connector license. Thanks! LeShel Rich

Hi all, I am working on a report, somehow got stuck. Here is the simplified yet detailed description of the problem. I created two formula out of OESHIHO table: formula A: if {OESHIHO.OPTFIELD}='A' then {OESHIHO.VALUE} else '' formula B: if…

After key in a new PO and print it out, but the item codes are missing. Anyone has experienced same issue?

I'm trying to use the same record twice in a report but with different criteria. It's on an invoice and in the details section I want the report to ignore a particular item id and it's data, but only show results for that same item id in another spot…

I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…

Hi We are using SAGE 300 and crystal reports 10. I've been strugling with this issue form more than 8 hours now and I really need help. The AUDTTIME field in ICHIST is a decimal(9) field. Now I've got to convert this decimal field to a time. This is…

I was writing a very simple report that I am trying to format the Sage 300 date for and I get an error. Does anyone know how to fix this or a different more reliable way to format Sage300 date fields. I tried using: pwFormatDate ({CPEMPL.HIREDATE…

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

I am using SAMINC to test linking a sub report to the picking ticket of an order. My problem is that the OEORDD table uses the full part number, but the IVITEMO drops the special characters. When I attempt to link I get no matches. How can I link the…

To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

I'm looking for a canned Bill of Lading report and thought I'd try the report store folks. Not showing up any longer. Does anyone know where they went?

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…

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