Adding Internet Addresses table to Direct Deposit Statement Report

(0) Share

Report

Posted on by IPDpowerBob

Hello,

I am trying to add the Internet Addresses table (colNetAddrs, SY1200) to the Direct Deposit Statement of Earnings report. I'm a little of a novice when it comes to report writer so I was looking for some help. I've tried creating a relationship from Payroll Work Check and Payroll Master but the fields it gives me to link to aren't right. I know in the Payroll Master that EmployeeID is the same as MasterID in Internet Addresses but it doesnt give me the option to link those two fields. The reason I want this table is so I can add the EmailToAddress to show up on the report. Is there anyone out there that can help?

Thanks,

Bob

*This post is locked for comments

All responses (3)

Answers (0)

IPDpowerBob 60 on at

Like (0)

Report

RE: Adding Internet Addresses table to Direct Deposit Statement Report

Ok, thank you for the suggestions.
soma 24,406 on at

Like (0)

Report

RE: Adding Internet Addresses table to Direct Deposit Statement Report

My suggestion is you can use custom RW function to achieve the same with help of Dexterity and use the same. VBA is not supporting if you using web client.

Hope this helps!!!
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding Internet Addresses table to Direct Deposit Statement Report

Hi Bob,

You can use custom RW function or VBA code to show EmailToAddress field in your report.