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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Custom EDT - Problems ...
Microsoft Dynamics AX (Archived)

Custom EDT - Problems after string size increased

(0) ShareShare
ReportReport
Posted on by _MGP 506

I have a custom EDT which I am using within Purchase orders and it was 60 characters long.

I've changed it to 4000 characters, done a full data synchronisation (from data dictionary), closed the client, deleted the AUC client files and restarted the AOS.

All of the tables appear to have 4000 characters in the AOT and also aligned in the SQL database but I am getting errors when doing various operations.

Simply opening up the PurchTable from the AOT and filtering on the affected field causes a database error:-

Cannot select a record in Purchase orders (PurchTable).
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 11.0]Invalid precision value

Also, I get the same errors trying to run the modified SSRS Purchase order confirmation report.

Does anyone have any known solution or suggestion?

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    _MGP Profile Picture
    _MGP 506 on at

    Having read this post https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/177918/invalid-precision-value-error

    I decided to reduce the limit to 1000 characters and simply by synchronising the database it worked.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

    Hi,

    So, you were able to solve this error yourself now?

  • Verified answer
    _MGP Profile Picture
    _MGP 506 on at

    Yes a shorter max string length resolved the problem but it's weird that AX 2012 doesn't accept the SQL Server limit of nvarchar(max) on a table field. Especially as it does successfully sync the AOT with the SQL table defintion.

    Btw I would accept the answer on the forum but the "Did this answer your question?" buttons are not visible (because it was my suggestion?!)

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

    Hi MGP,

    I have verified the answers for you now. That is the reason why I did ask if your issue had been solved. You can't mark your own answers as verified.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans