non-financial reporting - alternate source in multicompany mode

[davidwul]

I have created a alternate move line source to report on the contract acquisition.
1 credit is a contract gain and 1 debit is an end of contract
This is working very well until I try to use this in multi-company report.
When I want to report on multiple companies, the currency come into play and modify the numbers.

Any idea on how to solve this issue?

[sbidoul]

Can you be more specific?

[davidwul]

I have created an alternate source of move line on contract acquisition.
one new contract yield 1 credit, and one contract terminated yield 1 debit.
There is no issue when reporting within the same company. But in a multi-company report, the currency is complicating the situation.

here is a simple example with a French company and a Swedish company.
In 2022, both company have 1 contract created , so overall, (if we consolidate the companies) there is 2 new contracts
in 2023, both company have 1 contract terminated , so overall, (if we consolidate the companies) there is 2 contracts lost.
but because of the currency, if we consolidate in the Swedish company, the contract created become 12,67 (1euro =11, 67 SEK + 1 SEK)

I could make the alternate source to force the amount_currency to -1 when credit is 1, but the currency computation is not taken from the amount currency, but the end of period currency.
Any idea, how to solve this?

[sbidoul]

Ah, so you are trying to use debit and credit to count the contracts.
I'm afraid there is no solution for that, as it expects debit and credit to contain monetary values in company currency.

[davidwul]

My workarround as been to make a setting to define the company to consolidate to, and create sql the view with all move line to this company and add report_company_id.
Is there another way for non monetary reporting with MIS report?
or other module maybe, but MIS is pretty well advance...