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



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

  • export import cost codes

    Looking for guidance how we can export our standard cost codes from one company and import into another?

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

  • Scheduled Backup using System Administrator

    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?

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

  • Importing and Exporting Purchase Orders in PO Module

    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: 

    Export Error Message

    Can someone please send…

  • Update to 18.2 and Macro's

    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?

  • Is it possible to import quick bill invoices or non-contract invoices?

    I have been able to find the import layout for AR Invoice Import but it looks as if this is using contract based type billing for the imports.  Is there anyway to import an invoice as a quick bill with standard items on it?

  • Possible Data Corruption

    Sage300 CRE Version 17.1 Rev6

    We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the server…

  • Purchasing Module hangs on Configuring Database on Win10 machine

    We have one user of the Purchasing Module POIV that gets the error Not Responding when opening the program.  It hangs on configuring database.

    This doesn't happen with our Win7 users only the Win10 user.  We are using Sage300CRE version 16.1.

    Any ideas…

  • 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


    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…

  • Server hard drive filled SageReplicator .slg files?

    The Sage 300 CRE C: drive filled up and caused the Data folders to look as if the rights had been removed.

    It was caused by .slg files like this: "C:\Users\Public\Documents\GlobalSettings\SageReplicator\4148 - 131882004005307603.slg"

    There wer…

  • Where are formulas being used

    I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are.  So, if a formula is being used, is it used in another formula, report, etc.  I have 100's of formulas & reports…

  • Made Copy of Company - GL - Incompatible Account Format

    Created a New Company for testing purposes - copied all applicable files into new company per online instructions.    Everything in new company seems to look OK, except the GL accounts had a different format (the - and . appear to have been removed).    In this…

  • Payroll import time entry format

    I need to know what order the columns need to be in for import into Payroll.

    I haven't been able to find it in the in program help index, or by searching.

    I found a third party recource that gave me the first 9 (in order):

    Employee, Date, Job, Extra…

  • Is it possible to connect to the Pervasive Database from a Linux machine?

    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…

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

  • ODBC Error when attempting DELETE query

    I am trying to automate archiving of the Log files generated by sage.  We generate an average of 15,000 log entries a day and the LogViewer in sage is so slow it is nearly unusable after a month.  I am querying the data older than seven days and then inserting…

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