When adding or removing transactions from an unlocked invoice for a sub project the total transaction value can be greater or less than the invoice value. When this occurs there is an unallocated value for the sub project which is shown in red. The unallocated value needs to be allocated to the transactions before the pre-billing updates can be saved.
Click the image above to view the unallocated value on the sub project row.
Automatically split the unallocated value across the selected transactions for the sub project using the Auto Allocate button. The Unallocated Invoice Total for the sub project will be split across all transactions that are selected. This looks at the proportion the unallocated value to be greater for the transactions that have a higher chargeable value. Auto Allocate will not update any 'locked' transactions for the sub project.
You can also manually type the Invoice Value for the Transactions, or lock transaction rows to stop selected items from being included in the auto allocation. Manually entered invoice transaction values must add up to the sub project invoice total.
Assign the Unallocated Value to the invoice transactions by:
Click the image above to see the auto allocate button.
Auto Allocate Formula
Transaction Invoice Value = (Transaction Chargeable Value / (Total Chargeable Value- Sum of Locked Chargeable transactions for the Sub Project)) x (Sub Project Invoice Value - Sum of Locked transactions for the Sub Project).
ncG1vJloZp6klZa%2Fr7XNoKmeq5%2Bqv6Sx0meZpaeSY7CwvsRnrqKmlKTEtHrNnqtom5ykwqW0xKWnaHyVqLi1u89oeqimpJq7tXuhoqOloZ6cfKq61aignJ2jYr2zscGio6WXopqwsLPNoquip55jtbW5