• 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…
  • 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 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…
  • Crystal Report not displaying some fields when opened from Sage 300

    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…
  • Sage Custom Report viewing via Asp.Net MVC Application

    My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage. Can we develop…
  • Date Format

    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…
  • 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?