• 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?
  • Report on Item Activity

    I want a report for a single Non-Stock item to analyze the item's purchase and sales.
  • Custom Reports Freezing After 2023 Update

    Custom reports freeze when trying to run them after upgrading to sage 2023. They will open but refuse to run unless you interact with them (ex. clicking on the options or refresh icons). Even after interacting with them they take a while to load or crash…
  • error with PO form. inconveniences when printing purchase order form.

    When designing Purchase Order Form it on a workstation it prints correctly but when trying to do it on the corresponding computer the words are cut off, it has been tried centering, changing the fonts, adjusting and nothing, in the link show the error…
  • Setting up inventory items and assemblies

    As an example, I sell Receiving Sets which include a Burp Cloth and a Receiving Blanket. I set up the items Burp Cloth and Receiving Blanket as stock items with the inventory account 12000 (supplies). I set up an assembly Receiving Set and put in the…
  • 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…
  • 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?
  • Purchase dates for specific GL codes

    I need to know how much fabric I bought each month. When I purchase fabric, I enter the payment directly. I don't use the receive inventory feature. The GL code I'm looking for is 132 (inventory). I use hybrid accounting, accrual for inventory and cash…
  • 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?
  • Sage Intelligence Reporting for Sage 50 US will retire

    On our Sage 50 2022 we are receiving a notification about Sage 50 Intelligence Reporting is being retired. Will this affect the reports that are designed in this tool after the stipulated date?
  • 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…
  • 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…
  • A/R trial balance

    Is it possible in Sage 50 US (2021 version) to run just an A/R or A/P trial balance?
  • Custom Subset of Labels

    Hi - I'm trying to print a CUSTOM SUBSET of customers for labels through the Reports & Forms menu. Is there a way I can upload a file with customer numbers that would make the label printing ONLY occur for those customers? For example, I sent out…
  • GRN layout with GRN number

    Hi How to design GRN layout with GRN number in Sage 50 US Premium? Thanks Channa
  • Reporting

    I just switched employers and went from Sage Business Works to Sage 50 - is there a report in Sage 50 similar to Business Works Trial balance summary? What this report generates (only current period) is a list of all (or select) accounts with a prior…
  • Job Profitability not Pulling Status if Grouped by Job ID

    We have been using a profitability report that pulled in job ID, status, actual and expected revenues & expenses. All grouped by job. This month the status stopped pulling into the report, no clue why. Would anyone be able to explain what could be…
  • Sales History Report

    Hello, New to this group. I am trying to create a report that will list my customers sales history by month. I would like to have the following options. Sort by sales Rep- customers (alpha) date to start for sales info - sales by customer by month…
  • How can I get the prior year income to roll into retained earnings?

    I am new to Sage 50 and am trying to figure out why the Retained Earnings doesn't automatically roll the prior period net income into the next year's balance sheet. Right now when I print a balance sheet, it shows up on the balance sheet as (income)/loss…
  • Problem with inventory beginning balance

    Hi, I capture inventory beginning balance and in dont show in GL Summary Report, some one knows why this happend
  • 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