Sage 100

Is there a way to print the Earnings Report as a monthly trend....I dont need the detail by employee, just the total recap.  But also, not the current quarter, but all months of the calendar year... Where does the PR_EarningsReportWrk file gets its data from????

------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

I do this for clients by queriing the PR EmployeHistoryDetail/Header table for needed information.  Little tricky to do unless you have @Dan Burleson 's enhancement to get around the PII limitations in PR.  Or you could write a Crystal report to pull the data and then export to Excel for a pivot table.  Or do some sort of cross tabbing to summarize.
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------