1b.app
Link copied -

Report table of sales by orders

It is necessary to configure the sales table report on orders . The report correctly filters by supplier if the supplier is specified in the product card, but there may be cases when the same product is purchased from different suppliers.
For example, the product was posted from the supplier and sold, accordingly, it was included in the sales analysis report when filtering by this supplier , but if you specify another supplier in the product card (there was no posting from him) [file]13637[ /file] when filtering by the second supplier, the report will display the goods that were not shipped from him . Please tell me how to set up the correct filtering in this situation?
Original question is available on version: ua

Answers:

Unfortunately, according to your screenshots (where everything is drawn), the need is not clear.
Please clarify the links to the examples of filtration that you are talking about and what changes in the logic of the filter specifically you need.
18.01.2022, 16:57
Original comment available on version: ua

Lotocka_Kristina
Personal license

Maksym Vadimovych Tyndyk
OneBox production wrote:
Unfortunately, according to your screenshots (where everything is drawn), the need is not clear.
Please clarify the links to the examples of filtration that you are talking about and what changes in the logic of the filter specifically you need.

The product card (7001) lists 2 suppliers
1. If you filter the report by the first supplier from the product card, the data is pulled correctly, since the product was sold from the first supplier
2. if you select the second supplier in the filter (which is indicated in the card of the same product), this process and the product will be included in the report. If you follow the link in the report to the process number - warehouses tab - movement history, you can see that the goods were shipped from the first supplier .
Link to report filter sales table by orders with grouping: https://logogroup.crm-onebox.com/admin/report/desiner/10/view/?filter_order_id=0... 11. %D0%A4%D1%96%D0%BB%D1%8C%D1%82%D1%80%D1%83%D0%B2%D0%B0%D1%82%D0%B8 .
Tell me how to correctly configure the filter so that the report filters data by the supplier from which the posting was made.
24.01.2022, 14:58
Original comment available on version: ua


Lotocka_Kristina wrote:
Tell me how to correctly configure the filter so that the report filters data by the supplier from which the posting was made.

There is no such possibility - this is not an obvious filtration.
26.01.2022, 14:33
Original comment available on version: ua

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