Hello!
I will describe the real situation and what is desired!
1. The client sends an order in an Excel file.
2. The data, specifically the quantity of boxes and the price, is manually transferred to the specification file.
3. Then an invoice file is created based on the specification.
It is desired that upon receiving the order file, it is somehow uploaded or read, and only the items that are ordered (the blue column) are selected, and a Specification and Invoice file is created automatically, filling in the quantity of ordered boxes and the price from the order file.
Features:
All three files have different data content for the corresponding items.
When ordering, the client can order a different assortment each time.
We can create one file as a database where everything will be recorded, and only what is needed will be entered into the Specification and Invoice.
There are 20+ clients, and new ones are being added.
Each has its own prices.
In the Invoice, a different bank for payment is set for each client.
Ready to consider any possible implementation, offline or online. It is preferable to have the ability to expand and modify data. Adding items. Adding clients.
Ideally, it would be great if the client had their own login and could access a web page to place orders, and we would receive a notification about the order. If we approve it, the Specification and Invoice would be immediately generated and sent to the client for signing and payment, and to us for production.
From the realm of fantasy:
It would be good for the client to see their previous orders.
Based on the previous one, they could create a new order, changing only the quantity of boxes ordered.
The budget can be reviewed depending on the quality and capabilities of your execution, but it is not limitless.)