Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Line Items Transferred to Wrong Customer Invoice

(0) ShareShare
ReportReport
Posted on by 4

Hello,

GP2010 on SQL 2005

I have two orders (SOP) that were shipped to different customers (“CUST A” & “CUST B”).  When the orders were transferred to invoices, all of the line items from “CUST A’s” Order transferred to “CUST B’s” Invoice.  “CUST A” has no invoice linked to the order.  “CUST B” has it’s order linked to the invoice with the correct header and master #, but the line items on the invoice are not from the order.  They are from CUST B’s order. 

When this was originally brought to my attention, I was told there were problems with the distribution accounts (as the edit list indicated errors).  The invoice total was the same as the order total but the (incorrect) line items totaled up much higher. 

I ran reconcile and checklinks on SOP and it appeared to have fixed the problem.  Today I found out that what I mentioned above had occurred (wrong items).  I’ve done all my research, but can’t find what caused the problem.  At this point, accounting has entered manual invoices, but I need to find what happened and make sure no other transaction became corrupted. 

Has anyone experienced this?  I searched all of my resources, but have not found anything similar.   I would appreciate any help from the community.

Thanks in advance!

Jim

*This post is locked for comments

  • Jim Lines Profile Picture
    4 on at
    RE: SOP Line Items Transferred to Wrong Customer Invoice

    Hi Richard,

    Thanks for taking the time to respond.  Well, since this happened Friday during our huge month and quarter end rush, I wouldn't doubt something like that happened.  

    Regarding the master number, they are not duplicate - I had hoped that was the problem...

    Do you think it's worth opening a case with MBS?  I am sure management wants to know why this happened, but from my experience, it makes more sense to move on.  Thoughts?

    I do plan on restoring a backup and testing it myself, but you know how that will go.... it will work perfectly.

    Thanks again!

    Jim

  • Richard Whaley Profile Picture
    25,195 on at
    RE: SOP Line Items Transferred to Wrong Customer Invoice

    I have seen it before when you have multiple people entering orders and then sometimes deleting them.

    Do the original orders have duplicate master numbers?

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

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 >

Featured topics

Product updates

Dynamics 365 release plans