Request: Ability to Calculate Margins Based on Latest Price or Fixed Price Instead of Average Cost

Description of Issue:
Currently, when my sales team adds a new item to the system and quotes a customer, the system calculates margins based on average cost. This makes it difficult for salespeople to accurately understand the real margins they are setting.

The only workaround available is to export the item list, update the average cost, and reimport into the system. This creates significant operational and risk issues:

• Salespeople are not trained in handling spreadsheets and exports/imports.
• Allowing them to manage CSV updates increases the chance of errors, which can cause incorrect pricing and downstream reporting issues.
• Exporting/importing data also wastes time and creates inefficiency in the quoting process.

Business Case / Impact:

• Sales need real-time margin visibility when quoting customers.
• Using average cost distorts the actual profitability view, especially when prices fluctuate.
• The lack of visibility creates risk of underquoting or setting unprofitable margins.
• Removing the need for spreadsheet manipulation reduces error risk and ensures consistent data integrity.

Request:
Is there a way to change the margin calculation in CIN7 to use either:

1. Latest price, or
2. Fixed price (set at the product level),

instead of average cost?

This would provide more accurate and real-time profitability insights for sales, without requiring risky manual data handling.