<img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.svg"> <a name="add-reports-merging-sale-and-point-of-sale-datas"></a> <h2>Add reports merging 'Sale' and 'Point of Sale' Datas</h2> <p>Add a graph report view in the Report menu to merge sale and point of sale Net informations:</p> <ul class="simple"> <li>Net Sales Evolution;</li> <li>Net Sales by Category (3 levels);</li> <li>Top Products saled;</li> </ul> <a name="technical-information"></a> <h3>Technical Information</h3> <ul class="simple"> <li>As this module merge point of sale and sale information, the sql views are using UNION statement; So, performance are very bad, and to avoid that this module create MATERIALIZED view;</li> <li>So information doesn't take into account, last day sales;</li> <li>A cron Task update the materialized view each night;</li> </ul> <p><strong>you so need Postgresql 9.3+ to install this module;</strong></p> <a name="ref"></a> <h3>Ref:</h3> <p><a class="reference external" href="http://stackoverflow.com/questions/18134798/why-does-my-view-in-postgresql-not-use-the-index">http://stackoverflow.com/questions/18134798/why-does-my-view-in-postgresql-not-use-the-index</a></p> <img alt="/pos_sale_reporting/static/description/sale_and_pos_net_sale.png" src="/pos_sale_reporting/static/description/sale_and_pos_net_sale.png" /> <a name="credits"></a> <h4>Credits</h4> <a name="contributors"></a> <h3>Contributors</h3> <ul class="simple"> <li>Julien WESTE;</li> <li>Sylvain LE GAL (<a class="reference external" href="https://twitter.com/legalsylvain">https://twitter.com/legalsylvain</a>);</li> </ul>