• Sales Order reports

    Currently when we receive a Purchase order we run the stock status report and add the column "Quantity on Sales Orders" to see if anything that came in is on a Sales Order for a customer. It doesn't tell you what the Sales Order number is so you have…
  • Tracking stock parts found both in bins & built assemblies

    In Sage 50 Quantum is there a simple way to view stock levels of parts some of which are in built assemblies and some still found in parts bins? For example we have an instrument that us comprised of over 600 unique parts. Within the instrument are 50…
  • 1099 in Sage 50 2023 Help!

    We just installed the update and my 1099 forms are gone. When I click on Tax Forms it takes me to a new program that is completely different - is there any help in printing 1099's like we did previously? It almost seems like it is setting it up to file…
  • 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?
  • 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…
  • Accounts Payable Report - Expense Account

    I need to approve payments for the AP check run. My accountant gives me a report of vendor, invoice, amount, and GL account. However, the GL account is Accounts Payable account. I need a report that shows what Expense or Inventory account the invoice…
  • Filing 1099 misc in Sage 50

    My name is Kent McDonald and I'm a sole proprietor located in Albuquerque, NM. I'm using Sage 50 and I use two different independent contractors to do my typing. To set up my 2020 1099 Misc reports, I go to employees then forms. I then choose Federal…
  • Sage 50 1099-NEC prints one record per page instead of 2

    Hi All, I followed the instructions to have the templates for the 2020 1099-NEC, 1099-MISC & 1096 forms added to my Sage account (I do NOT have a payroll subscription, so those are the instructions I followed). When I open Sage, the forms are now…
  • Check Printing Glitch

    I am new to Sage50 and am trying to pay bills with a check. When I get everything ready and click print, it says "Printing page1" and then just keps going. I've let it get as high as "Printing page 1000" and it just keeps climbing, but never prints anything…
  • Proposals and Incremental Invoices

    Once again I have a very unhappy client because of the misleading representation of quantities on an incrementally billed invoice originating from a proposal. The invoice form I print shows columns for the item quantity, the line item proposal amount…
  • 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…
  • Expense Tickets

    I use Quantum version. I have entered an Expense Ticket and have it assigned to a job. It is not showing on the job ledger report. How do I get the expense tickets to show there?
  • 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…
  • 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…
  • Customer Sales Reports; Customer Sales History, Customer Transaction History, Sales Journal, Income Statement-Matching

    Hello, I am researching Sales Tax Payments. When reporting and paying sales tax you must report all monies received for that period. All of our sales are in the same state. When pulling the Customer Sales History report it ties to the Income Statement…
  • Cost of Good Sold Journal Totals not matching other Reporting?

    Can anyone lend guidance on why the COGS in Sage 50 Income Statement does not match the COGS calculated on the Inventory Profitability Report and both of those vary widely from the COGS total found on the Cost of Goods Sold Journal Report? While I…
  • Cash basis reports

    Why are not all reports in a cash basis company created on a cash basis? The job register and the Customer Sales History reports are just two that I have found that report results based on the accrual basis rather than cash basis. Therefore none of the…
  • Cannot create report on Server

    Getting the above issue when trying to access reports on the server side, we can however access the report functionality on the client systems, any ideas??
  • 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…
  • Is there anyway to run a GL report that shows the transaction description for activity hitting a balance sheet account without having to click into the transaction?

    So this issue completely baffles me. I am trying to review some balance sheet account activity but I am getting frustrated because I can't figure out how to run a report that displays transaction description like it does for an Income Statement Account…