Dynamics 365 Project Operations

Project journal reversed with the change funding source at project contract, system does not reverse the journal with the original funding source financial dimension. Due to this it causes the inconsistency for the reconciliation.

Please refer to Issue 886210

When enabling the "Project invoice proposal performance enhancement feature" in the "Project management and accounting parameters" a new setup for "Invoice"

"Display available transactions automatically" is available to set the default value.

But in the "Project invoice proposals" when creating a new proposal the "Display available transactions automatically" is greyed out.

For single invoice automatically would be fine.

But for a collective invoice, many filters has to be entered. And for every field the system automatically try to display the result. But this takes several minutes.

The best would be, when the "Display available transactions automatically" would not be greyed out in the create invoices proposal form.

Workaround: "Project invoice proposal performance enhancement feature" disabled

Scenario: You have a customer with an separate invoice account on the customer record.

The same customer is setup on a project contract.

When invoicing the project and creating the project invoice proposal and selecting the project contract. The invoice account from the customer record is selected instead of the customer on the project contract funding source.

A workaround is to create two customer records for the same customer (one with invoice account and one without).

The funding source on the project contract have to be the customer account without an invoice account.

This workaround generates tremendous numbers of customer accounts.

It should be possible to select when generating a project invoice proposal whether the funding source or invoice account is the receiver of the invoice.

All Project entries are recorded on Historical Cost, as determined by the Project Date or the Open Ledger Accounting date (depending on the Parameters set).

When adjusting Project Entries or using the functionality Post Costs. Dual Currency scenario's are not accurately handled and posted.

An enhancement to the process, will be to ensure that Adjustments/Post Costs are performed from the original transaction and that the Accounting Currency and Reporting Currency values are determined off the original posted vouchers or Transaction ID's and not by applying the adjustment date Exchange Rates.

At the moment, date based inputs on Project Accounting creates permanent differences on Reporting Currency and requires consistent Reporting Currency Adjustment journals on Main Accounts prohibited for Manual Posting.

Example:

Source Transaction = ZAR 450.00; Posted: 3 Feb 2022.

Accounting Currency = ZAR, Reporting Currency = USD.

When performing a Post Costs entry and selecting 3 Feb on the transaction - Accounting Currency and Reporting Currency is correctly interpreted.

The Post Costs function is however generally used as an Adjustment event in future periods.

When performing the entry on 7 Feb, the Accounting Currency entry will be correct, but the Reporting Currency scenario will have interpreted the entry on the 7th of Feb and creates a permanent difference on a Balance Sheet account.

Therefore the request to ensure that Project Accounting transactions and adjustments are carried on Historical Cost.

We received feedback from our customer that it would be helpful for users to receive a warning when the same field is updated by another user in parallel as it is the case in F&O. For example, if the customer in a project changes and another user changes it in parallel, the user should receive a warning message that says (similar to F&O): "The record shown has been updated by another user."

The advantage would be that updates by any users would not have the risk of overwriting values that are (already) changed by another user at the same time.

I have requirements to financially post discounts to a different GL on projects. The discounts would be coming from item requirement sales orders. I would like to see the Category Groups and Project Category Groups extended to be able to specify a GL account for discounts, similar to what is currently available for item group setup for sales orders.

F+O workflows for Project Budgets, PO Approvals etc. are limited to a small set of fields to be used as workflow conditions e.g. Project ID. All of which can not be delineated in the Project module to indicate the nature or type of Project which can be a required in respect to who and what approvals are required. E.g. a capital project may have additional approval steps / controls compared to an internal project.

As there is only 1 Project ID number sequence, this field can not be utilized as a workflow condition to dictate workflow branches based on the nature of the Project. The only viable work arounds are to either have a manual Project ID number sequence and inform users of Project ID naming conventions which they will need to enforce on their own or create a Project Group financial dimension.

In respect to the Project Group financial dimension, this is not an ideal candidate for a financial dimension segment as we can dictate postings based on Project Groups and have dedicated accounts for capital v. internal v. revenue etc.

Idea: Utilize the same functionality / logic as Fixed Groups to allow for the definition of unique number sequences by Project Group. This would both enable the use of Project ID in workflow configurations beyond simply 'Is Project? condition' and eliminate the need for customers to create a Project Group financial dimension simply to add improved workflow capabilities.

Alternatively - Add the Project Type field into Project Budget and Purchase / Sales Order workflows

Currently, project tasks are managed by checking whether the completed work time exceeds the total work time.

For example, there is no feature to check whether a task is complete even if the completed work time is less than the planned time.

By implementing a feature to check whether a task is complete or incomplete, regardless of the completed work time, users will be able to manage their tasks more accurately.

We would like to have a field that allows us to see how many hours a task was planned for at the time of order receipt, and to see how much difference there was during and at the end of the project.

However, the Project Task Grid in Project Operations does not allow the addition of custom columns because it is the item used to manage the Work Breakdown Schematic (WBS) in iFrame, which is hosted within Microsoft Dataverse.

We would like the ability to add custom columns to achieve the desired behavior.

Currently, it is necessary to have Project Operations integration enabled in an entity to import a Project Contract header or other relevant data.

It is necessary for the Legal Entity to not have any data to be able to enable this feature, which leads to a dead-end in which you may need to import data but cannot do it due to the lack of integrated legal entity. At the same time, you are unable to integrate the entity because it already has a project on it.

It is true that the public documentation informs of this limitation, but we would still request to have an option to allow this feature on legal entities with data on them.

https://learn.microsoft.com/en-us/dynamics365/project-operations/environment/resource-configure-integration-per-legal-entity#define-the-project-operations-deployment-scenario-for-a-legal-entity

The main idea here is to allow options to users and not force them to undo the work they already have done.

If there is an alternative or a workaround been created for this design choice, please give a clear roadmap or timeline for when it is going to be applied.