Budget: 5000 UAH Deadline: 3 days
Good day. I can help with the task. But on the condition of either having a copy of the database. Or a stable connection to the server with a copy of the database.
Hello.
There is such a technical task.
It is necessary to set restrictions on the shipment of products with a specified remaining shelf life. That is, it is necessary to establish a restriction in % or in months (there should be a choice) and products that do not meet the restriction cannot be sold to the customer.
For example, I set a minimum remaining shelf life of 12 months, which means that in the customer's order, when pulling the batch, products with a remaining shelf life of less than or equal to 12 months cannot be included, even if such products are available in stock.
This also applies to the restriction in % of the total shelf life.
For example, if the total shelf life is 24 months, that is 100%.
If we specify that the remaining shelf life must be 70%, it means (24/100*70=16.8 months) that products with a remaining shelf life of more than 16.8 months will be included in the order.
If we specify 50%, then accordingly, products with a remaining shelf life of more than 12 months can be included in the order.
If the total shelf life is 36 months and with a restriction of 70%, products with a remaining shelf life of more than 25.2 months will be included in the order.
These settings must be made in the contract with the counterparty.
If no restrictions are set, the program pulls batches from the available stock using the FIFO method.
If a restriction is set in months, it is not possible to set a restriction in % for the same contract, and vice versa, if a restriction is set in %, the field for setting the restriction in months becomes inactive.
When deleting a set restriction, both fields are active; when setting any restriction in one field, the other becomes inactive.
In the case where more products are ordered than are available in stock, the program splits the ordered unit line into several lines according to the batches that will be sold, taking into account the restrictions, and creates another line indicating the quantity that cannot be sold due to the absence of available stock that can be sold. That is, if 1000 units are ordered, of which we can sell 500 units, and the other 500 are either not in stock or have an unsuitable shelf life, the program creates a separate line for these 500 units with an empty batch.
All these actions are performed by clicking the button to fill in batches using the FIFO method.
When clicked again, the program should not duplicate lines with empty batch values.
The settings must be performed via AniDesk through our user.
Budget: 5000 UAH Deadline: 3 days
Good day. I can help with the task. But on the condition of either having a copy of the database. Or a stable connection to the server with a copy of the database.
Python 52 proposals 31 July
Testing & QA 11 proposals 29 July
13 proposals 28 July
PHP 63 proposals 28 July
Web Programming 66 proposals 22 July