The vdvCustomerPaymentAppl View has been around for many versions. In Sage 500 v7.4 there was a minor change with Customer Payments and Apply to Invoices. This was a positive change in that we had more ways to associate Payments to Order, Shipment and eventually Invoices.
The vdvCustomerPaymentAppl View uses a component of this enhancement. What we recently noticed is that there is a missing Index on tarCustPmtAppl to enhance the performance of this View.
After doing some major analysis on this View what we have uncovered is the following missing Index.
So you would run a script like this, then click on the query plan column link. This would give you the plan. Then you could do a save as on that plan and give it a .sqlplan file extension.
The results for the client were amazing. The client said they remember this task taking sometimes over 10 minutes or more to return the results, now it is seconds!
