• 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…
  • Employee Earnings Report

    How can I get a report on an employee earnings not including bonus and overtime?
  • 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…
  • 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…
  • 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
  • Reporting Question - Invoices & COGS

    I am looking to see if this is possible on the built in reporting, or if it possibly is something that Intelligence Reporting offers ( which we do not have )- Run a report of invoices, with a column with the COGS for each invoice line. The invoice register…
  • 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…
  • Setting up a financing loan and posting payments for the loan

    the Peach Tree software we are using is pretty dated I believe 2011. We receive statements monthly from the bank for a large equipment financed loan. The accounts used in setting up the loan were Note payable to the bank; Interest Expense, and the other…
  • 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…
  • 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…
  • Job Profitability Report - What Table is the PO Number pulling from?

    Hi. I am running the job profitability report.... I have added the column "PO Number" to the report but no data is being generated in that column (and there should be). Can someone please tell me what table that column (PO Number) is being pulled…
  • Report that shows items ordered and the ship address and ship via method.

    FormerMember
    FormerMember
    Hi all, I am trying to create a report for our shipping department. They need to see the sales order number, the items ordered and quantity, and the address and the ship via. I can summarize everthing but the ship via on a custom Sales Order Report…
  • Search by Item Description

    I have tried searching within the inventory item list, but I am not getting the results I am looking for. Is there something I am missing? All the answers to this question previously seem to be out of date for my version and I am pretty new to sage.
  • Which report can show me the daily income and expenses

    I want to be able to view my daily income and expenses after the day's sales.
  • Aging Report

    Good Afternoon, Looking for some help on the aging reports. I have a customer set up Net 30 days and after reviewing their aging report example Inv. Date 4/7/2015 is still in my 0-30 days and I have others, after I check the invoice itself the due date…
  • Rollups Across Segments

    Our segments are NNN-DD-PPP-CC where N are the natural accounts, D are the departments, P are the Products Categories, and C are the Product sub classes. Our chart of accounts for revenue looks something like this: 400 400-D1 400-D1-PCat1 400-D1-PCat1…