30
Under the Project Timesheets with Rate/Amount Entry, when I enter the timesheets, especially if it's for multiple employees, it would be nice to have a sum total of the extended amount at the bottom, to easily spot if the payroll report matches with the timesheet entries. Right now it only show totals for the hours and eqpt units. Does someone know how to add the sum total at the bottom? Thanks.
*This post is locked for comments
Hi Sprt2,
Two tables hold the information from this timecard screen - PJtimdet and PJtimhdr. I was thinking you could just get the total extended amount from PJtimhdr but it doesn't look like we store the total extended amount for the entire timecard in the header record. The PJtimdet table holds the extended amount for each line.
I suppose you could add a field to the timecard screen and enter some code behind that field to sum the extended amount from all the PJtimdet records with that DocNbr. That's just a best guess on my part.
Let us know how it goes.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
