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 between invoice raised for 100 ,2time 200 ... against 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




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

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


-----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 


  SET @error = 1;

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



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