Descrizione del progetto
Hello, there! At the moment, the enterprise is faced with the task of forming convenient order accounting systems. If you want to do this job, write your terms.
Our main wishes are below.
A table should be created to account for orders received by the enterprise.
For an approximate view of the table, see para. Orders logging file.
All the necessary data should be entered by the manager in the order database (Data sheet), for clarity it is better to do this in the form of an Order Form, in which there should be such fields: date, account number, customer, product name, number, price, total order amount, payment date, payment amount (it is necessary to provide the possibility to make several dates and amounts, because. Often paid in parts, plan. Shipping date, plan. The amount of shipment, fact. Date of shipment, name of shipped products, number of shipped products.
Customer and product names should be made as a drop-down list with the possibility of adding new names and auto-search.
Further, from the data on orders it is necessary to form consolidated reports (list of Payment, Shipment). In summary reports, you need to add the calculation columns "Residue" .
It is also necessary that data on planned and actual shipments in terms of dates and names are automatically (e.g., the data on the planned and actual shipments). using the Update Production Plan button, they were fed into the file. Accounting by tables (shipment plan list).
Our main wishes are below.
A table should be created to account for orders received by the enterprise.
For an approximate view of the table, see para. Orders logging file.
All the necessary data should be entered by the manager in the order database (Data sheet), for clarity it is better to do this in the form of an Order Form, in which there should be such fields: date, account number, customer, product name, number, price, total order amount, payment date, payment amount (it is necessary to provide the possibility to make several dates and amounts, because. Often paid in parts, plan. Shipping date, plan. The amount of shipment, fact. Date of shipment, name of shipped products, number of shipped products.
Customer and product names should be made as a drop-down list with the possibility of adding new names and auto-search.
Further, from the data on orders it is necessary to form consolidated reports (list of Payment, Shipment). In summary reports, you need to add the calculation columns "Residue" .
It is also necessary that data on planned and actual shipments in terms of dates and names are automatically (e.g., the data on the planned and actual shipments). using the Update Production Plan button, they were fed into the file. Accounting by tables (shipment plan list).
