Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Entry Prompts to A...
Microsoft Dynamics GP (Archived)

SOP Entry Prompts to Add customer ID repeatedly even if customer exists.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Appreciate if you could help us resolve this issue in SOP Entry Screen.

When the user enters an existing customer id and tabs out it prompts "Do you want add the customer ? Yes, No

Even if the user clicks "yes" or "no" it keeps prompting the message again and again. The user is stuck and forced to forcefully close the session by end task.

The issue occurs intermittently and randomly with different users. 

There is customization which uses a database trigger to calculate a handling charges based on a percentage defined in customer maintenance user defined field. The Trigger is triggered at the line Item level .

Environment info: MS Dynamics GP 2016R2

SQL : SQL Server 2014 

Regards,

Satish Mulgi

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP Entry Prompts to Add customer ID repeatedly even if customer exists.

    Thanks for your response. Just did a code walk through with the developer and identified some unwanted logic added to customer id change event. We have disabled these scripts in the customization and deployed the chunk. Waiting for feed-back.

    i believe this would solve the problem.

    Thanks for support. Appreciate it

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: SOP Entry Prompts to Add customer ID repeatedly even if customer exists.

    Another silly thing to check is that users are not copying the customer id from another document with copy and paste and sometimes "catching" an extra hidden character or space at start or end of the customer id?

    I've seen this happen in the wild for item SKU numbers. 

    Tim.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: SOP Entry Prompts to Add customer ID repeatedly even if customer exists.

    First check if issue is occurring because of the customization by disabling the customization by going to tools>> customize>>Customization Status and disable the customization, if there are database triggers defined on SQL level then also disable them, if you will not get any issue then  it means customization is breaking gp code and forcing it to misbehave. :)

    After know the reason of issue we can solve it nicely.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans