• Check Register doesn't show correct Payee

    Recently my check register report does not show the correct name that was printed on the check. How do I fix this? I need it to show the Remit 1(2,3,) name not the Vendor Name so it matches the actual check. We have lots of Vendors that require us to…
  • Adding a note to receivables aging report for individual invoices

    I'm using Sage 50 US. I'm looking for a way to add a comment about an invoice that would show up when I run the aging report. For instance, when a customer communicates to me that the invoice will be paid on a certain date, or if there is an issue with…
  • Employee Earnings Report

    How can I get a report on an employee earnings not including bonus and overtime?
  • Generate a Report for Customer's Open Sales Order Ship Dates

    Regarding our customer sales orders, we have multiple items that ship from different vendors. Is there a way to enter the estimated ship dates for each line item and then create a report to email to our customer? Currently we create an excel spreadsheet…
  • Quarterly Governmental Reports

    Hello, We recently upgraded to Sage 2022. In our older version, we had a Quarterly Governmental Report that was available under Payroll - Reports. This report is not listed in the 2022 version. Does anyone know how I can obtain this report? Thanks,…
  • After paying supplier's invoice, it still shows on Aged Payables Report

    I’m using Sage 50 US. When I pay a supplier’s invoice before the due date, the invoice still shows up on the Aging report, but now as a negative dollar amount. The report subtracts that from the total amount due for that column, which makes the total…
  • 1099 Reports

    We are wanting to run the 1099 report to see if anyone is missing their TIN. When we attempt to run it, we are not given 2023 an an option on the drop down menu. Our fiscal year runs from Oct 1 - Sept 30, so I am not sure if this is part of the issue…
  • Sales Rep Commission Reports

    Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get. I have tried to do it through the Invoice Register, but the report that it spits…
  • Reports not available - Sage 50 accounting 2018

    Hello everyone, I have a problem, we are currently using Sage 50 accounting US 2018 version. And it does not show me the reports that Sage brings, except for the ones I previously customized. I am on ek release 2018.2, will there be any newer one…
  • Past time to update Report & Forms Designer?

    Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…
  • Question about Intelligence Reporting being retired

    We have a person that just started learning Sage 50 US Intelligence Reporting recently. We purchased the connector a month ago but have not installed it because we aren't on the newest software version. We got the email notice that it is being retired…
  • Sage Intelligence Reporting for Sage 50 US will retire

    On our Sage 50 2022 we are receiving a notification about Sage 50 Intelligence Reporting is being retired. Will this affect the reports that are designed in this tool after the stipulated date?
  • Sort customer by region and sales

    Is it possible to create a Report sorting the Customer by Region/Country AND by Gross Sales?
  • Balance Sheets ran for same period don't match

    We use Sage 50 Quantum. I ran a balance sheet for period ending 12/31/20 back on February 24th 2021. Today I ran the balance sheet for the same period 12/31/20 and the retained earnings GL is different from the report I ran in February. I am wondering…
  • Number of decimal places in forms / reports

    Hi all, I'm facing an issue on the number of decimal places in the sales order total and tax amounts simply price related amounts even if I set it to four decimal places the value displayed in the print preview rounds off the actual value to two decimal…
  • MISSING RESOURCE: Variable uses and Automation type not supported in Visual Basic

    Hello, I am having trouble with a running a few reports in the Report Manager that I have created data containers for in the Connector Tool. I keep getting a missing resource error like this one: https://imgur.com/a/PlNPghp This occurs right at…
  • Sage 50 Items Sold Reports

    Hello All, Does anyone know how to run a report that will show items sold in March 2020 vs items sold in April 2020. Basically a comparison report in one report
  • Is there a way to calculate the commission by item sold?

    Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen
  • Customer contact for sales order?

    Is the customer contact stored in the sales order? You have to choose a contact in order to select a shipping address, but I don't see a way to get to the contact name in a report.
  • raw material report

    We sell a lot of products that have a lot of common assemblies so to capture WIP we have all our products made up of multiple levels deep assemblies. Now we have been inundated with orders and I was hoping for a easy way to show if we had enough raw materials…
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • Column titles not printing entirely

    Since upgrading to Sage 50 2020, some of the words in my column titles are not printing on my financial statements. When I open Designer, I can see the words there, they are just not printing or showing onscreen. Sage support told me they can't help…
  • Sage 50 US Accountant Edition 2020 - Vendor Names on Reports

    FormerMember
    FormerMember
    I have a client that data entered several transactions to their bank account register and incorrectly coded multiple transactions to an incorrect Vendor ID. I instructed the client to go back and create a separate vendor ID for these separate transactions…
  • Drill Down Problem

    I'm getting an error when trying to do a drill down: "The drill-down report Report Designer Add-In-GL Transactions 1-0 required to perform the drill-down doesn't exist" I'm using Sage 50 US 2019. We called sage and after speaking with several…
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…