Topic: Windows Application
Good day Everyone!
I am new baby for MVD and I am not familiar with the script.
I need help for the following:
Assume I have created the windows application for my client. Do my client need to purchase the MVD software in order to run the application?
I have my database design blueprint for my application:
Table:
- Products
- Location -> One location need to be default
- Delivery Order Header -> - Delivery Order Line
- Sales Invoice Header -> - Sales Invoice Line
Header and Line Table
It is better to separate the Delivery Order Table and Sales Invoice Table separately or use the same table?
Get Location Default
When user add new record on the Delivery Order, the default location auto show on the Delivery Order Header.
Do I need to write the script? If yes, how to write the script.
Generate Sales Invoice from Delivery Order
After completed the Delivery Order transaction, I would like to make a button click to generate the Sales Invoice and copy the Delivery Order Header Information and Line to Sales Invoice Header and Line? Do I need to write the script for this? If yes, how to write the script.
Select Delivery Order from Sales Invoice
From the Sales Order Form, user click "Add New" record for Sales Invoice and select the Customer Name. I need to create a button -> click to show all the "Delivery Order Transaction" related to this customer only. User can tick the check box to select which DO to be selected and click "Generate" -> those selected "Delivery Order" will copy the Delivery Order Line to the Sales Invoice Line auto. It is difficult to write the script?
How do I write such script?
Thanks for the advise.
Jack Lim