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…

Buenas tardes estimados, estoy buscando un reporte o como crearlo en sage 50, este reporte se llama Kardex y registra las entradas, salidas y saldos de cada producto y sus costos unitarios de entradas, salidas y totales. Pueden auxiliarme por favor. Gracias…

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…

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.

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?

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…

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…

Excel is giving the error "An unexpected error occurred: External component has thrown an exception" when opening a Sage 50 US Sage Intelligence Financial Designer report. What is causing this and how to fix it?