Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales invoice with two...
Microsoft Dynamics GP (Archived)

Sales invoice with two master numbers

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

This is an interesting one.....

When running  a smartlist or sales history report one invoice 219239A displays twice . When drilling into smartlist on both invoices under " sales document detail inquiry zoom" they have different master numbers from each other 252357 and 252326. In Customer Inquiry by document we see one invoice with master # 252357. When querying the RM and SOP open/history tables We see one invoice with master number 252357. We ran reconcile and checklinks. I ran the " Search all table for a value" script on this master number 252326 , nothing populated. How can one invoice has two master numbers and one master number be seen on reports but no were else!? What else can I check?

Thanks for your help!

*This post is locked for comments

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Sales invoice with two master numbers

    ShellyAnn,

    I've seen similar problems with clients who have a massive number of SOP transactions processed each day. From time to time, a sales header will be committed to a table without supporting lines, and the reverse.

    We created some queries to look for this condition in the table, and at month-end we use these queries to identify problem records and deal with them. How we deal with them depends largely on the particulars of the situation.

    I am sure once you've analyzed the data in the table (Lyn's given you a leg-up there), you'll figure out one of the records needs to be kept and the other likely needs to go. Funny thing is the "A" at the end of the document number is a common method users employ to enter a document, when the document number is already taken in the DB.

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: Sales invoice with two master numbers

    You can try these scripts, to see if you can possibly isolate the table(s) where invoice #219239A exists for master number 252326.  

    -- SOP Tables

    select SOPNUMBE, COUNT(*) as [COUNT] from

    (

    select SOPNUMBE from SOP10100 W

    UNION ALL

    select SOPNUMBE from SOP30200 H

    ) C

    group by SOPNUMBE

    having COUNT(*) > 1

    -- RM Tables

    select DOCNUMBR, COUNT(*) as [COUNT] from

    (

    select RMDNUMWK as DOCNUMBR from RM10301 W

    UNION ALL

    select DOCNUMBR from RM10201 W

    UNION ALL

    select DOCNUMBR from RM20101 O

    UNION ALL

    select DOCNUMBR from RM30101 H

    ) C

    group by DOCNUMBR

    having COUNT(*) > 1

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans