Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015).
My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities.
What is the process for updating…
Does Sage prevent creating one vendor with multiple accounts if you enter a duplicate EIN number? I have two companies that have the same name except one is an LLC at the end and one is an INC. They are two different companies, but it brought up the importance…
When I enter contract values in Job Central and then click 'Finish' I get the attached error. I'm unable to save any changes. Please advise. I'm on Windows 11 if that matters.
We are currently running in Sage CRE version 20.4, our cyber security has highlighted that the Pervasive SQL Version was outdated (Pervasive PSQL Version Vulnerability CVE-2017-11757) in the software. Any acknowledgement and remediation plan for this…
I am trying to create a condition that looks at one of our checklist items in JC setup. We have all the items names in JC setup with what they are for, but they are displaying in MYA under the JC Jobs table as checklist 1, checklist 2, etc. instead of…
I had a KB that described the process of deleting the replicated database(s) from the SQL server (compnaydata, izenda, etc) to start from a clean slate, can anyone point me to this KB.
Thanks
V
Hi Everyone!
Our roofing company regularly has to submit safety pre-qualification info when we bid for a project. We have places that we can store this information for company wide access (OneDrive, network drives, etc.), but I was curious to see if…
We have two databases for payroll. We have an employee who will be switching jobs and therefore needs to be moved from one database to the other. Is there a way to merge his records at year-end so that he still only gets one W-2, or will we need to provide…
I am trying to figure out where the new W-4 Amounts are stored in the CRE database tables. The new amounts such as deductions, other income show up as only a single character field in the master 'PR Employee' table. There must be a table that ties to…
I have several clients that use Sage 300 CRE and I need to help them install and set up the Sage 300 SQL Replicator. If you are an independent consultant with experience installing the replicator, please contact me as soon as possible.
We just installed SQL Replicator and previously used Anterra Datacenter. The table PRM_MASTER__EMPLOYEE_TAX has a field called Tax_ID that, when using Anterra, held Tax ID's like FED, MED, MED_E, etc. Now, using SQL Replicator, that has changed to a long…
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?
I just recently setup SQL Replication and that seems to be working well now.
Now my goal is to create some reports from this data. Is there any documentation that explains the data structure?
For example, what does PRT, RTT, PJF mean?
More specifically…
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…
I was hoping someone might be able to shed some light on how SQL Replicator and the SQL server are going about creating the .bak files. We are running into an issue where these are taking up a large amount of space on the server and upon deleting some…
Hello,
I am doing integration with Sage 300 CRE and trying to read data from some tables.
As an example I am using installed "Construction Sample Data" folder and it's subfolders.
For some data/fields I do not know in which tables/columns to look…
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…
Could someone provide me a mapping or quick summary explanation on the fields in the following tables:
[GLM_MASTER__ACCOUNT]
[GLM_MASTER__ACCOUNT_ACTIVITY_HISTORY]
I was also wondering what table stores the information to determine what the…
Hello Everybody,
Sage training materials, data flow sections in particular, refer to data files e.g. Billed.BLI, Activity.ARA etc. Does anybody know if there is a document describing mapping between data files and actual table names?
Thank you,
…
Hello,
Just wondering if anyone else has seen something similar to what we are facing. Currently we have Sage 300 CRE ver 15.1.33 Rev 2 installed on Windows Server 2012 R2 Standard. The server is joined to our local domain. We have Document Management…
HI,
We have been getting random errors, not on every client computer at our company. The error is
This program has quit.
I/O Error. Pervasive status code 3110. The network layer is not connected.
Please refer to the Pervasive documentation…