ANSWERED - Sop Integration Freight Calculation Error

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Nvc 6/9/2010 5:28:00 PM

Sop Integration Freight Calculation Error

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>

<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>

<taCreateSopPaymentInsertRecord_Items>

<taCreateSopPaymentInsertRecord xsi:nil="true"/>

</taCreateSopPaymentInsertRecord_Items>

<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>

</SOPTransactionType>

</eConnect>

Hope someone could help me on this :)

Version: Unknown or N/A

Section: eConnect

DynDeveloper.com

Sop Integration Freight Calculation Error