Dynamics Community Forum Thread Details

Performance in the project module/project invoices

Hello,

We are facing big performance issues when using the project module in D365 Finance & Operations.
These are intercompany orders.

1. "Invoice proposal" button on the project: taking several minutes
2. Selection of lines that should be processed: takes 10 minutes

3. Invoice proposal creation: takes 5 minutes

4. Posting of invoice proposals in batch job: 4-5hours

5. Many times the batch job times out without any information or error

Testcase: 130 sales orders, 2000lines
All custom code and ISVs removed

We have had Microsoft and our technical partners look into this, and we believe all "simple" things have been tested.
We also see this slowness with much fewer sales order lines.

Anyone else that have had these issues? Experience with working with and invoicing through the project module with high amount of transactions?
Could it be historical transactions that the project module goes through each time?

If you view telemetry, does it seem like a query is blocking anything, or does it seem like it is just looking up way too much?

I'd suggest, if you can, if you have a tier 1 VM, can you use the activity monitor in SSMS to see what queries are happening? It should help show if something is blocking. Alternately, you could run a trace for one of the shorter exercises and then analyze the trace...you may see a query with a high count in terms of the number of times it ran.

There can be a lot of factors, for example, if you have lots of pricing records, or resource validations, categories or category validations, tax calculations, or tax calls to an external API, etc...it could be repeating any of those things on every line. Still, nothing should take as long as you are describing, so it seems like it might be getting stuck, either blocked or stuck in a loop.

Quick Links

Leaderboard