Summary
Formulas to print the registration number on the T-4 in Sage 300 CRE Payroll.
Resolution
Note: If there is not an amount in Box 20 or Box 52, the account number will not appear in Box 50.
If you have one registration number for all of your employees:
- From the Payroll Tools menu, select Modify Forms, T-4 Formats.
- Select your T-4 Form and click on the Amounts tab.
- Select box 50 and click Text.
- Enter you registration number in the Description and click OK.
- Click Save, then Close.
If your registration numbers are entered in Setup, Employees:
- From the Payroll Tools menu, select Formulas.
- Click Index and select Public Formulas.
- Click new and enter the formula:
- LOOKUP(Misc 1 (PR Employee), Employee (PR Employee))
Note: You can also use a custom field to store the registration number. In this case, replace "Misc 1 (PR Employee)" with "<Custom field> (Pr Employee Custom Fields)"
- LOOKUP(Misc 1 (PR Employee), Employee (PR Employee))
- Click OK, enter a Formula name, click OK and Close.
- From the Payroll Tools menu, select Modify Forms, T-4 Formats.
- Select your T-4 Form and click on the Amounts tab.
- Select box 50 and click Formula.
- Select the formula you created above and click OK.
- Click Save, then Close.
If your Box 50 registration numbers are entered on the Union Local setup:
- From the Payroll Tools menu, select Formulas.
- Click Index and select Public Formulas.
- Click new and enter the formula:
- LOOKUP(Address 2 [PR Union Local], Union ID [PR Employee], Union Local [PR Employee])
- Click OK, enter a Formula name, click OK and Close.
- From the Payroll Tools menu, select Modify Forms, T-4 Formats.
- Select your T-4 Form and click on the Amounts tab.
- Select box 50 and click Formula.
- Select the formula you created above and click OK.
- Click Save, then Close.