AnsweredAssumed Answered

Summary Field

Question asked by Sophia on Mar 22, 2011
Latest reply on Mar 23, 2011 by philmodjunk


Summary Field


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.