Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Credit Limit Issue

Posted on by Microsoft Employee

Hello all,

I am having an issue with Credit Limits in GP. One of our clients is getting the "This transaction exceeds the customer's credit limit. Do you want to continue?" message. I looked at the Customer and they had a Credit Limit of $100,000. They only have $30,000 of open invoices. The moment they type in more than $20,000, they get the error message. 

* I am getting the total number by adding all open & work invoices and/or by running the AR Aged Trial Balance. I normally compare the 2.

I have tested this on other customers, and get varying results. Some seem to be showing similar issues while others are completely fine. I cannot find the common denominator between them.

Other things I have noted:

  • In Receivables Management Setup, Display Over Credit Icon and Warn If Customer Over Credit are unchecked
  • There are no Process Holds Setup (I saw something that mentioned this in a different post)
  • The Credit Limit Warning for the Customers is the same as the amount
  • The customer isn't on hold or inactive
  • I ran the Report only (not reconcile) for the Reconcile Current Customer Information and did not see anything that I thought would cause the issue

Has anyone ever seen something like this or have any ideas about what could be causing it?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Credit Limit Issue

    I ran the report only (not the full reconcile because I will have to take the company down to make a backup first and they are very busy) and did not see anything that would be causing an issue. There was an amount On Order for the customer that would be removed but it was only for about 20k. It still wouldn't equal the amount needed for them to get the Credit Limit message.

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Credit Limit Issue

    On to the next step.

    Let's make sure everything lines up so run a reconcile on both the Current Customer Information and the Outstanding document amounts

    Microsoft Dynamics GP > tools > utilities > Sales > Reconcile

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Credit Limit Issue

    Jeffrey,

    Unfortunately, it doesn't look like that is the issue either. All of them are set to the same amount as the Credit Limit.

    In the If Total Balance Due Exceeds: $100k

    Of If the Sum of (field is blank) and Beyond Exceeds: $0.00

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Credit Limit Issue

    Hi RM82

    One more thing for you to check is the Display Credit Limit Warning on the customer record.

    Open the customer master record  Cards > Sales > Customer. Click on Options

    On the credit limit line you may have 100,000 entered. Click on the Blue arrow pointing to the right

    Check and see if any conditions are entered based on over due aging periods.

    This may be causing your issue.

    If not, let us know and we can think of some other trouble shooting tips.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans