Invoice amount vs payment amount

Hi all:

I have an invoice and payment file where I would like to see if we have paid more than the invoice amount. (payment amount > invoice amount).

Appreciate in providing a formula to detect if we paid more than we suppose to.

Please note that our invoice and payment file does have payments in (-) and these represents credits from suppliers.

Cheers,

Preparation

Accepted answers

Qiu

@Hussein982
Can you kindly check the "PAYMENT_AMOUNT" is of numeric type with a select tool?

All comments

Qiu

@Hussein982
Something like this?

New Workflow5.yxmd

Hussein982

Thanks @Qiu. Appreciate the prompt response. One thing is not working for me is the (endi endi).. not quite sure why its not picking up or I am doing something wrong in the formula?

Let me know once you have a chance please.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703