Error in the report "Table of products that were not sold for the period"
2024-08-07 14:21:02
Leave a message in this thread and the user's contacts will be shown to you
Good day!
Example of a product in the report https://kiyservice.1b.app/app/report/desiner/25/view/?filter_storagenotsaleprodu... id %5B%5D=12&filter_storagenotsaleproduct_storageid%5B%5D=33&filter_storagenotsaleproduct_showonlyavail=1&filter_order_cdatefrom=2024-07-15&filter_order_cdateto=2024-07-15&filter_product_articul=481925928948&ok=%D0%A4%D0%B8%D0%BB %D1%8C%D1%82% D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C, it is written that it has not been sold for 275 days, but in fact the last sale of this product was on August 3, 2024
here is the order https://kiyservice.1b.app/117951/
here is the product sale history https://kiyservice.1b.app/app/storage/products/19840/storage/?type=sale&ok=%... D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
I displayed the required status in the report settings, but it still shows incorrect information
Please help to figure it out, thanks!
Original question is available on version: ua
Example of a product in the report https://kiyservice.1b.app/app/report/desiner/25/view/?filter_storagenotsaleprodu... id %5B%5D=12&filter_storagenotsaleproduct_storageid%5B%5D=33&filter_storagenotsaleproduct_showonlyavail=1&filter_order_cdatefrom=2024-07-15&filter_order_cdateto=2024-07-15&filter_product_articul=481925928948&ok=%D0%A4%D0%B8%D0%BB %D1%8C%D1%82% D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C, it is written that it has not been sold for 275 days, but in fact the last sale of this product was on August 3, 2024
here is the order https://kiyservice.1b.app/117951/
here is the product sale history https://kiyservice.1b.app/app/storage/products/19840/storage/?type=sale&ok=%... D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
I displayed the required status in the report settings, but it still shows incorrect information
Please help to figure it out, thanks!
Answers:
https://kiyservice.1b.app/app/report/desiner/25/view/?filter_storagenotsaleprodu... 11&filter_storagenotsaleproduct_stor ageid%5B%5D=12&filter_storagenotsaleproduct_storageid%5B%5D=33&filter_storagenotsaleproduct_showonlyavail=1&filter_order_cdatefrom=2024-08-07&filter_order_cdateto=2024-07-15&filter_product_articul=481925928948&ok=%D0 %A4%D0%B8%D0%BB%D1%8C%D1%82 %D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
Days without sales are counted in the period by the date of order filtering. That is, the filter that I dropped counts "days without sales on the date 2024-08-07"
Days without sales are counted in the period by the date of order filtering. That is, the filter that I dropped counts "days without sales on the date 2024-08-07"
07.08.2024, 14:27
Original comment available on version: ru
Морозов Сергей Сергеевич
Sergey Morozov
Sergey Morozov
Leave a message in this thread and the user's contacts will be shown to you
Thank you
Can you tell me why your dates are backwards?
date of creation from 07.08.2024
date of creation is 15.07.2024
What dates should I select to get up-to-date information for this quarter/year?
Can you tell me why your dates are backwards?
date of creation from 07.08.2024
date of creation is 15.07.2024
What dates should I select to get up-to-date information for this quarter/year?
07.08.2024, 14:40
Original comment available on version: ru
It depends on what is relevant information for you. Days without sales are counted for a specific date, and the sales amounts themselves are already in the context of a specific period. In this regard, the question is: what do you want to see?
07.08.2024, 14:50
Original comment available on version: ru
Морозов Сергей Сергеевич
Sergey Morozov
Sergey Morozov
Leave a message in this thread and the user's contacts will be shown to you
We need information about how many days certain goods have not been sold since the beginning of the year and up to the current day.
as I understand it, you need to specify dates like this https://kiyservice.1b.app/app/report/desiner/25/view/?filter_storagenotsaleprodu... otsaleproduct_storageid%5B%5D=12&filter_storagenotsaleproduct_storageid%5B%5D=33&filter_storagenotsaleproduct_showonlyavail=1&filter_order_cdatefrom=2024-08-07&filter_order_cdateto=2024-01-01&ok=%D0%A4%D0%B8%D0 %BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
as I understand it, you need to specify dates like this https://kiyservice.1b.app/app/report/desiner/25/view/?filter_storagenotsaleprodu... otsaleproduct_storageid%5B%5D=12&filter_storagenotsaleproduct_storageid%5B%5D=33&filter_storagenotsaleproduct_showonlyavail=1&filter_order_cdatefrom=2024-08-07&filter_order_cdateto=2024-01-01&ok=%D0%A4%D0%B8%D0 %BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
07.08.2024, 15:00
Original comment available on version: ru
Yes, in the first date always indicate the current day and it will show the current day.
07.08.2024, 15:19
Original comment available on version: ru
Морозов Сергей Сергеевич
Sergey Morozov
Sergey Morozov
Leave a message in this thread and the user's contacts will be shown to you
Accepted, thank you!
07.08.2024, 15:29
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
