I'm having a problem with the daily sales report when clicking on a date to show the profits, the issue is caused when purchasing products that the purchase unit is not a base unit, what happens is that the sma_costing table records the wrong unit cost, it's not converting the cost to base unit, so when the daily sales report shows the product's cost it shows a big number because it's multiplying wrong numbers,

for example: I purchase a dozen eggs for $12 ($1 a piece), so when i sell those eggs, the sma_costing table registers 12 in quantity and $12 in purchase_unit_cost, but the purchase unit cost should be $1, by the way the sales unit cost is registered correctly. So what the daily sales profit shows it's 12 eggs multiplied by $12 = $144 products cost, when it should be $12.

Please fix this