Skip to main content

Notifications

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) / AX2009 Advanced Query ...
Microsoft Dynamics AX (Archived)

AX2009 Advanced Query 1:N Fields Missing

(0) ShareShare
ReportReport
Posted on by lispyj 132

I have used the advanced query on the SaleTable form to link the SalesLines table to the SalesTable using 1:N.  When looking at the fields in SalesLine, not all of the table fields are visible.  Specifically, I am looking or RemainSalesFinancial.  What controls the whether fields are available using this query tool?

*This post is locked for comments

  • lispyj Profile Picture
    lispyj 132 on at
    RE: AX2009 Advanced Query 1:N Fields Missing

    Thanks.  I used the wrong table, as you suspected.  I linked the SalesLines, not the Order Lines.  Now that I look, the SalesLines is a view that I made myself!  

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 295,923 Super User 2025 Season 1 on at
    RE: AX2009 Advanced Query 1:N Fields Missing

    Hi Lispyj,

    What exact table did you link? When using the advanced query you will see table labels in stead of the technical names. Make sure the table Order lines is used. Then the field Invoice Remainder (RemainSalesFinancial) is normally visible. At least it does now in my environment.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Kempeth Profile Picture

Kempeth 4

#1
Andy Adamak Profile Picture

Andy Adamak 4

#1
Community Member Profile Picture

Community Member 4

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans