DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Archives

 
Inventory account is not getting updated

Hi,

 I am creating an item using eConnect by assigining ItemClassID (ItemClassID has proper accounts are assigned).

even in this case my Inventory account is not getting updated.

I am using <taUpdateCreateItemRcd> to create an item, <ITMCLSCD>GOODS</ITMCLSCD> for classid also I am using <USEITEMCLASS>1</USEITEMCLASS>.

Note: If I edit the class and assign same classid again then it shows me two popups as follows

1. Do you want to update the item with information from class GOODS?

[Yes] [No] [Cancel]

2. Do you want to update the item posting accoounts and overhead defaults with costing information from class GOODS?

[Yes] [No]

If I click [Yes] in both the above cases and follow my procedure of filing PO, receiving PO and finally Purchasing Batches then inventory account adds the currosponding value - I want to do the same using eConnect.

 

Please help me out....

Thanks in advance.

~ Amol

[:|]

 

 
eConnect for updating Employee Information

Hello,

I am trying to use E-Connect 10 to update Employee Information in Microsoft Dynamics GP 10. Thanks to for a great "Getting Started" post. I followed it mostly and was able to use Serialization to build <taCreateEmployee> node. I also got it to update GP Employee record as expected.

Now, my problem is I am not sure how to update only some fields with this approach.

Is there a way where I can just update these 3 fields : PayrollStatus, EmploymentType and JobCode  and leave the other information on <taCreateEmployee> untouched using E-Connect. Please bear with me as I am a newbie to E-Connect.

Thanks again for your help. 

 

 

 
Item Tax Schedule cannot be populated when item is nontaxable or based on customer

Item Tax Schedule cannot be populated when item is nontaxable or based on customer

Grrrrr.

I was trying to insert a line into Dynamics 9 using this:

    <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>
            <taSopLineIvcInsert>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>STD00455415          </SOPNUMBE>
                <CUSTNMBR>20538          </CUSTNMBR>
                <DOCDATE>4/1/2010</DOCDATE>
                <LOCNCODE>001</LOCNCODE>
                <ITEMNMBR>HANSO~BARRINGER~MS 1967        </ITEMNMBR>
                <UNITPRCE>0.255</UNITPRCE>
                <XTNDPRCE>510.00</XTNDPRCE>
                <QUANTITY>2000</QUANTITY>
                <COMMNTID>               </COMMNTID>
                <PRCLEVEL>420538     </PRCLEVEL>
                <ITEMDESC>BARRINGER MS 1967 (HANSON)                                                                           </ITEMDESC>
                <TAXAMNT>61.2</TAXAMNT>
                <LNITMSEQ>163840</LNITMSEQ>
                <DOCID>STDORD         </DOCID>
                <SALSTERR>ATLANTA        </SALSTERR>
                <SLPRSNID>               </SLPRSNID>
                <ITMTSHID>GWINNETT       </ITMTSHID>
                <IVITMTXB>3</IVITMTXB>
                <TAXSCHID>GWINNETT       </TAXSCHID>
                <PRSTADCD>205380318081304</PRSTADCD>
                <ShipToName>PROVIDENCE GROUP LLC ,THE                                        </ShipToName>
                <CNTCPRSN>WARREN JOLLY                                                 </CNTCPRSN>
                <ADDRESS1>4311                                                         </ADDRESS1>
                <ADDRESS2>BAVERTON DRIVE                                               </ADDRESS2>
                <ADDRESS3>103                                                          </ADDRESS3>
                <CITY>SUWANEE                            </CITY>
                <STATE>GA                           </STATE>
                <ZIPCODE>30024      </ZIPCODE>
                <COUNTRY>                                                             </COUNTRY>
                <PHONE1>6797945492           </PHONE1>
                <PHONE2>                     </PHONE2>
                <PHONE3>                     </PHONE3>
                <FAXNUMBR>                     </FAXNUMBR>
                <ReqShipDate>4/1/2010</ReqShipDate>
                <FUFILDAT>1/1/1900</FUFILDAT>
                <ACTLSHIP>1/1/1900</ACTLSHIP>
                <SHIPMTHD>DELIVERY       </SHIPMTHD>
                <AUTOALLOCATELOT>1</AUTOALLOCATELOT>
                <GPSFOINTEGRATIONID>                               </GPSFOINTEGRATIONID>
                <INTEGRATIONID>                               </INTEGRATIONID>
                <QTYFULFI>2000</QTYFULFI>
                <UpdateIfExists>1</UpdateIfExists>
                <UOFM>each     </UOFM>
            </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true"/>
        <taSopTrackingNum_Items xsi:nil="true"/>
        <taSopCommissions_Items xsi:nil="true"/>
        <taSopLineIvcTaxInsert_Items xsi:nil="true"/>
        <taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>
        <taSopUserDefined xsi:nil="true"/>
        <taSopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taSopMultiBin_Items xsi:nil="true"/>
        <taSopHdrIvcInsert xsi:nil="true"/>
        <taSopToPopLink xsi:nil="true"/>
        <taSopUpdateCreateProcessHold xsi:nil="true"/>
        <taCreateSOPTrackingInfo xsi:nil="true"/>
        <taMdaUpdate_Items xsi:nil="true"/>
    </SOPTransactionType>
</eConnect>

 
GL00100 Account Master

Notes:

ACCTTYPE

  • 1 = Posting Account
  • 2 = Unit Account
  • 3 = Fixed Allocation Account
  • 4 = Variable Allocation Account
eConnect LICENSING

NOTE:

We don't intend this site to be an authority on licensing for eConnect or any other product, but I'm asked frequently how it is handled. I was send a communication from Microsoft that I'll copy below, and maybe it'll be a help. If there are any questions, please contact Microsoft. Also, please note the date of this entry (things change fast)

The question was how many licences do we need for our existing clients with customizations?
taPopEnterMatchInvHdr eConnect Error - Tax detail amount does not match the header tax amount

=================================================
Editor's note 7/17/2019 There are three eConnect nodes involved: taPopEnterMatchInvHdr, taPopEnterMatchInvLine, and TaPopRcptLineTaxInsert. This error indicates that the 'tax detail' (that's TaPopRcptLineTaxInsert) does not match the header (that's taPopEnterMatchInvHdr) 

Carefully look at those nodes, they have to sum to the same amount. The lines have to sum also, but you'll get a different error if they don't sum. 

The case below involves lines that don't sum, but usually it is because you have not included TaPopRcptLineTaxInsert at all. 

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

I'm trying to pass both header and item-level tax details for a purchasing invoice into GP, but I'm getting the error "tax detail amount does not match the header tax amount".

I have successfully used the header option "Use header level tax details", but I'd like to have more control and pass in both header and item-level tax details (I want to populate POP10360 with both).

 Here's my econnect.xml - thanks for any help you can provide:

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <SMTransactionBatchType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taCreateUpdateBatchHeaderRcd>
            <BACHNUMB>A-2010-04-21</BACHNUMB>
            <BCHCOMNT>Created by eConnect POP Purchasing Invoice 4/21/2010 11:35:31 PM</BCHCOMNT>
            <SERIES>4</SERIES>
            <GLPOSTDT>4/21/2010</GLPOSTDT>
            <BCHSOURC>Rcvg Trx Ivc</BCHSOURC>
            <DOCAMT>0</DOCAMT>
            <ORIGIN>2</ORIGIN>
            <NUMOFTRX>0</NUMOFTRX>
        </taCreateUpdateBatchHeaderRcd>
    </SMTransactionBatchType>
    <POPEnterMatchInvoiceType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateItemRcd xsi:nil="true"/>
        <taUpdateCreateVendorRcd xsi:nil="true"/>
        <taCreateVendorAddress_Items xsi:nil="true"/>
        <taPopRcptLineTaxInsert_Items>
            <taPopRcptLineTaxInsert>
                <VENDORID>ADVANCED0001</VENDORID>
                <POPRCTNM>RCT1552</POPRCTNM>
                <TAXDTLID>CANGST+PS7N0</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>83</ACTINDX>
                <TAXAMNT>0.70</TAXAMNT>
                <TAXPURCH>10.00</TAXPURCH>
                <TOTPURCH>10.00</TOTPURCH>
            </taPopRcptLineTaxInsert>
            <taPopRcptLineTaxInsert>
                <VENDORID>ADVANCED0001</VENDORID>
                <POPRCTNM>RCT1552</POPRCTNM>
                <TAXDTLID>CANGST+PS7N0</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>83</ACTINDX>
                <TAXAMNT>0.70</TAXAMNT>
                <TAXPURCH>10.00</TAXPURCH>
                <TOTPURCH>10.00</TOTPURCH>
                <RCPTLNNM>16384</RCPTLNNM>
            </taPopRcptLineTaxInsert>
            <taPopRcptLineTaxInsert>
                <VENDORID>ADVANCED0001</VENDORID>
                <POPRCTNM>RCT1552</POPRCTNM>
                <TAXDTLID>CANONPST+PS8N0</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>171</ACTINDX>
                <TAXAMNT>0.80</TAXAMNT>
                <TAXPURCH>10.00</TAXPURCH>
                <TOTPURCH>10.00</TOTPURCH>
            </taPopRcptLineTaxInsert>
            <taPopRcptLineTaxInsert>
                <VENDORID>ADVANCED0001</VENDORID>
                <POPRCTNM>RCT1552</POPRCTNM>
                <TAXDTLID>CANONPST+PS8N0</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>171</ACTINDX>
                <TAXAMNT>0.80</TAXAMNT>
                <TAXPURCH>10.00</TAXPURCH>
                <TOTPURCH>10.00</TOTPURCH>
                <RCPTLNNM>16384</RCPTLNNM>
            </taPopRcptLineTaxInsert>
            <taPopRcptLineTaxInsert>
                <VENDORID>ADVANCED0001</VENDORID>
                <POPRCTNM>RCT1552</POPRCTNM>
                <TAXDTLID>USCITY+PS1N0</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>169</ACTINDX>
                <TAXAMNT>0.10</TAXAMNT>
                <TAXPURCH>10.00</TAXPURCH>
                <TOTPURCH>10.00</TOTPURCH>
            </taPopRcptLineTaxInsert>
        </taPopRcptLineTaxInsert_Items>
        <taPopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taPopEnterMatchInvLine_Items>
            <taPopEnterMatchInvLine>
                <POPRCTNM>RCT1552</POPRCTNM>
                <POPMtchShpRcpt>RCT1551</POPMtchShpRcpt>
                <ShipRCPTLNNM>16384</ShipRCPTLNNM>
                <PONUMBER>PO2253</PONUMBER>
                <QTYINVCD>2.00000</QTYINVCD>
                <ITEMNMBR>LISA TEST 2</ITEMNMBR>
                <VENDORID>ADVANCED0001</VENDORID>
                <RCPTLNNM>16384</RCPTLNNM>
                <UNITCOST>5.00</UNITCOST>
                <EXTDCOST>10.00</EXTDCOST>
                <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
                <Purchase_Site_Tax_Schedu>CANONGSTPST+7*</Purchase_Site_Tax_Schedu>
                <TAXAMNT>1.50</TAXAMNT>
                <POLNENUM>16384</POLNENUM>
            </taPopEnterMatchInvLine>
        </taPopEnterMatchInvLine_Items>
        <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true"/>
        <taPopEnterMatchInvHdr>
            <POPRCTNM>RCT1552</POPRCTNM>
            <VNDDOCNM>PO2253_3way</VNDDOCNM>
            <receiptdate>4/21/2010</receiptdate>
            <BACHNUMB>A-2010-04-21</BACHNUMB>
            <VENDORID>ADVANCED0001</VENDORID>
            <VENDNAME>Advanced Office Systems</VENDNAME>
            <SUBTOTAL>10.00</SUBTOTAL>
            <TAXAMNT>1.60</TAXAMNT>
            <PYMTRMID>Net 30</PYMTRMID>
            <TAXSCHID>COMPANYPUR</TAXSCHID>
            <Purchase_Freight_Taxable>3</Purchase_Freight_Taxable>
            <Purchase_Misc_Taxable>1</Purchase_Misc_Taxable>
            <VADCDTRO>PRIMARY </VADCDTRO>
        </taPopEnterMatchInvHdr>
        <taMdaUpdate_Items xsi:nil="true"/>
    </POPEnterMatchInvoiceType>
</eConnect>


 
eConnect taPopEnterMatchInvHdrPOP error: "No Freight Tax Schedule" but using Base On Vendor

I'm sharing this error - I submitted it to MS eConnect team and it does seem to be a bug with eConnect and they plan on fixing this.  Version 9.0.3.0 of eConnect.

Getting same error for Miscellaneous taxes that's set up as Base on Vendor.

When it's Base on Vendor, there isn't a tax schedule assigned to
Freight. It uses all the tax details within the invoice-level tax
schedule to calculate the default taxes.  I even forced the setting of
the tax schedule and it still gave me this error. I then changed the tax
option to Taxable for freight and picked the same tax schedule as on the
invoice and then it worked. My guess is that something is up with Base
On Vendor.

Main parts of error:
Failed to transfer invoice to Great Plains - System.Exception: Sql
procedure error codes returned:
Error Number = 4807  Stored Procedure taPopEnterMatchInvHdr  Error
Description = No Freight Tax schedule, but a freight tax value was
passed in
Node Identifier Parameters: taPopEnterMatchInvHdr

POPRCTNM = RCT1560
Related Error Code Parameters for Node : taPopEnterMatchInvHdr
FRTTXAMT = 0.08000


My eConnect.xml file is at bottom of this corrrespondence.

 
Be careful with whitespace in node when serializing eConnect xml

No question, just something else to share from my co-worker.

Dim xs As New XmlSerializer(GetType

(eConnectType))

 

xs.Serialize(sw, econnect)

 

People might be interested in an issue I’ve run into with eConnect SOP. (And even if you’re not, I’m going to tell you anyway because it took me way too long to figure this out because there are a bunch of "yes, set default taxes" flags that I had to grind through before I realized what was happening, and that the documentation explicitly says "pass ‘’ into this parameter to clear it…")

It appears that in going from the model objects to the XML document, the serializer will collapse a run of whitespace into an empty node. (But it won’t when it’s something like "AARONFIT0001 " - whitespace is a wonky area in XML-land…) So (for example) if you want to leave the per-line-item Ship To Tax Schedule blank with a "<TAXSCHID> <TAXSCHID>", it will end up as <TAXSCHID></TAXSCHID> in the XML, and then when eConnect calls the stored procedure, it passes the argument as @I_vTAXSCHID=default Instead of actually passing in the whitespace, which is what I want. 

 
AR Historical Aging

This is a second version of the AR Aging script, it loops through the open RM transactions an updates the aging buckets

Note: This script (and every other script on this site) is provided 'as-is' and needs to be verified by a qualified accountant

 
Errors from IVInventoryTransactionType with taIVTransactionMultiBinInsert

I am receiving some strange errors when I try and include multi-bin data as part of an inventory transaction import with eConnect 10.0.4.

The inventory adjustment imports fine without multi-bin. But when I add the multi-bin, eConnect is returning errors that make it seem like the multi-bin record can't be included as part of the inventory transaction.  It is as if eConnect is trying to commit the multi-bin transaction before the IV Adjustment is saved.  Based on this, I'm assuming I will need to import the IV transaction first, then import the multi-bin, which I can do, but seems odd for this transaction.

Anyone else experienced this?

The errors I get when I include multi-bin:

 Sql procedure error codes returned:
Error Number = 5927  Stored Procedure taIVTransactionMultiBinInsert  Error Description = Document Number does not exist
Node Identifier Parameters: taIVTransactionMultiBinInsert                     

Error Number = 5932  Stored Procedure taIVTransactionMultiBinInsert  Error Description = Item does not exist on the document
Node Identifier Parameters: taIVTransactionMultiBinInsert                     

Error Number = 5936  Stored Procedure taIVTransactionMultiBinInsert  Error Description = Bin does not exist - set Create Bin flag
(CreateBin) = 1 if you want to create it.
Node Identifier Parameters: taIVTransactionMultiBinInsert                     

Error Number = 5945  Stored Procedure taIVTransactionMultiBinInsert  Error Description = The quantity passed in for Multi Bin is greater than what was passed to the line
Node Identifier Parameters: taIVTransactionMultiBinInsert                     

 

My full XML:

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <IVInventoryTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taIVTransactionSerialInsert_Items xsi:nil="true" />
    <taIVTransactionLotInsert_Items xsi:nil="true" />
    <taIVTransactionLineInsert_Items>
      <taIVTransactionLineInsert>
        <IVDOCNBR>00000000000000174</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>CC 750</ITEMNMBR>
        <TRXQTY>1250.0</TRXQTY>
        <UNITCOST>0.23</UNITCOST>
        <TRXLOCTN>REDRIVER</TRXLOCTN>
      </taIVTransactionLineInsert>
    </taIVTransactionLineInsert_Items>
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taIVTransactionMultiBinInsert_Items>
      <taIVTransactionMultiBinInsert>
        <IVDOCNBR>00000000000000174</IVDOCNBR>
        <IVDOCTYP>0</IVDOCTYP>
        <ITEMNMBR>CC 750</ITEMNMBR>
        <QUANTITY>1250.0</QUANTITY>
        <BIN>RED RIVER PLANT</BIN>
      </taIVTransactionMultiBinInsert>
    </taIVTransactionMultiBinInsert_Items>
    <taIVTransactionHeaderInsert>
      <BACHNUMB>MXIV0416</BACHNUMB>
      <IVDOCNBR>00000000000000174</IVDOCNBR>
      <IVDOCTYP>1</IVDOCTYP>
      <DOCDATE>2010-04-16</DOCDATE>
      <POSTTOGL>0</POSTTOGL>
      <MDFUSRID>MAXADMIN</MDFUSRID>
    </taIVTransactionHeaderInsert>
  </IVInventoryTransactionType>
</eConnect>

 
GL Trial Balance Script

Note:

 Like all scripts, this one is provided *as is*, without any warrantee for its suitability for your purpose. There is no substitute for due diligence

 
eConnect taPopRcptLineTax ACTINDX= 0 in POP10360

I'm sharing my original problem and then resolution here.

 Originally, I was only passing in the ACTINDX value:

<taPopRcptLineTaxInsert>

<VENDORID>ADVANCED0001</VENDORID>

<POPRCTNM>RCT1549</POPRCTNM>

<TAXDTLID>USCITY+PS1N0</TAXDTLID>

<TAXTYPE>0</TAXTYPE>

<ACTINDX>169</ACTINDX>

<TAXAMNT>0.91</TAXAMNT>

<TAXPURCH>90.25</TAXPURCH>

<TOTPURCH>90.25</TOTPURCH>

</taPopRcptLineTaxInsert>

Although I passed in a value > 0 for the account index, 0 appeared for this value in the POP10360 table and it would not post.

 

 

 
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3