Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect POP Receivings Tax in GP 2013

Posted on by Microsoft Employee

I am trying to  import PO Receivings document to GP using eConnect. The import is working okay but the tax information is missing.

The taxes are based on the vendor, so in "taPopRcptLineInsert" i am passing to Purchase_IV_Item_Taxable = 3 which according to eConnect documentation is used for "3=Based on vendor"

the xml for eConnect object is

==========================

<?xml version="1.0"?>

-<eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">-<POPReceivingsType><eConnectProcessInfo xsi:nil="true"/><taRequesterTrxDisabler_Items xsi:nil="true"/><taUpdateCreateItemRcd xsi:nil="true"/><taUpdateCreateVendorRcd xsi:nil="true"/><taCreateVendorAddress_Items xsi:nil="true"/><taPopRcptLotInsert_Items xsi:nil="true"/><taPopRcptSerialInsert_Items xsi:nil="true"/>-<taPopRcptLineInsert_Items>-<taPopRcptLineInsert><POPTYPE>3</POPTYPE><POPRCTNM>RCT1250</POPRCTNM><ITEMNMBR>OFFICE-HOME</ITEMNMBR><VENDORID>MICROSOFT</VENDORID><VNDITNUM>OFFICE-HOME</VNDITNUM><UNITCOST>10</UNITCOST><QTYSHPPD>2</QTYSHPPD><QTYINVCD>2</QTYINVCD><Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable><LOCNCODE>MAIN</LOCNCODE><receiptdate>4/10/2012</receiptdate></taPopRcptLineInsert></taPopRcptLineInsert_Items><taPopRcptMultiBin_Items xsi:nil="true"/><taPopRcptLineTaxInsert_Items xsi:nil="true"/><taPopRctUserDefined xsi:nil="true"/><taPopDistribution_Items xsi:nil="true"/><taAnalyticsDistribution_Items xsi:nil="true"/>-<taPopRcptHdrInsert><POPRCTNM>RCT1250</POPRCTNM><POPTYPE>3</POPTYPE><VNDDOCNM>2000</VNDDOCNM><receiptdate>4/10/2012</receiptdate><BACHNUMB>TEST IMP CAD</BACHNUMB><VENDORID>MICROSOFT</VENDORID><CURNCYID>Z-C$</CURNCYID><XCHGRATE>0.98</XCHGRATE></taPopRcptHdrInsert><taMdaUpdate_Items xsi:nil="true"/></POPReceivingsType></eConnect>

=========================

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect POP Receivings Tax in GP 2013

    Hi, Did you find any solution for solve it?

    I need to send XML to PM and need that GP calculate the Taxes by default.

  • Chris Roehrich Profile Picture
    Chris Roehrich 289 on at
    RE: eConnect POP Receivings Tax in GP 2013

    Not sure what you mean by vendor taxes but I will give it a try.   You can get the Tax Schedule ID from the Vendor Card (PM00200.TAXSCHID).  Then the Tax Detail ID's for that Tax Schedule ID are in the TX00102.   So the following can be used to get the Tax Detail ID's for the Tax Schedule ID assigned to a Vendor ID named '1122':

    select TAXDTLID from TX00102 where TAXSCHID in (select TAXSCHID from PM00200 where VENDORID = '1122')

    The details like the Percentage and GL account for the Tax Detail ID are in the TX00201 table if you need to know the details.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect POP Receivings Tax in GP 2013

    Thanks Chris.

    I didn't know that the POP tax engine is not available in eConnect.

    do you know if there is away to get the Vendor taxes from SQL Server

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: eConnect POP Receivings Tax in GP 2013

    Hello,

    I think you are not using 'taPopRcptLineTaxInsert'

    msdn.microsoft.com/.../bb625299.aspx

    Thanks

    Sandip

  • Verified answer
    Chris Roehrich Profile Picture
    Chris Roehrich 289 on at
    RE: eConnect POP Receivings Tax in GP 2013

    You need to supply the tax node:

    taPopRcptLineTaxInsert

    In your XML you have <taPopRcptLineTaxInsert_Items xsi:nil="true"/> so you are not passing tax information.  There is no POP tax engine in eConnect like we have in SOP so you need to provide taxes manually.

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

Product updates

Dynamics 365 release plans