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

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

The field can have a maximum of 2 decimal places

(0) ShareShare
ReportReport
Posted on by 295

In purchase order line in direct unit cost, The system would not  accept 3 decimal places.

The following message appears.

Ex : "Your entry of 28.118 is not an acceptable value  for 'Direct Unit Cost Excl.VAT'. The field can have a maximum of 2 decimal places."

In General Ledger Setup .

Amount Decimal Places  = 2:3

Unit Amount Decimal Places = 2:3

Version : NAV 2013 R2 (7.10.35473)

Please Help.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    Where exactly you set Decimal places in General Ledger Setup?

  • Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    Check the Currencies setup also.

  • Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    You can change them in development environment

  • ErwinMT Profile Picture
    295 on at
    RE: The field can have a maximum of 2 decimal places

    This is my currency set up.  

    Amount Decimal Places = 2:3

    Unit Amount Decimal Places = 2:3

    Amount Rounding Precision = 0.001

    Unit Amount Rounding Precision = 0.001

  • ErwinMT Profile Picture
    295 on at
    RE: The field can have a maximum of 2 decimal places

    Development Environment

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    [quote user="ErwinMT"]

    Development Environment

    [/quote]

    With a developer license, you can modify the required field

    If you don't have developer licence, contact your NAV partner.

     

  • ErwinMT Profile Picture
    295 on at
    RE: The field can have a maximum of 2 decimal places

    I have a developer license and I can modify the settings

  • Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    Then go to the respective table and field and correct the settings..

    :)

  • ErwinMT Profile Picture
    295 on at
    RE: The field can have a maximum of 2 decimal places

    I already did that. Still no luck.

    This is my currency settings.

    Amount decimal places = 2:3

    Unit-amount decimal places = 2:3

    Amount rounding precision = 0.001

    Unit amount rounding precision = 0.001

  • Community Member Profile Picture
    on at
    RE: The field can have a maximum of 2 decimal places

    Did you correct field in  purchase order ?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans