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.
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.
[quote]
Bodyako Dmitry
Employee wrote:
Good afternoon, please give a link to your report.
[/quote]
https://andser.crm-onebox.com/admin/report/desiner/6/view/?filter_storagemove_datefrom=2020-10-01&filter_storagemove_dateto=2020-10-31&filter_order_productionstoragenameid%5B%5D=4&filter_order_workflowid%5B%5D=14&filter_order_statusid%5B %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
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.
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.
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
Donate
You don't have enough funds in your account Top up