Improvements to Inventory Transaction History performance
Some improvements to the response time of the Inventory > Order > Transaction History tab by applying these indexes.
Advanced SQL skills necessary
CREATE INDEX IX_SO_Main_BillWhenComplete ON SO_Main(BillWhenComplete)
CREATE INDEX IX_SO_Main_CreditNote ON SO_Main(CreditNote)
CREATE INDEX IX_SO_Lines_LineLinkID ON SO_Lines(LineLinkID) INCLUDE(InvoiceHistoryID)