web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 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

  • 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.

     

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans