• 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,…
  • Open Sales Order Reporting

    Has anyone found a way to generate a report for Open Sales Orders that shows how much of an item is still open, or how much of the Sales Order total is still open? For example, I have a Sales Order with 100 pcs, totaling $10,000. 50 of those pieces have…
  • 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…
  • Time Tickets Not Used in Sales Invoice

    How can I get a Time Ticket report of time tickets not used in A/R invoices? All of my saved custom reports somehow disappeared and I lost a report that listed only tickets not already used on a customer invoice. I cannot find a report with a filter on…
  • Invoice Line Item Detail -> Cash Disbursement Journal

    Our controller has asked that we send a weekly report to decision makers showing all of the cash leaving the building & what it was for. They are looking to see the line item description or detail that would pull through to the G/L in this report. I…
  • 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…
  • How can I search for quantities sold of an inventory item for years past based on invoices?

    I am looking to get the numbers as shown in the History tab of an inventory item - but over a range of time and not just the last 12 months. A sales order report does not work for me because we do not always create a sales order for the items if we…
  • Sage 50 report which will show what reimbursable expenses were attached to a specific customer invoice?

    We're using the Apply tickets/expenses to add reimbursable expenses to a customer invoice. Is there a Sage report which will show what invoices were attached to a specific customer invoice? The Job Profitability report shows all the job expenses, but…
  • 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…
  • 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…
  • 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
  • Peachtree 2011 Question pertaining to a credit on a customer account

    Hello, I would like to know if there are different results when a credit to a customer account is created by generating a new sales/invoice with a negative quantity & negative amount as the invoice amount vs creating an actual credit memo as per the…
  • 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…
  • How do I run a Sales Tax Liability report in Sage 50?

    I need to run a Sales Tax Liability report for a client so that I can prepare monthly/quarterly/annual sales tax returns (for multiple states) and remit the proper payments to the various states. I am relatively new to Sage 50, and have not had to run…