Sage 50 US

When exporting to Excel, SAGE currently applies an odd and deceptive number formatting. #,##0.00;-#,##0.00;* ?? This formatting makes zero values appear empty when they are not. This leads to some confusion as there is a huge difference between an…

I have a customer who has an invoice created on 7/26/2023. Their credit terms are due on the 10th day of the next month. Today is 8/21/2023, and their invoice is in the 61-90 days overdue category. Why is that? I changed their terms to Due in 30 days…

Good afternoon, I am looking to create a report that I cant run daily that will detail all transactions recorded on the system date (audit log of activity). We recieve and prepare invoices using a variety of dates so I'm thinking the system date is…

Hello - I'm new to Sage 50 Premium Accounting. Looking for a reporting solution or GL account segment configuration to produce a balance sheet or income statement on a combined basis and at the segment/cost center/project level. I'm able to the latter…

It is currently no possible to ADD a report to an Existing Group. To "add" a report, one will overwrite the existing Report Group with a New List of Reports. There is an issue with confusion and naming of the "new" group that is prone to problems…

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…

Currently Sage 50 Quantum - 2023 version does not show Qty to Ship on the Sales Backorder Report. Also the Amt Shipped shows line item wrongly. Please fix this issue asap Thank you Dan

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…

is there a way to change the layout of my income statement so i can have multiple accounts feeding into a general account and where i can change the order in which my accounts are showing up on the statement?

Is there a report that will show a list of invoices and what job they are billed to? I tried the invoice register but the job # is grayed out, why it's even listed if you can use it makes no sense.

Ok, hope somebody out there can help me figure this one out. I'm working on a union report with 5 sub reports, using Sage 50 US. At one point, when running the union report, it errored out with "Pivot table field name is not valid". I eliminated one…

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?

Why can't I run a report for a year that is closed? It's not like I'm making changes, I just need totals.

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…

Hi! I was trying to export a report to Excel and it is frozen. Can not log out and restart a new session. When I log out and back in I go back to the screen that is trying to download the report. I am logged into a remote server. How can I cancel…

Hello, We are a HVAC manufacturers rep with a small warehouse using Sage 50 for Accounting, inventory, & invoicing. All invoicing for products drop shipped from manufacturer and shipped by our warehouse is done through Sage 50. Vendor invoices are linked…

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!

Can I generate a report for an inventory item that shows every time it has been ordered, unit cost and vendor. Similarly can I get a report that shows every time I have sold an inventory item, the price and the customer? All of the reports I have been…

Does Crystal Repots work with Sage 50? If so what versions? From previous responses it looks like you need to use the 32-bit version and not the 64-bit, correct? Is Sage planning on removing support of Crystal Reports?

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…

Hi all .. So I'm not yet a Sage50 user but looking into different aspects of things in order to make an informed decision that I can take to upper management.. We are currently running QB enterprise solutions and have periodically issues with reports…

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…

I began using Intelligence Reporter and when I attempted to run the Balance Sheet - Actual vs Prior report I got the message " Layout Generation Error - Please make sure that you have the latest Alchemex software components installed" and then Intelligence…