A new Expense Code is always assigned to a Type. The Type can either be a Flat Amount or Expense Rate. To find out whether the Expense code created is set to Flat Amount or Expense Rate, we have to create a custom formula to get the right results in reports.

We can create a custom column in Expense detail report with the following formula.

IF((ISNULL(NumberOfUnits))>0,"Flat Rate","Expense Rate")

Start a free Replicon trial today based on your business needs

Start Free Trial