We are utilizing the Notes feature (yellow sticky note) in both our general journal entries as well as voucher notes for our payables transactions. Now that we have all of these "notes" everywhere, Accounting would like to include them on the TB Detail report and/or in a Smartlist Builder report. I am able to add the notes by linking the Records Notes Master to the Note Index, but that only gives me the notes entered for the general posting journals. How can I add the Voucher Notes to the report for any payables transactions? If it originated in the GL, they want to see those notes, if it originated in payables, they want to see the voucher notes - they only want to run one report.
(convert(varchar(255),[c].TXTFIELD)) as GLNote,
(Select MAX(y.NOTEINDX) from PM30200 y where y.VENDORID = a.ORMSTRID and y.DOCNUMBR = a. ORDOCNUM) as PMNote
from GL20000 a
LEFT OUTER JOIN [dbo].[SY03900] c ON (a.[NOTEINDX] = c.[NOTEINDX])