SP IN JE

[Former Member]

HI,

Is it possible to make project code field mandatory in manual je?

[Former Member · Accepted solution]

HI agranshu,

Yes it can be done through SP. Do you want it for header or row level??

Thanks,

Joseph

[Former Member · Accepted solution]

Hi jospeh,

thanks, i want it to be in header level

[Former Member · Accepted solution]

Hi Agranshu,

try this;

IF @transaction_type = N'A' AND (@Object_type = N'30') 
BEGIN 
if Exists ( select T0.TransId from OJDT T0 where  T0.Transtype='30' and 
 t0.transid = @list_of_cols_val_tab_del and (T0.Project is null or T0.Project= ''))
BEGIN 
SELECT @Error = 1, @error_message = N'Please select Project code !!'
END
END

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Josp,

SAP having some document that doesnot have facility to put Project code but JE is creating after running the document ,if i apply your given Notification then it will not allow to run the document as it will pass NULL value in Project code in automatic JE creation. In that what should i do ?Example for SAP document isSAP 2007A > Financial> Exchange Rate Differences.

[Former Member · Accepted solution]

Hi Joseph,

SAP having some document that doesnot have facility to put Project code but JE is creating after running the document ,if i apply your given Notification then it will not allow to run the document as it will pass NULL value in Project code in automatic JE creation. In that what should i do ?Example for SAP document is Exchange Rate Differences

Path :SAP 2007A > Financial> Exchange Rate Differences.