[Vicki Hillary]

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.

——————————
Vicki Hillary
RDV Corporation
Grand Rapids MI
——————————

[Barry Crowell]

Vicki,

Does accounting need to use the Report Writer GL trial balance report?  I ask because it would, in my opinion, be a lot easier to link to the notes for Payables from the SSRS report for the GL trial balance.

——————————
Barry Crowell
Senior Business Consultant
KTL Solutions, Inc
Frederick MD
——————————
——————————————-

[James Hummer]

?Here is a query that you can try to use and put it in SL. 

Note it only looks at GL20000 and PM30200 but brings in the Note Indx from Payables into GL

select a.NOTEINDX,

(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])

Jim

——————————
James Hummer
Consultant
Solver
Los Angeles CA
——————————
——————————————-