Ready to Process on PO's Performance Impact

This is just a quick heads up. I’ve spent a considerable amount of time working through a performance issue on PO entry. We have a customization that allows the user to enter in summarized lines then with the click of a button it will generate the individual line with Part,qty and UOM. This works no problems at all, but the performance of generating the “split out lines” was awful (4.5Mins for 100 line).

After exhausting nearly all avenues I discovered that the Purchase Tax Defaults ->Ready to Process flag in Company configuration had been checked. This was adding additional updates to the POHeaderTax, PODetailTax and PORelTax tables.

Unchecking the flag reduced the creation of lines to 14 seconds. Still not what the developers are seeing but more acceptable.

image

We are on 10.1.600.25, so I am not sure what the difference between 10.2.xxx would have.

1 Like