1b.app
Link copied -

Improvement: "Report on product sales for the selected period"

It is necessary to refine the report, namely, to add the "Not sold" column, which will count the quantity of goods from the BP with the Order canceled status (without NR return). This status includes PSUs that were not picked up or refused delivery by Nova Poshta, but we did not issue a refund for them and storage is charged.
It is also necessary to consider the sum of the cost of these goods.
Original question is available on version: ru

Answers:

Good afternoon, please give a link to your report.
05.11.2020, 11:24
Original comment available on version: ru


Bodyako Dmitry
Employee wrote:
Good afternoon, please give a link to your report.

https://andser.crm-onebox.com/admin/report/desiner/6/view/?filter_storagemove_da... %5D=83&filter_order_statusid%5B%5D=194&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=172&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=95&filter_order_statusid%5B%5D=171&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D =188&filter_order_statusid%5B%5D=85&filter_order_statusid%5B%5D=86&filter_order_statusid%5B%5D=178&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=112&filter_order_statusid%5B%5D=179&filter_order_statusid%5B%5D=180&filter_order_statusid%5B%5D=115&filter_order_statusid %5B%5D=113&filter_order_statusid%5B%5D=208&filter_order_statusid%5B%5D=110&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D=206&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=170 5D=103&filter_order_statusid%5B%5D=169&filter_order_statusid%5B%5D=93&filter_order_statusid%5B%5D=185&filter_order_statusid%5B%5D=88&filter_order_statusid%5B%5D=104&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D= 181&filter_order_statusid%5B%5D=186&filter_order_statusid%5B%5D=177&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=209&filter_order_statusid%5B%5D=215&filter_order_statusid%5B%5D=217&filter_order_statusid%5B%5D=218&templateid=&ok=%D0%A4 %D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
05.11.2020, 14:10
Original comment available on version: ru

1. Make a column with the number of goods in processes on a certain status 2h. In the report settings there will be a choice of statuses.
2. Make a column with the sum of the cost (the sum of the purchase fields. The price for these goods should be taken from the table of process products?) Will take 3 hours.
06.11.2020, 16:27
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment