Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kevin Brennan]

Hi,

How do we generate a report showing all of the notes attached to each customer card?

(We may want to manually review – and move some info to the “proper fields.”)

Is there a canned report in NAV?

Is there a way to pop this off using Jet Reports?

Thanks in advance for your help!

Regards,

-Kevin

——————————
Kevin Brennan
Coloramics LLC dba Mayco Colors
Hilliard OH
——————————

[Jason Wilder]

There is a system table called 2000000068 Record Links that store Notes and Record Links.  In NAV you would use the Record ID of your Customer and filter on this table something like  Customer.Record ID = Record Link.Record ID and Record Links.Type = Note.  Then you would need to stream the blob field called “Note” that holds the text of the note.  This is pretty easy to do from the NAV development environment.

Can’t imagine anything else that can do this including Jet reports since these fields are stored in a different format in SQL.  If you look at the Record Link table in SQL you will see both the Record ID and Note fields look like gibberish.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Kevin Brennan]

Thanks, Jason –

This gives me a path forward to explore. 

We’ll drop a tag note – like “Jason rocks” on a customer note, then search for that specifically in the related fields, as you suggested above.

I’ll look into how to search blob for specific text.

Regards,

-Kevin

——————————————-