• Sage Paperless - Update SQL Server

    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…
  • Vendor Duplicate

    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…
  • Data Dictionary for Technisoft Service Manager

    Does anyone know how I can get the Data Dictionary for VM (Service Manager)?
  • Job Central Error when Finishing

    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.
  • Testing out Power BI from Microsoft

    When trying to use Power BI to connect to the Sage 300 CRE (22.2) do I select SQL server, MySQL, BI Connector or something else?
  • 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.

    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…
  • unable to read field checklist3 from JC Job

    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…
  • What table in the DB has all the Job Setup Change Management information

    What table in the DB has all the Job Setup Change Management information - looking for the table that has the markup grid
  • SQL Replicator and SQL Databases

    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
  • Safety Pre-Qualification Information

    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…
  • Merging employees for W2 from two databases?

    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…
  • Where can I find the new W-4 Amounts in the CRE PR Tables?

    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…
  • Looking for an independent consultant (not a Sage reseller) with expertise in implementing the Sage 300 SQL Replicator

    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.
  • SQL Replicator and the table PRM_MASTER__EMPLOYEE_TAX

    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”.

    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?
  • How to make sense of Data structure after SQL replication?

    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…
  • PO archive and upgrade?

    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…
  • SQL Replicator and Backup Files

    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…
  • Sage 300 CRE Pervasive DB information related to some tables

    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…
  • Sage 300 Construction and Real Estate PRM tables Pervasive

    FormerMember
    FormerMember
    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…
  • Database Editor Crashed and Locked Out Our Database

    How to I check back in our database, after Database Editor crashed and locked me out?
  • Table Question for GL

    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…
  • Data files -> tables mapping

    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, …
  • Document management issues with Sage 300 CRE with new users

    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…
  • Pervasive status code 3110

    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…