We recently updated a Comment ID used to display the billing location on our invoices, and invoices generated/printed after that update was made do not show the updated comment but rather the old comment info. Is a manual update to every SOP Quote document required for this type of change? I sincerely hope not........
*This post is locked for comments
Tim,
Thank you very much for your reply. I had a feeling it would be a matter of requiring an update to each Quote record, which will then transfer over to invoices when that quote is transferred for the billing period. It has been years (8 or so) since I originally had to do this exact setup so I could not recall whether an update for each quote would be required but could not think of an alternative for the end user. I will let our user know that we can work with them to update via SQL, as that would be an easy way to REPLACE the existing text rather than manually opening dozens of quotes to remove/save then update/save them.
Melissa,
Think of the Comment IDs as templates, like a premade rubber stamper.
By typing or selecting a comment id, a COPY of that comment id is stamped into the order, if you remove the comment id from the comment id field in SOP entry window, it will then erase the comment (and as it happens any additional text you entered over and above the preconfigured comment) from the order.
So changing the text of the comment ID will only change the rubber stamper, it will not change all the documents you stamped with it.
Its not that bad though, you have two options:
1. Use a GP Macro (Google mail merge Dynamics GP macro) to open each quote, remove then add again the comment id and finally save the document. But you need to be aware that if users are in the habit of adding extra text in addition to that in the comment, then that text will also be removed.
2. Use SQL to update the comments. This should only be done if you have a competence in SQL, or contact your GP partner for help. By updating the CMMTEXT field in the SOP10106 table, for all documents where the comment ID is that in question. Doing this is more precise as you could use a REPLACE statement in SQL to replace any occurrences of the previous text with the new version (you will need to convert to varchar(max) first).
See the post here for a more rich explanation:
www.timwappat.info/.../Updating-Dynamics-GP-Comment-ID-in-Sales-Order-Entry
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (