I upgraded a client to 2022 and the client later discovered the Payrate Change Report only shows entries made since the upgrade from 2019 with Payroll 2.23.0 install. I have a copy of converted 2019/2022 PR-AUDIT file in Excel with the correct data and I would like to import the 2022 current records into this file. I know that technically you cannot import into the PR_AUDIT file but I am hoping there is a possible way around this.
The records appear in table, so no purge occurred. However, no pay rate changes are printing since the upgrade.
Has anyone had success with this or suggestions.
Alyson Mitchell
Software Consultant III
Alyson.Mitchell@warrenaverett.com
(D)
(C)
334.260.2336
334.207.4983
3815 Interstate Court, Montgomery, AL 36109
Ranked as one of the top managed service providers (MSP) and managed security service providers (MSSP) in the world several years in a row.
To contact our Software Support Team call 844.712.6223 or email software@warrenaverett.com. To contact our Technical Services Team call 888.419.9090 or email resource.center@warrenaverett.com
I seem to recall having created a UDT, then importing records into it, then adding to the report and linking via the EmployeeKey. I don't recall the specific table I did this for, and I don't know if this would work for your scenario, but you could try it.
Susan,
Thank you for your suggestion. I will check into this.
is it Sage 100 Premium? If so, you could merge it in using a query.
Doug,
It is Sage 100 Standard.
You said "The records appear in table, so no purge occurred. However, no pay rate changes are printing since the upgrade. " Instead of re-importing the records that are already there and since it is apparently a simple report, can you dump the file with Crystal and see how the older records are different? I have a converted 2022 (from 2021 w/PR 2.23) and ancient records are reported. I would also be interested to see if the older records are being written to the work table or if they are being filtered somehow.
FWIW: I tried creating a new Crystal Report against PR_AUDIT and discovered that, although the file was clearly there, it couldn't be found by Crystal or by DFD&M. It was the only file in the PR company folder where the date was unchanged from before the conversion. Only after I changed a pay rate of an employee, was it readable other than by the standard Pay Rate Change report.
------------------------------Dan BurlesonSoftware ConsultantConnex Software------------------------------
Jim Woodhead | Principal Consultant
p: 800.627.9032 x125 | m: 619.990.3946
e: jimw@dsdinc.com
w: dsdinc.com
FWW: I tried creating a new Crystal Report against PR_AUDIT and discovered that, although the file was clearly there, it couldn't be found by Crystal or by DFD&M. It was the only file in the PR company folder where the date was unchanged from before the conversion. Only after I changed a pay rate of an employee, was it readable other than by the standard Pay Rate Change report.
PO Box 372, Sunset Beach, CA 90742
Email: membership@90minds.com
JoinBenefitsLearn More
About UsTerms of Use