Hi Everyone,
I'm hoping one of you may be able to shed light on this topic as I am attempting to create Inventory Variances in our database that override the quantity available.
For example, if the item# has a negative quantity available, I'd like the TRXQTY to override the negative quantity available values .
As of now I have successfully achieved this when passing a positive value but for some reason when I pass a negative value (to subtract from the inventory) it throws this error:
Sql procedure error codes returned:
Error Number = 1789 Stored Procedure= taIVTransactionLineInsert Error Description = The Transaction Qty (TRXQTY) exceeds the Qty available
Node Identifier Parameters: taIVTransactionLineInsert
IVDOCNBR = 9872422-CHARGEOFF
IVDOCTYP = 2
ITEMNMBR = 7-38545-02004
Related Error Code Parameters for Node : taIVTransactionLineInsert
TRXQTY = -278
If anyone has had success passing negative TRXQTY values when the quantity available is also negative I'd appreciate any advice or input.
Here is the xml I'm feeding:
<?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">
<IVInventoryTransactionType>
<taIVTransactionLineInsert_Items>
<taIVTransactionLineInsert>
<IVDOCNBR>9872422-CHARGEOFF</IVDOCNBR>
<IVDOCTYP>2</IVDOCTYP>
<ITEMNMBR>7-38545-02004</ITEMNMBR>
<TRXQTY>-278</TRXQTY>
<TRXLOCTN>CA2</TRXLOCTN>
<InventoryAccountOffSet>69709-01</InventoryAccountOffSet>
<OverrideQty>1</OverrideQty> (I added this line in manually on the Document Sender because even when set to 1 it didn't show up.)
</taIVTransactionLineInsert>
</taIVTransactionLineInsert_Items>
<taIVTransactionHeaderInsert>
<BACHNUMB>91+ CR</BACHNUMB>
<IVDOCNBR>9872422-CHARGEOFF</IVDOCNBR>
<IVDOCTYP>2</IVDOCTYP>
<DOCDATE>06/30/2020</DOCDATE>
</taIVTransactionHeaderInsert>
</IVInventoryTransactionType>
</eConnect>