credit limit exceeded calculation

The current calculation for the credit limit exceeded calculation includes open invoices, open sales orders, and closed sales orders. How do I change it to not included closed sales orders?

  • 0

    The settings for Credit Limit Checking in AR Options are to use either the defined credit limit or the age of invoices on the A/R Aging, or to use both. It does not look at closed sales orders.  It will include open sales orders if you select the checkbox to include them.

  • 0 in reply to GerriV

    Thank you for your quick response, but unfortunately, that is not true in my system. I intentionally placed the limit of this one customer at open invoices + open sales orders, but I still get the credit limit exceeded message. There are closed sales orders listed on the S/O tab of this customer. When I set the credit limit to include those, the message goes away. I have checked the A/R Options, but it only gives a box to check to include Open S/Os. I didn't see an option related to Closed S/Os. Have you had this happen?

  • 0 in reply to Christine W
    Is it because you have the Aging Category for Credit Limit Exceeding warning set to only 30 days? That would result in any balance in the 30 day column to be calculating as exceeding the credit limit. Not on a dollar basis but on a day basis.
  • 0 in reply to Weidman
    Have you tried running the utility AR | Utilities | Recalculate Open Order Amounts? Possible the value may have gotten out of sync.