Sage 300

I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…

A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN

Sage2018 SP2 new server. office 2010, when you launch statement designer comes up with error "cmdStart : Error on opening the xla macro.", if you click close says "cannot run macro RemoveAutoStartFiles" excel macros are enabled and VBA enabled too.…

When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…

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…

We're applying for a line of credit with our bank. I need to create a simple report listing our current debt. GL/reports/current/(start/stop range) lists all transactions & entries and I don't need that much. I just need a summary of each vendor. Will…

Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.

Client moving to new software per new owners in a couple of months, so do not wish to upgrade Sage 300. Sage 300 v 2012 local install, data on server. Workstation crashed, wiped and reinstalled. External IT firm installed Office 365 with 32 bit Excel…

Hi, I am unable to run any report: I get a message box that says: Initialising FR Error (12): Fail in starting Print Financial Statements and when I push OK, another box, pops up: Error: PrintReport:Error on running StartGL9100 in macro …

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…

Sage 300 v2016 GL Financial Reporter (FR) Is there a way to specify a range of Fiscal Periods that spans between two fiscal years when generating an Income Summary in FR? I have a bank asking an Income Summary from 7/1/2015 through 06/30/16. Coming…

I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…

Dear Friend, My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code? For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…

Is there a procedure required to update the price list item descriptions? Only the item status reports show corrections at this point.

Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?

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…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…

How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.

How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…

Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.

How do I add an Custom Field from an inventory item to the picking ticket? I actually want to a 10 custom fields the report

It there a way to not show the discount date and discount amount when the discount amount is zero?

Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.

Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…

We have just upgraded a client from Sage 300 5.6 to 6.2. We had customized the OE invoices on 5.6 to print in draft on pre-printed stationery using dot matrix printers (Epson LX-350, Epson FX-2190 and OKI ML280). After the upgrade, the forms still work…