Sage 300

Hi, A client has been printing an FR Report for many months now but then she suddently started to receive an error message this week: "Initializing FR Error (12) : Fail in starting Print Financial Statements" I tried a few of the usual MS-Excel…

Good day, I have a problem with my FRView and I am desperate for help. FRView does not function properly on one of my Servers. The specifications are: Server 2012 R2 8 Virtual CPUs 16GB RAM 200GB virtual HDD When an FRView report is…

Accpac 2016, PU1, Excel 2016 32 bit. Excel add-on for financial report writer IS added to Excel. Excel is part of Office 365 on the workstation.. When you run the print financial statements function, Excel comes up and it appears to run through all…

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…

Greetings, I have heard that Financial Reporter will not be supported in Sage 300 2017. Does anyone have any information on that? Thanks,

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…

Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query. They are trying to insert ”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…

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…

How do you create a report to show the sales for a national account if the customer numbers are not contiguous?

Hi I installed Accpac 500ERP 5.5a on my PC and the following error shows when i using it. (This is the first time I use Accpac so i have no idea about this error. And my PC environment is Windows7 64bit) Error：Crystal Report Viewer "Failed to retrieve…

Hello, I run Po aged report & PO action report, however there are some po not finished yet missing in the action report but includes in aged report. very weird! and my aged report includes tax while the action report not. could somebody indicate the possible…