Share
ReportI'm using Dynamics SL 7.0 & need to print the notes on a Crystal Report. I've tried PJNOTES with no luck.
*This post is locked for comments
You’re offline. This is a read only version of the page.
20
I'm using Dynamics SL 7.0 & need to print the notes on a Crystal Report. I've tried PJNOTES with no luck.
*This post is locked for comments
Aloha Mikki,
I also want to point out that adding a Note to the Timesheet in Dynamics SL is different than adding a note to the timesheet in Business Portal. Dynamics SL uses sNote as Barry mentions. Business Portal uses PJNotes, with a odd reference using PJNotes.key_value. What would be nice is if the notes were stored in the same location and can thus be referenced from either process.
Just a minor vent.
Aloha,
-Scott
Try sNote - that table holds notes for most SL functions.
(Projects can be an exception - it has its own table, but I think it also uses sNote.)
The nID field is the key, and holds the same value as the NoteId field in the related table.
So, if you add a note to, say, the Customer table, the note is held in sNote, where sNote.nID = Customer.NoteId.
Hope that helps
Barry
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (