Sales Order Quotes considered in Credit Limit Calculations

SOLVED

We're piloting the use of Sales Order Quotes and all of a sudden we have customers getting flagged with credit limits.  We want to keep open sales orders in the credit limit calculation but not open quotes.  How can we do this?

I saw the earlier post "Are Sales Order Quotes considered in Credit Limit Calculation?" but I have no indication that DSD multi-currency installed.  Its not showing on the installed modules listing and to my knowledge are not using multiple currencies.

  • +1
    verified answer

    I tested this on mine and quotes were not included.  What does this screen look like for your customer?

  • 0

    Check the values on the Credit pop-up screen.

    For a quote, "This Order" is zero (even when the quote total is non-zero), and there is no warning.

    For a standard order, "This Order" is non-zero, with the warning.

    There is also an option to check both the limit, and the Aging... so your extra warnings may not be from Quotes.

  • 0

    Thanks for the quick reply.  I'm double-checking the information I was given.  I've reproduced your example and indeed the credit limit was not flagged

  • 0

    Sorry the quick answer was too good to be true.  Actual customer data shows that the quotes are indeed impacting AR.  Below is from Customer maintenance:

    This is probably a rabbit trail question but I noticed that these quotes were from the previous week.  Would there be daily tasks or batch updates that would cause today's test quote to not be updated yet?

  • +1 in reply to KR169387
    verified answer

    Not in regular Sage 100.

    What matters is the value shown on the Credit pop-up, not there.  Are quotes included in THAT Open Order total?

    As I said, you may have Aging based warnings enabled too.  That 120 days aging amount could be the cause.

  • 0 in reply to KR169387

    Wait, you are looking at two different things.  The AGING are those orders that have been INVOICED.  The tab you are showing is the ORDERS information, or UN-INVOICED orders.

  • 0 in reply to Kevin M

    Ok so the Open Order Total in the Credit pop-up does not include the quotes.  It looks like the confusion came when that "Total Ordered Amt" of 51,416.08 plus the invoice "Balance" 52,951.33 touched on the credit limit - and the real culprit is the one, old invoice for $604.

    I've repeated this pattern on a customer without an old invoice and didn't have issue.  The total ordered in customer maintenance includes the quotes but the Credit pop-up from the Sales Order Entry module does not.  

    Thank you bethbowers and Kevin M for helping clear this up.