Integration Manager Payroll Transactions

(0) Share

Report

Posted on by Sunil Chhabra

1,930

We had an integration setup for years that was working correctly. We import the pay rates from the import file.

After installing Advanced HR - the pay rates were no longer importing - Per Terry Heley' suggestion we changed the security on the payroll window and the Integration manager is now bringing the rate from the imported file.

Now it is only importing the last record - real strange. For example, I created the following to import. It will only import the last row. If I delete the last row which has PTOH code then the Row with HOUR paycode becomes the last row and gets imported.

BatchID,BatchComment,PP Beg Date,PP End Date,EmpID,PayCode,Hours/Units,Amount/Rate,Dept,Position

UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,HOLI,21,12.5,INST,TEC
UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,HOUR,22,15,INST,TEC

UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,PTOH,23,17.77,INST,TEC

Thanks

*This post is locked for comments

All responses (4)

Answers (0)

Sunil Chhabra 1,930 on at

Like (0)

Report

RE: Integration Manager Payroll Transactions

No sort order just group by batch.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Integration Manager Payroll Transactions

In your integration what are you specifying for the sort order or grouping?
Sunil Chhabra 1,930 on at

Like (0)

Report

RE: Integration Manager Payroll Transactions

Richard,

I deleted the integration and redid it and it worked. What I am trying to figure (i must not have noticed this before) why the does Integration occur in "reverse order"

The following is my order of import - but in GP the Transaction number is the highest for the first record and lowest for the last record. I have added the column transaction number as it appears in Payroll Transaction Entry window.

UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,HOLI,21,12.5,INST,TEC (Transaction # #815)

UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,HOUR,22,15,INST,TEC (Transaction # 814)

UFPAYROLL,HOURLY,4/12/2027,4/18/2027,BARB0001,PTOH,23,17.77,INST,TEC (transaction #813)

I know I can sort it different ways in the Transaction Grid - but I am curious if this is normal behavior?

Thanks
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Integration Manager Payroll Transactions

I would try these two things:

First, try entering a payroll transaction manually and see if any new or unexpected windows appear.

Second, Tools->Customize, Customization Status. Highlight Advanced Payroll products and click disable and run the integration. Perhaps this will help narrow down which product is causing the change in behavior. There is more than one product for the Advanced Payroll/HR so be sure to disabled them all and then add them back one by one.