General information
Category:
Coding, syntax & commands
Hi Allan,
We faced a similar situation. Out client needed a "quicker" way to enter orders. We gave them a "quick order" dialog with a grid that was prefilled with all of the products and prices. (In our case the list of products and the prices were variable by customer) The grid contained a QTY column so all the users had to do was enter the quantity. In our case, the customers were faxed a copy of their product/price list each week and if they used that list when ordering over the phone, the process was very quick.
Ken
>I was brainstorming today with one of our clients who is using one of our order entry applications.
>The appearance of the current application is probably somewhat typical in that the products are in the grid and each line has the item #, description, price, quantity (entered by user) and extension of the line.
>He mentioned that several of the endusers would rather see the input screen in a spreadsheet format such as:
>
>Gloves - Leather
>Mens
>Colour S M L XL Total
>Black
>Brown
>Grey
>Total
>
>The endusers would enter the qty's per colour/size and Excel would calculate the totals both for the colour and the size.
>Also, each colour/size would be a different item #.
>
>From a tecnical viewpoint, I would prefer not to use a hardcoded Excel template but build the speadsheet in VFP 7 and invoke Excel. When they are finished, I would want to bring the data back into VFP 7.
>
>Has anyone done something similar and hopefully point me in the right direction?
>TIA.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only