Abigail Florence
New member
- Local time
- Today, 14:36
- Joined
- Nov 7, 2022
- Messages
- 10
Hi
I have created a system for a client who has been using many spreadsheets until now and feels there are too many errors this way.
There are two tables. One for the weekly orders and one for the monthly flour orders.
I have made an order form which the user should be able to put in customer name, product description/code and quantity and the system should fill in the rest of the details – price, product code/description. And then it should also calculate the total by quantity*price and adding VAT if relevant. I have no idea how to do this!
Then, I made a customer orders report which the user will print out weekly. It should only show orders of that week not all the orders, but I don’t know how. This should be in alphabetical order.
There is also an overdue report for unpaid orders.
I have attached the system for you to see and would greatly appreciate any help with any of the above mentioned points.
I would also love to hear your opinion to see if it can be improved on further.
Many thanks
Abigail
I have created a system for a client who has been using many spreadsheets until now and feels there are too many errors this way.
There are two tables. One for the weekly orders and one for the monthly flour orders.
I have made an order form which the user should be able to put in customer name, product description/code and quantity and the system should fill in the rest of the details – price, product code/description. And then it should also calculate the total by quantity*price and adding VAT if relevant. I have no idea how to do this!
Then, I made a customer orders report which the user will print out weekly. It should only show orders of that week not all the orders, but I don’t know how. This should be in alphabetical order.
There is also an overdue report for unpaid orders.
I have attached the system for you to see and would greatly appreciate any help with any of the above mentioned points.
I would also love to hear your opinion to see if it can be improved on further.
Many thanks
Abigail