Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-234198]
*Issue:*
AP open clearing detail report is encountering a timeout issue due to missing index in table tblAPBillDetailTax
{noformat}CREATE NONCLUSTERED INDEX [tblAPBillDetailTax_intBillDetailId]
ON [dbo].[tblAPBillDetailTax] ([intBillDetailId],[intTaxCodeId],[intTaxClassId])
GO{noformat}
!pastedImage_d159139_0.png|height=495,width=910!
*Expected Result:*
The open clearing detail report should not encounter timeout issue.
|