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) / Error in All Purchase ...
Microsoft Dynamics AX (Archived)
Answered

Error in All Purchase Order

(0) ShareShare
ReportReport
Posted on by AX 2012 r3 2,426

Good Morning,

While opening All purchase order i am getting the following error

"Cannot read a record in Purchase orders (PurchTable).
An unsupported NULL value has been selected from the database.


[Microsoft][SQL Server Native Client 11.0][SQL Server]Changed language setting to us_english.

Cannot read a record in Purchase orders (PurchTable).
An unsupported NULL value has been selected from the database.


Microsoft][SQL Server Native Client 11.0][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation."

Please help me.

Regards.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Did you insert/update records in the AX database directly from any other source than AX, like SQL or third party applications? That could cause such problems, and you should never do such a thing.

    You need to find which record in your SQL database that has the unsupported value and adjust it to the default value which is supported by AX.

    Another reason could be a corrupt or old usage data for that form. Go to File > Tools > Options > Usage data > Reset.

  • Verified answer
    AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at

    Good morning Vilmos,

    Thanks for your reply..i did that but again that error is coming.

    I resolved that

    Solution : Just i synchronized purchtable and restored and saved and compiled..

    Now its opening fine.

    Thanks,

    Have a good day.

  • GSK Profile Picture
    GSK 70 on at

    Hello Vilmos,

    I came across the same issue as the person who started this thread, and although that issue seemed to have been resolved in a different way than you suggest, I followed your suggestion and that worked fine for me.

    Thanks for the advice.

    BR

    GSK

  • AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at

    Hi Geert,

    Can you share what have you done.

    It may help others in future.

    Please update the thread.

    Regards.

  • AFROZ SHAIK Profile Picture
    AFROZ SHAIK 5 on at

    How to resolve the same issue in D365 F&O?

    Does your solution apply for D365 F&O?

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!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans