Purchase Order - Stop users to entering items from different Vendors

[former_member817621]

Hi,

Is there setting for users to stop entering items from different vendors on purchase order?

Example:

if Item ABC belongs to Vendor XYZ, we dont want user to allow entering item ABC to another Vendor while creating Purchase Order.

Thanks,

[jitin_chawla · Accepted solution]

Hi,

Don't think this kind of working is available from the system itself. I hope you must have checked the Preferred Vendor in the Purchasing Tab.

May be you can check the option of code in SP_TransactionNotificaiton which could help.

Kr,

Jitin

[duduvictorino]

Olá, cria uma TN e insira o código abaixo. Só verifica se na sua base existe a váriavel CNT.

IF :object_type = '22' AND (:transaction_type = 'A' OR :transaction_type = 'U') THEN

Select count('A') INTO cnt From OPOR A

Join POR1 B ON A."DocEntry" = B."DocEntry"

Join OITM C ON B."ItemCode" = C."ItemCode"

Where A."CardCode" not in (Select T0."VendorCode" From ITM2 T0 Where T0."ItemCode" = B."ItemCode")

and C."InvntItem" = 'Y'

and A."DocEntry" = :list_of_cols_val_tab_del;

IF :cnt > 0 THEN

error := '2205';

error_message := 'PN DEVE ESTAR NO CADASTRO DO ITEM.';

END IF;

END IF;

[former_member817621]

Thanks for your help Jitin. That did the trick.

On other note, I am new to SAP but I have extensive knowledge in .Net. How difficult it is to write .Net code to trigger events on Forms like Sales Orders OR Purchase Orders. I want starting point on how and where to write code and SAP B1 can pick up my code to trigger events?

I know this is very broad question but any guidance will be appreciated and helpful.

Thanks again for your help.