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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How do I change a Customer name on Posted invoices

(0) ShareShare
ReportReport
Posted on by 80

I have a customer who recently conatct me and said that there name is incorrect and wants all statments sent to them with the correct name.  I changed the name in the card howeverit doesn't seem to change it for the posted invocies. Can someone tell me if I have to void them all and them repost, or is there another way?

Thx,

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mike Smith Profile Picture
    6,840 on at
    Re: How do I change a Customer name on Posted invoices

    You have several options.

    The reports are pulling data from the SOP related tables and not from the RM Customer table, so an update the customer record would update the related RM Customer table, but not the SOP table as SOP is essentially a snap-shot of what was entered in the RM Customer table at the time of creation.  Options include voiding an re-entering invoices, updating tables in SQL (I would highly recommend working with your GP partner on this), or looking at the underlying report to see if customer name could be updated to pull from the RM Customer table and not the SOP table.

  • Suggested answer
    Tracey Steere Profile Picture
    on at
    Re: How do I change a Customer name on Posted invoices

    Hi Lu,

    If this is a permanent change to the Customers Name you could always use the PSTL tool under Sales> Customer Name Modifier to change the Customers name. This will effect all reports that has the Customers name on it.

    Cheers Tracy

  • Ian Grieve Profile Picture
    22,784 on at
    Re: How do I change a Customer name on Posted invoices

    I'd second Tracey's suggestion of using PSTL which became entirely free last year.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans