Hi there everybody,
in order to save time to the user I was thinking to automate the input of Batch info. Before let me explain our business process.
1.Create the Purchase Order
2. After 2 months~ Entry Good, using the "Copy From" button
3. In field "Quantity" of the row CTRL-TAB and then the user add all the Batch Info.
Problem is that, since we selling reels of Nylon-Polyester etc.. the weight per reels is always different, as well as the info related to the reel and some time the packing list of our vendor got more than 500 reels
So what I thought, let the user do the process, but instead of load all the info related to the reels he/she insert just one and then thru my program I modify and add all the other. But I was reading in another thred, Yatsea Li, say that is not possible (picklist-problems).
Now my question, what could be the best solution, in order to implement some functionallity to let the user save time and avoid misktake, because, I forgot to mention it before, but we got packing list in Excel format from our supplie, so I was thinking using VBA per Excel to Upload all the information directly via oPickList object.
Hope I explain properly myself
Thnx
Roberto