Budget Variance Report with additional columns

[rmehta]

Add following columns in Budget Variance Report

• Budgeted Amount (based on budget)
• Requested Amount (based on material request)
• Committed Amount (based on purchase orders)
• Consumed Amount (based on purchase invoice)

[aakvatech]

Actually it's better to have a main report that shows the calculation for compare_expense_with_budget() and then a separate report that shows breakdown of:
budget_records
get_accumulated_monthly_budget
get_requested_amount
get_ordered_amount
get_actual_expense
get_amount
expense_amount (why it is always 0?)