Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Same check for 2 customer's ID

Posted on by 225

Hi folks,

We have some customers who hold 2 different customers' ID in GP. Sometimes they sent us only 1 check for different invoices on 2 IDs. Is there a way to split out the check to apply against the invoices? 

Thank you in advacne for your advice.

*This post is locked for comments

  • Nhi Nguyen Profile Picture
    Nhi Nguyen 225 on at
    RE: Same check for 2 customer's ID

    Hi all,

    Thank you so much for your prompt assistance.

    I have solved the issue with Customer combiner or modifier.

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: Same check for 2 customer's ID

    Also if the both customers are same and two customer id was created by mistakenly or some reason. They can combine both customers to single with using PSTL tools.'

    Please have a look on the Customer combiner or modifier.

    mahmoudsaadi.blogspot.ae/.../customer-combiner-utility.html

    Hope this helps!!!

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Same check for 2 customer's ID

    Another thought about national accounts, which I think is the correct method to use, is that you could set up a third customer to act solely as the parent for the other two customer IDs. Conceptually I have had this method work better for folks who consider each ID 'equal' instead of parent/child.

    Kind regards,

    Leslie

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Same check for 2 customer's ID

    If one customer to belongs to another customer, then you can setup National Accounts Customer to apply a single check from parent custom to child customer.

    Please have a look on the below link to analyse and setup the National Accounts if this functionality meets your business process.

    community.dynamics.com/.../national-accounts-for-receivables-in-dynamics-gp

    Hope this helps!!!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Same check for 2 customer's ID

    Other thought - first is there a reason for the single customer to have multiple IDs in the system?

    Is there a reason for this, or is it due to 'user error' when the order entry people are allowed to enter Customers and don't look very hard and therefore enter extra copies of the same customer?

    Reason I ask is we encountered this some time back and we periodically did a Customer ID Cleanup and used the PSTL tools to combine the two or three IDs into a single ID.  All records and transactions are combined and nothing is lost.

    Let me know what you think of the idea?  It works well.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Same check for 2 customer's ID

    Record two different cash receipts (which are practically one), for the same payment issued by your customer. They can be applied separately to the different invoices accordingly.

    Isn't this practical ?

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