In which table sales order line level note will be saved in Dynamics GP 2013?
In above figure as i showed that note where it should be stored in GP Database table?
Advance Thanks for you all
*This post is locked for comments
The notes of the Line Items correspond to the notes of the Item itself and not to the Sales Transaction Line.
Record notes are stored in the table SY03900 (Record Notes Master), but the NOTEINDX you need is found in table IV00101 (Item Master) and not in table SOP10200 (Sales Transaction Amounts Work).
The following script will help you to find the note you are looking for:
SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, SY03900.NOTEINDX, SY03900.DATE1, SY03900.TIME1, SY03900.TXTFIELD
FROM IV00101 INNER JOIN SY03900 ON IV00101.NOTEINDX = SY03900.NOTEINDX
WHERE (IV00101.ITEMNMBR = 'REDMINOTE1')
SY03900 - Record Notes Master. It stored all notes with reference to NoteIndx field that is stored at SOP line record.
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
Share
Report
All responses (
Answers (