How to enter registration numbers in box 50 of the T-4 slip

Use the following setup or formulas to print the registration number on the T-4 in Sage 300 CRE Payroll.

 NOTE: If there isn’t an amount in Box 20 or Box 52, the account number won’t appear in Box 50. 

You have one registration number for all of your employees

1. From the Payroll Tools menu, select Modify Forms, T-4 Formats.
2. Select your T-4 Form and click the Amounts tab.
3. Select box 50 and click Text.
4. Enter you registration number in the Description and click OK.
5. Click Save, then Close.

You enter the registration numbers in Setup, Employees

1. From the Payroll Tools menu, select Formulas.
2. Click Index and select Public Formulas.
3. 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)" 
4. Click OK, enter a Formula name, click OK and Close.
5. From the Payroll Tools menu, select Modify Forms, T-4 Formats.
6. Select your T-4 Form and click the Amounts tab.
7. Select box 50 and click Formula.
8. Select the formula you created above and click OK.
9. Click Save, then Close.

You enter the Box 50 registration numbers on the Union Local setup

1. From the Payroll Tools menu, select Formulas.
2. Click Index and select Public Formulas.
3. Click new and enter the formula:
   • LOOKUP(Address 2 [PR Union Local], Union ID [PR Employee], Union Local [PR Employee])
4. Click OK, enter a Formula name, click OK and Close.
5. From the Payroll Tools menu, select Modify Forms, T-4 Formats.
6. Select your T-4 Form and click the Amounts tab.
7. Select box 50 and click Formula.
8. Select the formula you created above and click OK.
9. Click Save, then Close.