BP Customer Vendor Same

[thobenjo1]

Hi Experts,

I wanted to create a customer who is also our vendor ,but when I am trying to add the customer it says duplicate bp name,this is beacuase of the query in sql,but If i dissable this query we will be able to create duplicated vendors or customers ,how to change this and make the bp into both customer and vendor but not to have 2 same name in vendor/customer.

-If 1 < (SELECT count(T1.CardName) FROM OCRD T1

--where T1.CardName in (SELECT T0.CardName FROM OCRD T0 WHERE T0.CardCode=@list_of_cols_val_tab_del))

--Begin

--SET @error = 1

--SET @error_message = N'Business Partner Name cannot be duplicated.'

--End.

SAP b1

[wojciech_wozniak]

Add a condition to distinguish the type of BP, for example: T0.CardType = 'S' AND T0.CmpPrivate = 'C'

[jbrotto]

May I suggest the same numbers but a different prefix such as a V and C.

[former_member790399]

Hi Prakash

we can do this customer become vendor and same as vendor become the customer

just follow this steps:

Goto the transaction code BP

Then enter you customer or vendor number

Then click on edit option