• Importing budget estimates into Job Cost

    Hey Sage experts, Can anyone provide an excel template or guidance in importing budget estimates into Sage from our excel job master. I’ve been able to create a working template for accounts payable which is great for credit cards and payroll. my…
  • How do I download a report to Excel?

    I am running an accounts receivable aging report by customer and need to download the report to Excel. However, when I try to do so, I get an activation error message "Printer not activated, error code -30". I don't know why I'm getting this message since…
  • Import format for EQ

    I have been trying to find out what format I need to put my excel spreadsheet in. I need to import depreciation on our vehicles into the EQ module on a monthly basis. I can't seem to find the answer and I don't seem to have the add on that the videos…
  • Exporting reports to excel - extra lines added and footer showing up in the middle?

    When I export a report to excel, if the details of the report are not very long then the footer of the Report Form shows up in the middle of the data and overwrites the line. If there is a lot of data, then I get three blank lines in the middle of the…
  • Excel query to MSSQL database to Pervasive SQL not working

    We are running Sage 300 Real Estate and construction v14.1. Our Timberline users run an excel add-in query to extract data from the Timberline database to use for analysis. The query first connects to a SQL server which has an ODBC connection to the Pervasive…
  • Spaces added to cell data when exporting reports to excel

    For our insurance, I have to export a report to excel. Some columns in the report have extra spaces added to the data in the cell. Does anyone have experience getting Report Designer to export the data without adding spaces?
  • Save time on reporting and analysis using Excel and Sage 300 Construction and Real Estate

    Sage 300 Construction and Real Estate (formerly Sage Timberline Office) Office Connector automatically connects your Sage 300 Construction and Real Estate data to Excel. You can save hours on reporting and analysis tasks using Excel. Best of all, Office…