Sage 300

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

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…

Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…

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

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…

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.

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…

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…

A client is trying to run an accrual report - see details below. In Earnings/Deductions Summary Accrual Vacation Current Balances Employee 100 to Employee 9999 This produces a 39 page report that she can only print 37 pages of and she gets…

Hi Expert, I'm very new with Sage. Can you please give me a hind to extract AR/AP aging? Any query would be appreciated. Rgds, Sokkorn

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.

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.

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…

We use Sage 5.6A 500 ERP at our offices. Whenever I run a custom report (to generate sales numbers), 50% of the time the program will crash when I try to export it into an excel data file. The report runs FINE, we can see the information in the report…

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