Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Credit Limit Issue

(0) ShareShare
ReportReport
Posted on by

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
    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
    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
    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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans