• Recurring entries showing as negative balance in aged payables report

    I'm new to accounts payable and Sage 50, so forgive me if this is a silly question. I have certain payments set up as recurring entries. On the aged payables report, it show the balance as negative. What causes this? Am I setting up the recurring entries…
  • Tax Liability Report and Payroll Tax Report State SUI is not calculating correctly

    The Tax Liability Report and Payroll Tax Report's State (GASUI) does not calculate correctly. The line item Liability Calculated on GASUI has the Tax Liability calculating correctly.
  • Quarterly Income Statement and Balance Sheet

    Is there an easy way for a novice to produce both an Income Statement and Balance Sheet broken down by Quarter? I've tried to use the Design Feature and I just don't understand it!
  • 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…
  • GL not automatically applying payments

    I was trying to reconcile the Aged Payables to our General Ledger account and I noticed we were off by quite a bit. Then I noticed that there were transactions that didn't show up in the aged payables indicating that they had been paid but they only showed…
  • Employee Earnings Report

    How can I get a report on an employee earnings not including bonus and overtime?
  • 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…
  • 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,…
  • Why are Sage default reports garbage?

    Almost every default report or form in Sage is garbage. There's fields with letters cut off or numbers cut off or bad calculations. I'm try doing do a simple customer statement and it can't even figure out how to get the aged invoice in the right bucket…
  • Report on Item Activity

    I want a report for a single Non-Stock item to analyze the item's purchase and sales.
  • Inventory Movement Analysis/Report

    I am looking for reporting that shows both purchases and sales with quantities and $ CR/DB. Found reports do not show data on items with Current O/H of zero or do not show the desired detail. Working with LIFO inventory and would also like to be able…
  • Slow Moving Products

    Is there a report on Sage 50 Accounting that can show slow moving items? I can trying to find a report or list that shows the last transaction date on items in our inventory but cant seem to find that. Any help or suggestions?
  • Why have the sub headings "This year" and "Last year" disapeared from the 2 year income statement in Sage 50?

    My two year income statements say "Current Month" twice and "Year to Date" twice but the sub heading "This Year" and "Last Year" are gone. They are there when I go to Design but they don't show on screen or print. How do I get them back?
  • Report to show GL account 50500 that have not been job costed

    New to this forum! I am looking to run a report that shows any material or subcontractor costs that have hot been job costed in Peachtree. Not sure where to ask this question!
  • 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?
  • How to print a report that give you the total spend by vendor

    I am trying to print a report that shows what we have paid (total spend) to each vendor by year. I know this information pulls if it is a 1099 vendor but how to I get these details for my vendors that I purchase all of my inventory from that do not require…
  • 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?
  • Is it possible to continue using an older version after switching to a different product for current use?

    On of my IT clients has moved their active accounting to a different provider, as the result of a consolidation. They want to know if they have to keep upgrading, and paying the annual fees, in order to use their current version (Sage50 2019) for historical…
  • Question about Intelligence Reporting being retired

    We have a person that just started learning Sage 50 US Intelligence Reporting recently. We purchased the connector a month ago but have not installed it because we aren't on the newest software version. We got the email notice that it is being retired…