Hello Experts,
I have made a query in which i defined specially for my exports customer only, if no zip code defines in customer details then in zip code value will be "999999".
But query runs for all customer as whether zip code is there or not..
So please tell me what value in query should I change to get my data done properly..
Below is the query :
IF @object_type = '23' and (@transaction_type IN ('A','U'))
begin
IF EXISTS(select * from OQUT
left outer join OCRD on OCRD.CardCode=OQUT.CardCode
left outer join CRD1 on CRD1.CardCode=OCRD.CardCode
where OQUT.DocEntry=@list_of_cols_val_tab_del and
OCRD.GroupCode=104 and CRD1.ZipCode <> '999999')
begin
set @error = '-14010'
set @error_message = 'Export Customer Zipcode should "999999".'
end
end
Regards
Malay Gandhi