Skip to Content
0
Former Member
Dec 05, 2011 at 06:10 AM

Profit center issue

25 Views

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