x Want to participate? Join the group to interact

  • Sage shuts down creating group reports

    I was doing a report group and sending to an existing Excel file like I have for years. Same report group. I did it 2 days ago for march and april. next day I go to do the same report for may it starts the process, then shuts down. I restarted, I tried…

  • Export Quantity Discounts in bulk

    Hello! We are in the process of building a website solely for our wholesale customers. We need to be able to put in the Quantity Discounts per item/ group of items. How can you export a list of Quantity Discounts including the Minimum Qty for Discount…

  • Sage 50 2023 Cannot export to Excel

    I've just upgraded Sage 50 to the 2023 version. Now when I try to Export to Excel, I get the message "An unexpected error occurred while copying your report to Microsoft Excel". I have previously used this feature daily. I have restarted my computer several…

  • Inconsistent date format when export data to excel

    My excel version is Office 2016. When I export data from Sage 50 to excel, there are different date format in the date column (as below image, different date format for 12/4/2022 and 14-4-2022). It is difficult to use Excel Power Query to do some analysis…

  • Excel Import of Sales Orders Error??

    I keep getting the same error and am losing my mind. I exported Sales Order Journal FIRST to see which columns needed to be filled in. I used that form to copy/paste info into a new excel to import into sales order. I keep getting two errors - says line…

  • export Purchase Order from Sage 50 Quantum

    Is there a way to export a Purchase Order from Sage 50 Quantum into an Excel doc?

  • Exporting to Excel

    Is it possible to export Work Ticket information into Excel from Sage 50 Quantum Accounting 2020?

  • Can't print to Excel

    My computer recently crashed. Sage 50 was installed on the new computer, along with MS Office 2016. I cannot get any reports to come up in Excel, using the Intelligence Reporting path. It says I need Excel 2003 or higher. Help.

  • GL Acct ID Only Populates on First Line in Report

    In a number of reports that include GL Acct ID, only the first line of a record will include the GL Acct. Below is an example from the Job Ledger Report. All four lines are in GL Acct 4000, but the report only lists the acct ID for the first. This creates…

  • RE: E-mail multiple Sales Order Acknowledgements

    Steve is correct, no easy way inside Sage 50. We do have an add-on product named DSStudio that will send anything you like in whatever format you like. You could group all those sales orders into one attached PDF or create a one page layout that contains…

  • RE: Error

    Typically this is due to an incompatible version of Excel or User Account Control (UAC) blocking the communication between Sage 50 and Excel. Compatible versions of Microsoft Office are 2007, 2010, and 2013. The full version (not click-to-run or Microsoft…

  • Importing inventory prices from Excel

    What is the procedure to accurately import to Sage 50 new pricing on inventory items through an Excel spreadsheet? Specifically I am having difficulty in locating the file to import from, does it need to be saved as a certain type of file?

*Community Hub is the new name for Sage City