File Repair

Is there a financial statement for three years?

Resolution:

Currently there is not a financial statement that pulls for three years. The software does allow you to view reports from closed available years in the range under the Options button. The financial statements information can be exported in to Excel as an option to customize in Excel.

By |November 19th, 2017|File Repair|0 Comments

Error: “Failed to retrieve data from database.” data from database.” data from database

Resolution:

Note: Sage no longer supports connecting Crystal Reports with Sage 50—US Edition nor troubleshoots customized reports.  Crystal Reports will still work with Sage 50—US Edition.

Section I: Set Database Location

Setup the ODBC Connection. Follow Article ID 12693 (How do I connect to the program using ODBC/OLEDB?)J
Inside Crystal Reports: select Database, click Set Database Location
[…]

By |November 19th, 2017|File Repair|0 Comments

When will the 2015 941 be available?

Resolution:

The 941 is typically available the third or fourth week in March every year.

By |November 19th, 2017|File Repair|0 Comments

If I make a change to a default general ledger (GL) account will the change be retroactive?

Resolution:

Changes made to default GL accounts will apply to any future transactions. The change will not retroactivly change transactions already entered into the system

By |November 19th, 2017|File Repair|0 Comments

How to install a new instance of SQ

Resolution:

You will need the SQL Server disk
Browse to Server Installation Center
Click on Installation
Browse to where the disk is.
Go through wizard

If you already have SQL installed and would like to create a new instance.

After installing Version 20.
Open the Data Administration
Select on of the current instances.
This will give […]

By |November 19th, 2017|File Repair|0 Comments

How can I tell which Sage 100 Contractor databases are available on the server?

Resolution:

The Database Connections Status window shows you which databases you can use with SQL Server.  Moreover, it explains why you cannot use certain databases, and suggests possible remedies.

To use the Database connections Status window:

Start Sage 100 Contractor (SQL)
In the Connect to SQL Server dialog, hold down the Shift key and click the [Connect] […]

By |November 19th, 2017|File Repair|0 Comments

My e-file state tax form was rejected by Aatrix because the dates are incorrect

Resolution:

Start the form over and enter the correct information.
E-file the form through Aatrix.
If you also make payments through Aatrix, contact Aatrix at 701-746-6814 to verify the status of your payments or further instructions.

By |November 19th, 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 |November 19th, 2017|File Repair|0 Comments

How to use the Sage Download Manager with the Internet Explorer Version 11

Resolution:

Open Internet Explorer v11 or later.

In the Menu Bar or Command bar go to TOOL
Select Compatibility View Setting.
Add this website to compatibility View type: sage.com
Click ADD and then click Close.
Try to download the Sage 50—U.S. Edition product or FAS.

By |November 19th, 2017|File Repair|0 Comments

Error: UPDATE statement conflicted with the CHECK constraint “ck:lgract. nxtchk”. The confliction occurred in the database table “dbo.lgract, column nxtchk. The statement has been terminated when paying credit card

Resolution:

The check number field only has a 12-character limit. Remove some to have that amount, and it will save.

By |November 19th, 2017|File Repair|0 Comments