Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Which table stores the Notes that are created by users while in the Sales Order page? I am creating a Jet report and would like to extract the notes that have been created on a Sales Order.
Hi, it is stored in Table ID 2000000068 "Record Link" table the linkage is by using Record ID. I think you cannot directly extract using Jet Report ,because "Note" is being stored in BLOB .
You might need to process first the data from Record Link to custom table to show the order no. and note in text format.
Thanks for your response. Ok i just checked and it doesn't come up as a table in jet reports so we will look at other options.
Did you tried above mentioned link to extract?
You can use the NL(BinaryText) function to return values from the BLOB (notes) fields.
The notes and memos stored in the Record Link table are tricky to get out of NAV because you have to do some concatenating.
Also, Jet Reports has no control over the conversion that happens via Windows and Excel when the BLOB is reconstructed in the workbook so you may see some strange characters returned by the Windows Codepage.
I have provided some screenshots below which show the basic setup of a report that will do this.
You would need to be using the fully licensed Jet Reports product in order to accomplish this, you can't do it with the free Jet Basics product.
The Record Link table is should be available regardless of what type of Dynamics NAV data source you are using in Jet Reports.
The object is 2000000068 - Record Link. The type is "Note". This object retains both "Links & Notes" It is also on the "Instance" level, so it will retain all Links and Notes for every company found within the instance.
Business Applications communities