HI all, I wish to calculate the outstanding invoice balance overdue over a period of time for each customer. It seems that it can be achieved via summary report over all invoices related to that customer. However, I wish to do a step further by comparing it with the credit limit allowed for each customer and prompt a alert next time when another invoice is to be input again.
Somehow, I can't figure out how to do calculation against figures under summary field. Any other functions ready in FM? Appreciate any thought/idea.