How to prevent Duplicate AP Invoices ??
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
Balaji Sampath replied
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!'