GR IR difference on condition

[Former Member]

Hi frnds,

My report is to disply the Purchase orders for which the GR and IR are having different values.

Here I have a contion for whinch if the difference is less then those POs should not disply in the report. So I have created a condition GR - IR value is greater than 5 and less than -5 then those POs should not disply.

But here I am facing a problem If for one PO GR is there but no IR so in this case i.e If IR is not there then the PO should come into final report irrespective of the difference between GR - IR value.

I.e If IR is not there then It should not check the condition.

How this can be achieved?

Regards,

Sridhar

[Former Member]

Hi Sridhra,

Plz find the details.

Normally PO = GR .But IR may be leass than or greater than to u r PO (U can check with MM People for Understanding).

1. Now you don't want to display the PO values <=IR Values.

2. If there is no GR you should not dipaly PO Values.

So use C.K.F to achieve results.

1st Solution :

If PO <= IR

Result = " "

else

Result = PO.

As per second Point If IR is not there above condition will not work so it will display all teh PO's

Regards

Ramakanth.

[Former Member]

Sridhar,

In the same formula: finding difference between GR & IR also find out IR is Zero or not using boolean functions.

Like: (IR > 0)*(GR - IR) gives Zero if IR is Zero or difference.

Srini