transaction rate type isn't generating automatically

Dear ALL

I have an issue when i create a transaction ( invoice, credit memo ...) when the currency is different and i save the transaction it give me error (transaction rate type is not defined)

in the manage conversion rate -> the transaction date is created and defined + the type is ticked as by default

As a workaround i am manually clicking on the icon near the currency and selecting my conversion Type

but it should be defined automatically because i have to upload some transactions by spreadsheet and it can't be done manually one by one

thank you

Regards