• 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?
  • Income Statement Issue

    Monthly and YTD Amount showing as the same amount on the Income Statement. How can I fix this?
  • 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,…
  • Reporte Inventarios Kardex

    Buenas tardes estimados, estoy buscando un reporte o como crearlo en sage 50, este reporte se llama Kardex y registra las entradas, salidas y saldos de cada producto y sus costos unitarios de entradas, salidas y totales. Pueden auxiliarme por favor. Gracias…
  • Sales Backorder Qty to Ship

    Currently Sage 50 Quantum - 2023 version does not show Qty to Ship on the Sales Backorder Report. Also the Amt Shipped shows line item wrongly. Please fix this issue asap Thank you Dan
  • 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…
  • Edit Level 2 Totals for account group total Sage 50 accounting

    Using Sage 50 US Premium Accounting Several years ago, I created a custom financial statement report. In this report I created Level 2 group totals for several groups. Now I have added a few new expense accounts I would like to add these accounts into…
  • 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…
  • I am trying to do quarterly sales tax for the first time. I can't see a Sale Tax Report item on the Report menu.

    Good Morning Everyone: Sage 50 "Help" alludes to their being a Sales Tax Report. I don't see one. What am I missing? Other useers on this forum mention they had to buy a third party tool for Quarterly Sales Tax Reports. What is the actual truth. …
  • Inconsistent date format when export data to excel

    My excel version is Office 2016. When I export data from Sage 50 to excel, there are different date format in the date column (as below image, different date format for 12/4/2022 and 14-4-2022). It is difficult to use Excel Power Query to do some analysis…
  • Sage 50 user logging and history

    Hello, We need to see which employee entered a specific transaction. We had multiple users signing in to the same account so when we ran the audit trail report it just showed that account. Does Sage 50 perform any additional logging that would tell…
  • 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…
  • 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…
  • 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
  • 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…