Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans