JonEast 3/13/2008 11:14:58 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.

Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3