Skip to main content
Microsoft Dynamics GP forum
Unanswered

Integration Manager Payroll Transactions

editSubscribe (0) ShareShare
ReportReport
Posted on by 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

Attachments
  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Integration Manager Payroll Transactions

    No sort order just group by batch.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Integration Manager Payroll Transactions

    In your integration what are you specifying for the sort order or grouping?

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans