File Repair

How do I view a employee’s pay but not have it post to the system?

Resolution:

Click Tasks, Payroll Entry
Select the Employee Id
Do not click save and/or do not print the check

By |December 6th, 2017|File Repair|0 Comments

Why aren’t Rental Equipment Allocations computing an amount on the Time and Material invoices?

Resolution:

Insure Equipment Estimated Use, Recovery and Rental Rates are set up in Equipment (8-3).
Insure the T and M Billing Setup (3-10-1) for the job has an Equipment Rate table.
Insure that the Rate Table is specifying either that piece of Equipment, or that piece of Equipment’s type.
***NOTE: Computing the T and M Invoice […]

By |December 6th, 2017|File Repair|0 Comments

Error: “Your sign in was unsuccessful. Please correct the errors and try again.”

Resolution:

1) Correct settings. Check by typing password in text editor (notepad).

2) Use “Forgot your password?” link to reset password.

3) Have your Sage 300 Online account administrator login to the User Management interface and Invite or Re-Invite your user.

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

Can the pound symbol be removed from the invoice number when emailing invoices

Resolution:

Currently, Sage 50 does not have a feature, to allow the remopound symbolval and or modification of the subject line, when emailing forms

By |December 6th, 2017|File Repair|0 Comments

How to integrate Act! with v20 Sage 100 Contractor

Resolution:
Before you migrate Act! settings
The steps in this section assume that you have:

Set up Act! for version 19.6, and have created opportunities, and so on, in that program.
Installed Sage 100 Contractor version 20.1
Migrated your Sage 100 Contractor from version 19.6 to version 20.1.
Reinstalled the Act! plugin.

Migrating Act! settings

Open Act!.
Click […]

By |December 6th, 2017|File Repair|0 Comments

The SQL server browser service is running on the local server, the local connection failed

Resolution:

Follow the naming convention: ServerNameInstanceName

By |December 6th, 2017|File Repair|0 Comments

My 941 form says it is for the year 2013 when I am trying to run it for 2014

Resolution:

The first quarter 941 is typically released in March.
Select the 2013 or 2014 941 form and click OK.
If the updated form is available, you will be prompted to run an update.
Note:  If you are not prompted for the update then you can manually download the tax forms update.  See Related Resources article ID 11368 How […]

By |December 6th, 2017|File Repair|0 Comments

What is the correct process for depositing cash receipts for multiple clients?

Resolution:

In order to have separate transactions that reflect the separate checks that are received the recommended work flow is to make a separate deposit in cash receipts for each check.

This will create separate transactions that can more easily be reconciled on the bank reconciliation screen

By |December 6th, 2017|File Repair|0 Comments