I would like to add the data [customer_order_number] into the statement payout (in place of details) but I cannot find the field in the options ; any help appreciated!

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…

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 this…

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…

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.…

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…

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?

Hi,

Can anyone help to identify where the quotes and orders data is via the odbc please.

thanks

Is there are report in Sage 50 intelligence reporting that I can modify.  I need to create a report Sales by State.  I need for taxes. 

I need to add Quantity and Item ID columns to the monthly quote report.  

How do I do that?

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 of…

Hi there.  I have a report which runs well.  I can run it from within Report Manager, and I can extract the scheduler command to a batch file and run it.  However, when I run it through the task scheduler it does not run.  The error in the "BICoreUnattended…