Net to zero if Business and Contra part is the same

[ShreyaSharma]

Hi Team,

Can someone help me on ...

i have attached the Data ..

logic is 

if Category contain AC and RV and if Business and the contra part is the same company code it should be net off 

..

Many Thanks

[AngelosPachis]

Hi @ShreyaSharma ,

Not sure if I understood the requirements correctly, but would something like this work?

I changed the logic to check the [Category] field for AC OR RV, because if an AND was used then that field should include both values

[messi007]

@ShreyaSharma,

I suppose that you want to check if the line match the condition you need to subtract [Local Currency Amount]-[Journal Transaction Amount] 

Attached the workflow,

Hope that helps,

Regards,

[ShreyaSharma]

Hi @AngelosPachis 

Thanks for your quick support..

So we also need to check the Local Currency amount and Journal Transaction amount net to zero. If its zero then status should be updated as Net Off

[messi007]

@ShreyaSharma,

Please see below:

If this solves your issue please mark the answer as correct, it will help others!

Regards,

[AngelosPachis · Accepted solution]

Hi @ShreyaSharma 

So I have added that additional condition for Local Currency amount and Journal Transaction amount in that if statement similarly to what @messi007  has done. Not sure why you would need a Contains, it is up to you to decide which one works best for your use case.

Hope it works better now? 

Regards,

Angelos