The PayrollEarningCode table has CacheLookup property set as EntireTable. Since in our solution we have more then 1000 PayrollEarningCode records, the table works extremenly slowly.

According to recomendation form Microsoft (actually, from you guys) tables which have TableGroup = Reference are not allowed to have CacheLookup = EntireTable.

My recomendation would be to change it from Entire to NonInTTS.

Category: Payroll
Ideas Administrator

Thank you for reaching out. Your suggestion may be a product bug. If possible, please reach out to the relevant support channels as specified in product support (http://go.microsoft.com/fwlink/?LinkID=616937).