web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Rashid Farooq Profile Picture
    1,000 on at

    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

  • 0x001a4 Profile Picture
    60 on at

    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.

  • Suggested answer
    Richard Whaley Profile Picture
    25,195 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans