• Editing the report layout in Sage 50

    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!

  • invoice ledger showing jobs billed to

    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.

  • Union Report-Pivot Table Field Name is Not Valid

    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…

  • 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?

  • Running Payroll Reports for Prior Years

    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.

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

  • Copying Find Transactions Report to Excel Frozen

    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…

  • Sales vs material cost reporting

    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…

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

  • 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! 

  • Inventory item history

    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 Reports work with current versions of Sage 50?

    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?

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

  • How flexible and easy to use is Crystal Reports for Sage50US?

    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…

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

  • Is Alchemex software for Intelligence Reporter Required?

    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…

  • Is it possible to continue using an older version after switching to a different product for current use?

    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…

  • Question about Intelligence Reporting being retired

    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…

  • an unexpected error occurred: External component has thrown an exception

    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?

  • Quotes/Orders Tables

    Hi,

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

    thanks

  • Sales by State

    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. 

  • Quote Reports

    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?

    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…

  • Scheduled report not running

    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…