Browse By Tags

  • Sage 300 2023 and Custom Crystal Report

    Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…
  • Sage 300 always prompt SQL login database when Custom Report from Crystal Report is printed

    Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…
  • 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…
  • 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…
  • Is there any easy way to show the currency used on a purchase order

    I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?
  • Crystal report Issue

    Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…
  • 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 Error on export button

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

    Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.
  • The Crystal Reports Print Engine is currently busy. Please wait a few moments and try again.

    Hello, For starters, I'm using Simply Accounting 2012. We can't upgrade at this time because we also use integration to ACT! which is no longer supported by Sage. All computers (15 or so) are running Windows 7 Pro 64-bit. For years we've been printing…