Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Add Notes from both GL and AP

  • 1.  Add Notes from both GL and AP

    SILVER CONTRIBUTOR
    Posted 7 days ago

    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

    GOLD CONTRIBUTOR
    Posted 6 days ago
    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
    ------------------------------



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

    SILVER CONTRIBUTOR
    Posted 5 days ago
    ​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
    ------------------------------