Sage Construction & Real Estate

We are building an ODBC inquiry that shows the profits for each job. Is there a field that shows the pre-tax billed amount? We found a field that has the total billed amount including taxes.

id there a way to edit the path for all reports on the Application reports menus to a new sever and folder. I want to cleanup all none Sage reports and move to a custom folder. I want to clean up the report paths in each report menu.

Hi, I'm connecting to Sage via an ODBC driver. I have everything working except the use of 'TOP'; I get the following error SQL error: [Simba][SimbaEngine ODBC Driver]SELECT TOP 1<< ??? >> * FROM <Table>, SQL state 37000 in SQLPrepare Is there a way…

We are looking for a way to automate archiving our clients Log Viewer files. The issue we are having has to do with getting access to delete data from the QLM master log file from an ODBC connection. Reading the data has not given us any issues, but when…

I'm trying to edit a crystal report that references "Timberline Data Source" (TDS). By edit, I mean add fields from tables that are not part of the original report. I cannot seem to access any tables other than those that are part of the original, out…

Login credentials work initially when doing query, and can see query results in Microsoft query window, but cannot move results to excel worksheet. Get "invalid user ID or password specified", and when click "OK" get "[Microsoft] [ODBC driver manager…

I lost the link between Crystal Reports and Timberline database for creating new and editing existing reports. We have recently upgraded Crystal Reports, updated to Sage 300 CRE 14.1, and I have a new computer. Sage support said the error relates to …

I need a 64bit Timberline driver.

I need to create a linked server from ms sql server to access my timberline data. I managed to create one using the Pervasive ODBC Client interface driver. What I really need it to create it using the Timberline Driver. Has anyone ever done this?…

Hello, I am looking for a solution to a puzzling situation I have come across. I am entering data into the takeoff for my materials, and am getting exact numbers for my labor man hours based on the coinciding labor amounts. However, I wish to round…

How are folks linking the dependent details in Sage HRMS to Sage Construction & Real Estate 300 for ACA compliance? (Besides manually entering) I've tried Microsoft Access but no avail. When I tried to link the table I created in Excel to the ACA Dependent…

Is it possible to write data using excel and ODBC to Sage 300 without purchasing 3rd party software? Is there a tutorial on how to set this up. I would like to input vendor insurance cert information using a grid instead of opening each vendor and commitment…

I'm preparing to import a budget. I have a budget number for nearly every GL account for multiple company divisions. However, the "store budgets" box is not currently marked on these accounts. Is there a quicker way to mark "store budget" on a mass…

I've run into a problem with one of my new computers when trying to run ODBC in excel on a file that I've used for years. The machine is running Windows 7 and Microsoft Office 2013. The excel file still runs fine on one of my other machines that is running…