web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) In which table sales o...

Microsoft Dynamics GP (Archived)

In which table sales order line level note will be saved in Dynamics GP 2013

(0) Share

Report

Report

Posted on by Community Member

In which table sales order line level note will be saved in Dynamics GP 2013? 7484.Notes.png

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

SY03900 - Record Notes Master. It stored all notes with reference to NoteIndx field that is stored at SOP line record.

Was this reply helpful? Yes No
Verified answer

coquisalsa 2,725 on at

Like (0)

Report

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')

Was this reply helpful? Yes No
Galina 1,077 on at

Like (0)

Report

Actually, what you are pointing at is an Item Master note. Don't use it to put comment in the sales line.

The table you need is SOP10202

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans