Blocking of Duplicate Customer Ref Number in AR Invoice

[Former Member]

Good Morning Experts,

Just want to know how to block duplicate customer reference number in AR Invoice Entry. System is currently give message that "Customer ref number already exists in this document type..".

My set up for Document Remarks Include in Document Settings is BP Reference Number. Is there any additional set up that needs to be done so that system will block duplicate reference number?

Version SAP 2007A

PL 30

Localisation Australia/New Zealand

Thanks

Sandra

[Former Member · Accepted solution]

The message you received means the blocking of Duplicate Customer Ref Number is working. What else do you need?

Thanks,

Gordon

[Former Member · Accepted solution]

There is a message if reference number already exist but I want to block it. I think B1200B has it under the document settings.

Is there also a way to block duplicate customer refernce number in SAP 2007A?

Thanks

[Former Member · Accepted solution]

You may use SP_Transaction_Notification to block.

[Former Member · Accepted solution]

Hi

You can try this sp_transaction notification : Copy the given code to store procedure sp_transaction notification where it says --add code here

if (@object_type = '13' or @object_type = '15')

and (@transaction_type= 'A' or @transaction_type= 'U')

begin

declare @venno as varchar(100)

if @object_type = '15'

begin

select @venno = NumAtCard

from opdn

where docentry =@list_of_cols_val_tab_del

if 1 != (select count(docentry) from ODLN with(nolock) where NumAtCard = @venno)

begin

select @error = 1

select @error_message = 'Duplicate Customer ref no in SO Receipts. ! '

end

end

else

if @object_type = '13'

begin

select @venno = NumAtCard

from opch

where docentry =@list_of_cols_val_tab_del

if 1 != (select count(docentry) from OINV with(nolock) where NumAtCard = @venno)

begin

select @error = 2

select @error_message = 'Duplicate vendor ref no in AR Invoices. ! '

end

end

end

This will block the transaction when you have duplicate customer reference . It will let you put same customer reference in Sales order but it will block from delivery

<b>Please test it in test environment </b>

Thank you

Bishal

[Former Member · Accepted solution]

Thanks for the reply... Got it..

Sandra

[tgjaneesh]

Hai Sandra,

For blocking the duplication of Customer ref No. in copying document you can use the configuration in Document settings

Administration - Document setting - Per Document Tab - Select AR Invoice you can block / warn / without warn the document ref no. copying

Regards

Janeesh

Edited by: tgjaneesh on Aug 26, 2011 11:42 AM

[Former Member]

Hi,

Does anyone know if SAP has included this functionality in the latest patch(8.81pl07) or any plan to develop?

Thanks

[former_member187989]

hi,

Check this note,apply to ar invoice case.

SAP Note 1258097 - Can the Suppliers Reference number be made unique?

Jeyakanthan

[michael_boucher2]

B1 provides no functionality for blocking you from creating a document with a duplicate reference, it can only warn you. I think you could achieve this with the B1UP Addon.