Open Forum

Expand all | Collapse all

Remove credits from AR report

  • 1.  Remove credits from AR report

    Posted Sep 11, 2019 02:07 PM
    Can anyone tell me how to run an AR report without credits showing? I just want to see the people I need to collect on.

    ------------------------------
    Jennifer Jones
    Cinch Kit, LLC
    Houston TX
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Remove credits from AR report

    Posted Sep 11, 2019 09:43 PM
    Specifically, there are filter options for Balance Amount, just set that to be "greater than Zero"

    "Outstanding Sales Aging Report" is the title. It could also be "Aged Accounts Receivable Report".

    If the picture I'm attaching transfers properly, that is what the window looks like:


    ------------------------------
    Brett Hensley
    Business Development Manager
    Technology Management Concepts
    El Segundo CA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Remove credits from AR report

    Posted Sep 12, 2019 02:59 PM

    Thank you for your reply. This did work for me. However, is there a way to just see past due only? I can not find what filter to use for that.

     

    Jennifer signature

     




    Conference-BCNAVUG_200x200


  • 4.  RE: Remove credits from AR report

    Posted Sep 12, 2019 03:36 PM
    Hi Jennifer:

    If you run the aging by due date instead of invoice date, and use the "show if overdue by" field (key in the number of days beyond due date that you want to see, I used 5D and it gave me everything that was over 5 days past due). I hope this helps you out.

    Thanks,
    Steve



    ------------------------------
    Steve Caredeo
    General Accounting Manager
    FoodState
    Manchester NH NH
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Remove credits from AR report

    NAVUG ALL STAR
    Posted Sep 12, 2019 06:42 AM
    @Jennifer Jones,

    You may want to consider using the Credit Management feature for collections instead of just the ageing. You can filter by Customers with a Balance greater than zero. The factbox for Credit information also provides contact information, payment methods, terms, last payment info, credit limit, etc.


    ------------------------------
    Amanda Mayer
    New View Strategies
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Remove credits from AR report

    Posted Sep 12, 2019 03:01 PM
    Thank you! I never knew this even existed. Is there a way to run a report from her that just shows past due accounts? Also, do you provide any consultation services?

    ------------------------------
    Jennifer Jones
    Cinch Kit, LLC
    Houston TX
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Remove credits from AR report

    NAVUG ALL STAR
    Posted Sep 12, 2019 03:53 PM
    Jennifer,

    Unfortunately, I do not see one, since it is linked to the Customer table and not the Customer Ledger Entry table. Personally, I like this view and would re-consider my internal process to see how best to utilize it, because of all the additional information in the factboxes.

    If that doesn't work, then the suggested filtering on the ageings or a saved view of the Customer Ledger Entries where the Due Date is equal to yesterday (t-1d) double sorted on Remaining Amount and Customer Number might be your best option.


    ------------------------------
    Amanda Mayer
    New View Strategies
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: Remove credits from AR report

    Posted Sep 12, 2019 08:58 AM
    Hi Jennifer:

    If you have a customer that has open invoices and open credits, and you just want to see the open invoices, the best way to do this is to use the Customer Ledger Entries screen, and use the following filters: Open = "Yes", and Document Type = "Invoice" (see screenshot below). From there you can Print to Excel, and create a pivot table by Customer No.

    If you just want to see customers that don't have an overall credit balance, then Brett Hensley's suggestion on running an Aged Accounts Receivable Report, with a filter of Balance >0.00 would work.

    Good luck !!
    Steve



    ------------------------------
    Steve Caredeo
    General Accounting Manager
    FoodState
    Manchester NH NH
    ------------------------------

    Conference-BCNAVUG_200x200


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