Budget calculations may require transaction amounts of the "Credit" transaction type to exist as a negative amount. Columns need to be added and updated to the existing derived table finance_invoice_transactions.sql.
The two columns:
Add column effective_transaction_amount If there is a transaction type "Credit", then multiply the amount of this transaction with -1. Otherwise take over the transaction amount.
Update the column transaction_fund_id Merge the fund IDs of the column from_fund_id with the fund IDs from the column to_fund_id into one column.
Budget calculations may require transaction amounts of the "Credit" transaction type to exist as a negative amount. Columns need to be added and updated to the existing derived table
finance_invoice_transactions.sql.The two columns:
effective_transaction_amountIf there is a transaction type "Credit", then multiply the amount of this transaction with -1. Otherwise take over the transaction amount.transaction_fund_idMerge the fund IDs of the columnfrom_fund_idwith the fund IDs from the columnto_fund_idinto one column.