How to Get ...............................of Duplicate Invoice...........

[Former Member]

Dear Members

I have problem, actually vendor sends us the invoice with 2 more duplicate copies of the same Invoice, there is a possibility of double entry of the same invoice , how can i restrict the same

i am using Invoice number in user defined felid

[Former Member · Accepted solution]

ya suda

I am using SBO 2005 B its not working what you said in this version. can you suggest any thing else

Edited by: C.H.Ajay Kumar on Mar 10, 2008 3:56 PM

[former_member583013 · Accepted solution]

Ajay,

May be this was implemented on a later patch. Could you check your patch level and see if it works on a later patch by upgrading a standalone PC.

If you do not prefer this route, then you could use the SBO_SP_TransactionNotification. Code sample below.

IF @transaction_type = 'A' AND @Object_type = '18'

BEGIN

IF EXISTS (SELECT T0.DocEntry FROM [dbo\].[OPCH\] T0 WHERE T0.NumatCard IN (Select NumatCard FROM OPCH WHERE CardCode = T0.CardCode)

AND T0.DocEntry = @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 1, @error_message = 'Duplicate AP Invoice'

END

END

Suda

[former_member583013]

Hi Ajay,

Just for my understanding I would like to know why you choose to enter the Vendor Invoice number in a User defined field when there is a SAP field for Vendor Ref No. on the AP Invoice.

I have seen that if you use the Vendor Ref No and if someone enters a number for the same vendor which already exists in the Database ....SAP will automatically show a message

<Font Color="RED" size=3> Vendor Inv No. already exists in a document of this type. Continue?

</Font>

This I am talking about in SBO version 2005A, you should test this in your local version.

Suda

[Former Member]

Hi,

you may use sbo_sp_transactionnotification and there check ih exist invoice in the system already with the same udf (if exists, set @error to 1). Here in the forum you may find a lot of examples how to use it.

hope it helps

Petr