Announcements
Hi All,
Pls. advice which table will have the date shown on top of the notes windows.. for purchase receiving's
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 385 Super User 2026 Season 1
Subra 270
Martin Dráb 243 Most Valuable Professional
