• Why are Sage default reports garbage?

    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…
  • Inventory Movement Analysis/Report

    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…
  • ACTIVATION BUSINESS INTELLIGENCE REPORTING

    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?
  • 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?
  • 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…
  • 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. How do I get them back?
  • 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!
  • Sage Intelligence Reporting is being retired for Sage 50 US

    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…
  • 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 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 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…
  • 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…
  • Copy Standard Intelligence Reporting into Report Manager

    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…
  • Sage Intelligence Reporting Webcasts

    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…
  • exporting reports to excel

    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…
  • Process exit code = 259 and proc handle keeps jumping - report stuck executing

    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…
  • How to calculate month-end inventory?

    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…
  • Sage 50 2020 with Intelligence Reporting - won't connect

    Upgraded to Sage 50 2020 and Intelligence Reporting does not work. It starts, it connects, but does not execute any of the reports. Tried others than the custom that was created. Is there a different version of Intelligence Reporting to install?
  • GL Source Codes

    Hello Everyone, How we can get the data from Sage 50 US ( Accountant Edition 2019) ) for GL Source Codes, Hierarchy of Account Segments using COM API or .Net API?
  • Sage 50 Intelligence Reporting Create SUM expression using GROUP BY or PARTITION

    I created a Sage 50 Intelligence report and need to create a SUM expression that uses the GROUP BY or PARTITION to be able to create a SUM based on the data in another column. I also want the sum to be included on every row of the data. Does anyone have…
  • Has anyone created a .CSV file to export local wages to local tax collector (Berkheimer in Pa)?

    I was wondering if a support group member has created a report, in the correct format, to upload via Berkheimer website in PA? I'm frustrated with manually entering the info each quarter and would very much appreciate any assistance. Thank You!
  • Expanding Column Width in reports is not working

    I suppose to be able to have a white arrow to increase column width, but it never shows up when I hoover over the blue marker of each column.
  • ODBC access counts as active Sage50 users

    I'm looking a Sage documentation that says third party applications entered using CrystalReprts.UDL file counts as active users. When I use an addon, Sage50 says the maximum number of users .... Does anyone have information about this?