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

Announcements

News and Announcements icon
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

    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
    Microsoft Employee on at

    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

    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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans