Apply MC Payment to SOP Invoice through eConnect

(0) Share

Report

Posted on by Tim W

2,925

Hi All,

We receive payments in various currencies through our CC processors and we have built an eConnect integration to push those in and it works fine for documents in originating currency but errors out when we try to bring in MC payments.

In testing if we set rate to 1.0 then it works fine for the other currencies but any rate calculation fails with an error on taSOPHdrRecalc and we've done quite a bit of testing with varied additional elements parameters.

Just wondering if anyone has ever been successful doing a MC SOP Payment integration.

Here's a sample doc.

<?xml version="1.0"?>
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<SOPTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taUpdateCreateCustomerRcd xsi:nil="true" />
    <taCreateCustomerAddress_Items xsi:nil="true" />
    <taSopSerial_Items xsi:nil="true" />
    <taSopLotAuto_Items xsi:nil="true" />
    <taSopLineIvcInsert_Items xsi:nil="true" />
    <taSopLineIvcInsertComponent_Items xsi:nil="true" />
    <taSopTrackingNum_Items xsi:nil="true" />
    <taSopCommissions_Items xsi:nil="true" />
    <taSopLineIvcTaxInsert_Items xsi:nil="true" />
    <taCreateSopPaymentInsertRecord_Items>
      <taCreateSopPaymentInsertRecord>
        <SOPTYPE>3</SOPTYPE>
        <SOPNUMBE>INV0000003774</SOPNUMBE>
        <CUSTNMBR>ABC35907</CUSTNMBR>
        <DOCDATE>2016-10-01</DOCDATE>
        <DOCAMNT>100</DOCAMNT>
        <CHEKBKID>OPERATING</CHEKBKID>
        <CARDNAME>VISA</CARDNAME>
        <CHEKNMBR>xxxx1111</CHEKNMBR>
        <AUTHCODE>_88382034182401</AUTHCODE>
        <PYMTTYPE>6</PYMTTYPE>
      </taCreateSopPaymentInsertRecord>
    </taCreateSopPaymentInsertRecord_Items>
    <taSopUserDefined xsi:nil="true" />
    <taSopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taSopMultiBin_Items xsi:nil="true" />
    <taSopHdrIvcInsert>
      <SOPTYPE>3</SOPTYPE>
      <DOCID>INV</DOCID>
      <SOPNUMBE>INV0000003774</SOPNUMBE>
      <DOCDATE>2016-10-01</DOCDATE>
      <CUSTNMBR>ABC35907</CUSTNMBR>
      <BACHNUMB>CC_BATCH</BACHNUMB>
      <CURNCYID>EUR</CURNCYID>
       <PYMTRCVD>100</PYMTRCVD>
     <UpdateExisting>1</UpdateExisting>
    </taSopHdrIvcInsert>
    <taSopToPopLink xsi:nil="true" />
    <taSopUpdateCreateProcessHold xsi:nil="true" />
    <taCreateSOPTrackingInfo xsi:nil="true" />
    <taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Tim W 2,925 on at

Like (0)

Report

RE: Apply MC Payment to SOP Invoice through eConnect

Hi Mark,

Other than looking at the SP and passing additional suspected fields in case 'update if exist logic' missed it, no. I had not thought to refract the code, I think in our case we'll just write our own SP as it's a payment on an invoice which is one row in one table and updating two fields in the hdr record. It would be a different story if we took deposits on orders as we'd have to run the Gl logic for deposits.

Mostly was hoping some eConnect TA in Fargo would read my post and want to give it a look and save me the $500.

Enjoy your summer, I've been to Melbourne and it is spectacular.

Best

Tim

Was this reply helpful? Yes No
Verified answer

mavrick5au 6 on at

Like (0)

Report

RE: Apply MC Payment to SOP Invoice through eConnect

Have you tried looking at the taSopHdrRecalc stored procedure to see what the actual cause of the 1189 error code is?

Regards,

Mark

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (0)

Report

RE: Apply MC Payment to SOP Invoice through eConnect

Hi Heather and Praveen, thanks for your comments back and taking the time to drill in further.

Heather, we can add them (and do) through the UI but it's not a scalable solution for us and so I'm looking to automate further. The eConnect payment object does not ask for currency, it assumes same as SOP Invoice (which is exactly what we want). With EUR to USD rate set to 1.0 a EUR payment is created against a EUR invoice as we would desire it to do (functional is USD). That occurs as expected when SOP Invoice has a rate 1.0 (it's in exchange table also as such). When rate is not 1.0 then the eConnect call to it's SOP Header Recalc procedure throws the error below.

To me, looks like a bug in eConnect or just something eConnect was never conceived to do. For that answer, I'll need to pony up $499 so I thought I'd take a swing through the Community to see if anyone else has tried this.

Thanks to both of you for taking the time to review,

Tim

Error returned:

Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:

Error Number = 1189 Stored Procedure= taSopHdrRecalc Error Description = Payment total does not match deposits+payments entered for document

Node Identifier Parameters: taSopHdrRecalc

SOPNUMBE = INV0000003774

SOPTYPE = 3

Related Error Code Parameters for Node : taSopHdrRecalc

PYMTRCVD = 100

Error Number = 2218 Stored Procedure= taSopHdrIvcInsert Error Description = Unable to update the existing SOP Header record

Node Identifier Parameters: taSopHdrIvcInsert

SOPNUMBE = CPINV0000003774

SOPTYPE = 3

<taSopHdrIvcInsert>

<SOPTYPE>3</SOPTYPE>

<DOCID>CASH PAY</DOCID>

<SOPNUMBE>INV0000003774</SOPNUMBE>

<DOCDATE>2016-10-01</DOCDATE>

<CUSTNMBR>ABC35907</CUSTNMBR>

<BACHNUMB>CC_BATCH</BACHNUMB>

<CURNCYID>EUR</CURNCYID>

<PYMTRCVD>100</PYMTRCVD>

<UpdateExisting>1</UpdateExisting>

</taSopHdrIvcInsert>

Was this reply helpful? Yes No
Praveen Kumar RR 1,552 on at

Like (0)

Report

RE: Apply MC Payment to SOP Invoice through eConnect

Hi Tim,

Please provide Error Message you are getting through eConnect Import Process.

Please check User Access to Multicurrency you are trying to pass. It is required for User to have access to each Currency.

eConnect support Multicurrency transactions also, so it is possible to locate exact cause once you provide us Error Message or Error Snapshot.

Thanks,

Praveen

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Apply MC Payment to SOP Invoice through eConnect

Hi Tim

I don't know about via eConnect, but can you do it in the user interface?

Apply MC came in with 2015, but only if the currencies were the same on the invoice and payment.

Is this the case with your integration? Or are you trying to apply e.g. EUR payment to USD invoice.

If that is the case, then I would not expect you to be able to do that because I don't believe you can do it in the UI.

Cheers

Heather

Was this reply helpful? Yes No