Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect - Invoice Rec...
Microsoft Dynamics GP (Archived)

eConnect - Invoice Receipt Match

(0) ShareShare
ReportReport
Posted on by BDazzo 50

I have successfully imported both the PO and the Receipt, but I am having trouble with the Invoice Match.  It seems that the 'Match Shipment Receipt Number' is required.  It does not populate during the import and then all the line items have an error message "Error: Line Items are not fully matched".  However when you enter the Trx manually, the Receipt Match number fills in automatically based on the Po/Item combination.   Is anyone aware of how I can get around this?

 

  <?xml version="1.0" encoding="utf-8" ?>
- <eConnect>
- <POPEnterMatchInvoiceType>
- <eConnectProcessInfo>
- <taPopEnterMatchInvLine_Items>
- <taPopEnterMatchInvLine>
  <POPRCTNM>RCT057088</POPRCTNM>
  <PONUMBER>HVS12815017</PONUMBER>
  <QTYINVCD>2000</QTYINVCD>
  <ITEMNMBR>00603-2544-28</ITEMNMBR>
  <VENDORID>CARDI004</VENDORID>
  <VNDITNUM>00603-2544-28</VNDITNUM>
  <VarianceAccount>60-65-000-1300-00</VarianceAccount>
  <UNITCOST>0.6291</UNITCOST>
  <EXTDCOST>1258.2</EXTDCOST>
  <NONINVEN>1</NONINVEN>
  <AUTOCOST>0</AUTOCOST>
  <AutoInvoice>0</AutoInvoice>
  </taPopEnterMatchInvLine>
- <taPopEnterMatchInvLine>
  <POPRCTNM>RCT057088</POPRCTNM>
  <PONUMBER>HVS12815017</PONUMBER>
  <QTYINVCD>1200</QTYINVCD>
  <ITEMNMBR>00603-2582-21</ITEMNMBR>
  <VENDORID>CARDI004</VENDORID>
  <VNDITNUM>00603-2582-21</VNDITNUM>
  <VarianceAccount>60-65-000-1300-00</VarianceAccount>
  <UNITCOST>0.0414</UNITCOST>
  <EXTDCOST>49.68</EXTDCOST>
  <NONINVEN>1</NONINVEN>
  <AUTOCOST>0</AUTOCOST>
  <AutoInvoice>0</AutoInvoice>
  </taPopEnterMatchInvLine>
  </taPopEnterMatchInvLine_Items>
- <taPopEnterMatchInvHdr>
  <POPRCTNM>RCT057088</POPRCTNM>
  <VNDDOCNM>HVS12815017</VNDDOCNM>
  <Receiptdate>2015-1-29</Receiptdate>
  <BACHNUMB>INVOICES</BACHNUMB>
  <VENDORID>CARDI004</VENDORID>
  <SUBTOTAL>0</SUBTOTAL>
  <AUTOCOST>1</AUTOCOST>
  </taPopEnterMatchInvHdr>
  </POPEnterMatchInvoiceType>
  </eConnect>

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - Invoice Receipt Match

    Good to hear that your problem is solved

  • Verified answer
    BDazzo Profile Picture
    BDazzo 50 on at
    RE: eConnect - Invoice Receipt Match

    Thank you for your response.  I was trying to avoid the requirement for the invoice match number.  In the end I used a SQL lookup to find the correct number.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect - Invoice Receipt Match

    It seems that you have missed a schema node for the multiple line items <taPopEnterMatchInvToShpMultiLine>. In this you need to pass the parameter "POPMtchShpRcpt" for the Matching shipment receipt number and the all the other required parameters for this XML Schema which will take care of your issue.

    Sample Document Structure:

    Document structure
    <eConnect>
    <POPEnterMatchInvoiceType>
    <eConnectProcessInfo />
    <taRequesterTrxDisabler_Items>
    <taRequesterTrxDisabler />
    </taRequesterTrxDisabler_Items>
    <taUpdateCreateItemRcd />
    <taUpdateCreateVendorRcd />
    <taCreateVendorAddress_Items>
    <taCreateVendorAddress />
    </taCreateVendorAddress_Items>
    <taPopRcptLineTaxInsert_Items>
    <taPopRcptLineTaxInsert />
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items>
    <taPopDistribution />
    </taPopDistribution_Items>
    <taAnalyticsDistribution_Items>
    <taAnalyticsDistribution>
    </taAnalyticsDistribution_Items>
    <taPopEnterMatchLotInsert_Items>
    <taPopEnterMatchLotInsert>
    </taPopEnterMatchLotInsert_Items>
    <taPopEnterMatchSerialInsert_Items>
    <taPopEnterMatchSerialInsert>
    </taPopEnterMatchSerialInsert_Items>
    <taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvLine />
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items>
    <taPopEnterMatchInvToShpMultiLine>
    </taPopEnterMatchInvToShpMultiLine_Items>
    <taPopEnterMatchInvHdr />
    <taMdaUpdate_Items>
    <taMdaUpdate />
    </taMdaUpdate_Items>
    </POPEnterMatchInvoiceType>
    </eConnect>

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans