Displaying the posting date field in the balance in warehouses
There is a report on stock balances in the system /admin/shop/storage/balance/ https://prnt.sc/vckmlu
1. You need to add a field to the table the date of arrival of the goods at the warehouse.
It is the date of the warehouse operation of posting this particular product. If we filter by separate records https://prnt.sc/vckou9, then it shows each product separately as arrivals and, accordingly, their arrival dates may be different.
2. You also need to add sorting by this field: from A to Z and from Z to A by date.
3. Add a filter for this field to the filter panel https://prnt.sc/vckr1y
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
1. You need to add a field to the table the date of arrival of the goods at the warehouse.
It is the date of the warehouse operation of posting this particular product. If we filter by separate records https://prnt.sc/vckou9, then it shows each product separately as arrivals and, accordingly, their arrival dates may be different.
2. You also need to add sorting by this field: from A to Z and from Z to A by date.
3. Add a filter for this field to the filter panel https://prnt.sc/vckr1y
Answers:
1.2h If there are 2 or 3 arrivals, it will show the date of the first one.
2. Will there be a sorting option in the filtering panel, will it work? In the filter you choose "sort XX ascending" or "sort XX descending". Around 4h
3. 3h
2. Will there be a sorting option in the filtering panel, will it work? In the filter you choose "sort XX ascending" or "sort XX descending". Around 4h
3. 3h
03.11.2020, 18:53
Original comment available on version: ru
Bodyako Dmitry
Employee wrote:
1.2h If there are 2 or 3 arrivals, it will show the date of the first one.
2. Will there be a sorting option in the filtering panel, will it work? In the filter you choose "sort XX ascending" or "sort XX descending". Around 4h
3. 3h
1. And why will it show only the date of the first one? We can show the date of each arrival for a separate product.
2. Do you mean this setting? https://prnt.sc/vd3564
04.11.2020, 08:58
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
1. Multiple dates, each on a new line? Yes
2. I'll take a look or https://prnt.sc/vd3564 it will be possible to embed here or into the filter, if that sorting does not work here. It is better to do this at the time of completion
2. I'll take a look or https://prnt.sc/vd3564 it will be possible to embed here or into the filter, if that sorting does not work here. It is better to do this at the time of completion
04.11.2020, 10:59
Original comment available on version: ru
Bodyako Dmitry
Employee wrote:
1. Multiple dates, each on a new line? Yes
2. I'll take a look or https://prnt.sc/vd3564 it will be possible to embed here or into the filter, if that sorting does not work here. It is better to do this at the time of completion
1. Do you mean like this? https://prnt.sc/vd5k2r
If there are 3 items in stock, will they have different dates?
Is it possible to do this exactly as 3 lines of goods? That is, there will be 3 lines like this https://prnt.sc/vd5kym, 1 piece each and each has its own arrival date?
04.11.2020, 11:09
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
1. yes
2. Check the box on the left in the filters "display as separate records" and it will be separate lines without grouping
2. Check the box on the left in the filters "display as separate records" and it will be separate lines without grouping
06.11.2020, 16:35
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
