Sales Order Notes

(0) Share

Report

Posted on by Community Member

Hi,

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.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

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.

https://community.dynamics.com/nav/b/navisiontechnicalkulla/archive/2015/11/10/how-to-read-write-notes-in-navision-using-c-al

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

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.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,113 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Record Link!!

Did you tried above mentioned link to extract?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi CILG,

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.

Was this reply helpful? Yes No
Suggested answer

azelaya59 2,807 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No