web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Payroll Check Inquiry

(0) ShareShare
ReportReport
Posted on by 399
An employee submitted their check stubs when applying for a mortgage, but the check amount was cutoff so we provided them re-printed stubs and the underwriters discovered the figures didn't match.
 
The Year To Date gross amount on the Duplicate Paystub Report is inflated the exact amount as two pay advances from earlier in the year. The actual pay stub is correct, it is only when you go in the payroll check inquiry screen to re-print the stub that the figure is off. 
 
Where does the report pull the gross YTD figure? Could the advance pay not be setup properly? Employee Summary under cards>payroll displays the proper amounts.
Categories:
I have the same question (0)
  • Taylor_Greenwood Profile Picture
    399 on at
    Payroll Check Inquiry
    After digging around in Report Writer, it appears this figure is calculated from a conditional formula: 

    conditional expression being:
     

    uprReprintCheckTemp.Payroll Record Type>0


    true case:
     

    FUNCTION_SCRIPT( RW_Reprint_Gross_YTD.uprReprintCheckTemp.CheckDate. uprReprintCheckTemp.Employee ID.uprReprintCheckTemp.Check Number.uprReprintCheckTemp.Level )

     

    false case:

    0

     

    I’m assuming the report is generated from temp tables, I’m also assuming said tables can’t be edited. Is there something that can be edited, as to not twice count the pay advances? If the data is being pulled from the UPR tables, that seem correct, why is the advance not reflecting properly (as though it’s not reflecting the pay advance deduction when the next payroll run was done)? When looking at the transaction history of the audit trail codes, the advances are a wash. You see the advance, you see the negative amount on the subsequent run that offsets the advance - same pay code etc.  

     

    For the time being, I put a data field (sum) in place of the conditional formula, which worked for all the stubs that did not include the advance deduction on the run after the advance. (The payroll run after the advance lists the negative figure under current but also lists the YTD total - same figure both rows, thus it doubles the salary set up this way)

  • Suggested answer
    Lisa at AonC.com Profile Picture
    910 Super User 2025 Season 2 on at
    Payroll Check Inquiry
    If you have confirmed the Advances set up is correct, you should add this to the Ideas List for GP.  Based on your analysis it sounds like something that should be fixed in the report.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 758 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 611 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 410

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans