I have a eConnect vb 2005 application which takes products shipped from a shipping program and then puts invoices into great plains based on that info. My problem is that I need to check sufficient inventory levels before putting in a invoice which may cause a shortage...

 Accounting is sometimes late getting new inventory in the system, therefore a shipped product could come through with no inventory to cover it, then when the inventory is added after the invoice the costing gets screwed up...

 QUESTION: How can I check inventory levels of a product before integrating the invoice for the product?

 Doug Crowe

Simple:

Inventory is in IV00101, inventory quantities are in IV00102. Watch the rcrdtype field, 1 is a master record, 2 is a warehouse or location record. Just run a query on the IV00102 and get your quantity. Also look at the atyalloc field, that's the quantity allocated. That means that you have existing orders against that product.

 Will that work for you?

BTW, please post your successes here, as well as your questions. Anything cool that you figure out, help the community.

I am sure that would have worked, but I found a little simpler answer...

 In the taSopLineIvcInsert XML, I added "<QtyShrtOpt>5</QtyShrtOpt>" which causes a error to kick the document back when you try to send via econnect. then you can evaluate the error detecting shortage as the problem when it is relevant, which means I dont have to perform the check in every instance saving some resources and time in the flow.

 Doug Crowe

a value of 5 here for QtyShrtOpt does not cause a error to kick back as expected (as my great plains partner told me it would), in reality it only shifted the qty to the "Qty Canceled" field in the transaction rather than the qty billed field. This resulted in a extended price on the line of 0, which means the document amount was 0, causing a error of discount can not exceed document amount, cause the discount was set as if the qty was being billed.

 hope that makes sense to you. Anyway, I am now going to try unchecking "Allow Backorders" in setup, and change the QtyShrtOpt value to 3, meaning backorder all in the case of a shortage, my hopes are that trying to backorder when it isnt allowed will cause the error to come back like I want, therefore keeping the invoice from integrating, meaning it will remain in the shipping system.

 I will let ya know after I try it how this approach works.

Doug