web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Richard Whaley Profile Picture
    25,195 on at

    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?

  • Jim Lines Profile Picture
    4 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans