Hi Experts,
Need help with looking up amounts upto $1 upwards and downwards, as per data in the Bills file.
2 inputs exist - Bills & Cash Receipt
Base file is 'Bills' which needs to be looked up in the 'Cash Receipt' file based on Account and Amount.
However, there should be a tolerance of $1 upwards and downwards while looking up the 'Cash Receipt' file.
For example, if the amount in the 'Bills' file is $100.12, the lookup tolerance should be from $99.12 to $101.12
If the match is found, then comment to be updated in the output file is 'Cash Received', else it should be 'Cash Not Received'
Thank You
