Sales Calculation (Dashboard)

[ol3mon]

Hello,

I would like to suggest a new field in "Client profile" to correct the calculation of total "Sales" seen in user dashboard.

Scenario :
I have multiple clients with multiple Primary Currencies:
Client1: 5 000 $, Client2: 9 000 DH, Client3: 1 000 €.

My System Currency is set as US $.

Current state :
In the dashboard we can see total "Sales" as : 15 000 $ (System Currency)
Which is not reflecting the real total "Sales" value.

Suggestion :
Add a multiplier field in the "Client profile" next to the "Primary Currency".

-> Client Profile
Client1: [Primary Currency: $], [Currency Multiplier: 1.00]
Client2: [Primary Currency: DH], [Currency Multiplier: 0.27]
Client3: [Primary Currency: €], [Currency Multiplier: 1.15]

The [Currency Multiplier] field would be fed with manual user input.

-> Total "Sales" Calculation (Dashboard)
[(Client1_invoice_value)x(Client1_multiplier)] + [(Client2_invoice_value)x(Client2_multiplier)] + [(Client3_invoice_value)x(Client3_multiplier)]

-> Expected result :
(5000x1.00) + (9000x0.27) + (1000x1.15) = 8 580 $
Which is a more real "Sales" value.