• 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…
  • Sales Order reports

    Currently when we receive a Purchase order we run the stock status report and add the column "Quantity on Sales Orders" to see if anything that came in is on a Sales Order for a customer. It doesn't tell you what the Sales Order number is so you have…
  • 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…
  • Tracking stock parts found both in bins & built assemblies

    In Sage 50 Quantum is there a simple way to view stock levels of parts some of which are in built assemblies and some still found in parts bins? For example we have an instrument that us comprised of over 600 unique parts. Within the instrument are 50…
  • 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…
  • Reporting Using Item Type

    I would like to run Sales reports by Item Type but I don't see any reports that has that field available. Any suggestions?
  • User Security Setup

    Is it possible to setup a A/R & A/P clerk position to have access to Job Profitability Reports WITHOUT having access to payroll fields/access?
  • Sort customer by region and sales

    Is it possible to create a Report sorting the Customer by Region/Country AND by Gross Sales?
  • Is there a way to run a report showing Monthly Balance Sheet's for a given Fiscal Year vs running the BS report twelve different times?

    I am wanting to do some monthly Balance Sheet Analysis for past years and was wanting a report showing the ending Balance Sheet amount for each month in a year instead of having to manually trying to compile twelve different reports, Is there a fairly…
  • Accounts Payable Report - Expense Account

    I need to approve payments for the AP check run. My accountant gives me a report of vendor, invoice, amount, and GL account. However, the GL account is Accounts Payable account. I need a report that shows what Expense or Inventory account the invoice…
  • Does a profit and loss report exist in Sage 50?

    Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…
  • 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…
  • Proposals and Incremental Invoices

    Once again I have a very unhappy client because of the misleading representation of quantities on an incrementally billed invoice originating from a proposal. The invoice form I print shows columns for the item quantity, the line item proposal amount…
  • 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
  • financial statement formats

    I have gotten an error message on one of my financial statement formats that "the number of lines on this format exceeds 260" But when I use the Sage Standard Format there are well over 260 lines. Is this message generated by the number of total types…
  • 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
  • Expense Tickets

    I use Quantum version. I have entered an Expense Ticket and have it assigned to a job. It is not showing on the job ledger report. How do I get the expense tickets to show there?
  • A/R Report Showing Incorrect Payment for Customer

    On the AR is it showing a payment of 935.28 and an outstanding invoice of 467.64 but shows a credit on their account of 467.64 ONLY on the AR not on their customer account view - it shows zero. A prepayment was done in the amount of $467.64 and it was…