Open Forum

Expand all | Collapse all

Add Notes from both GL and AP

  • 1.  Add Notes from both GL and AP

    Posted Dec 04, 2018 02:40 PM

    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

  • 2.  RE: Add Notes from both GL and AP

    Posted Dec 05, 2018 01:05 PM

    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

  • 3.  RE: Add Notes from both GL and AP

    Posted Dec 06, 2018 01:41 PM
    ​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])


    James Hummer
    Los Angeles CA

If you've found this thread useful, dive deeper into User Group community content by role