Unable to set a user defined values in image field

[iNDdM]

I have a user defined field of image type on AR Order window at line level. I need to setup a user defined value off a formatted search on this field however I cannot place the cursor in the field to activate Tools-customization tools - User defined values setup window ( or shift+alt+F2)

The cursor always changes to a hand icon on the field and you can only double click on it.

[Abdul]

You can't write values to image fields as there fileds are used to save the image file name selected by the user. An alternate would be to try post-transaction notification but thats not an ideal solution as it may void the SAP support contract. 

[Johan_H]

Hi,

To my knowledge this is not possible without an addon. The best alternative is to create a link type field. There you can create a formatted search, but it would not bring the image to the document.

However, with this solution you could look into using crystal reports to actually open/print the image from the link. The principle is described in the answer to this question.

Regards,

Johan

[iNDdM]

I have a customer database done by a previous partner that has implemented this ( formatted search on a image user defined field ), so is the reason for asking the question . Now we need to implement this on another database at the same customer site ( on customers request ) - so far I too cannot see a way to do this without directly writing into Business One tables - ( which seems how the previous partner may have done ??) - however I do not want to do a direct write - it will void SAP support.

I hope an SAP employee sheds some input here.

[Johan_H]

I was not suggesting direct writing to the database. Although, writing to simple User Defined Fields is unlikely to void your warranty.

If a previous partner has managed to create a FMS in an image field, and you have access to this database, you should be able to investigate how it has been done. The first question is, what does this solution look like in the client? Is it used to print the image, or to show the image in the GUI?

With an addon, I mean a solution that uses the DI API and/or UI API.

[iNDdM]

Hi Johan_H ,

When I meant writing directly I didn't mean The data into user defined field. Its rather the setup info into CSHS table.

The scenario is below.

There is a formatted search that has been set up on a user defined field to populate itself with the image based on a query. However to set up such a you need to  define user defined value set up from tools menu, for this you need to Click on the field and place the cursor in it  ( then pressing shift alt and F2 key) .

With a SAP business one you cannot place the cursor in an image field . You can only double click on it which brings up another window asking for the location of image file , which is the normal behaviour .

However somebody has created a formatted search on this field ,  and the only way they could have done it is by writing the necessary setup information - such as the query name, which field to trigger from etc …  directly into the database table – CSHS -  to create this user defined value set up.

I don't want to write direct into SAP fields

[Johan_H]

In that case, there are two options:

1. The existing solution was made with approval from SAP Support. In this case you could do the same, and aksSAP Support for permission and perhaps instructions.
2. The existing solution was made without approval from SAP Support. In this case the customer's warranty / support has already been compromised. In this case you need to find out if the customer is aware of this, and approved the solution anyway back then.

Also, again, what does the old solution look like? If it is only used for printing, the image field is unnecessary, as you can achieve the same goal with a link field with fms and Crystal Reports.