Sage 50 US

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…

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.

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!

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…

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…

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…

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…

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…

I am in the process of activation my Business Intelligence Reporting in Sage 20 2022, but it is asking for Activation code, how do I get this code?

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…

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?

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…

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?

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!

We will be removing the Sage Intelligence Reporting solution from our Sage 50 U.S. Edition product portfolio. We have made this decision to streamline our product offerings and development resources to better serve our customers. Sage Intelligence Reporting…

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…

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…

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…

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…

Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…

Hi, I have Sage 50 US Quantum 2020 edition. How can I make a copy of a standard Intelligence Reporting, Jobs Profitability Report, into the Report Manager so I can modify it. I need to modify it a little and regularly email to someone in the company…

Hello to our Sage 50 U.S. members! :) We understand the impact the Coronavirus (COVID-19) is having and how it has and still is affecting your business. We want you to know: we're here to help and as the new year approaches, we would like to take the…

I used to be able to export balance sheets and income statement to excel where the headers would be included in the body of the report. Recently, when I export the same reports, I cannot get the headers to be included in the body of the report. Why…

Hi: I am new to Intelligence Reporting. I am trying to run any report (like the Dashboard Analysis) on my Peachtree company. It is at the Executing phase. The process window shows one row. The "proc handle" field on that row keeps changing. The "exit…

Hi everyone, I'm new to sage 50 US. I know that sage 50 can only show the month-end inventory balance for the last 12 months. What if I need to go back further? Is there a way I can do it on the back-end using the database and pervasive sql to do…