Our management asked me to make a gross margin report which the report has;
Preferred Vendor Name
Normal Selling Price
Customer Price List
The Input key was Gross Margin Start and End .
Above query need to evaluate all price list given to customer... so we know which margin to be evaluate to increase total margin of the company..