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
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.
Record Link!!
Did you tried above mentioned link to extract?
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.
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.
Share
Report
All responses (
Answers (
2,807
