Project Allocation custom functionality logic

Summary:

We have the following scenario to address:

Scenario Details:

• Project: PB1
• Task 1.1:
  • Transaction Currency: EUR
  • Ledger Currency: USD
  • Expenditure Item Date: 20-APR-2024
  • Currency Conversion Rate: 1.07
  • Raw Cost in Transaction Currency: 100
  • Raw Cost in Ledger Currency: 107

Reallocation:

• To Task 2.1: 70%
• To Task 2.2: 30%
  • Transaction Currency: EUR
  • Ledger Currency: USD
  • Currency Conversion Date: 30-APR-2024
  • Currency Conversion Rate: 1.09
  • Raw Cost in Transaction Currency: 100
  • Raw Cost in Ledger Currency: 109

We are using a custom integration (which passes negative lines to Task 1.1 and positive lines to Tasks 2.1 and 2.2) to calculate allocation. While we are able to allocate the raw cost successfully, the difference in the currency conversion date results in different exchange rates. To avoid this, we aim to allocate both Raw Cost in Transaction Currency and Raw Cost in Ledger Currency instead of having the system calculate the raw cost in ledger currency based on the exchange rate. However, it shows a warning and ignores the cost populated in FBDI.