Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Import time system VAC...
Microsoft Dynamics GP (Archived)

Import time system VAC bal and hrs using Intergation.

(0) ShareShare
ReportReport
Posted on by Stephanie Riley 25

We are using Intergration Manager to import hourly time from our time system and would like to add vacation balance and vacation hours used to be displayed on our paycheck stub.

These fields are not available in the IM Payroll Transaction table to be mapped to our source file.

  1. How can this be done?

The Report Writer uses the Payroll Check Work table fields on our payroll stub.  I can drag and drop Vacation Available field onto Report Writer and use Sick Time Available field if GP was to provide this data but it is not.

We will not use GP to accure any vacation time since we use a 3rd party time system.

Any help would be greatly appreciated.

*This post is locked for comments

  • Stephanie Riley Profile Picture
    Stephanie Riley 25 on at
    Re: Re: Import time system VAC bal and hrs using Intergation.

    Hello Sandip, thanks for your response.

    My first thought was to use the Business Intelligence Studio and create a SSIS package.  I was hoping to add to our existing payroll transaction but the payroll transaction adaptor in IM does not have the fields like the payroll master adaptor does.  Playing around with the payroll master adaptor I created another IM which worked without errors but its scetchy as to if the report writer will work using these fields with GP business rules.

     

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Import time system VAC bal and hrs using Intergation.

    Riley,

    I have wrote my own customize code using C# to import vacation and sick time from ADP, instead of importing all timesheet transaction into Dynamics GP I pulled difference of current and previous vacation or sick difference thats way I don't have to import all transaction, just see difference and pass + or - entry.

     Thanks

    Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans