eConnect Inventory Adjustment

MikeWal

unread,

Apr 20, 2010, 10:25:01 AM4/20/10

to

I am trying to process inventory transactions via eConnect. Increaes in
inventory process fine, but decreases do not. You can not use a negative
number for the transaction quantity, you indicate whether the adjustment is
an increase/decrease in the ADJTYPE field of taTransactionMultiBinInsert.
However it still increases inventory rahter than decrease. What am I missing
here?

Steve Endow

unread,

Apr 20, 2010, 6:54:57 PM4/20/10

to

Hi,

I have developed an eConnect inventory transaction integration that
imports negative numbers for decrease adjustments. It works fine.

Why do you say that you cannot use a negative number for transaction
quantity? Are you receiving a specific error?

What version of GP / eConnect are you using?

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

MikeWal

unread,

Apr 21, 2010, 9:30:04 AM4/21/10

to

I am using ver 10 of both. The error message I am getting is:

Event Type: Error
Event Source: Microsoft.Dynamics.GP.eConnect
Event Category: None
Event ID: 791
Date: 4/20/2010
Time: 3:17:30 PM
User: N/A
Computer: EMWEB
Description:
Microsoft.GreatPlains.eConnect Version=10.0.0.0
Microsoft.Dynamics.GP.eConnect

Sql procedure error codes returned:
Error Number = 5942 Stored Procedure taIVTransactionMultiBinInsert Error
Description = The QTY entered has to be > 0
Node Identifier Parameters: taIVTransactionMultiBinInsert

IVDOCNBR = 00000000000156585
IVDOCTYP = 1
ITEMNMBR = 22F S-3
QUANTITY = -8
BIN = M2EE
Related Error Code Parameters for Node : taIVTransactionMultiBinInsert

<taIVTransactionMultiBinInsert><IVDOCNBR>00000000000156585</IVDOCNBR><IVDOCTYP>1</IVDOCTYP><ITEMNMBR>22F
S-3</ITEMNMBR><QUANTITY>-8</QUANTITY><BIN>M2EE</BIN><CREATEBIN>1</CREATEBIN><OVERRIDEBIN>1</OVERRIDEBIN></taIVTransactionMultiBinInsert>
at
Microsoft.Dynamics.GP.eConnect.eConnectMethods.ExecStoredProcedures(String
xml)
at
Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String
ConnectionString, ConnectionStringType ConnectionType, String sXML,
SchemaValidationType ValidationType, String eConnectSchema)

Thx, Mike

"Steve Endow" wrote:

> .
>

Steve Endow

unread,

Apr 21, 2010, 4:13:46 PM4/21/10

to

Hi,

I see, thanks for the additional info. My integration is not using
bins. Let me test with a bin item and see what results I get.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

Steve Endow

unread,

Apr 21, 2010, 8:28:09 PM4/21/10

to

Hi,

I haven't modified my eConnect integration, but instead I just tested
this in the GP user interface with TWO and believe that you should be
sending a positive value to the TransactionMultiBinInsert node.

When the transaction is entered manually in GP, the Inventory
Adjustment line quantity is negative, but when you select the bin and
quantity on the Bin Quantity Entry window, you can only enter positive
numbers.

It is definitely inconsistent and not the greatest design (negative
extended quantity, but positive selected quantity), but it does appear
to properly decrement the bin quantity.

If you send a negative value for the adjustment line quantity, but a
positive value for the bin quantity, does eConnect import that without
errors and bring the transaction in properly?

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

MikeW

unread,

Apr 22, 2010, 10:37:01 AM4/22/10

to

Steve,

Thanks, you are right on target. I added a second quantity field. The
first is TRXQTY for taIVTransactiobLineInsert, the second is QUANTITY for
taIVTransactionMultiBinInsert. TRXQTY accepts the negative quantity, the BIN
level quanity must be positive.

Thx so much!!

"Steve Endow" wrote:

> .
>