Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Track back from "payroll calculate checks" to PA Timesheet & Payroll transaction GP2010 & GP2013

Posted on by Microsoft Employee

Hi,
I am using GP 2010, SP5 and US Payroll with below integrations. Need this in both GP2010 & GP2013
PA - Project Accounting, TS - Timesheet, SL - Subledger, GL - General Ledger, PR - Payroll

(A) 1st query
=============
(1) PA TS integrated with Payroll, payroll integrated with vendor,
PA TS integrated with Billing, and all post to/through SL & GL

(2) Post TS which would be available in PR batch
(3) Build Checks & Calculate checks (stop here)

Here is my customization need.
I need to fetch the Tax amounts, benefit amounts which are in below tables relating to
the PR posted and TS posted tables. I need to track these tax & benefit amounts to
the trx ids of PR & TS

UPR10202 -- UPR_WORK_HDR -- Payroll Work Header
UPR10205 -- UPR_WORK_Benefit -- Payroll Work Benefit

I could not get a link between these tables to PR & TS tables nor in SDK. Can anyone help me to
the column that links Calculate check & PR & TS posted tables

(A) 2nd query
=============
I also would like to get a similar link after Print Checks process completed between
after posted print checks, PR trx no. & TS trx no. (or such key)
After print checks the data would be in other tables & not in "UPR Work tables".

Your early help would be much appreciated.

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans