Error while creating a sales entry using web services

(0) Share

Report

Posted on by Community Member

Using GP 2010 and Web services

I am trying to create a sales invoice using CreateSalesInvoice() of web service. I get error and looking server event log has following information.

Exception message:
Error Number = 9386 Stored Procedure taSopLineIvcInsert Error Description = No price level was found for the originating currency and DEFPRICING was set to 1 for a multi-currency transaction. eConnect does not currently support this configuration.

I understand that eConnect has a limitation (web service uses eConnect). But my question is how to get around this problem? Should I supply any parameter? Am I missing or passing something incorrectly? I have set PriceLevelKey on the invoice line to something other than DEFAULT.

More details or error from windows event log

Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = INV0808526
SOPTYPE = 3
Related Error Code Parameters for Node : taSopLineIvcInsert
DEFPRICING = 1

<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<CUSTNMBR>SAI15MAY0110593</CUSTNMBR>
<DOCDATE>2015-05-01T00:00:00+10:00</DOCDATE>
<ITEMNMBR>CCOL0AD1M</ITEMNMBR>
<AutoAssignBin>1</AutoAssignBin>
<TOTALQTY>1</TOTALQTY>
<PRCLEVEL>DIRECT</PRCLEVEL>
<DOCID>STDINV</DOCID>
<AUTOALLOCATESERIAL>0</AUTOALLOCATESERIAL>
<AUTOALLOCATELOT>0</AUTOALLOCATELOT>
<RequesterTrx>0</RequesterTrx>
<ALLOCATE>0</ALLOCATE>
<UpdateIfExists>0</UpdateIfExists>
<KitCompMan>0</KitCompMan>
<DEFPRICING>1</DEFPRICING>
<DEFEXTPRICE>1</DEFEXTPRICE>
<CURNCYID>Z-AUD</CURNCYID>
<IncludePromo>0</IncludePromo>
<CKCreditLimit>0</CKCreditLimit>
<QtyShrtOpt>2</QtyShrtOpt>
<QTYTBAOR>0</QTYTBAOR>
<QUANTITY>1</QUANTITY>
<QTYCANCE>0</QTYCANCE>
<RecreateDist>0</RecreateDist>
<SOPNUMBE>INV0808526</SOPNUMBE>
</taSopLineIvcInsert>

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Sai,

Have you setup the default price level for the item in GP.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Babu,

The item has price group as DEFAULT, Default selling U of M as EACH and Default price level as DEFAULT.

Should I change Default price level to something else?

Thanks,

Sai

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Sai,

No need to change that please check whether you have selected the default currency which should be same as your transactions currency.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Babu,

I guess it is set from what I can see in the screen.

I have updated my original post with more details of error from event log. See if it helps.

Thanks,

Sai

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

It looks like specifying currency key for the invoice caused the issue. It works now after I took it out.

I am specifying Unit price per line with Currency, Decimal digits, and Value. This works.

Thanks,

Sai

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (1)

Report

Hi Sai,

you need to provide ISO currency code AUD then it should work.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Sai,

Second Babu's comment... from your XML code it looks like you pulled the Z-AUD currency which are the demo currencies for the Fabrikam company... not the one that you setup in your price-list (which is AUD)..

If you don't specify a currency code, it will assume that the transaction is in functional currency of the company, but sometimes that's not what you want, especially in an MC environment.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Béat,

This is how I had provided currency. Not sure why it took it as Z-AUD.

CurrencyKey currencyKey = new CurrencyKey();
currencyKey.ISOCode = "AUD";
salesInvoice.CurrencyKey = currencyKey;

However, I have commented these lines now and supply currency only to invoice line(s).

Thanks,

Sai

Was this reply helpful? Yes No