Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Please, insert a customer with open balance

(0) ShareShare
ReportReport
Posted on by 60

Hi,

Im having a problem in the Apply Sales Document window, when inserting an specific customer ID it shows the message "Please, insert a customer with open balance", This customer does not have any pending invoices, how can I correct this ?

*This post is locked for comments

  • Suggested answer
    Joshua Page Profile Picture
    on at
    RE: Please, insert a customer with open balance

    Hi Gael!

    There's really only one supported method of changing the balance yype of a customer, basically what your doing is actually creating a new customer and keeping the old one for historical purposes. You'll need PSTL for this if you are on GP2010 as the tool noted below was in PSTL pre GP 2013. As always please test in a test company first to verify results

    Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012

    support.microsoft.com/.../871973

    1) Go to Microsoft Dynamics GP>Tools>Utilities>Sales>Customer Combiner Modifier.

    2) Change the ID of this customer using the tool (such as appending old to it).

    3) Enter a new customer with the original ID.

    4) Renter the transactions as needed for the "new" customer.

    5) You'll then need to reduce the original customers balance to 0. (A Credit document would do the trick on this part and there's other methods you could use as well depending on the exact situation).

    Thank you very much for your time and have a great day!

  • Gael Abreu Profile Picture
    60 on at
    RE: Please, insert a customer with open balance

    Hi Frank,

    It seems that I cant insert my customer in the Apply Sales Document window because it does not have "Open Balance", so I went to the customer card > options, and saw that this customer has "Forward Balance" Balance Type. How can I change this Balance Type to "Open Item"?

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Please, insert a customer with open balance

    You can't apply a payment or other credit document if there are no invoices to apply to.  What are you attempting to do?

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