Site Search:
Sign in | Join | Help

eConnect Multi-Currency in PM Transactions

Last post 06-11-2008 4:19 AM by JonEast. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 03-13-2008 11:14 AM

    eConnect Multi-Currency in PM Transactions

    Has anyone managed to successfully create a multi-currency transaction using the PMTransaction schema when you need to also pass in the distributions.

    It always seems to put my originating amounts into the functional amount fields and therefore the document will never post in GP.

    This is for GP10 by the way...

    Fabrikam Sample:

    <!-- payables invoice creation with taxes, MC, and has Freight and Mics Charges -->
    <eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
        <PMTransactionType>
            <taPMTransactionInsert>
                <BACHNUMB>SAVE</BACHNUMB>
                <VCHNUMWK>00000000000038444</VCHNUMWK>
                <VENDORID>DOLECKIC0001</VENDORID>
                <DOCNUMBR>29</DOCNUMBR>
                <DOCTYPE>1</DOCTYPE>
                <DOCAMNT>500</DOCAMNT>
                <DOCDATE>2007-02-12</DOCDATE>
                <PSTGDATE>2007-02-12</PSTGDATE>
                <VADDCDPR>PRIMARY</VADDCDPR>
                <PYMTRMID>Due 20th</PYMTRMID>
                <TAXSCHID>COMPANYPUR</TAXSCHID>
                <DUEDATE>2007-03-20</DUEDATE>
                <DSCDLRAM>0</DSCDLRAM>
                <PRCHAMNT>500.00</PRCHAMNT>
                <CHRGAMNT>500.00</CHRGAMNT>
                <TRXDSCRN>Multi-Currency Test</TRXDSCRN>
                <PORDNMBR>101</PORDNMBR>
                <SHIPMTHD>DROP SHIP</SHIPMTHD>
                <CURNCYID>Z-C$</CURNCYID>
                <XCHGRATE>3.1722000</XCHGRATE>
                <EXPNDATE>2007-02-12</EXPNDATE>
                <EXCHDATE>2007-02-12</EXCHDATE>
                <EXGTBDSC>Canadian-Sell</EXGTBDSC>
                <EXTBLSRC>CompuServe</EXTBLSRC>
                <RATEEXPR>6</RATEEXPR>
                <DYSTINCR>0</DYSTINCR>
                <RATEVARC>.0500000</RATEVARC>
                <TRXDTDEF>1</TRXDTDEF>
                <RTCLCMTD>0</RTCLCMTD>
                <PRVDSLMT>1</PRVDSLMT>
                <DATELMTS>1</DATELMTS>
                <CREATEDIST>0</CREATEDIST>
            </taPMTransactionInsert>
        <taPMDistribution_Items>
          <taPMDistribution>
            <DOCTYPE>1</DOCTYPE>
            <VENDORID>DOLECKIC0001</VENDORID>
            <VCHRNMBR>00000000000038444</VCHRNMBR>
            <BACHNUMB>SAVE</BACHNUMB>
            <DISTTYPE>6</DISTTYPE>
            <ACTNUMST>000-1100-00</ACTNUMST>
            <DEBITAMNT>500</DEBITAMNT>
          </taPMDistribution>
          <taPMDistribution>
            <DOCTYPE>1</DOCTYPE>
            <VENDORID>DOLECKIC0001</VENDORID>
            <VCHRNMBR>00000000000038444</VCHRNMBR>
            <BACHNUMB>SAVE</BACHNUMB>
            <DISTTYPE>2</DISTTYPE>
            <ACTNUMST>000-1100-00</ACTNUMST>
            <CRDTAMNT>500</CRDTAMNT>
          </taPMDistribution>
        </taPMDistribution_Items>
        </PMTransactionType>
    </eConnect>

    Thanks,

    Jon.

    Filed under: ,
    • 193.132.233.220
  • 06-10-2008 3:21 AM In reply to

    Re: eConnect Multi-Currency in PM Transactions

    I am also facing the same issue.Can anybody help on this

    thanks

    Pramodh

    • 61.8.153.203
  • 06-10-2008 5:43 AM In reply to

    Re: eConnect Multi-Currency in PM Transactions

    I eventually figured it out.  You need to pass in the distributions before the transaction header.  The transaction header stored proc is the one which does all of the multi-currency calculations.

     

    Jon.

    • 62.169.151.34
  • 06-11-2008 12:21 AM In reply to

    Re: eConnect Multi-Currency in PM Transactions

    Thanks for the quick reply.. Can you please provide the sample xml .

     thanks

    Pramodh C

    • 61.8.153.203
  • 06-11-2008 4:19 AM In reply to

    Re: eConnect Multi-Currency in PM Transactions

    It should be something like this: -

     

    <!-- payables invoice creation with taxes, MC, and has Freight and Mics Charges -->
    <eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
        <PMTransactionType>
        <taPMDistribution_Items>
          <taPMDistribution>
            <DOCTYPE>1</DOCTYPE>
            <VENDORID>DOLECKIC0001</VENDORID>
            <VCHRNMBR>00000000000038444</VCHRNMBR>
            <BACHNUMB>SAVE</BACHNUMB>
            <DISTTYPE>6</DISTTYPE>
            <ACTNUMST>000-1100-00</ACTNUMST>
            <DEBITAMNT>500</DEBITAMNT>
          </taPMDistribution>
          <taPMDistribution>
            <DOCTYPE>1</DOCTYPE>
            <VENDORID>DOLECKIC0001</VENDORID>
            <VCHRNMBR>00000000000038444</VCHRNMBR>
            <BACHNUMB>SAVE</BACHNUMB>
            <DISTTYPE>2</DISTTYPE>
            <ACTNUMST>000-1100-00</ACTNUMST>
            <CRDTAMNT>500</CRDTAMNT>
          </taPMDistribution>
        </taPMDistribution_Items>
            <taPMTransactionInsert>
                <BACHNUMB>SAVE</BACHNUMB>
                <VCHNUMWK>00000000000038444</VCHNUMWK>
                <VENDORID>DOLECKIC0001</VENDORID>
                <DOCNUMBR>29</DOCNUMBR>
                <DOCTYPE>1</DOCTYPE>
                <DOCAMNT>500</DOCAMNT>
                <DOCDATE>2007-02-12</DOCDATE>
                <PSTGDATE>2007-02-12</PSTGDATE>
                <VADDCDPR>PRIMARY</VADDCDPR>
                <PYMTRMID>Due 20th</PYMTRMID>
                <TAXSCHID>COMPANYPUR</TAXSCHID>
                <DUEDATE>2007-03-20</DUEDATE>
                <DSCDLRAM>0</DSCDLRAM>
                <PRCHAMNT>500.00</PRCHAMNT>
                <CHRGAMNT>500.00</CHRGAMNT>
                <TRXDSCRN>Multi-Currency Test</TRXDSCRN>
                <PORDNMBR>101</PORDNMBR>
                <SHIPMTHD>DROP SHIP</SHIPMTHD>
                <CURNCYID>Z-C$</CURNCYID>
                <XCHGRATE>3.1722000</XCHGRATE>
                <EXPNDATE>2007-02-12</EXPNDATE>
                <EXCHDATE>2007-02-12</EXCHDATE>
                <EXGTBDSC>Canadian-Sell</EXGTBDSC>
                <EXTBLSRC>CompuServe</EXTBLSRC>
                <RATEEXPR>6</RATEEXPR>
                <DYSTINCR>0</DYSTINCR>
                <RATEVARC>.0500000</RATEVARC>
                <TRXDTDEF>1</TRXDTDEF>
                <RTCLCMTD>0</RTCLCMTD>
                <PRVDSLMT>1</PRVDSLMT>
                <DATELMTS>1</DATELMTS>
                <CREATEDIST>0</CREATEDIST>
            </taPMTransactionInsert>
        </PMTransactionType>
    </eConnect>

    Jon.

    • 62.169.151.34
Page 1 of 1 (5 items)