File Repair

How do I add or remove columns on a report?

Resolution:

From the Select a Report window or from the displayed report, click Columns.
Select the Show box is checked, this is the setting that will allow the column will be included on the report.
When the Title box is checked, the field name will display on the report as a heading.
When the Column Break box […]

By |October 15th, 2017|File Repair|0 Comments

Error: “At least one damaged transaction has been found in account [number] in the period beginning [date]….”

Resolution:

Section I: Run Data Verification

Change the accounting period to period 1, see Related Resources article ID 11440 How do I change the accounting period?, in Related Resources.
Select File, then Data Verification.
Select Both Tests, then Start.
Save the backup. When the backup completes, the data tests will begin automatically.
If you get the same […]

By |October 15th, 2017|File Repair|0 Comments

Can I add the customers phone and email address to they layout of the sales order

Resolution:

Unfortunately at this time phone number and email address are not options to add to the layout of the Sales Order. You can, however, add these fields to the printed form

By |October 15th, 2017|File Repair|0 Comments

My company is not in the Company List in Sage 100 Contractor v20

Resolution:

Company admin or not a user in the database

Close Sage 100 Contractor 2016
Open Database Administration
Select Company Admins / SQL Logins
Select Add Company Administrator
In the Select the company to manage dropdown, select the company that is missing from the company list
In the Select a company administrator dropdown, select a user to be admin
Click […]

By |October 15th, 2017|File Repair|0 Comments

How do I connect to the SQL Server using encrypted communication?

Resolution:

On the server, navigate to X:Sage100ConCommon (where X is the Sage = 100 Contractor data location).
Open the SAGE100CON_ConnectionSettings.xml file (where SAGE100CON is the SQL instance name).
Note: This file controls some of the settings in the .NET framework class System.Data.SqlClient.SqlConnectionStringBuilder. For detailed information about these settings, see:
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder%28v=vs.110%29.aspx
Edit the settings as needed.
Save the […]

By |October 15th, 2017|File Repair|0 Comments

Why does a vertical, blue line appear on Grid/Gantt view in my 10-3 Schedule

Resolution:

The vertical, blue line represents the report date. The report date is the current date that appears on the Date and Time properties in Windows Control Panel

By |October 15th, 2017|File Repair|0 Comments

Error: “Sage 50 cannot be started…”

Resolution:

The error message can occur for a number of reasons. To find the solution that best fits, please answer the following questions. If the answer is no, go to the next question. If you answer yes, follow the article suggested. If the article does not resolve the issue, return to this article and pick up […]

By |October 15th, 2017|File Repair|0 Comments

How to Connect Sage Construction Anywhere to v20 Sage 100 Contractor

Resolution:

If you have been using Sage Construction Anywhere with Sage 100 Contractor version 19.5, and want to use it with version 20.1, you will need to switch the connection from version 19.6 to version 20.1.
Note: These instructions assume that you do not intend to maintain a connection to both version 19.6 and version 20.1.
A Sage […]

By |October 15th, 2017|File Repair|0 Comments

Does DacEasy need to be installed on the computer to convert the data to Sage 50?

Resolution:

Sage DacEasy must be installed on the same computer as Sage 50 in order to convert DacEasy company data to a Sage 50 release.

By |October 15th, 2017|File Repair|0 Comments

How do I add the vendor name to Equipment Checks in 8-5 Equipment Payments?

Resolution:

Create a Calculated Field

To add the vendor’s name to the Pay to the Order of line of a 8-5 Equipment Check, create a Calculated Field.

Type eqpmnt^vndnme as the name of the Calculated Field.
In the Description box, type Vendor name on Equipment Check.
In the Expression box, type [SELECT actpay.vndnme FROM actpay WHERE eqpmnt.lender […]

By |October 15th, 2017|File Repair|0 Comments