We have a solution that creates SOs through eConnect. We have it deployed with a large number of customers, but we are getting a strange error with one customer. We are getting the following error...
Error Number = 928 Stored Procedure= taSopLineIvcInsert Error Description = Invalid Price Level Node Identifier Parameters: taSopLineIvcInsert SOPNUMBE = EDI178041 SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert PRCLEVEL = 2014 10 OFF Error Number = 9177 Stored Procedure= taSopLineIvcInsert Error Description = Currency/Price Level/UofM combination is not included in price list for this item Node Identifier Parameters: taSopLineIvcInsert SOPNUMBE = EDI178041 SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert NONINVEN = 0 UOFM = EA <taSopLineIvcInsert> <SOPNUMBE>EDI178041</SOPNUMBE> <SOPTYPE>2</SOPTYPE> <CUSTNMBR>WHI250</CUSTNMBR> <DOCDATE>2014-04-24</DOCDATE> <ITEMNMBR>1901050</ITEMNMBR> <UNITPRCE>0</UNITPRCE> <XTNDPRCE>139.75</XTNDPRCE> <QUANTITY>24</QUANTITY> <ITEMDESC>TRAUMEEL 50G</ITEMDESC> <DEFPRICING>1</DEFPRICING> <QtyShrtOpt>3</QtyShrtOpt> <NONINVEN>0</NONINVEN> <PRSTADCD>PRIMARY</PRSTADCD> <AUTOALLOCATELOT>1</AUTOALLOCATELOT> <UOFM>EA</UOFM> <PRCLEVEL>2014 10 OFF</PRCLEVEL> </taSopLineIvcInsert>
Obviously, the "Currency/Price Level/UofM combination" error is about a Price list not set up for the customer. Using the sample database, I can replicate that error message when passing in a Price Level/UOM that is currently not setup.
For this customer, in their company database, that price level/UOM IS setup. If you manually create a sales order with that same data, it works fine.
The only difference I see in this customers company database is they have "multi-currency" turned off, where in my sample company database, there is multi-currency, and I have to enter the Currency ID into the price level setting. For this customers database, you can not set any currency ID.
Does anyone think this might be the problem, or maybe a bug in eConnect when no currency id is setup, or turned off? Or can there be another setup problem elsewhere that I need to look into?
thanks
Bill
*This post is locked for comments