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 / Finance | Project Operations, Human Resources, ... / ValidTimeStateFieldTyp...
Finance | Project Operations, Human Resources, ...
Answered

ValidTimeStateFieldType in a table

(0) ShareShare
ReportReport
Posted on by Danial47 142

HI all,

In my salesorderlistpage form, all records do not display in the grid because of the date effective table of logisticspostal address.

When I update validto field from the database, I can see the records in the grid.

So what should I do to display all records in the grid?

Thanks.

  • Suggested answer
    Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    Hi Gunjan,

    Thank you so much for your guidance.

    I really appreciate your idea.

    Its worked finally....

    I changed the join type without any change in ValidTimeStateAutoQuery property.

    Thanks a lot.

    BR.

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: ValidTimeStateFieldType in a table

    Hi Danial,

    The join type needs to be changed from the underlying query. Please go to AOT > Queries > SalesTableListPage and change the join type.

    As for the ValidTimeStateAutoQuery property, please leave it as "AsOfDate" (the default value) for now and try again.

  • Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    When I set ValidTimeStateAutoQuery of salestable to daterange, my grid does not return any records!!

  • Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    Hi Gunjan,

    I can not change the join type.

    Thanks3683.PNG5228.PNG7120.PNG

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: ValidTimeStateFieldType in a table

    Hi Danial,

    Please go to Tools > Options > Development and turn on "Show all layers" for Application object layer. Please share a screenshot of the object so that we can see in which layers it is modified.

    You can also try setting the join mode to Outer join and check if you can see all the sales order records.

  • Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    join mode is innerjoin and fetchmod : 1:1

    anyway, i do not see any customization in CUS or USR layer.

    thanks.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: ValidTimeStateFieldType in a table

    Hi Danial,

    Sales order list page by default does not have LogisticsPostalAddress as a data source. I believe there is some customization don here.

  • Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    it is a default join of ax form, not customized.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: ValidTimeStateFieldType in a table

    What is the join mode between SalesTable and LogisticsPostalAddress?

  • Danial47 Profile Picture
    Danial47 142 on at
    RE: ValidTimeStateFieldType in a table

    Thanks for your reply, but I try it before, and does not work!!!

    I have many sales orders which not show in the grid.

    BR.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans