Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error while creating a...
Microsoft Dynamics GP (Archived)

Error while creating a sales entry using web services

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while creating a sales entry using web services

    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

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Error while creating a sales entry using web services

    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.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: Error while creating a sales entry using web services

    Hi Sai,

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while creating a sales entry using web services

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while creating a sales entry using web services

    Hi Babu,

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

    GP1.JPG

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

    Thanks,

    Sai

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: Error while creating a sales entry using web services

    Sai,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while creating a sales entry using web services

    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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: Error while creating a sales entry using web services

    Hi Sai,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans