Editing SOP Order Very Slow

(0) Share

Report

Posted on by Ian Grieve

22,782

I'm currently examining an SQL trace and wondered if anyone had seen SOP Trx Entry being very slow update when a user makes a change to a line (e.g. by setting a quantity to backorder)? The larger the order the slower it is.

*This post is locked for comments

All responses (2)

Answers (0)

Tim Wappat 5,703 on at

Like (0)

Report

RE: Editing SOP Order Very Slow

Yes I have but it was just SQL server needed a maintenance attention. Rebuilding indexes, checking usual SQL best practices in place got things back to normal.

Be interested in what you find.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Editing SOP Order Very Slow

Ian, Can you give us additional information. What is GP and SQL Version. Is this happening in all workstations. Do you have any customization SOP Trx Entry ?