The on-account transactions form holds lines for the different on-account transactions (Milestones, Deductions, Prepayment Journal lines, Beginning balances) depending on the project type. They can be created either via Billing rules or manually.
- Client may use it in different ways, and sometimes where this is being used to drive invoicing that has been based off quotation lines, certain clients may want to see the individual lines broken down into the elements of build-up as it was in the quote. This result in potentially having to create multiple lines on the on-account form.
- Also in a dense project hierarchy with on-account lines at different sub-project highlighting it at the top of the hierarchy can present you with quite a large number of lines.
Required function
- Users require a TOTAL field, which is a read-only summary on this form to show a total of the lines. This easily allows the on-account lines to be compared to either the forecast/budget/quotation lines that have been created.
- This can be implemented by choosing to provide a single TOTAL which considers all the different types of the on-account lines or a box each for each type of on-account and a TOTAL that represents the sum of the individual total.
- The TOTAL box should be able to reflect the correct totals in a mixed hierarchy of project types and the different levels within the hierarchy (ie be able to reflect the sums of all on-account lines from child projects within the hierarchy).
This will make a massive difference and improve efficiency of using this form.
Comments
We made one futher step and implemented a % control: enter a milestone as a percentage of the total:
"Enter the project milestones as % of the total contract amount"
To be able to enter or adjust the amount (Sales price) of any kind of on-account transactions as a percentage of the total contract value, implement the following controls on the ProjTransOnAcc form:
1) Total contract: a persisting value, saved in an association with the current project (i.e. the caller or the Project id from the first milestone on the form - if called as a standalone menu item). A small separate table is preferred to avoid concurrent updates and deadlocks. This value must be directly editable by the user to provide the 'seed value' when no milestones exist.
2) % shall be an "edit" kind of a field in the lines. It shall update the Sales price on : Sales price = Currency::amount(Total contract * %) / 100). If the user primarily edits the Sales price, the "%" field should work in the opposite direction and display the amount in the current line as a percentage of the Total contract.
Category: Project Resource Management
Totals on milestones, billing rules and contract commitments can be achieved with New Grid Control feature- R-Click total numeric column
Category: Project Resource Management
Administrator on 11/3/2021 8:23:40 PM
Thanks for submitting this idea. A new grid control now allows subtotals for amounts on the On-account Project form. Just right click on the column and select "total this column." More information on the grid control can be found here:
Grid capabilities - Finance & Operations | Dynamics 365 | Microsoft Docs
Andy Choi
Program Manager, Project management and accounting
Microsoft