DynDeveloper.com

This article discusses error 3770, Duplicate MSTRNUMB

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>

I'm trying to determine how and where GP is making this mistake.  Our users are entering sales orders for drop ships.  In the sales order, they are entering the manufacturer part number that corresponds to our part number in the sales order line comments (SOP10202).  Then, they generate a purchase order from that sales order (SOP60100) and those comments, which is the mfg. part number,  are added to the PO line item comments (POP10550) "automatically".

Approximately 30% of the time, the comments don't transfer over correctly.  

My question is this:  is there a stored procedure that gets executed to generate the PO or is it done programmatically by GP (leaving me no way to determine what is causing the comments to not match some of the time)?

Data and query below.

Thank you,

James

Howdy

Is there a way to create a work order via eConnect?

Thanks