cancel
Showing results for 
Search instead for 
Did you mean: 

Validation issue in the Journal entry:

Former Member
0 Kudos
54

Hi all,

Requirement is validation for project code mandatory with all document expect equity and outgoing and incoming payment.

but in the reconcillation of business partner

when A/p invoice and outgoing payment reconcillation is done..

validation is not allowing.

please somebody help the issue in below query

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Poornima

Did you apply the validation through SP or SDK?

please paste the copy of the code here

I think you cannot apply validation for automatic transactions.

Former Member
0 Kudos

Hi Dasan,

Thanks for your reply

The validation through SP.

i had created validation for purchase and sales document and condition for jounal ledger expect equity.

i missed it above.please find the query below.

if @transaction_type='A' and @object_type=30

begin

if exists (select t0.TransId from JDT1 t0 INNER JOIN OACT t1 ON t1.AcctCode=t0.Account

where t0.TransId=@list_of_cols_val_tab_del and (t0.Project is null or t0.Project='') AND t1.GroupMask<>3)

begin

select @error=101

select @error_message='Enter Project Code'

END

end

Regards,

Poornima

KennedyT21
Active Contributor
0 Kudos

Hi Poornima..

Pass the Objectcode in the where condition 321 internal reconcilation.

try this

if @transaction_type='A' and @object_type=30

begin

if exists (select t0.TransId from JDT1 t0   inner join ojdt c on  t0.TransId=c.TransId   INNER JOIN OACT t1 ON t1.AcctCode=t0.Account

where t0.TransId=@list_of_cols_val_tab_del and (t0.Project is null or t0.Project='') AND t1.GroupMask<>3

and c.TransType<>'321'

)

begin

select @error=101

select @error_message='Enter Project Code'

END

end

Regards

Kennedy

Former Member
0 Kudos

Hi Kennedy,

Tons of Thanks .

now Validation is allowing for internal reconciliation also.

Regards,

Poornima

Answers (1)

Answers (1)

former_member205766
Active Contributor
0 Kudos

Hi Poornima

Can you try the below settings

With Regards

Balaji Sampath