• How to show Fund (or project) column in General Ledger report

    I'm wondering if there's a way to have a transaction's fund allocation represented in the General Ledger report from Sage 50? My client would like to review all transactions via the General Ledger and see also what fund each is attributed to. Right now…
  • XLGL Account number including department

    Hello all. Sage 50 has an income statement report that shows departments as rows. Does anyone know how to replicate this with XLGL? We do not want each department in a separate column (which is what we get using a departmental income statement.) We…
  • Daily generated report

    IS their a way to generate a Daily report of income coming into the business. That could be sent out by email?
  • Intelligence Reporting for Sage 50 Canadian version

    I was told recently by customer service that when I starting using the Department option and could not get any of the reports I needed I could use this reporting. I was told that I could use the designer report option to produce project reports by department…
  • Additional Reports for Sage 50 Canadian Intelligence Reporting

    Does anyone know what happened to the Additional Reports for Sage 50 Canadian Intelligence Reporting? It seems only US and Pastel reports are available.
  • Data extraction

    Is there a tool out there to extract sage 50 data. We need a file of every transaction for the last 3 years that contains customer, invoice #, items, totals, tax and Very importantly the Message field. Any ideas? Thanks Doug
  • Does anyone have new Intelligence Reports available for sales analysis?

    Hello, Is it possible for Sage 50CA IR to integrate some of the Sage 50 US IR into the Canadian system. Should be an easy process. Can we put this on a wish list for the next update? We have done some research, and Sage 50 US Intelligence Reporting…
  • Does Sage 50 Desktop Accountants version integrate with Office 365 and Intelligence reporting features?

    I bought the connector from Sage and am using the right version of Office 365 but nothing but "subscription not available errors"??? Any thoughts where to go next? Martin
  • Intelligence Reporting license manager does not recognize sysadmin user's new hardware

    The sysadmin user for Intelligence Reporting is changing hardware (new laptop). The license manager application for Intelligence Reporting only recognizes sysadmin's old hardware and the sysadmin user is not able to run reports. How do we transition the…
  • Custom Aged Vendor by Project Report

    Hello, I have created a custom report to show aged vendor payables by project. Everything is working well, except that it is pulling all of the vendor invoices, not just the unpaid ones. I am not completely familiar with the database table and field…
  • Month by Month Income statements

    FormerMember
    FormerMember
    So, I'm trying to analyse income month by month, seems like the only way to do this is to run a report for one month, then export to excel, then cut and paste next month beside it. Only problem being... Where a category was created it does not show in…
  • Extracting Departmental Reports

    FormerMember
    FormerMember
    Hi there Sage City! Subsequent to rolling forward our company's accounting period I can no longer extract departmental reports in Sage 50. Anyone here who has the same experience? There are no problem with the other reports (ei. balance sheet), at least…