ANSWERED - GP Changes Inventory Transaction Unit Cost

	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

telular 5/31/2016 3:47:48 PM

GP Changes Inventory Transaction Unit Cost

We are running GP 2010 and using eConnect to integrate inventory adjustment transactions. We want to force the unit cost per line item on the transaction, but GP seems to be changing our specified costs to the current cost somewhere in the background. Below is the XML we are submitting. For the line with item number 07T-10501 we are passing $17.15 as the unit cost. The integration goes through without error, but then when we look at the transaction in GP the cost is showing $16.71 (the current cost of that item). How can we get it to persist to the number we are passing, $17.15?

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

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

-<IVItemMasterType>

<eConnectProcessInfo xsi:nil="true"/>

<taRequesterTrxDisabler_Items xsi:nil="true"/>

<taUpdateCreateItemRcd xsi:nil="true"/>

<taUpdateCreateItemCurrencyRcd_Items xsi:nil="true"/>

<taIVCreateItemPriceListLine_Items xsi:nil="true"/>

<taIVCreateItemPriceListHeader xsi:nil="true"/>

-<taItemSite_Items>

-<taItemSite>

<ITEMNMBR>LABOR - PRODUCTION1</ITEMNMBR>

<LOCNCODE>CREATPRO</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>FLOOR PARTS - PRODUCTION1</ITEMNMBR>

<LOCNCODE>CREATPRO</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>613-00043</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>613-00044</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>617-00004</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>617-00005</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>072-00037</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>072-SMSX</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>07T-10401</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>07T-10501</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>391-00037</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>394-00010</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>399-CL4TVT-075-120J</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>601-00004</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>610-00003</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>610-00004</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>613-00022</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>613-00027-01</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>613-00028</ITEMNMBR>

<LOCNCODE>CREATE294</LOCNCODE>

</taItemSite>

-<taItemSite>

<ITEMNMBR>90HV1-W00GN/20TG075-120</ITEMNMBR>

<LOCNCODE>CREATPRO</LOCNCODE>

</taItemSite>

</taItemSite_Items>

<taCreateItemVendors_Items xsi:nil="true"/>

<taCreateKitItemRcd_Items xsi:nil="true"/>

<taCreateInternetAddresses_Items xsi:nil="true"/>

</IVItemMasterType>

-<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>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>LABOR - PRODUCTION1</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-1159</TRXQTY>

<UNITCOST>1.00</UNITCOST>

<TRXLOCTN>CREATPRO</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>FLOOR PARTS - PRODUCTION1</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-406</TRXQTY>

<UNITCOST>1.00</UNITCOST>

<TRXLOCTN>CREATPRO</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>613-00043</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-90</TRXQTY>

<UNITCOST>0.14</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>613-00044</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>0.13</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>617-00004</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>0.19</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>617-00005</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>0.19</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>072-00037</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>5.45</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>072-SMSX</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>0.80</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>07T-10401</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>63.85</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>07T-10501</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>17.15</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>391-00037</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>1.87</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>394-00010</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>12.35</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>399-CL4TVT-075-120J</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>158.87</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>601-00004</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>1.02</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>610-00003</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>2.11</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>610-00004</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>2.76</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>613-00022</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>2.67</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>613-00027-01</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>8.31</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>613-00028</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>-45</TRXQTY>

<UNITCOST>2.08</UNITCOST>

<TRXLOCTN>CREATE294</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

-<taIVTransactionLineInsert>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<ITEMNMBR>90HV1-W00GN/20TG075-120</ITEMNMBR>

<UOFM>EA</UOFM>

<TRXQTY>45</TRXQTY>

<UNITCOST>314.86</UNITCOST>

<TRXLOCTN>CREATPRO</TRXLOCTN>

<IVIVOFIX>3093</IVIVOFIX>

</taIVTransactionLineInsert>

</taIVTransactionLineInsert_Items>

<taAnalyticsDistribution_Items xsi:nil="true"/>

<taIVTransactionMultiBinInsert_Items xsi:nil="true"/>

-<taIVTransactionHeaderInsert>

<BACHNUMB>C05-31-16 01:24</BACHNUMB>

<IVDOCNBR>ADJ27148</IVDOCNBR>

<IVDOCTYP>1</IVDOCTYP>

<DOCDATE>5/31/2016</DOCDATE>

</taIVTransactionHeaderInsert>

</IVInventoryTransactionType>

</eConnect>

Version: GP 2010

Section: Dynamics GP, eConnect

DynDeveloper.com

GP Changes Inventory Transaction Unit Cost