We are into distribution network and hence we have many distributors with salesman who goes to different routes for capturing orders in market from shop hence searching out some solution so that these orders can be taken directly into a web based software in which some drop down selection will be done to select distributor name, beat name, then outlet list assigned to that beat and then salesman will start taking order for that particular outlet by selecting from our sku list.
After capturing the order he should see final summary of order for that outlet and at the end of his route he should see his day summary by outlet.
Also we need to capture all this data on excel format from where we can download the same and analyse.
These summaries are to be available to salesman so that he can view it any time.
For ur help i am attaching a thought how we need the process