Search results matching tag 'eConnect 10'

Sop Integration Freight Calculation Error

Nvc — Wed, 09 Jun 2010 21:28:00 GMT

Hello!
I'm working with econnect 10, writing an integration for a sop
invoice. So far, the integration goes well, but I have an issue when
the invoice includes a freight amount.
I set the CREATETAXES = 1 and CREATEDIST = 1 and altough the taxes
calculate fine, the account distributions doesn't.

I send the information this way:
ivcHeader.FREIGTBLE = 0
ivcHeader.FRTSCHID = ivcHeader.TAXSCHID
ivcHeader.FREIGHT = FREIGHT_AMOUNT

But, in distributions, the account for FREIGHT doesn't calculate the
tax. I try to send the FRTTXAMT, but I get the error 866: Cannot pass
in tax and markdown amounts when creating taxes on the fly

Even if I remove the flag CREATETAXES, it doesn't calculate well. I compare the invoice created with econnect and other from GP, and everything is the same, except for the BKTFRTAM field. Is there any way to populate it?

Here's the XML code:

<?xml version="1.0" encoding="utf-8" ?>
- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/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>
- <taSopLotAuto>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>D000040411</SOPNUMBE>
<LNITMSEQ>16384</LNITMSEQ>
<ITEMNMBR>YR16943</ITEMNMBR>
<LOCNCODE>YR VENTA</LOCNCODE>
<QUANTITY>1</QUANTITY>
<LOTNUMBR>R822</LOTNUMBR>
<EXPNDATE>31/12/2020</EXPNDATE>
</taSopLotAuto>
- <taSopLotAuto>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>D000040411</SOPNUMBE>
<LNITMSEQ>32768</LNITMSEQ>
<ITEMNMBR>YR04076</ITEMNMBR>
<LOCNCODE>YR VENTA</LOCNCODE>
<QUANTITY>1</QUANTITY>
<LOTNUMBR>02D8</LOTNUMBR>
<EXPNDATE>01/03/2011</EXPNDATE>
</taSopLotAuto>
<taSopLotAuto xsi:nil="true" />
</taSopLotAuto_Items>
- <taSopLineIvcInsert_Items>
- <taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>D000040411</SOPNUMBE>
<CUSTNMBR>X01078</CUSTNMBR>
<DOCDATE>09/06/2010</DOCDATE>
<LOCNCODE>YR VENTA</LOCNCODE>
<ITEMNMBR>YR16943</ITEMNMBR>
<UNITPRCE>95.00000</UNITPRCE>
<XTNDPRCE>95.00000</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>D</DOCID>
<TAXSCHID>YR IVA INCLUIDO</TAXSCHID>
<AUTOALLOCATELOT>1</AUTOALLOCATELOT>
<UOFM>UNIDAD</UOFM>
</taSopLineIvcInsert>
- <taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>D000040411</SOPNUMBE>
<CUSTNMBR>X01078</CUSTNMBR>
<DOCDATE>09/06/2010</DOCDATE>
<LOCNCODE>YR VENTA</LOCNCODE>
<ITEMNMBR>YR04076</ITEMNMBR>
<UNITPRCE>140.00000</UNITPRCE>
<XTNDPRCE>140.00000</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<LNITMSEQ>32768</LNITMSEQ>
<DOCID>D</DOCID>
<TAXSCHID>YR IVA INCLUIDO</TAXSCHID>
<AUTOALLOCATELOT>1</AUTOALLOCATELOT>
<UOFM>UNIDAD</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>
<taCreateSopPaymentInsertRecord xsi:nil="true" />
<taCreateSopPaymentInsertRecord xsi:nil="true" />
</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>D</DOCID>
<SOPNUMBE>D000040411</SOPNUMBE>
<LOCNCODE>YR VENTA</LOCNCODE>
<DOCDATE>09/06/2010</DOCDATE>
<FREIGHT>30</FREIGHT>
<CUSTNMBR>X01078</CUSTNMBR>
<SUBTOTAL>235</SUBTOTAL>
<USER2ENT>admin</USER2ENT>
<BACHNUMB>CT09/06/2010</BACHNUMB>
<PRSTADCD>ENVIO</PRSTADCD>
<CREATECOMM>1</CREATECOMM>
<CREATETAXES>1</CREATETAXES>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<DEFPRICING>1</DEFPRICING>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>

Hope someone could help me on this :)

Inventory Master Import Error

venuasg — Mon, 17 May 2010 13:11:09 GMT

Hi All,

I get an error while importing through eConnect for taUpdateCreateItemRcd the error says "Cannot insert the value NULL into column 'UOFM', table TWO.dbo.IV00107; Column does not allow nulls. Insert Fails"

Following is my XML, can any one let me know am i missing something here.

<?xml version="1.0" encoding="utf-8" ?>

- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

- <IVItemMasterType>

<taRequesterTrxDisabler_Items xsi:nil="true" />

- <taUpdateCreateItemRcd>

<ITEMDESC>eCONNECT TEST ITEM</ITEMDESC>

<ITMCLSCD>MODEMS</ITMCLSCD>

<USCATVLS_6>YES</USCATVLS_6>

</taUpdateCreateItemRcd>

<taUpdateCreateItemCurrencyRcd_Items xsi:nil="true" />

<taIVCreateItemPriceListLine_Items xsi:nil="true" />

<taItemSite_Items xsi:nil="true" />

<taCreateItemVendors_Items xsi:nil="true" />

<taCreateKitItemRcd_Items xsi:nil="true" />

</IVItemMasterType>

</eConnect>

Re: Econnect GL Transaction

ravishankarp — Wed, 12 Aug 2009 17:02:29 GMT

Hi I am also getting the following error while integrating GL transaction having around 1600 GL Line Entris including Analytical Accounting information. I have changed the connection timeout in component services but no use.

I am trying to integrate GL Entries using eConnect. Some integrations are working fine but some integrations are giving the following errors

1) A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host)

2) The root transaction wanted to commit, but transaction aborted (Exception from HRESULT: 0x8004E002)

3) the timeout period elapsed prior to completion of the operation

Your urgent response (or) advise is required , as it is stopping the user activities.

Most of the times these errors are occuring if the xml file is large.

eConnect 10 GL Journals with Tax

paulus_999 — Wed, 15 Jul 2009 10:42:34 GMT

Hi All

Anyone out there know what the settings need to be in the Journal Line schema to allow a tax detail ID or tax schedule id to be recorded against a Journal Line.

This would effectively be the same as pressing the'Tax Entry' button on the Journal entry screen within GP

Thanks

Paul

eConnect 10 Install

Roshan — Wed, 01 Jul 2009 15:11:48 GMT

I installed eConnect10 runtime ,i am not able to see the details in the c:Program files\Common Files\Microsoft Shared\eConnect10 folder .i could see object,Release information,Requester Setup folders in the eConnect 10 folder.There is no XML Schemas,Services, eConnect Samples etc folders in the eConnect 10 folder.

I already have eConnect 9.0 in my system. Will this effect new instal

eConnect with Manufacturing and/or Horizons?

dev — Wed, 24 Jun 2009 18:09:50 GMT

Are there any custom nodes out there for the Dynamics Manufacturing or Horizons Manufacturing? I remember talking to some MSFT developers 3 or 4 years ago and they said some manufacturing functionality would be available soon, but I haven't heard anything since. Any alternatives out there? We have been doing screen-level integration and I can't tolerate it any more for obvious reasons...

Adding lines to an existing receipt

dev — Wed, 24 Jun 2009 18:05:02 GMT

Is there a way to insert line items via taPopRcptLineInsert onto an existing receipt? When I try to feed it the desired existing POPRCTNM, I get the error 'Input variable contains a duplicate document (POPRCTNM)". It works of course if I leave the POPRCTNM field empty, but it places each separate transaction on its own receipt and I would like to manage the receipts better than that. Any ideas?

Taxes not being caclulated during POPTransactionType integration

MaxBV — Tue, 23 Jun 2009 14:21:22 GMT

We are developing a PO integration with Non-Inventory items into GP10 using eConnect 10.

Microsoft Dynamics GP\Tools\Setup\Purchasing\Purchase Order Processing\Options.. configuration has
Tax Calculation: Advanced
Tax Options: Base on vendor for Non-inventory items, Freight and Misc

The sample integration XML looks like:

<?xml version="1.0" encoding="UTF-8"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eConnect.xsd">
  <POPTransactionType>
    <taPoLine_Items>
      <taPoLine>
        <PONUMBER>0014281</PONUMBER>
        <VENDORID>VEN1</VENDORID>
        <LOCNCODE>MAIN</LOCNCODE>
        <ITEMNMBR>ITM1</ITEMNMBR>
        <QUANTITY>3.00</QUANTITY>
        <PRMDATE/>
        <NONINVEN>1</NONINVEN>
        <InventoryAccount>0010-0000-1220  -000</InventoryAccount>
        <ITEMDESC>ITM1 DESC</ITEMDESC>
        <UNITCOST>123.45</UNITCOST>
        <UOFM>Each</UOFM>
        <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
        <Purchase_Site_Tax_Schedu>PURCH</Purchase_Site_Tax_Schedu>
        <ORD>16384</ORD>
        <NOTETEXT/>
       <CURNCYID>CAD</CURNCYID>
      </taPoLine>
    </taPoLine_Items>
    <taPoHdr>
      <PONUMBER>0014281</PONUMBER>
      <VENDORID>VEN1</VENDORID>
      <VENDNAME>VEN1 NAME</VENDNAME>
      <DOCDATE>2009-06-17</DOCDATE>
      <TAXSCHID>PURCH</TAXSCHID>
      <Purchase_Freight_Taxable>3</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>3</Purchase_Misc_Taxable>
      <FRTSCHID>PURCH</FRTSCHID>
      <MSCSCHID>PURCH</MSCSCHID>
      <CURNCYID>CAD</CURNCYID>
      <NOTETEXT>TEXT</NOTETEXT>
    </taPoHdr>
  </POPTransactionType>
</eConnect>

Vendor "VEN1" has TaxScheduleID="PURCH"
Vendor "VEN1" has Purchase address, which has TaxScheduleID="PURCH"
SiteID "MAIN" has TaxScheduleID="PURCH"

TaxScheduleID "PURCH" has GST in it, so it' 5%

eConnect 10 creates PO with PO lines no problem. However when I open PO in GP10 client header tax amount nor details tax amount are

calculated. When I change quantity or cost or Cut/Copy back TaxScheduleID in PO using GP10 client detail taxes get calculated on focus leave

from the editbox control.

It feels like the tax calculation engine is not being invoked by eConnect 10, because POP10100.TXENGCLD=0 for the integrated PO header.

What am I doing wrong that taxes don't get calculated during the integration? Is there a way to invoke or force tax re-calculation via eConnect 10?

Please advise me what to do.