Skip to Content
avatar image
Former Member

Formatted search

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 06, 2012 at 05:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello zz ymt, thanks for the good solution!

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

      Thanks

  • avatar image
    Former Member
    Mar 04, 2012 at 01:45 AM

    Hi,

    Welcome you post on the forum.

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

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2012 at 05:45 AM

    Hi Aaryat......

    Please check this link.......

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

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2012 at 05:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded