Hi
I am using the following SP for making Profit Center mandatory in A/.R Invoice document.
The issue is, the system accepts when i select the 1st Dimension, but if i select the 2nd dimension it gives me the message to select the profit center (as per the Stored Procedure)
It will be great if someone can help in solving this issue.
--- Profit Centre mandatory for A/R Invoice
If @object_type = '13' and (@transaction_type = 'A')
begin
IF EXISTS (SELECT T0.DOCENTRY FROM OINV T0 Inner join inv1 T1 on T0.DocEntry=T1.DocEntry WHERE (T1.ocrcode is null
) AND T0.DOCENTRY = @list_of_cols_val_tab_del)
begin
set @error = 1
set @error_message = 'Choose Profit Center'
end
end
regards
Karthik