Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sending a timekeeping ...
Finance | Project Operations, Human Resources, ...
Unanswered

Sending a timekeeping XML to eConnect

(0) ShareShare
ReportReport
Posted on by SMCDeveloper 10

I have been looking to develop a process for our company using eConnect. We have time records we are trying to process into Great Plains.

We have installed eConnect and found some xml samples that can be used with eConnect to send data into our GP system. 

I havent found any examples either in the folder or online about demonstrating what is used when inputting time data into GP.

I have been directed to this page here: https://docs.microsoft.com/en-us/previous-versions/dynamicsgp/developer/ff623839(v=msdn.10)

and found the XML Nodes: <taPATimeSheetLineInsert> & <taPATimeSheetLineInsert>

Im wondering if anyone could help me get started. We will have a sql table full of records we would like to push into this process. If someone could share either code or an example on how to do this it would be greatly appreciated. Struggling to get this working for us

Categories:
Microsoft Dynamics GP
  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Sending a timekeeping XML to eConnect

    By default, eConnect doesn't have any XML sample documents regarding Project Accounting, but I did find a colleague that had a SQL script for an eConnect PA timesheet, which is below, hopefully it helps....

    Thanks

    SET NOCOUNT ON

    BEGIN TRANSACTION

     DECLARE @O_iErrorState INT,

         @oErrString VARCHAR(255),

         @oRptString VARCHAR(255)

       ---- taRMApply

       --====================================================================

    /**/

       SET @O_iErrorState=0 -- Reset Errors

       SET @oErrString=''

       EXEC taPATimeSheetLineInsert

    @I_vPATSTYP = 1,

    @I_vPATSNO = 'ZZZZZ002',

    @I_vEMPLOYID = 'ACKE0001',

    @I_vCURNCYID = 'z-US$',

    @I_vPADT = '04-12-2017',

    @I_vPAPROJNUMBER = 'HOTELEDGER',

    @I_vPACOSTCATID = 'CONSULTING',

    @I_vPAQtyQ = 1,

    @I_vPAbllngtype = '1',

    @I_vPAUNITCOST = '250',

    @I_vPATOTCST = '250',

           @O_iErrorState=@O_iErrorState OUT, @oErrString=@oErrString OUT

       SELECT @oRptString = 'SELECT ErrorCode, SourceProc, ErrorDesc FROM DYNAMX16U..taErrorCode WHERE ErrorCode IN (' + REPLACE(RTRIM('0'+@oErrString),CHAR(32), ',') + ')'

       EXEC(@oRptString)

    /**/

    --HEADER

       --====================================================================

    /**/

       SET @O_iErrorState=0 -- Reset Errors

       SET @oErrString=''

       EXEC taPATimeSheetHdrInsert

    @I_vPATSTYP = 1,

    @I_vPATSNO = 'ZZZZZ002',

    @I_vEMPLOYID = 'ACKE0001',

    @I_vCURNCYID = 'z-US$',

    @I_vPADOCDT = '04-12-2017',

    @I_vBACHNUMB = 'ISAACTEST',

    @I_vPAREPD = '15',

    @I_vPAREPDT = '04-09-2017',

           @O_iErrorState=@O_iErrorState OUT, @oErrString=@oErrString OUT

       SELECT @oRptString = 'SELECT ErrorCode, SourceProc, ErrorDesc FROM DYNAMX16U..taErrorCode WHERE ErrorCode IN (' + REPLACE(RTRIM('0'+@oErrString),CHAR(32), ',') + ')'

       EXEC(@oRptString)

    /**/

    IF @O_iErrorState = 0

     COMMIT TRANSACTION

    ELSE

       ROLLBACK TRANSACTION  -- Simplifies re-testing

  • SMCDeveloper Profile Picture
    SMCDeveloper 10 on at
    RE: Sending a timekeeping XML to eConnect

    eConnect - PA Timesheet example is what i believe im looking for

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans