Search for Business Partners by Address Data

[Former Member]

Hi,

I have noticed that the contact person and address data are not part of the search window for business partners. Is there any possibility of making them available for searching too?

In our business, it is very important that we can look for all customers that are living in a specific town or all customers that have a special occupation...

Thanks a lot!!

Corinna

[Former Member]

Have you tried using foprm settings to add these fields? It will only allow you to add the default address & contact, but it is a quick fix?

[former_member583013]

Corinna,

There are a few ways to handle this and one of the most easy one is using Formatted Seaches (FMS). Formatted Searches are nothing but SQL queries that can be linked to a field on the form and by User action (when user press Shift+F2), the FMS can be made to trigger prompting the user the values for the fields you want to enable the searching on. The Search will display the results on the query results window from where the user can select the relevant BP.

This is effect when you implement this on the BP Code or BP Name field. Since most implementation already have a formatted search on BP Code for generating the next BP Code...you could link this to BP Name. I am giving below a simple example (query) of search the BP by Contact Person

SELECT T1.CardName AS 'BP Name' FROM [dbo].[OCPR] T0 INNER JOIN [dbo].[OCRD] T1 ON T1.CardCode = T0.CardCode WHERE T0.Name = '[%0\]'

[Former Member]

hi,

we had a similar problem. you can solve it by a formated search like this one :

SELECT T0.[CardCode], T0.[CardName], T0.[U_nachname], T1.[SlpName] FROM OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode WHERE T0.[ZipCode] =[%0] OR T0.[MailZipCod] =[%0] OR T0.[U_altekdnr] = [%1] OR T1.[SlpName]=[%2]

e.g. we link it into the CardCode field.

regards