Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How is it possible to check if there are any documents attached for a specific quality order in ax2012

Posted on by Microsoft Employee

Hello to everyone.

I am wondering if there is any way to check if there are any documents attached for a specific quality order in code. I tried by checking if RefCompanyId RefTableId and RefRecId exist in table DocuRef for a specific DataAreaId in InventQualityOrderLine but with no avail...

*This post is locked for comments

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: How is it possible to check if there are any documents attached for a specific quality order in ax2012

    That's exactly  what you need to do

    select firstOnly docuRef
    where docuRef.RefCompanyId == InventQualityOrderLine.DataAreaId
       && docuRef.RefTableId   == InventQualityOrderLine.tableId
       && docuRef.RefRecId     == InventQualityOrderLine.RecId;


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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans