Comments
Why this is critical in PPACWhen moving from LCS to PPAC, we lose direct SQL insight that is essential for operating D365 F&O in production. Capabilities such as viewing long-running queries, blocking trees, live executing statements, and terminating problematic SQL sessions are required to resolve deadlocks and performance issues in real time.Without these, even basic production incidents would require opening Microsoft support tickets just to obtain transient runtime data. This significantly increases resolution time and business impact, especially since many SQL issues must be analyzed while they are happening.Today, partners and customers can self-service most SQL-related incidents in LCS. Removing this without an equivalent PPAC replacement is an operational regression and introduces unnecessary dependency, downtime risk, and inefficiency.At minimum, PPAC should provide read-only SQL runtime insight and index visibility to maintain current operational capabilities.
I have a couple more comments about this. By not allowing summarization it means that we cannot tie ALL of the entries in the project journal back to the project planning line since you cannot post multiple times to the same project planning line in a single journal document.Lastly, the project ledger entry is not tied to the project planning line with the below setup. So, if you go into the project planning lines, you cannot tell that anything has been posted against the specific line you are looking at.
I'd like to add to this that it would be great to summarize the entries by resource, job and task. We would like to tie the posted hours back to the job planning line specifically for that resource, it makes it easier to track actual hours when you go into the planning lines. But, since you cannot post to the same planning line multiple times in one project journal entry, this is not possible. Right now, If you specify a week of dates, what you get is a list of all the daily entries by resource, job and task. It would be much better to have an option to summarize them for the time period specified.