You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: