Formatted search

[Former Member]

Hi,

I want to know about e-learning of formatted search or there is any video that makeS help me regarding formatted search plz let me know

Thank you

[Former Member · Accepted solution]

hi,

How to work with formatted search with SAP Business One 8.81?

Firstly, You need to create Query using Query Generator

1. Tools->Queries->Query Generator.

2. Type the table name (eg. Ohem) in the first text box and press tab.

3. Double click the field (eg. empID) you want to query.

4. Click Execute button.

5. Click Save button.

6. Type Query Name. (eg. Getempno)

7. Type General in the Query Category box.

8. Click Save button.

9. Close Query Preview Dialog box.

10. Close Query Generator Dialog box.

After that, you need to use User defined value

1. Open the Form you want to use Formatted Search. (eg. Human Resources->Employee Master Data)

2. Place the insertion point in the EmployeeNo text box.

3. Tools->User-Defined Values.

4. Click Yes button.

5. Choose the option Search in Existing User-Defined Values according to Saved Query.

6. Click Open Saved Query button.

7. Expand General note and choose the query name. (eg. Getempno)

8. Click OK button.

9. Click Update button.

10. Please check in the box Employee No and you will see formatted search button.

best regards,

zzymt

[simone_pastorin · Accepted solution]

Hello zz ymt, thanks for the good solution!

Do you know if this is possible also via DI API or UI API?

Thanks

[Former Member]

Hi aaryat,

Rfere this link. Thats very help full for you.

http://www.tiinfotech.com/SAP-B1_benefits/Formatted-Search-UDF.pdf

Thanks,

Srujal Patel

[Former Member]

Hi Aaryat......

Please check this link.......

http://www.hkcompass.com/Download_Centre/brochure/sap_business_one_blue_print_english.pdf

Regards,

Rahul

[Former Member]

Hi,

Welcome you post on the forum.

You may search User Defined Value from B1 e-learning to find it.

Thanks,

Gordon