Performance in the project module/project invoices

(1) Share

Report

Posted on by EN-04120816-0

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?

I have the same question (0)

All responses (1)

Answers (0)

t4m7 61 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No