• Antregrate Custom made piped Crystal Report / existincg Exe in Sage 300 Web Screen

    Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    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…
  • Need to update a crystal reports invoice with a specific field

    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
  • Printing error

    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…
  • Commitment Count - Total & Unique

    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…
  • Sage 300 2019 Report unable to use View Table as Data Source

    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…
  • report in Crystal which runs from crystal but generates nothing from reports Menu

    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?
  • Formulas to pull out First name & Middle Initial separately

    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…
  • Sage 300 2018 UI Container Error on Print Preview

    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.
  • Print Preview not working - Sage 300 2018 PU2

    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…
  • GL report - opening balances

    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…
  • Print Financial Satements - FrCom Addin

    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…
  • Crystal report datapipe connector fix from years ago does not work for Sage 300 2016

    Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?
  • Inserting a running total from a Formula field to OE Invoice report

    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…
  • ..\a4wdp.c

    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…
  • Error message when trying to edit Sage 300 Certified Payroll report

    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."…
  • Order Entry Form

    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…
  • GL Trial balance

    Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.