Open Forum

Expand all | Collapse all

Customer Credit Limit

  • 1.  Customer Credit Limit

    Posted Feb 05, 2019 06:17 PM
    Does anyone know how the Over Credit Limit warnings are calculated?  Meaning, what is used to calculate the currently used portion of the Customer's Credit Limit?  Does NAV look at the Customer's Balance, the Customer's Balance plus Open Orders, the Customer's Balance plus Shipped Not Invoiced?  We are using NAV 2017.  Thanks!

    ------------------------------
    John Hawkins
    Accounting Systems Manager
    Wilks Brothers
    Cisco TX
    ------------------------------


  • 2.  RE: Customer Credit Limit

    TOP CONTRIBUTOR
    Posted Feb 05, 2019 07:38 PM
    If you allow the notification warning to occur, click on the Notification Details.... the page that opens shows you a list of amounts with balances used to determine the credit limit has been exceeded.

    Screenshots are from NAV 2017.

    Balance is sum of open customer ledger entries (you can drill into them from here. A great tool if a CSR is on the phone with a customer when they get this warning.) The Outstanding Amount comes from sales lines where the document type is order or invoice (the document does not need to be released however if released it will not be shipped and/or invoiced.) Next is a line showing amount shipped not invoiced. None of these seem to consider Blanket Orders or Credit Memos (posted or unposted.) Current, Total and Credit Limit as self explantory. This page also shows prepayments. I did not test how, if at all, prepayments will affect the limit calculation. If you use these, you can test this out.

    This was a great question and a fun one to figure out for you. Hope this helps. I learned something today!
    Notification Details
    Limit exceeded details

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software

    Join us at User Group Focus in Houston, March 13-14, 2019.

    Woo-hoo! There is a track for Business Analysts this year.

    Join me and my co-panelists and presenters at the following sessions:
    BAN75 - Ask the Analysts
    CFO90 - Ack! My A/P Person Just Left, What Do I Do Now?

    Not for you, check out the other great content at https://www.ugfocus.com/focus/locations/houston/houston2
    ------------------------------



  • 3.  RE: Customer Credit Limit

    Posted Feb 07, 2019 04:38 PM
    Thank you Cynthia!  This was very informative :-)

    ------------------------------
    John Hawkins
    Accounting Systems Manager
    Wilks Brothers
    Cisco TX
    ------------------------------



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