Search found 3 matches

by lukek
Sat Feb 06, 2021 10:17 am
Forum: Help
Topic: Formatted SSN in reports
Replies: 5
Views: 5422

Re: Formatted SSN in reports

Using 12.6.5 - Professional Edition. I figured it out though. If you add a custom column to the report, set the formula to pre-group, set format to String. You'll use the following formula: string_concat('-', (string_substring(#sin#, 0,3)), string_concat('-',(string_substring(#sin#, 3,2)), (string_s...
by lukek
Fri Feb 05, 2021 2:21 pm
Forum: Help
Topic: Formatted SSN in reports
Replies: 5
Views: 5422

Re: Formatted SSN in reports

I am using Pay Stub Reports and the Deductions by Employee template. I am setting up the file to send to the company that handles our 457 retirement plan. They require the report have formatted SSN's (with the dashes). I thought I could create a custom column and fenagle a formula to do this, but I'...
by lukek
Fri Feb 05, 2021 2:09 pm
Forum: Help
Topic: Formatted SSN in reports
Replies: 5
Views: 5422

Formatted SSN in reports

Hello All,

I've searched the forum and didn't see an answer to this question. Is there a way to make a custom field in reports that will format the SSN appropriatly? (i.e. - 111-22-3333)?