Support UDR Sales History Trx Edit List Reports in Elliott 8.6
In COP -> Processing -> Sales History Trx Processing -> Reports -> Edit List, we currently do not support Report Desk. We are here proposing to add UDR support for Sales History Trx Edit List. One of the main consideration is CPHSTTRX table primary key begin with Invoice Date. Most of the sales history report are limited to a particular date range. Therefore, all sales history report will have a date range. Using CPHSTTRX table as the primary table for sales analysis will result in best performance. I suggest we also join to the following tables:
* left join CPINVHDR
* left join IMITMFIL
* left join ARCUSFIL
* left join ARSLMFIL
* left join CPSHPFIL
The selection of invoice date range is mandatory in the filter area.