You’re offline. This is a read only version of the page.
115
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
I understand this is old, but wanted to add my experience with this error.
I found while working with an eConnect integration that simple errors can often generate this as a "dummy" error. For example, once my SOPNUMBE did not match between my header and detail nodes.
So to anyone that comes across this for items that do have the UoM/Price Level setup, just do a quick double check of the basic format/layout of the XML file.
I think the issue is on <AUTOALLOCATELOT>1</AUTOALLOCATELOT> parameter. If you pass the value for this parameter to 1 (0=Auto; 1=Manual; 2=Mixed), then you need to use the <taSopLotAuto> node create a Lot Numbers as manually for the Sales item line. So, try to pass the Zero to this parameter and test again.
Note: Sometimes the eConnect error message may not related to the original field of the issue.
Hope this helps!!!
Hello Bill,
Additional to Saadi, Please make sure that the customers GP system & integrated source data maintained the same Price level value.
for the Error code 928: please check the Price level(if the integrated source data have unknown price level) results error.
for the Error code 9177: the combination of Currency & UofM & Price Level is not included in the price list(Item Price List Maintenance)
Yes, I have tried it with both passing in the Currency ID, and without passing the Currency ID, both with the same result on the environment without Multi currency.
Hello Bill
To be honest, I have never came across such a case. I don't believe it could be a bug, since our most common reaction for uncommon cases, Oh, it is a bug :)
Anyway, would it be possible for you to proceed your considerable test on the same environment without Multi currency ? Furthermore, are you passing the functional currency or leaving it blank ?
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (