Open Forum

Expand all | Collapse all

Remove credits from AR report

  • 1.  Remove credits from AR report

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


  • 2.  RE: Remove credits from AR report

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



  • 3.  RE: Remove credits from AR report

    Posted 4 days ago

    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

     






  • 4.  RE: Remove credits from AR report

    Posted 4 days ago
    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
    ------------------------------



  • 5.  RE: Remove credits from AR report

    NAVUG ALL STAR
    Posted 5 days ago
    @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
    ------------------------------



  • 6.  RE: Remove credits from AR report

    Posted 4 days ago
    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
    ------------------------------



  • 7.  RE: Remove credits from AR report

    NAVUG ALL STAR
    Posted 4 days ago
    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
    ------------------------------



  • 8.  RE: Remove credits from AR report

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



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