Open Forum

Expand all | Collapse all

Credit Memo Application Visibility

  • 1.  Credit Memo Application Visibility

    Posted Sep 27, 2019 04:13 PM

    Hello,

    We have a large amount of credit memos that we have applied that we are trying to view how they got applied.  Is there an easy way to do this that you know of?

    Thank you!



    ------------------------------
    Andrea Boysun
    Assistant Controller
    Lucky's Market Parent Company LLC
    Niwot CO
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Credit Memo Application Visibility

    TOP CONTRIBUTOR
    Posted Sep 27, 2019 04:26 PM
    Edited by Ryan Galang Sep 27, 2019 04:30 PM
    Hi Andrea,

    First off, could you specify if you're referring to Payables / Receivables credit memos?

    At any rate, if you have SmartList Builder / Designer or if you're familiar with SQL - you can reference the apply tables:

    RM apply tables:
    • RM20201 - RM Apply Open File
    • RM30201 - RM Apply History File
    PM apply tables:
    • PM10200 - PM Apply To WORK OPEN File
    • PM30300 - PM Apply To History File
    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Credit Memo Application Visibility

    Posted Sep 27, 2019 04:31 PM

    It is for payables.  I believe we have a smart list for AR but not for AP.

    Thanks,

    Andrea



    ------------------------------
    Andrea Boysun
    Assistant Controller
    Lucky's Market Parent Company LLC
    Niwot CO
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Credit Memo Application Visibility

    GPUG ALL STAR
    Posted Sep 30, 2019 09:10 AM
    Hi @Andrea Boysun

    Rather than create a view or see it in SQL, if  you just want to "see" how it was applied, go to the inquiry screen ​and highlight the Credit Memo and then click the blue "Unapplied Amount" in the column listing.

    This lets you "see" what they are applied to.

    I would suggest grabbing a view from Victoria Yudin and using that in a SmartList if this is something you need to have at all times and easily reportable on.

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


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