TS will look like this:
For the action "Calculate the average price of taking the product and write it in an additional field"
https://take.ms/PZy5qImprove the ability to specify warehouse priorities:
- Add a tick "Take the price of posting according to the FIFO method (instead of the average price)"
- If the checkbox is checked - show 2 columns: Warehouse (from the list of warehouses), Priority (manually specify an integer, the higher the number, the higher the priority).
- Making the setting "Add priority setting" - when clicked, another line is added with a warehouse and a priority
As a result, we set, for example, 2 warehouses
Warehouse 1 - Priority 2
Warehouse 2 - Priority 1
It should work like this - if there is a balance in a warehouse with the highest priority (in this case, Warehouse 1), then we take the price from it until the goods on it run out according to FIFO
If the goods ended in Warehouse 1, then we start from the earliest arrival to pull the price from Warehouse 2 and so on for all priorities. We do not need to divide anything in the price, we take only the price at which the goods are credited, that is, do NOT apply summation and division in variables
The rest - we make a reference book, write the condition for the product + margin values into it, pull these values into the product card according to the condition, and then calculate each price level using the formula.
___________________________________
We already have 40+ actions when saving a product card, which can lead to a long processing of goods + add actions for calculating prices (5 actions) and filling from the directory (5 actions)
If we make changes like this:
1) For the action "Calculate the value using the formula and write to the specified field"
https://take.ms/e1wStadd the ability to specify multiple lines to record different values in different fields
https://take.ms/lv9FUas in the setting below
2) For the action "Fill in an additional field based on additional fields and reference data"
https://take.ms/g1eNCAdd the ability to take several values from the directory and fill in different product fields
https://take.ms/tOsZlDoes this optimize the processing time for all actions? With these improvements, I can reduce the number of actions to 10-20.
Rate it please?