Open Forum

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

Re-create Check Stub in SQL

  • 1.  Re-create Check Stub in SQL

    SILVER CONTRIBUTOR
    Posted 5 days ago
    ​Is there a way to create a report on 'Re-create check stub' using SQL that would capture all the credit memos applied to invoices in that payment as well?
    I am able to see all the invoices but no credit memos and would like to, if there is a possibility.

    Thanks!

    ------------------------------
    Namrita Lohani
    FNM
    Raleigh, NC
    ------------------------------


  • 2.  RE: Re-create Check Stub in SQL

    TOP CONTRIBUTOR
    Posted 5 days ago
    @Namrita Lohani
    If you're looking for a SQL view, try this one by @Victoria Yudin
    https://victoriayudin.com/2008/10/22/sql-view-ap-apply-in-gp/
    Thanks
    Windi​​

    ------------------------------
    Windi Epperson [Designation]
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    Norman OK
    405-946-1774 Ext 102
    ------------------------------



  • 3.  RE: Re-create Check Stub in SQL

    TOP CONTRIBUTOR
    Posted 5 days ago
    @Namrita Lohani
    Side note that you've tried the view but it doesn't include the credit memos.  I'm going to tap
    @Victoria Yudin again so she can chime in.

    Are the credits apply before the check run is done, or are they included as part of the check batch creation process?  Not sure if that matters but just asking.
    Thanks
    Windi​​​

    ------------------------------
    Windi Epperson [Designation]
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    Norman OK
    405-946-1774 Ext 102
    ------------------------------