• Crystal Report Printing Error

    I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
  • AR Aging Report with Description in Crystal Reports

    Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…
  • Report Manager Popup Window that says "unable to load report"

    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?
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    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…
  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
  • Sage 2017c web screen printing

    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…
  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    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…