Sales reports - where is the truth?

Good afternoon. In the first case (in Alain's report) you filter ORDERS by creation date in the second https://nutfarine.crm-onebox.com/admin/shop/storage/motionlog/?type=sale&datefrom=2021-04-01&dateto=2021-04 -30&productId=&serialnumber=&paymentid=&articul=&categoryid=&managerid=0&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0% B0%D1%82%D1%8C# WAREHOUSE ACTIVITIES by warehouse entry date. I hope you understand the difference between these entities and the fact that an order can be created today and sold, for example, in a month (or not sold from a warehouse).

You probably do not carefully look at the filtering settings. In both options, the date of creation is followed by a filter where a warehouse operation (Sale) and the date of this operation are selected. Well, the date of sale is selected in the magazine - which is the same in the mentioned reports

Previously, with the settings set, the sums of these two reports plus or minus UAH 1000 coincided. Now the difference is about 50,000 UAH - very noticeable. I want to understand what figure to equal to in order to take into account the sales of April

I saw that you selected a filter by the date of the warehouse transaction, but you additionally apply filtering by the date the order was created, despite the fact that here https://nutfarine.crm-onebox.com/admin/shop/storage/motionlog/?type=sale&datefrom= 2021-04-01&dateto=2021-04-30&productId=&serialnumber=&paymentid=&articul=&categoryid=&managerid=0&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0 %BE%D0%B2%D0%B0%D1%82%D1%8C# no such date

https://nutfarine.crm-onebox.com/admin/report/desiner/4/view/?filter_order_cdatefrom=2021-03-22&filter_order_cdateto=2021-04-30&filter_order_client=&filter_storageaction_type=sale&filter_storageaction_from=2021-04-01&filter_storageaction_to=2021-04 -30&filter_order_groupid=0&filter_order_workflowid%5B%5D=15&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=91&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=94&filter_order_statusid%5B%5D=95&filter_order_statusid%5B%5D =96&filter_order_statusid%5B%5D=97&filter_order_statusid%5B%5D=98&filter_order_statusid%5B%5D=99&filter_order_statusid%5B%5D=100&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D=103&filter_order_statusid%5B%5D=104&filter_order_statusid %5B%5D=106&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D=110&filter_order_statusid%5B%5D=113&filter_order_statusid%5B%5D=11 4&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=117&filter_order_statusid%5B%5D=118&filter_order_statusid%5B%5D=126&filter_order_statusid%5B%5D=145&filter_order_statusid%5B%5D=146&filter_order_statusid%5B%5D=151&filter_order_statusid%5B%5D=187&filter_order_statusid% 5B%5D=194&filter_order_statusid%5B%5D=196&filter_order_statusid%5B%5D=231&filter_order_statusid%5B%5D=232&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80 %D0%BE%D0%B2%D0%B0%D1%82%D1%8C If you add total lines to the sales report (OUR) then they will count the same as in the sales report (Alena) Now the question arose - what correctly sums up the table of the report on sales by category tree or the total rows?

That is, if I have a process where five products for 200 UAH are set in the product card, but I set these products a price of 0 for this particular process, then the sales report will show 0, and the report on products by category will show me 1000 UAH ?

No, in your case both the category report and the process report will show 0. The item sold report looks at the price of a product in a process, taking into account the discount of the process product. But if you apply a discount not for a specific product to the entire process, then the report on products sold does not take into account this discount.

what report do you call "on sold products" the one that Alena or ours? I'm confused

https://nutfarine.crm-onebox.com/admin/report/desiner/4/view/?filter_order_cdatefrom=2021-03-22&filter_order_cdateto=2021-04-30&filter_order_client=&filter_storageaction_type=sale&filter_storageaction_from=2021-04-01&filter_storageaction_to=2021-04 -30&filter_order_groupid=0&filter_order_workflowid%5B%5D=15&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=91&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=94&filter_order_statusid%5B%5D=95&filter_order_statusid%5B%5D =96&filter_order_statusid%5B%5D=97&filter_order_statusid%5B%5D=98&filter_order_statusid%5B%5D=99&filter_order_statusid%5B%5D=100&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D=103&filter_order_statusid%5B%5D=104&filter_order_statusid %5B%5D=106&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D=110&filter_order_statusid%5B%5D=113&filter_order_statusid%5B%5D=11 4&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=117&filter_order_statusid%5B%5D=118&filter_order_statusid%5B%5D=126&filter_order_statusid%5B%5D=145&filter_order_statusid%5B%5D=146&filter_order_statusid%5B%5D=151&filter_order_statusid%5B%5D=187&filter_order_statusid% 5B%5D=194&filter_order_statusid%5B%5D=196&filter_order_statusid%5B%5D=231&filter_order_statusid%5B%5D=232&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80 %D0%BE%D0%B2%D0%B0%D1%82%D1%8C which is below. By category

And how can I find out the orders to which the discount on the process was applied? Because the difference of 50 thousand is too big for a discount on the process.

try filtering by days to understand on which of the processes the data diverges. On a volume of 1k orders, it is impossible to understand which of the processes shows different data and why

I found the day where the discrepancy appeared. 04/16/2021 sales, order 18683 https://nutfarine.crm-onebox.com/admin/customorder/order/18683/edit/ In the order, the total amount is 97,250.00, but in the report https://nutfarine.crm-onebox.com/admin/report/desiner/2/view/?filter_order_cdatefrom=2021-03-22&filter_order_cdateto=2021-04-30&filter_storageaction_type=sale&filter_storageaction_from=2021- 04-16&filter_storageaction_to=2021-04-16&filter_order_client=&filter_order_workflowid%5B%5D=15&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=91&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=94&filter_order_statusid%5B% 5D=95&filter_order_statusid%5B%5D=96&filter_order_statusid%5B%5D=97&filter_order_statusid%5B%5D=98&filter_order_statusid%5B%5D=99&filter_order_statusid%5B%5D=100&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D= 103&filter_order_statusid%5B%5D=104&filter_order_statusid%5B%5D=106&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D=110&filter_order_statusid%1 der_statusid%5B%5D=114&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=117&filter_order_statusid%5B%5D=118&filter_order_statusid%5B%5D=126&filter_order_statusid%5B%5D=145&filter_order_statusid%5B%5D=146&filter_order_statusid%5B%5D=151&filter_order_statusid% 5B%5D=187&filter_order_statusid%5B%5D=194&filter_order_statusid%5B%5D=196&filter_order_statusid%5B%5D=231&filter_order_statusid%5B%5D=232&filter_product_id=0&filter_product_articul=&templateid=&ok=%D0%A4%D0%B8%D %8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C order amount is 48650.0000. Can you explain why this happened? I see that there code 44 gives the amount "57,750.00", but in the invoice it gives 9150. And if you look at the invoice, then the order amount will come out to be 48650.

Sorry, I figured out the problem myself. Corrected the mistake But still I wonder why in the report https://nutfarine.crm-onebox.com/admin/report/desiner/2/view/?filter_order_cdatefrom=2021-03-22&filter_order_cdateto=2021-04-30&filter_storageaction_type=sale&filter_storageaction_from=2021-04- 16&filter_storageaction_to=2021-04-16&filter_order_client=&filter_order_workflowid%5B%5D=15&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=91&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=94&filter_order_statusid%5B%5D= 95&filter_order_statusid%5B%5D=96&filter_order_statusid%5B%5D=97&filter_order_statusid%5B%5D=98&filter_order_statusid%5B%5D=99&filter_order_statusid%5B%5D=100&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D=103&filter_order_statusid% 5B%5D=104&filter_order_statusid%5B%5D=106&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D=110&filter_order_statusid%5B%5D=1_order tatusid%5B%5D=114&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=117&filter_order_statusid%5B%5D=118&filter_order_statusid%5B%5D=126&filter_order_statusid%5B%5D=145&filter_order_statusid%5B%5D=146&filter_order_statusid%5B%5D=151&filter_order_statusid% 5B%5D=187&filter_order_statusid%5B%5D=194&filter_order_statusid%5B%5D=196&filter_order_statusid%5B%5D=231&filter_order_statusid%5B%5D=232&filter_product_id=0&filter_product_articul=&templateid=&ok=%D0%A4%D0%B8%D %8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C was 48650 and not process sum 97250 ?

I do not quite understand the question, https://nutfarine.crm-onebox.com/admin/report/desiner/2/view/?filter_order_cdatefrom=2021-03-22&filter_order_cdateto=2021-04-30&filter_storageaction_type=sale&filter_storageaction_from=2021-04-16&filter_storageaction_to= 2021-04-16&filter_order_client=&filter_order_workflowid%5B%5D=15&filter_order_statusid%5B%5D=89&filter_order_statusid%5B%5D=90&filter_order_statusid%5B%5D=91&filter_order_statusid%5B%5D=92&filter_order_statusid%5B%5D=94&filter_order_statusid%5B%5D=95&filter_order_statusid% 5B%5D=96&filter_order_statusid%5B%5D=97&filter_order_statusid%5B%5D=98&filter_order_statusid%5B%5D=99&filter_order_statusid%5B%5D=100&filter_order_statusid%5B%5D=101&filter_order_statusid%5B%5D=102&filter_order_statusid%5B%5D=103&filter_order_statusid%5B% 5D=104&filter_order_statusid%5B%5D=106&filter_order_statusid%5B%5D=107&filter_order_statusid%5B%5D=108&filter_order_statusid%5B%5D=109&filter_order_statusid%5B%5D=110&filter_order_statusid%5B%5D=113&filter_order_statusid%5B%5D=113&filter_order_statusid%5B%5_order D=114&filter_order_statusid%5B%5D=116&filter_order_statusid%5B%5D=117&filter_order_statusid%5B%5D=118&filter_order_statusid%5B%5D=126&filter_order_statusid%5B%5D=145&filter_order_statusid%5B%5D=146&filter_order_statusid%5B%5D=151&filter_order_statusid%5B%5D= 187&filter_order_statusid%5B%5D=194&filter_order_statusid%5B%5D=196&filter_order_statusid%5B%5D=231&filter_order_statusid%5B%5D=232&filter_product_id=0&filter_product_articul=&templateid=&ok=%D0%A4%D0%B8%D0%BBD1 %82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C here now the specified process shows the amount 48650.0000

This is because I adjusted the price in the process and the amount of the process changed. And before that, there was the sum of the process 97250, and in Alain's report there was the sum 48650