BAS KUP settings

Desktop Apps, Enterprise Resource Planning (ERP) — incorrectly specified categories?

45 USD

Project translated automatically. Log in or register, to view the original

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.

Proposals 2

Vasily P.

7 0

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.

Vlad Bilokur
Kyiv, Ukraine
Nutritive Cosmetics

Projects 78
Rating 5.0
Rating 2 523

BAS KUP settings

Vasily P.

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Microsoft Power Platform/Power App

Need a specialist for developing an online store on Shopify with Amazon integration.

Need an Airtable architect to build a relational schema and a new clean Airtable base.

Small edit on the website