It would help to be able to cut and paste (or import) columns of information from Excel into MAS order entry grid fields. Occassionally a salesperson inputs lists of item numbers, order qty's and other info into a spreadsheet to manage a developing order, or received it that way from a customer. It would save alot of time if they could for example highlight a range of 100 item descriptions in Excel and cut/paste into the item description grid area in MAS SO. Obviously they would need to cut and paste or enter the other necessary details before being able to save and move on. Alternatively, an import from Excel, if formats matched, might also work there.
by: Brent Z. | over a year ago | Sales & Distribution
Comments
While a VI job can do this, the average user would benefit greatly from the simplicity of what you suggest. Escpecially where you don't want to create a VI job for only 100 records, but at the same time, you don't want to have to key all that data a second time if you already have it in excel. I'm just curious how data validation would be handled for each row when you paste. Would you only be able to paste a column at a time, or would your worksheet columns need to match your grid with all user input fields completed?
We often have prepacks/kits that are in Excel, and if we could just paste the cells with part numbers into SO data entry, or prices, or quantities that would be great. It would be so much easier than using VI. I find that a lot of customers send their orders in Excel so pasting into SO data entry would make the process so much simpler.