Dexterity - SOP Comment stored where?

[Borvik]

I'm having a little difficulty figuring out where the SOP Document comment is stored while creating it.

I'm attempting to automatically add a comment to orders - if a comment doesn't already exist. I can't check the Comment ID, as sometimes it doesn't have one (directly added - rather than from a saved comment).

Anyone know where this might be stored?

Thanks.

 

[winthropdc]

Everything you want to know about find tables and fields can be found at

http://blogs.msdn.com/developingfor...eld-information-in-microsoft-dynamics-gp.aspx

The comment is stored in the User Defined table.

sopUsrDefWorkHist (SOP10106) Sales User-Defined Work History

The same table is used for work and history documents.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Borvik]

I tried adding the 'Comment Text' field from that table to the SOP_Entry window already. Adding a comment via the expansion button did NOT populate that field.

I think I found something that will work though. I added a button for testing and this code to it:

local boolean result;
result = Field_GetBooleanProperty('Edited Button', FIELD_PROP_VISIBLE);

if result then
  warning "Visible";
else
  warning "Not visible";
end if;

That seemed to tell me whether it was edited or not - and I should be able to add that to the attached script. The only problem is that you can then delete the text in the comment - and it still shows as edited. Not a big deal - I think most users can live with this.