web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Table cache property i...
Finance | Project Operations, Human Resources, ...
Unanswered

Table cache property in D365FO

(0) ShareShare
ReportReport
Posted on by CU10121822-0 380
Hi team, i do research on Cache lookup property on table and trying to understand, which lookup we should use when. As I understood...
 
None - No caching. Always fetch data from db. 
 
 
Found - Caches only if record founds.
 
Found and Empty - Caches for both exist and non exist record.  If record not existed in table , it's avoid to repeat the db call.
 
Entire table - it will store whole table in cache after first select.
 
Notintts - used cache outside transaction. Means if we used ttsbegin and ttscimmit, cache will not work.
 
Is am I correct?
 
Pls advise. thanks!
 
Categories:
Dynamics 365 Finance
I have the same question (0)

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 445

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 440 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans