News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to read date shown...

Finance | Project Operations, Human Resources, ...

Unanswered

How to read date shown on top of notes window

(0) Share

Report

Report

Posted on by Ravi Polepalli

186

Hi All,

Pls. advice which table will have the date shown on top of the notes windows.. for purchase receiving's

Categories:

Microsoft Dynamics GP

All responses Img

All responses (2)

Answers Img

Answers (0)

David Musgrave MVP ... 14,042 Most Valuable Professional on at

Like (0)

Report

RE: How to read date shown on top of notes window

From a Dexterity level, the field is 'Date' of window Form_Note_X of form Form_Note_X where X can be 1 to 5 depending on which of the five note windows is being used.
Tim Wappat 5,703 on at

Like (0)

Report

RE: How to read date shown on top of notes window

This should get you started, the date will be null if no record so use ISNULL({field},'') function to deal with that if you need to.

SELECT [VENDNAME],

SY03900.DATE1+SY03900.TIME1 as [DatePlusTime],

SY03900.DATE1 as [Date],

TXTFIELD as [Time]

FROM

POP10300

LEFT JOIN SY03900

ON POP10300.RCPTNOTE_1=SY03900.NOTEINDX

WHERE POPRCTNM='RCT335508'

Same for history but different table.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 601 Most Valuable Professional

#2

Abhilash Warrier 416

#3

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans