Job description
I will order a custom SQL report for Subiekt nexo Pro.
Extract report - showing assortment ordered by customers by group/customer. The columns we want in the report are:
1. Lp,
2. assortment
3. date of original
4. quantity to be realized
5. warehouse
6. realization status
7. date of last realization
8. order
9. comments
The report is to show the current order status with grouping by customer. We have two warehouses, so warehouse filtering is also needed.
It wants to automate the sending of such a report.
A tab with a preview of the assortment ordered is available in the program, but strictly such a report is not.