How to build a Formatted Search base on the document type

[Former Member]

I need to build ONE formatted search that works on multiple documents.

For example:

If the user is working on a Sales Order the query uses Field Item UID in Screen $[$NI_00011.0.0] but if the user is working on an AR Invoice the query needs to be based on Field Item UID in Screen $[$38.6.0].

in Short:  If document is a Sales Order search records based based On Query One using the value of Field 1 but

                    if document is an AR Invoice, then search records based on Query TWO using the value of Field 2

So What is the syntax to detect the Document Type/Form Id/ObjectID of the active screen. Who do I detect what document type I am currently working on.

HELP.....

[Former Member · Accepted solution]

Hi,

The FMS with format $[$99.9.9] would be universal to all marketing documents such as $[$38.1.0]

Other than that, FMS has to be build for each individual object. There is no free choice of objects for you.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank Gordon,  I'll give this a try today.

BTW: Love your book... Great tool.

Mastering SQL Queries for SAP Business One

[Former Member]

Thank you all for your responses.

I ended up creating FMS for each Document Type.

Sales Orders,

Invoices,

Deliveries.

[former_member184146]

Hi Navarro,

               check the below link for formatted search

http://www.pioneerb1.com/wp-content/uploads/2012/09/How-to-Define-and-Use-Formatted-Search.pdf

Regards,

Manish