Sage Construction & Real Estate

Dear team , When trying to generate a payment voucher using crystal report ,following error obtained.

Hello, Recently we have moved from a publicly listed company to a limited liability one and looking to change the name on sage reports .

I am trying to determine the best possible backup solutions for Sage 300 CRE. Is it possible to restore single Sage files from a Microsoft Shadow Copy? If so, what is the correct way to do that without disrupting the database? Is it possible to…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

I have linked a commitment change order from ProCore - and I have to edit it - but it was already approved in Sage - Is there a way to delete this in Sage so I can unlink from ProCore?

Does anyone know anything about this field in AP- Transactions “Reference Date” Field ID “TREFDT”. How (By what process) and when is this field populated?

Many of us are not using SQL replicator as the hardware requirements are up there, server and client, and we have enough data that I believe we would need full SQL vs express. Especially if your accounting dept wants the data to be live.(which ours does…

Looking for a way to either extend description field OR enter text only line in between items. Has anyone done this in the past? Thanks in advance!

GL overvalued vs physical inventory at year end. I believe it's being caused by a lot of Receipt Adjustments that don't have a location showing in them. Is anyone else having/had this problem? What causes Receipt Adjustments and why do they overvalue…

I'm not able to create full image backup of my sage machine, so I'm planning on recreating it in another server. The issue being, when I open up System Administrator and I click my company folder, it says, "You have not selected all of your company folders…

Manually performing a company backup works fine but the scheduled backup does not backup the CompanyData folder. Is this a permissions issue as the scheduled backup is running the scheduled task as SYSTEM?

Hello! Is there any way to inactivate terminated employees or get them to stop pulling into reports- same question applies to closing jobs? Currently we are archiving terminated employees (and jobs) to a separate data folder as they will pull into reports…

I'm trying to pull records from the PJ Field Reports Labor Table in Crystal but I'm unable to figure out how the employee is being linked. Does anyone know what table is being used to link the employee to the PJ Field Reports Labor table?

Hey everyone, First time poster here because we are in desperate need for assistance. Here's the rundown... - We had been using Sage 17.1 for 2 years until Nov. 2019. With it, we have the SQL Replicator running all the time, and though "Scheduled…

So I am trying to switch over to using System Administrator to do the backups (we just started using SQL Replicator) and the first back up failed because someone left Sage open at their desktop and I got an error about Master.qlm being open. This will…

Good morning, can anyone refer me to a third party who can start a new instance for me in Sage? I'm in Englewood, Colorado. I'd like to move all the balances to the new instance without the back up and if I do need to look something up, I can do so in…

We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…

We are accessing Sage 300 CRE data in a web page using the ODBC 32 bit driver we set up as a system dnn (TMBWeb). The dsn points to the correct data folder and is configured for standard descriptions and maximum table segment size. We have a connection…

I am in need of a purchase order import template. I have tried using the help section to create one with no luck. Our consultant doesn't have one and I cannot work backwards by exporting because I get the following error: Can someone please send me…

I am querying the Timberline replicated database located on the Kettler “ktlrhq-db1.corp.ketsco.com” SQL Server instance. I need to perform several queries into this database. This query returns total amounts for each cost code, section and job: …

Does anyone have any experience importing labor costs from Paychex Flex to Sage 300CRE? Wondering if there is an import template available?

Just out of curiosity does anyone have older macros from 16 and before that has been brought over to 17 and was able to successfully use them with 18.2?

Hi, I'm having issues with trying to import a time entries file into Payroll. I've been reading that the file has to be a .txt and that I need to make sure there are no headers and each column needs to be made exactly how our layout is. Is there an…

I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…

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…