Sales Ledger Table #F42199

[2foot9]

Hi List. I am trying to speed up the search time in the Credit Memo form for the pricing of returns. It seems that regardless of the amount of Header Section or QBE data entered, the search must still plough through all the record hits in the ledger before it returns the queried data. Can anyony tell me the ramifications or damage that can happen if old records are deleted from the Sales Ledger Table? Alternatively, is there a method to return faster query results if the records cannot be deleted?

 

[Oliver]

Hi,

For F42199, JDE is using only a single unique index for the following fields (SLDOCO, SLDCTO, SLKCOO, SLLNID, SLUPMJ, SLTDAY)

Let your CNC create a custom index in JDE based on your data requirements.

Hope this helps.

 

[2foot9]

Hi Oliver,
Sorry for the slow response. We have added a custom index using the SLLITM and response from the query is much quicker.
Thank you.