• T5018 (CPRS) Print Form Option No Longer Available To User.

    Hi Everyone, We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…
  • Is there a way to build a Purchase Order Report to include the "Ship to" name?

    We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…
  • Commitment Count - Total & Unique

    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…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    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…
  • System Requirements for Sage 300

    We are upgrading to Sage 300 in a small environment aka 3 people. Or reseller is saying we need 32G RAM. The only document I found that might relate to this shows 3 deployment scenarios of Standard, Advanced and Premium. It doesn't elaborate as to what…
  • 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…
  • Missing with GL account folder and Administrative services functions

    Hi, I installed a fresh copy of SAGE 300 2018 and loaded sample data. It is fine with everything. But after loading customer earlier version data and upgraded, I am missing with Administrative services (except data activation) and GL account folder. I…
  • Upgrading server version 2014 to 2016

    Currently, SAGE is running on Windows server 2014 and IT is planning to upgrade the version 2016. This updates will not require any installation and uninstallation, It is straight forward version update. Does it have any impact with current running SAGE…
  • upgrade

    Hi there, After upgrading to sage 2016, we are losing the Users and have to enter them manually. Once they are entered the permissions reappear. Is it normal and is there a way to make sure the users upgrade as well? Thanks
  • 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…
  • 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…
  • Not a valid Crystal Report

    After upgrading to Version 14.1, some of our systems will not print Crystal Reports. When attempting to print we get the following error message. We have attempted to perform the suggested Resolution on KB 55371 with no results. Anyone have any ideas…
  • 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?