I am hitting serious performance issues on time phase for parts that have very long lead times.
These parts generate over 1000 time phase entries and can take up to 90 seconds to return.
I rebuild the indexes every week and this has no impact.
I posted the same question on the user group and the reason is that time phase calculates the running total for every entry, but alas, no suggestions as to how to fix it.
When facing problems with viewing the actual on hand quantity of materials for entries scheduled far out, I find that this method works best:
Open part tracker and go to the “Warehouse” tab.
Take note of the material quantity required for desired entry in question.
Subtract the “Total Demand Qty” from the “Qty On Hand”.
Then add the recorded material quantity from step 2 to the “Qty On Hand”. This will give you the actual quantity on hand.
Essentially you are taking out the demand of all other entries from the on hand quantity and adding in the amount for the entry in question, giving you the quantity on hand before the material is taken out for the entry in question.