40
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.
Perfect. thanks for your help.
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
In addition, I would like to get the paycode for the line items in dbo.PA23203
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (