Sage 300

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…

It would need to prompt for from bank, to bank, amount, and transfer date. then offer OK or cancel. The rest of the stuff on the bank transfer screen I find not helpful.

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…

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…

Hello all, We have a custom crystal report for Order Entry order confirmations. We have been printing Line Numbers on the report by using the special field "Record Number". However, we can no longer use this because if someone inserts a comment and…

I have a VB program that prints an invoice to a printer, or saves it to disk as a PDF. The response time is abysmal - up to 60 seconds to process a single invoice. The line is rpt.PrintReport. Can anyone share why they think this is? Sample code is below…

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…

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

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 have a client who needs an AR invoice form that shows a zero balance if paid in full. It is a request of one of their large customers. Has anybody created this form or would be interested in doing the customization?