Sage Construction & Real Estate

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

Making queries from excel / crystal reports is easy on a windows computer using the ODBC connections, but is this something that has been done from Linux computers on the network? For instance, if we have an application running on a random computer controlling…

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…

Yesterday, I decided to update to the latest version of Sage 100 Contractor (version 20.2.35.0) When I went to Upgrade the database I was denied permissions to access folders (yes, I was logged on as my system admin). After two unhelpful hours on the…

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…

I have an order in 11-2 Service Receivables that originally had parts, quantities and price in the Invoice Details grid - that calculated up to a total that was emailed as a Quote to a Client. Today, the grid on the Invoice Details tab for that order…

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…