You’re offline. This is a read only version of the page.
285
Hey Guys,
Let me preface by saying that I'm very new to GP and did not originally setup the installation that we have running. What I’d like to be able to do is to add comments to an invoice after it’s already been written to my database in GP but before it’s posted - I believe table SOP10100.
I was hoping it's as simple as doing an INSERT into the SOP10106
table using the corresponding sop number and type and put my text into the
CMMTTEXT. Does that sound right to anyone?
I also noticed in SOP10100 there is a field called COMMNTID and what appears to be the corresponding field in SY04200 along with a field called CMMTTEXT where I could put my notes. If my previous methodology (inserting into SOP10106) doesn't work, I figured to do an INSERT statement into SY04200 with a COMMNTID I will generate for each new note and put my notes into CMMTTEXT, and then do an UPDATE on SOP10100 and put the generated COMMNTID number in the COMMNTID field of the corresponding invoice.
The first of the two is a ton easier for me, but I'm open to suggestions. Any help with which (if either) would be more appropriate for my desired outcome would be greatly appreciated!
Thanks!
Aj
*This post is locked for comments
It sounds like you are trying to do this with a program rather than through the interface. That said, you could add the comments after posting. You also have Record Notes (SY03900) that have a link (Note Index) that ties a record there back to the sales document. You can write to this table through the interface or through code even after posting.
The Comment ID copies a pre-written comment from the comments table into the sales transaction comment text fields. Once there the comment text can be edited. Editing through the software ends when the transaction is posted.
Aj, if the document isn't posted yet, you should be able to open it, add the comments, then save it or post it.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (