Payroll posting edit list table

(0) Share

Report

Posted on by Fahad Humayun

1,340

Hi,

What is the SQL table of payroll posting edit list? While I see the data in Payroll posting edit list window after build/calculate checks, I want to create an SSRS report so I can review the posting accounts

*This post is locked for comments

All responses (4)

Answers (1)

kdraper on at

Like (0)

Report

RE: Payroll posting edit list table

I would love to use this table for reporting but for some reason the Pay Code (PAYROLCD) column is empty for me in the (UPR10209) table. Any ideas?
Fahad Humayun 1,340 on at

Like (0)

Report

RE: Payroll posting edit list table

Thanks brothers,

I was able to fetch all the info I had required, with your help.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Payroll posting edit list table

Hi Fahad,

You can refer UPR10209(Payroll Work Post) table to create custom SSRS report. if you need additional table(s) regarding the above case, refer the below associated table(s).

SY02300 - Posting Settings

UPR00400 - Payroll Pay Code Master

UPR41200 - Payroll Class Setup

UPR40301 - Payroll Position Setup

UPR40300 - Payroll Department Setup

UPR00100 - Payroll Master

GL00100 - Account Master
Verified answer

Naga Kiran on at

Like (0)

Report

RE: Payroll posting edit list table

Hi Fahad,

You should use the table UPR10209 to create the SSRS report to print the payroll posting edit list. Join the GL00100 (GL_Account_MSTR) and UPR10209 on ACTINDX to display Account Number and Account Description.

Hope this helps.