Has anyone stored custom comments which can then be inserted into the various Sales Order comments based on a BPM? We need to store Export Statements that are required to print in our Sales Order Header comments. The statement varies based on a classification selected which is a user defined field we created. Do we need to create a User Defined table to store these comments? We want the ability for a user to update the statements if changes are required.
Do you want the user to be able to change the comments after they’ve been inserted?
A User Code might work for storing the various classification dependent verbages (not sure if User Code is long enough for your text).
I need the user to be able to update the Source comment as we do not want to be the keeper of these statements when changes are required in future. Once a comment has been inserted into a Sales Order and the order is processed - the user does not need to update.
Looks like the Long Description for User Defined Codes is limited to 300 characters so that won’t work for us.
So a UD table it is.
Make sure you think about the following:
- If the classification changes, should any existing Comments be replaced or appended?
- If comments beyond the ones inserted, exist, replace them too?
- Require confirmation of the change of existing comments?
Any thoughts to adding a UD field to OrderHed to hold these special comments, then insert the field in the Order Ack form? You’d still have to store the special comment tetxts, and retrieve them, but it wouldn’t interfere with the “built-in” order head comments
I may suggest to create a UD field in the Usercode table, and create a custo in the Usercode maintenance to access it. You create your list of classifications and in the UD_description you would add your long comment.
That field could be set to your desired string length…
Would be (I think) an alternative solution than the UD table… 
Pierre
1 Like