18
Within the current version of D365 Finance if a user need, within the project module, to ask customer to advance the system displays a form asking the user to provide two information:
1- Customer advance date
2- Funding source
3- Description
4- Advance amount

When you work with multiple funding source linked by one or multiple funding rules you must then repeat the operation as many times as needed. And you must do it regarding your funding rule allocation.
As an example: If you have a project contract for 100 000$ amount with 2 funding sources (allocated as follow, 40% for A and 60% for B) and you want to ask customers advance for 30% of your project contract. You must ask a first advance for A (12 000$) and a second one for B (18 000$).

The second thing is advance deduction. By default, when creating invoice proposal, the system deducted 100% of posted customer advance. If you want to avoid this, you must manually split the advance.

if you link these two considerations it may become very hard to manage customer advance on the project level.

Accordingly, I propose these improvements:
1-Ask customer advance by funding rules (instead of funding sources). By doing this, if you need to ask an advance for X% of your project contract, you just have to select your funding rule and the system will create as many advance invoice as needed taking into consideration the funding rule allocation.
2- Adding options to the project level (or project group) to deduct customer advance accordingly to the following options:
2.1 Accordingly to the invoice amount / project contracts. E.g if your invoice is 15% of your project contract then the system deduces 15% of customer advance
2.2 (if you use Progress billing rules) Starting advance deduction from a defined percentage of completion. If you define advance deduction starting to 70% of project billing, then the system will start to deduce customer advance as soon as you reach 70 % POC
2.3 Equal to the invoice amount.

Thank you for your vote, I hope to see these improvements soon!
STATUS DETAILS
Needs Votes