• Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    If this is not possible what would the best way to accomplish this?

    I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not.

    Thanks

    V

  • Creating upload files for Arcoro...

    We are in the process of moving to Arcoro HR and I have been building imports for this.

    Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    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…

  • Importing Data

    Is there anyway to import anything into Sage 100 Contractor?  Certainly there is some mechanism for migrating data from QuickBooks or Excel to Sage 100... right? 

  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file.   I don't want to archive, I just want to delete.  I have tried ODBC connect…

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

  • Table and Field Naming mode - JDBC2Pervasive query

    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 format…

  • Ts.ctl file in use during backup vs 17.1.8

    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…

  • Sage 300 Construction and Real Estate PRM tables Pervasive

    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 Schema for Sage 300 CRE?

    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…

  • Renumber Sales Tax Districts and Sales Tax Entites

    We have been using Sage for about 5 years.  I have been using it for about 2 months.  My question is regarding the numbering of sales tax districts and sales tax entities.  If I have a sales tax district - let's call it 100 for example and it ties to a tax…

  • Permissions on attachment folders changed with upgrade to version 20.2.35

    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…

  • Invoice Details Disappeared but Grid Total Remained in 11-2 Service Receivables module

    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 is…