x Want to participate? Join the group to interact

  • 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?

  • 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…

  • Sage shuts down creating group reports

    I was doing a report group and sending to an existing Excel file like I have for years. Same report group. I did it 2 days ago for march and april. next day I go to do the same report for may it starts the process, then shuts down. I restarted, I tried…

  • 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…

  • 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…

  • 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

  • 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…

  • Can't print to Excel

    My computer recently crashed. Sage 50 was installed on the new computer, along with MS Office 2016. I cannot get any reports to come up in Excel, using the Intelligence Reporting path. It says I need Excel 2003 or higher. Help.

  • 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…

  • GL Acct ID Only Populates on First Line in Report

    In a number of reports that include GL Acct ID, only the first line of a record will include the GL Acct. Below is an example from the Job Ledger Report. All four lines are in GL Acct 4000, but the report only lists the acct ID for the first. This creates…

  • RE: E-mail multiple Sales Order Acknowledgements

    Steve is correct, no easy way inside Sage 50. We do have an add-on product named DSStudio that will send anything you like in whatever format you like. You could group all those sales orders into one attached PDF or create a one page layout that contains…

  • 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…

*Community Hub is the new name for Sage City