Product sales report
We need a Report on the sale of products, which should display: Nomenclature (product name), Quantity (the sum of all sales of this nomenclature), Incoming cost (the sum of all sales of this nomenclature), Sales cost (the sum of all sales of this nomenclature)
Filter by: First payment, Customer, Item series, Item name.
We made such a report https://hte.crm-onebox.com/admin/report/desiner/5/view/
But here you need to constantly expand the information, in this form it is not suitable, since then you need to do a lot of additional actions in order to summarize the quantity for the same products.
Attached a screenshot as we would like it to look visually
Is it possible to implement such a report with standard functionality, if not, then please evaluate.
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Filter by: First payment, Customer, Item series, Item name.
We made such a report https://hte.crm-onebox.com/admin/report/desiner/5/view/
But here you need to constantly expand the information, in this form it is not suitable, since then you need to do a lot of additional actions in order to summarize the quantity for the same products.
Attached a screenshot as we would like it to look visually
Is it possible to implement such a report with standard functionality, if not, then please evaluate.
Answers:
what didn't you like about this one?
https://hte.crm-onebox.com/admin/shop/products/ordered/mode/?datefrom=&datet... =7&workflowid[4]=15&statusid[0]=48&statusid[1]=49&statusid[2]=50&statusid[3]=51&statusid[4]=149&statusid[5]=167&statusid[6]=178&statusid[7]=184&statusid[8] =64&statusid[9]=65&statusid[10]=66&statusid[11]=10&statusid[12]=82&statusid[13]=86&statusid[14]=97&statusid[15]=99&statusid[16]=100&statusid[17]=101&statusid[18] =103&statusid[19]=104&statusid[20]=106&statusid[21]=107&statusid[22]=108&statusid[23]=109&statusid[24]=110&statusid[25]=111&statusid[26]=112&statusid[27]=113&statusid[28] =114&statusid[29]=117&statusid[30]=118&statusid[31]=168&statusid[32]=181&statusid[33]=40&statusid[34]=41&statusid[35]=42&statusid[36]=43&statusid[37]=138&statusid[38] =139&statusid[39]=146&statusid[40]=148&filterclientid=&sorttype=---&filterid=&filterarticul=&filtercode1c=&filtername=&filterpricefrom=&filterpriceto=&supplierid=&filterbrands=&cate goryid=&searchLine=
https://hte.crm-onebox.com/admin/shop/products/ordered/mode/?datefrom=&datet... =7&workflowid[4]=15&statusid[0]=48&statusid[1]=49&statusid[2]=50&statusid[3]=51&statusid[4]=149&statusid[5]=167&statusid[6]=178&statusid[7]=184&statusid[8] =64&statusid[9]=65&statusid[10]=66&statusid[11]=10&statusid[12]=82&statusid[13]=86&statusid[14]=97&statusid[15]=99&statusid[16]=100&statusid[17]=101&statusid[18] =103&statusid[19]=104&statusid[20]=106&statusid[21]=107&statusid[22]=108&statusid[23]=109&statusid[24]=110&statusid[25]=111&statusid[26]=112&statusid[27]=113&statusid[28] =114&statusid[29]=117&statusid[30]=118&statusid[31]=168&statusid[32]=181&statusid[33]=40&statusid[34]=41&statusid[35]=42&statusid[36]=43&statusid[37]=138&statusid[38] =139&statusid[39]=146&statusid[40]=148&filterclientid=&sorttype=---&filterid=&filterarticul=&filtercode1c=&filtername=&filterpricefrom=&filterpriceto=&supplierid=&filterbrands=&cate goryid=&searchLine=
20.09.2021, 23:59
Original comment available on version: ru
Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
what didn't you like about this one?
https://hte.crm-onebox.com/admin/shop/products/ordered/mode/?datefrom=&datet... =7&workflowid[4]=15&statusid[0]=48&statusid[1]=49&statusid[2]=50&statusid[3]=51&statusid[4]=149&statusid[5]=167&statusid[6]=178&statusid[7]=184&statusid[8] =64&statusid[9]=65&statusid[10]=66&statusid[11]=10&statusid[12]=82&statusid[13]=86&statusid[14]=97&statusid[15]=99&statusid[16]=100&statusid[17]=101&statusid[18] =103&statusid[19]=104&statusid[20]=106&statusid[21]=107&statusid[22]=108&statusid[23]=109&statusid[24]=110&statusid[25]=111&statusid[26]=112&statusid[27]=113&statusid[28] =114&statusid[29]=117&statusid[30]=118&statusid[31]=168&statusid[32]=181&statusid[33]=40&statusid[34]=41&statusid[35]=42&statusid[36]=43&statusid[37]=138&statusid[38] =139&statusid[39]=146&statusid[40]=148&filterclientid=&sorttype=---&filterid=&filterarticul=&filtercode1c=&filtername=&filterpricefrom=&filterpriceto=&supplierid=&filterbrands=&cate goryid=&searchLine=
The client wants visually in such a form as in the screenshot
21.09.2021, 10:57
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
then you need to use the report that is in the description but do not display the categories, but immediately the goods - so the rules?
21.09.2021, 14:50
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
Copyright © OneBox 2024
