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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Increase and decrease ...
Microsoft Dynamics AX (Archived)

Increase and decrease the number of decimal

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All

We have Increased the number of decimal places to 9 digests ,

xxpng.png

This resulted in the inability to reactivate revaluation currency function due to an imbalance some vouchers.

Now I need to re-reduce the number of decimal but I have a problem with the restrictions already posted.

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Increase and decrease the number of decimal

    Hi,

    Just wondering why has the number of decimal places been increased in the first place?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Increase and decrease the number of decimal

    Dear Dr.Ludwig

    Because currency in Egypt fell in value compared to the dollar.

    We needed to insert 6 number of i-decimal marks

  • Community Member Profile Picture
    Community Member on at
    RE: Increase and decrease the number of decimal

    Dear Dr.Ludwig

    There is another reason why we store finished goods with carton and we set price to Each  and carton contain 28 Each

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Increase and decrease the number of decimal

    What kind of error are you getting from reducing the size of the EDT?

    Numbers in the database are stored in datatype decimal(32,16), regardless of what the EDT says in AX.

    So if you make it smaller it cause truncation errors in AX. There is a way to correct that, but that requires adjusting all postings through SQL, which is NOT recommended. SQL doesn't really care about reducing decimal places in data.

    Solution would means updating the table through a SQL statement something like this:

    UPDATE dbo.GeneralJournalAccountEntry

    SET Amount = CAST(Amount as decimal(16,2))

    FROM dbo.GeneralJournalAccountEntry INNER JOIN dbo.GeneralJournalAccountEntry b ON dbo.GeneralJournalAccountEntry.Recid = b.Recid

    If you are going to try this, DO NOT do this on production but on a test environment.

    Disclaimer: This is purely a technical fix, functionality, you need to review every aspect, functionality and accounting wise.

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans