• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Indexes to access

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member Send Private Message
Posts: 41
Advanced Member
9/17/2009 7:38 PM
Hi all,

Any indexes I can use to help speed up AR and AP Distrib reports?

Thanks!
Norm
Veteran Member Send Private Message
Posts: 40
Veteran Member
9/18/2009 3:28 PM
Took a quick peek at apps 9.0.1 and there are 12 indexes for APDISTRIB and 8 for ARDISTRIB. I'd get hold of the definitions for your apps level to see if any of them will help. Unfortunately, my experience has been mixed with using alternate indexes for reporting. Lawson tends to define indexes for operational use rather than reporting and as often as not, there's not an index that does me any good. Sometimes you get lucky though, so good luck.