need a formula to reconcile

[madhusudhana]

need a formula to reconcile between my data and supplier uploaded data

 

[vletm]

madhusudhana
How to know which or any of those values are valid?
You could check this and
You could notice some of those ... or not.

 

[sureshsonti]

need a formula to reconcile between my data and supplier uploaded data

Is this what you want

 

[madhusudhana]

if the inv no differes from our data and suppler data but amount is same (less than 10/- differ only)we need a formula that type of match

 

[vletm]

madhusudhana
.. no answer,
then I cannot continue.

 

[madhusudhana]

madhusudhana
.. no answer,
then I cannot continue.

some of the bill nos have alphanumeric so that i matched inv no with concern gst gst no 1st if it is unmatched again have to verify with amount