Gross margin for projects

[cyberdee]

Hi,

How to add manually gross margin calculation? I want to add a formula which is below:

Budget Estimate Cost vs Actual Cost
Actual Invoice Received vs Actual Cost
Sales Order vs Actual Cost

For example:

BUDGET ESTIMATE VS ACTUAL COST
Estimated Cost: Rp 250.000.000
Total Costing Amount (via Time Logs): Rp 88.966,67
Total Expense Claim (via Expense Claims): Rp 177.349.700,00
Total Purchase Cost (via Purchase Invoice): Rp 13.177.200,00

Margin = ESTIMATE - COSTING AMOUNT - EXPENSE CLAIM - PURCHASE COST = Rp 59.384.133,33

---

Sales Order: Rp 365.000.000
Total Costing Amount (via Time Logs): Rp 88.966,67
Total Expense Claim (via Expense Claims): Rp 177.349.700,00
Total Purchase Cost (via Purchase Invoice): Rp 13.177.200,00

Margin = ORDER - COSTING AMOUNT - EXPENSE CLAIM - PURCHASE COST = Rp 174.384.133,33

---

ACTUAL INVOICE RECEIVED VS ACTUAL COST

Actual Invoice Received: Rp 355.000.000
Total Costing Amount (via Time Logs): Rp 88.966,67
Total Expense Claim (via Expense Claims): Rp 177.349.700,00
Total Purchase Cost (via Purchase Invoice): Rp 13.177.200,00

Margin = INVOICE RECEIVED - COSTING AMOUNT - EXPENSE CLAIM - PURCHASE COST = Rp 164.384.133,33

Can ERP next automatically create those formula? Or should we add in the core?

Please advise

Thanks

[rmehta]

This should be in the projects module. Yes you can add it in the core.

[cyberdee]

Thanks @rmehta if you can add this in the core module that would be excellent!

[rmehta]

If you need it immediately, you will have to contribute it. This is not on our priority list.