: Currency/Price Level/UofM error

(0) Share

Report

Posted on by Bill Vanselow

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

All responses (5)

Answers (0)

GMA 1,072 on at

Like (1)

Report

RE: : Currency/Price Level/UofM error

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.
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: : Currency/Price Level/UofM error

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!!!
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: : Currency/Price Level/UofM error

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)
Bill Vanselow 115 on at

Like (0)

Report

RE: : Currency/Price Level/UofM error

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.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: : Currency/Price Level/UofM error

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,