Views:

Applies to Product -Dynamics 365 Project Operations


What’s happening?
Customers are unable to finalize projects.


Reason:
The underlying cause is that there are unposted transactions associated with the project, which prevents the project stage from being changed to completed.


Resolution:
To resolve the project finalization issue:

  1. Check for any unposted transactions related to the project.
  2. Use the following SQL script to identify unposted transactions:  sql SELECT TransID, TransDataAreaId, DataAreaId, TransDate, TransactionOrigin, * FROM ProjUnpostedTransView WHERE ProjID = '' AND TransDataAreaID = ''
  3. Investigate any hidden unposted transactions using the following SQL script: sql SELECT ...
  4. Check for any pending deduction transactions with: sql SELECT TransID, DataAreaId, TransDate, TransactionOrigin, * FROM PROJONACCTRANSUNPOSTEDVIEW WHERE ProjID = '' AND DataAreaID = ''