Sage 300

We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…

2020 year's sales tax was easy. I just ran the tax tracking report for the relevant fiscal periods and sort by tax class, which for us is 1 for taxable items and 2 for non-taxable. But this year, the same report for both this year and last double counts…

Hi there, What FR function should I use in order to create a report showing department side by side? Also, is there a way to combine two departments? Thanks, Zia

Hi there, Can someone help me out an FR function here. I am new to the FR designer. I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021 =FR("PERIOD")&" Months Ended "&FR("END…

I get an error message when opening the COA report using the Web UI, can anyone help me?

This is not a question, just information: Recently, Crystal Reports started giving message "Unspecified Error" on certain reports, after working fine for many years. I have determined that there is suddenly an issue between Sage 300 desktop and Crystal…

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…

Hi All, I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.

I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…

HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format. for example: this is the original report…

Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.

Client has been running fine and this just this week we have been getting errors trying to use Financial reporter. I suspect a microsoft update but they are saying none applied. (I know don't belive them ) either way I need to know what one it was …

I am attempted to show the total of the misc costs on an invoice. I have created a calculated field for the misc costs that is equal to the extinvmisc only when the linetype is <> 1. This does calculated correctly, but when I use a sum formula it is three…

Hi Guys, Would a kind soul please help me ? Here is the case: I installed SAGE 300 2017 Workstation on a new PC running Windows 10 Pro. The only but about the installation was a warning message as follows: “There was a problem registering the…

Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment.. After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

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 datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?

I'm looking for a canned Bill of Lading report and thought I'd try the report store folks. Not showing up any longer. Does anyone know where they went?

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."…

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