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$
*This post is locked for comments
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156