Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to prevent Duplicate AP Invoices ??

hi Experts

 

End user Raised Po for 1000 quantities but good receipt Po comes one time 100,2nd time 200 ,3time 300 and so on...in between invoice raised for 100 ,2time 200 ... against GRPO..in between End user miss understand or communication some Duplicate bills are raised...

how i restrict duplicate postings??

note:(im using sap b1 2007 pl 17)

  Thanks & Regards

     AKR

Tags:
Former Member replied

Hi

You can Restrict Special character for Vendor Reference No in following  SP.

IF @object_type = '18' and @transaction_type in('A','U')

BEGIN

-----VERIFY IF THE Vendor Reference No has specical character OR IS NULL------

IF(SELECT COUNT(*) FROM OPCH WHERE DocEntry = @list_of_cols_val_tab_del AND (Isnull(NumAtCard,'') = '' OR NumAtCard LIKE '%ã%' OR NumAtCard LIKE '%á%' OR NumAtCard LIKE '%.%' OR NumAtCard LIKE'%à%' OR NumAtCard LIKE '%[%]%'))> 0 

BEGIN

  SET @error = 1;

  SET @error_message = 'Vendor Reference No can not be null or special characters!'

END

END

With Regards

Balaji Sampath

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question