• Report window exits on clicking Print button

    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…
  • Sage 2017c web screen printing

    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…
  • Is there any way to show the Invoice #, Inv. Date, Check # and Check date on one row in a JC Commitment Item report?

    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.
  • Excel 2016 with Sage 300 2012?

    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…
  • AR Subledger Balance by Month

    How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.
  • Getting a "Desktop not responding" Error

    When we try to access any A/P reports, we get an error "Desktop not Responding". We are running Sage 300 2016, on a Windows 10 workstation (fully patched). The error only seems ot be happening in A/P or Aging reports. I have looked online and tried some…
  • Sage 300 ERP - A/R Invoice Summary

    Hi All How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016). something that looks like: Thanks! Vendor A $50,000 Vendor B $100,000 …
  • Sage Custom Report viewing via Asp.Net MVC Application

    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…
  • Optional Fields and FR

    Does anyone know if I can pull in Optional Field Value 'Descriptions' into an FR report? I know I can pull in the Values. Thanks.
  • Unicode

    Hi there, I am currently on Sage 300 6.3 and when I print any reports it displays Ariel Characters. Is there a way to change the Unicode? Thanks.
  • slow printing

    Hi, We're on Sage 2012 PU6 and having slow printing of PO and OE invoice on server and workstations. It takes more than 30 seconds to get a preview. Any idea.
  • Sage 300 ERP payroll 7.2 - error when printing a report

    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…
  • Is Sage 300 2016 compatible with Windows 2003 32bit OS at the workstation level?

    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…
  • Wildcard in the first section of GL code

    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…
  • Reports very slow on in Sage 300

    My client is running Sage 300 2014 and when they run reports from their workstation they are very slow, but when someone from another office runs a report via their terminal server it runs very fast. Any ideas?
  • Why, when I correct typos in my item descriptions, they show in item reports but not price list reports

    Is there a procedure required to update the price list item descriptions? Only the item status reports show corrections at this point.
  • AP Reports requesting Parameters following upgrade to Sage 300 2016

    Client was upgraded from version 6.0a to 2016 yesterday. Since the upgrade none of the Accounts Payable reports will print. When we try to run any reports a screen comes up requesting a number of parameters be entered. All other modules (GL/AR/PO/CP)…
  • Crystal report datapipe connector fix from years ago does not work for Sage 300 2016

    Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?
  • Inserting a running total from a Formula field to OE Invoice report

    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…
  • BI Reporting Manager Error

    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…
  • Sales Tax on a Cash Basis

    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.
  • Non AR Cash Receipt

    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

    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.
  • Adding an Inventory Custom Field to the picking ticket

    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
  • Invoices not showing discount date if no discount is available

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