Sales Order Notes

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (5)

Answers (0)

Suggested answer

azelaya59 2,807 on at

Like (0)

Report

RE: Sales Order Notes

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.
Community Member Microsoft Employee on at

Like (1)

Report

RE: Sales Order Notes

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.
Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

RE: Sales Order Notes

Record Link!!

Did you tried above mentioned link to extract?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sales Order Notes

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.
Suggested answer

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: Sales Order Notes

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