After upgrading an environment from IFS10 UPD6 to IFS10 UPD15 I get below error message when trying to authorize an expense sheet containing mileage transactions (Expense_type_db = 1).
“Debit amount must have a value when currency debit amount is entered.”
After investigating this it seems like the error message is showing since the column GROSS_AMOUNT in table EXPENSE_DETAIL is NULL.
When authorizing an expense sheet, the column GROSS_AMOUNT get its value from EXPENSE_DETAIL.GROSS_CURR_AMOUNT * EXPENSE_DETAIL.GROSS_CURR_RATE.
When I create a mileage transaction in IFS, the columns GROSS_CURR_AMOUNT and GROSS_CURR_RATE is set to NULL (also CURRENCY_RATE gets a NULL value). Which in turn leads to a NULL value in the column GROSS_AMOUNT and the error message mentioned.
Anyone else who has experienced any similar issues? Is there maybe a setting or so to make sure that the columns GROSS_CURR_AMOUNT and GROSS_CURR_RATE gets a value when creating a mileage transaction?
Thanks in advance!