I am pursuing a usability problem with Sage 300 CRE Service Management module, the problem presents as isolated to a single workstation at a time but not the same computer or user.  When our service dispatch personnel push the create new work order button it takes 5-30 seconds to open the dialog box for location.  Which databases and tables does this process access when the button is pushed?  I have started removing data that is <5 years old which has improved viewing work orders and invoices, I suspect this process is digging through a huge table with very old data.

Thanks,

Mike