Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales document detail ...
Microsoft Dynamics GP (Archived)

Sales document detail inquiry errors

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

We have an instance of sales document information that seemingly got crossed.  Two separate sales orders for different Customers transferred to invoices.  When you open the Sales Doc detail inquiry window for either of the sales orders you see the quote, order and invoice information for all the sales documents - not just for one set as expected.  Quote A, Quote B, Order A, Order B, Invoice A, Invoice B etc.. are appearing in the inquiry window for both Order A and Order B - not just the document information pertaining to the single order.

Both invoices have been posted.  We have run Checklinks on the Sales series which did not resolve the issue.  How can we get this information to display correctly?  thank you..

 

*This post is locked for comments

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Sales document detail inquiry errors

    As Leslie suggested, check the Master Numbers in the transactions.  The master number is assigned to the original transaction document and the same number appears on all documents for the transaction.  Each transaction, not each document, needs to have separate master numbers.  So, a Quote is transferred to an Order, and that order is transferred to an Invoice and all 3 have the same master number.  But the next Quote/Order/Invoice are supposed to have a different master number.  Do your crossed document sets all have the same master number?

    There is a hole in GPs logic when the collection of sales documents in the work tables SOP10100 is large and sometimes duplicate Master  Numbers could be generated.  Check this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales document detail inquiry errors

    Hi Leslie,

     I ran select statements on the sop30200 for the order numbers and the invoice numbers.  The originating number for each invoice is the correct order number, no crossover.  Very weird!   The connection only seems to exist in the inquiry window, I can't find any other connection between the two sets of documents.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Sales document detail inquiry errors

    The only way I can think of to fix it is to edit the Sales Transaction Work and History files to chang the master number. The question, which one do you change to what?

    If you check the SOP Work and SOP History tables, are the master numbers in fact the same? What about the Original Number fields for each document? Does the daisy chain of document numbers work?

    Kind regards,

    Leslie

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