• 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!
  • 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…
  • Generate a Report for Customer's Open Sales Order Ship Dates

    Regarding our customer sales orders, we have multiple items that ship from different vendors. Is there a way to enter the estimated ship dates for each line item and then create a report to email to our customer? Currently we create an excel spreadsheet…
  • 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…
  • email not working from invoicing only

    Suddenly, I cannot send emails from the sales/invoicing. Other modules are working,
  • 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.
  • 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…
  • 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…
  • FUTA Withholding for Multi State Employee

    We recently had an employee move from one state to another. I did see that Sage50 suggests creating separate Employee IDs for each state the employee works in and I have done that and I think I have the state unemployment set up correctly. Now my concern…
  • 1099 Reports

    We are wanting to run the 1099 report to see if anyone is missing their TIN. When we attempt to run it, we are not given 2023 an an option on the drop down menu. Our fiscal year runs from Oct 1 - Sept 30, so I am not sure if this is part of the issue…
  • 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?
  • Sales Rep Commission Reports

    Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get. I have tried to do it through the Invoice Register, but the report that it spits…
  • 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?
  • 1099-DIV Forms

    I was disappointed to see that all of the customized 1099 forms I had set up in the past were gone. I am happy to see the 1099 NEC & Misc in the tax form screen, but my 1099-Div form is gone. I am now scrambling to figure out how I am going to print these…
  • 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!
  • 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…
  • 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…
  • PDF Preview not work Windows10, File not found It may have been moved, edited, or deleted. ERR_FILE_NOT_FOUND

    I am receiving the following message in the preview pane in outlook and windows explorer for all sage pdf attachments. This is including all the ones we create with email writer in sage and all the ones our vendor / customer send to us that were created…
  • 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…