Browse By Tags

  • Information Assistant RDP connection does not allow users to print via local printers

    Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…
  • Cashflow Statement - A/P operating vs investing activities

    Hello, I am trying to produce a reliable and accurate cashflow statement in Sage 50 Quantum Accounting Canada. To me, a cashflow statement should start with net income, then take into account cashflow adjustments from operating activities, investing…
  • 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…
  • Sales report by foreign currency

    Hi, We have sales in US and CAD. For the Sales Report by Customer : Is there a way to have the information in foreign currency, instead of CAD. Thanks.
  • 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…
  • Sales Reports

    Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks
  • 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…
  • Can you view the last time a report was used in Job Cost?

    I'm wondering if Sage 300 16.1 keeps track of the most recent time a report was used. The last guy who managed them never deleted anything so we have reports that are as old as dirt. I was wondering, instead of asking every person individually what they…
  • 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…
  • 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…
  • Project Reporting Only Goes Back 1 Year?

    We have some 'straggler' projects from 2014 that are still active projects. It seems I cannot generate any Project Income report that uses a date earlier than Jan. 1, 2015 now that I have rolled over into 2016. That seriously sucks :( Are there any…
  • 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…
  • 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?
  • Project Budget Detail Report

    I am trying to run my Project Budget Detail Reports - Actual Vs. Budget, however the first line of expenses has minimal amounts listed under "unassigned budget amounts". I am not sure why that is or where to go look for the error or what was missed. Does…