Improvements to Inventory Transaction History performance

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)