Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Web Services - Creatin...
Microsoft Dynamics GP (Archived)

Web Services - Creating Purchase Order - Decimal Places do not match setup

(0) ShareShare
ReportReport
Posted on by 0x001a4 60

I'm trying to create a purchase order in GP via web services. Our functional currency is set to CDN, for example, and our PO is going to be in USD.

 

Whenever I try to send it over I get this response from web services: 

A validation exception has occurred. Validation Errors: - Decimal Places passed in for UnitCost does not match setup. 7b27

 

This is the message in the event viewer log for eConnect: 

Microsoft.GreatPlains.eConnect Version=9.0.0.0

Microsoft.GreatPlains.eConnect

 

Sql procedure error codes returned:

Error Number = 6621  Stored Procedure taPoLine  Error Description = Decimal Places passed in for UNITCOST does not match setup

Node Identifier Parameters: taPoLine                                           

POTYPE = 1

PONUMBER = C123456

VENDORID = BLAHBLAH

Related Error Code Parameters for Node : taPoLine                                           

UNITCOST = 385.35

 

As you can see there is only 2 decimal places. I know this has something to do with currency because if I put together the exact same PO but use CDN currency, it works fine. Now if I take the decimal places off, I get a new message:

Microsoft.GreatPlains.eConnect Version=9.0.0.0

Microsoft.GreatPlains.eConnect

 

Sql procedure error codes returned:

Error Number = 492  Stored Procedure taMCCurrencyValidate  Error Description = This company does not have access to this Currency ID or is Inactive

Node Identifier Parameters: taMCCurrencyValidate                               

DOCDATE = 2010-10-07T00:00:00

Related Error Code Parameters for Node : taMCCurrencyValidate                               

CURNCYID = Z-US$

The vendor is definitely active and not having access to the currency doesn't make any sense because I can go into GP and create the same PO manually without a problem. 
Any help is greatly appreciated.

*This post is locked for comments

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Web Services - Creating Purchase Order - Decimal Places do not match setup

    Opps, the correct value for DECPLCUR to have 2 decimal places is 3. value 1=0 places, value 2=1 decimal place, 3=2 decimal places, etc

    The field is in several tables.  Each item has the field in the item master and when the item is copied to the sales order or purchase order, the value is copied to a field with the same name in the SOP amounts work SOP10200 table or the PO amounts work.

    It may simply be a matter of the item not being correctly setup in the Item Master.  Check that first.

  • 0x001a4 Profile Picture
    0x001a4 60 on at
    Re: Web Services - Creating Purchase Order - Decimal Places do not match setup

    Where would I find this field? I'm not using the econnect interface but I am using web services. I don't see a field that matches what you're describing.

  • Rashid Farooq Profile Picture
    Rashid Farooq 1,000 on at
    Re: Web Services - Creating Purchase Order - Decimal Places do not match setup

    Do not to focus on UnitCost field, set the value of field DECPLCUR.  The error message also not talking about UnitCost decimal places, it may require decimal places of DECPLCUR field.

    e.g: DECPLCUR = 2

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans