The error message occurs when processing payroll in Sage 50 Accounting.
Presents as Error: "The following formula listed on the Employee record does not exist in Payroll Formulas:
Employee ID: ID Formula Name: name, year, filing status. To correct this, select File, Payroll Formulas,
User-Maintained, and add this formula," or Error: "An invalid Filing Status is selected."
- The latest tax update isn’t installed
- The product isn’t activated
- Using an obsolete version
- Trying to issue payroll more than 10 days past support plan renewal date
- Payroll tax formulas have disappeared
Click on the section below that most closely describes the problem you're having, and that will expand it.
▼ The formula doesn’t exist in User-Maintained Formulas - Go to File, Payroll Formulas, User-Maintained Formulas.
Note: If this prompts the error "A managed exception was caught," see Error: "A managed exception was caught..." opening User-Maintained tax tables. - For Formula ID, enter XXSUI, replacing XX with your state abbreviation (for example, GASUI).
- For Formula Name, enter XXSUI ER YY, replacing XX with your state abbreviation, and YY with the current tax year abbreviation (for example, GASUI ER 26).
- Set Effect on gross pay to Subtracts from gross.
- Set Filing Status to All.
- Set How do you classify this formula to Tax.
- Set Tax Agency to State.
- Select your state from the dropdown list.
- Check Use this formula as a filter on the Payroll Tax report.
- In the Formula field, enter the following.
LIMIT = 0.00;
PERCENT = 0.00;
TAXABLE_GROSS = YTD_LIMIT (ADJUSTED_GROSS, LIMIT);
ANSWER = -TAXABLE_GROSS * PERCENT% - Change LIMIT and PERCENT to the correct limit and percentage as set by your state; the correct values can be obtained from your state's Department of Revenue.
- Click Save.
- Create a paycheck and verify that the error no longer occurs.
▼ You're starting a new payroll year - Go to File, Payroll Formulas, and then User-Maintained Formulas.
- Select the previous year's SUI formula from the Formula ID drop-down list.
- Change the Formula ID to end with the next number in sequence.
- Change the Formula Name to include the current year instead of the previous year (for example, change GASUI ER 25 to GASUI ER 26).
- If needed, change the Rate and Limit.
- Click Save.
- Create a paycheck and verify that the error no longer occurs.
▼ SUI is paid to multiple states - Go to File, Payroll Formulas, and then User-Maintained Formula.
- Select an SUI formula from the Formula ID drop-down list.
- Change the state abbreviation in Formula ID and Formula Name to the additional state's abbreviation (for example, change GASUI to ALSUI).
- Make sure the year in the Formula Name is set to the current year.
- If needed, change the Rate and Limit.
- Click Save.
- Repeat for other states if needed.
- Go to Maintain, Default Information, and then Employees.
- On the Company Fields tab, make sure that the formula for SUI is set to **SUI, and click OK.
- Go to Maintain, and then Employees/Sales Reps.
- On the Withholding Info tab, make sure the State Locality is set using the postal 2-state abbreviation.
- On the Company Fields tab, make sure SUI is checked Use Defaults.
- If changes were made to an employee record, click Save.
- Repeat for other employees if needed.
- Create a paycheck and verify that the error no longer occurs.
▼ Employees live in multiple states, but SUI is paid to only one state - Go to Maintain, Default Information, and then Employees.
- On the Company Fields tab, make sure that the formula for SUI is set to XXSUI (replacing XX with the state abbreviation), and click OK.
- Go to Maintain, and then Employees/Sales Reps.
- On the Company Fields tab, make sure SUI is checked Use Defaults.
- If changes were made to an employee record, click Save.
- Repeat for other employees if needed.
- Create a paycheck and verify that the error no longer occurs.
▼ Couldn’t find a user-created calculation - If the error indicates a calculation you created, either manually or using the Payroll Wizard (401K, Vacation, Sick, etc.) can’t be found, make sure the formula is present, and updated for the current year under File, Payroll Formulas, and then User-Maintained Formulas.
- Make sure the employee is set to Use Defaults for the payroll field in Maintain, Employees Sales Reps on the Employee Fields and/or Company Fields tabs.
- Update how the formula is classified. To the right of "How do you classify this formula," change it from Tax to Deduction.
- If a formula created through the Payroll Wizard doesn’t exist, contact Sage 50 Support at 866-747-3888
for guidance in recreating the formula.
- Solution ID
- 220924650010762
- Last Modified Date
- Mon Nov 21 17:55:39 UTC 2022
- Attributes
-
Product Details
Integrated Product: Blueprints
- Views
- 0