1b.app
Link copied -

Rate improvements by product

1) Modify in the price list import:
- the ability to write a value in an additional field of several fields
- possibility to specify the variable [cdate] and [cdatetime]
- add the "Do not fill if the value is already set" checkbox for this setting, respectively, for the date it should take into account that 0000-00-00 is an empty value
- add the setting "Ignore the setting for updating supplier fields" - only for the selected additional field
When importing a price list, it should work like this:
If there is a value in the additional field, then do not write a new one
If there is no value or it is equal to 0000-00-00, then write the date into it
+ this should work even if the checkbox "Only update supplier data if a product is found" is unchecked
2) In goods automation:
- finalize the action for copying fields from Posting
- selection of warehouses to consider
- selection of an additional field where to write the value
Original question is available on version: ru

Answers:

1.6h
2. Do you need to get warehouses every time you save a product? - this is some kind of game)
3. 7h
14.10.2021, 02:53
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
2. Do you need to get warehouses every time you save a product? - this is some kind of game)

we have the same action for calculating the average price, this is a similar principle, can't you do it?
My task is this:
here https://crm-onebox.com/ru/support/other/7869-otsenit-dorabotku-po-sortirovke-v-k... did a revision for LC.
This refinement only works for the warehouse, I need it to work for suppliers as well, but not by the update date of the supplier, but by the date when the supplier has it.
Here I described https://crm-onebox.com/ru/support/other/11099-dorabotat-filtr-v-kabinete-klienta... - I wrote that they decided, but in fact - no (
14.10.2021, 12:43
Original comment available on version: ru


Sukhanitsky Andrey
Integrator
Integrator CRM wrote:
we have the same action for calculating the average price, this is a similar principle, can't you do it?

so this is complete garbage to get warehouses and recalculate ...
need another solution
what is the purpose of this paragraph. ?
18.10.2021, 01:14
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
so this is complete garbage to get warehouses and recalculate ...
need another solution
what is the purpose of this paragraph. ?

here I described https://crm-onebox.com/ru/support/other/11099-dorabotat-filtr-v-kabinete-klienta...
duplicate:
Made revision https://crm-onebox.com/ru/support/other/7869-otsenit-dorabotku-po-sortirovke-vk....
Now we have added a supplier, but we do not maintain a warehouse for it, but simply write it as a supplier and write the quantity from the supplier to the product card, then display it in the office, if the supplier has one
You need the ability to sort by the date of receipt from the supplier.
The only idea I have so far is:
Modify the field in the product card (in the Suppliers tab) "Date of receipt", write on this date when it appeared in stock. To control the updating of this field, I propose to reset it if the goods are out of stock at the supplier (that is, the checkbox is unchecked)
Then, in the previously modified filter, we add sorting by this date, it should be sorted in parallel with the posting date. The priority will be posting, that is, if the goods appeared at the supplier and in the warehouse, then we show by the date of the warehouse (or for newer goods - who has a date closer to the current one, I will agree on this)
If there are other suggestions how to implement, please tell me.
18.10.2021, 01:16
Original comment available on version: ru


Sukhanitsky Andrey
Integrator
Integrator CRM wrote:

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
so this is complete garbage to get warehouses and recalculate ...
need another solution
what is the purpose of this paragraph. ?

here I described https://crm-onebox.com/ru/support/other/11099-dorabotat-filtr-v-kabinete-klienta...
duplicate:
Made revision https://crm-onebox.com/ru/support/other/7869-otsenit-dorabotku-po-sortirovke-vk....
Now we have added a supplier, but we do not maintain a warehouse for it, but simply write it as a supplier and write the quantity from the supplier to the product card, then display it in the office, if the supplier has one
You need the ability to sort by the date of receipt from the supplier.
The only idea I have so far is:
Modify the field in the product card (in the Suppliers tab) "Date of receipt", write on this date when it appeared in stock. To control the updating of this field, I propose to reset it if the goods are out of stock at the supplier (that is, the checkbox is unchecked)
Then, in the previously modified filter, we add sorting by this date, it should be sorted in parallel with the posting date. The priority will be posting, that is, if the goods appeared at the supplier and in the warehouse, then we show by the date of the warehouse (or for newer goods - who has a date closer to the current one, I will agree on this)
If there are other suggestions how to implement, please tell me.

finalize it 8 hours
20.10.2021, 18:56
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