Billing Issues in Timesheet when multicurrency is setup

[asoral]

Information about bug

Scenario:

• 3 Companies

  • USD
  • INR
  • Euro

• 2 Employees

  • Emp1 => Working for INR
  • EMP2 => Working for Euro

• Global Default

  • Currency => INR

• Add a new Timesheet Entry

  • Company => Euro
  • Employee => Emp1
  • Currency => USD (because my project billing is in USD)

• Problems

  • Currency conversion shown in timesheet is taken from global default. So, if my project is in USD, i.e. I will select USD on the timesheet, but the global default is INR. The conversion in timesheet shows as:
    • 1 INR = ? USD However, the company on this timesheet has the default currency setup as EURO. So, what I expected to see there was
    • 1 USD = ? Euro (and not what is shown by default, which is what you see above)
  • Emp1 works for INR Company, so what I created the Activity Cost, I assumed (since it did not have currency link field) that the Costing & Billing Rates are both in INR because employee works for the company dealing in INR
  • When I see the timesheet Details child table for a row that is billable, I expect to see the costing rate and billing rate in INR. But it shows that in USD. Which is picked from the currency field. I think this is not correct because the employee cost & billing is in the currency of the company he works for.
  • On the left there are more fields in the child table billable section, which shows Billing Rate, Costing Rate and Amount fields in INR, which it is showing because of Global Defaults. This should have been USD because my project is in USD, my client needs this info.
  • There should be one more column break in the child table billable section to show Billing Rate, Costing Rate and Amount fields in Euro because my company in Euro on this timesheet and when I want to see the total costing and total billing report summed up I would have to do them all in one single currency which will be the company currency.
  • Project fields "Total Costing (from Timesheet)" and "Total Billing (from Timesheet)" should be in company currency but it is currently in Global Default Currency and sums up all wrong numbers.

Module

accounts, projects

Version

Frappe Version - 15 (latest) ERPNext Version - 15 (latest)

Installation method

FrappeCloud

Relevant log output / Stack trace / Full Error Message.

NA

[KanchanChauhan]

@asoral We are currently addressing the issue you've encountered, as we are experiencing a similar challenge. If you have already found a resolution, could you please share your approach? Alternatively, we would appreciate your feedback if you are interested in testing our solution.