Refinement of the report Turnover by suppliers
There is a report https://crm.mebelok.com/admin/shop/report/suppliersturnover/?datefrom=2021-11-07... D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
Can I add to it to unfold the processes where these goods were sold with a link to the processes?
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Can I add to it to unfold the processes where these goods were sold with a link to the processes?
Answers:
Is the supplier reconciliation act not suitable for solving this need? Or do you need specific details like in this report?
16.11.2021, 17:43
Original comment available on version: ru
Tyndyk Maxim Vadimovich
OneBox production wrote:
Is the supplier reconciliation act not suitable for solving this need? Or do you need specific details like in this report?
Details are needed in this report.
16.11.2021, 19:07
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
And the columns should all be as detailed as the process?
How would you understand that when forming a query, for optimization and performance purposes, grouping / summing queries are used, and your version requires enumeration.
How would you understand that when forming a query, for optimization and performance purposes, grouping / summing queries are used, and your version requires enumeration.
17.11.2021, 16:13
Original comment available on version: ru
Tyndyk Maxim Vadimovich
OneBox production wrote:
And the columns should all be as detailed as the process?
How would you understand that when forming a query, for optimization and performance purposes, grouping / summing queries are used, and your version requires enumeration.
do not quite understand..
Can you explain with an example?
17.11.2021, 17:50
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Strilec Anton Nikolaevich KTS wrote:
do not quite understand..
Can you explain with an example?
The table header contains the columns "Number of units sold" / "Amount of cost per product sold" and so on.
Should they count in the same way in the context of each process that is unfolding?
18.11.2021, 13:51
Original comment available on version: ru
Tyndyk Maxim Vadimovich
OneBox production wrote:
Strilec Anton Nikolaevich KTS wrote:
do not quite understand..
Can you explain with an example?
The table header contains the columns "Number of units sold" / "Amount of cost per product sold" and so on.
Should they count in the same way in the context of each process that is unfolding?
Well, in fact, yes, since these data are taken to calculate the report.
So that you can see in detail from what the figures in the report were formed
19.11.2021, 15:51
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Well, in fact, such a refinement will reduce the speed of the report at times, if not dozens of times - is this acceptable?
Estimated around 12h
Estimated around 12h
22.11.2021, 14:55
Original comment available on version: ru
Tyndyk Maxim Vadimovich
OneBox production wrote:
Well, in fact, such a refinement will reduce the speed of the report at times, if not dozens of times - is this acceptable?
Estimated around 12h
If dozens of times, then of course it is not acceptable.
Are there any options for solving the speed of the report?
24.11.2021, 09:43
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
If dozens of times, then of course it is not acceptable.
This is an abstract judgment, I cannot provide you with exact data before implementation. Maybe everything will not be so critical.
But you must understand that there will be a difference - to make 1 query summarizing orders or iterate over each order and make miscalculations.
Are there any options for solving the speed of the report?
Not to do something in it that will require additional time for counting / queries?)
24.11.2021, 15:39
Original comment available on version: ru
https://crm.mebelok.com/admin/shop/report/suppliersturnover/?datefrom=2021-11-07... D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
added a checkbox to the filters "Show details on processes with product sales operations" - next to the supplier, it becomes possible to expand the processes on sales of the supplier's goods
added a checkbox to the filters "Show details on processes with product sales operations" - next to the supplier, it becomes possible to expand the processes on sales of the supplier's goods
08.02.2022, 15:13
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
