Notifications
Announcements
No record found.
Hi,
I'm trying to get the payroll data for an invoice. Specificially the payroll start(PAREPDT) and end date(PAPeriodEndDate).
I'm using the table dbo.ReqRecvDocHeader to get the receivable invoice and dbo.PA23203 to get the line items. How could I could from the invoice data to the payroll data?
I see dbo.ReqPATimesheetHeader contains the columns I need but I do not know how to link the two together.
Thanks.
In addition, I would like to get the paycode for the line items in dbo.PA23203
Hello,
The RM Invoice is going to be the same document number as the Billing Invoice in Project which is seems you have that part down. then you would link the PACOSTDOCNO in the billing details PA23203 table to the PA30100 table to get the timesheet header which has the reporting period and end date. After that link the PA30100 to the PA30101 table which has the Timesheet Detail to get the pay code used on the timesheet. Hopefully in your environment like most, you will only use 1 pay code per employee for Project Timesheets, because it is possible to use more than 1 which would make things a bit more difficult for you potentially.
Here is a SQL join of what I described above to get you started.
SELECT a.PADocnumber20,
b.PAREPD,
b.PAPeriodEndDate,
c.PAPayCode
FROM PA23203 a
JOIN PA30100 b
ON a.PACOSTDOCNO = b.PATSNO
JOIN PA30101 c
ON c.PATSNO = b.PATSNO
Thanks,
Isaac Olson
Microsoft Support
Perfect. thanks for your help.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 384 Most Valuable Professional
