Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SOP Multiple Customers...

SOP Multiple Customers showing up on single master #

(0) Share

Report

Posted on by Community Member

Orders are getting entered in GP manually and transferring to an invoice. They look fine in the Customer Inquiry windows and cash receipt windows, and when you drill into each document the document looks fine. The problem is when you drill into the Document details, where the Master Numbers show up, there are multiple customer Orders/Invoices to one Master Number. We ran Check Links on the Sales Series to correct the problem, and that worked, but the problem is still occurring whereby several customer orders/invoices are getting attached to one master number. Does anyone know if this is a bug that may have been fixed in Dynamics GP R2? We've corrected a couples, but the issue keeps happening. Thanks!

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SOP Multiple Customers showing up on single master #

Hello DMLibby

This is a known issue related to master numbers being assigned improperly. I have used a solution provided by MVP Mariano to get things solved out. Check it out on Using T-SQL and recursive CTE to find related sales documents

The same case was reported by Tim Foster on SOP Master Numbers not being assigned properly

Let us know if you need any further assistance,