Duplicate reference number

[Former Member]

I am researching how to create a warning when a duplicate customer reference number is used for the same BP. I have read previous threads and it appears that there is supposed to be a setting to prevent or warn for this condition.

This is the answer from previous threads:

Go to

Administration>System Initalization>Document Settings-->

Click Per Document Tab->Select Document Sales Order>

When Duplicate Reference No. occurs-->Select warning/Block

When I click on the per document tab and select sales order i only get theses options.

Default days for order cancellation

Allow changesd to existing orders

Activate availability check

Sales order approved

Is the option available in this version to give a warning when a duplicate reference number for a BP is entered?

We are on 2007 PL 47.

Thanks

[Former Member]

You may check this thread:

Thanks,

Gordon

[michael_boucher2]

You can use TransactionNotification Stored Procedure to achieve this. Something like this should do the job....

IF @object_type = '17' AND (@transaction_type='A' or @transaction_type='U')
BEGIN
IF EXISTS (SELECT T0.NumAtCard FROM ORDR As T0 WHERE T0.U_SOTYPE = 'SO' AND T0.CardCode In (SELECT T1.CardCode FROM ORDR AS T1 WHERE T1.DocEntry = @list_of_cols_val_tab_del) And T0.NumAtCard In (SELECT T2.NumAtCard FROM ORDR AS T2 WHERE T2.U_SOTYPE = 'SO'AND T2.DocEntry = @list_of_cols_val_tab_del) GROUP BY T0.NumAtCard HAVING COUNT(*) > 1)
BEGIN
	SELECT @Error = 1, @error_message = 'Duplicated Customer Ref. No. Found'
END
END

[Former Member]

Thanks for the input but I am not familiar with using TransactionNotification Stored Procedure. Can you recommend how to learn how do this?

I am also trying to figure out if there is a setting or not if any one knows the answer.

[michael_boucher2]

I'm not sure if there is any documentation around, perhaps one of the SAP people can help here?

I don't believe there is a built-in feature to achieve this.