Does anyone have a solution for bulk receiving of serialized items in Epicor 10.1.400.xx. We often get in 2000-5000 serialized items that don’t have a full sequence of serial numbers. We end up spending hours either scanning in the serial number or entering many ranges of serial numbers. Any thoughts?
Are you familiar with DMT - Data Management Tool. It’s pretty commonly sold to customers direct from Epicor. It would do exactly what you need, assuming you had the serial numbers in digital form already.
http://www.dotnetit.co.uk/solutions/solution/epicor-data-management-tool-dmt
There are varying degrees of customization which you could do for this task.
As Adam has mentioned, if you have these all in an appropriate CSV format (and most importantly, you trust the vendor to provide 100% accurate data for what you’ve received), you could set up DMT templates for the creation of the receipt, serial numbers, etc. The DMT tool now has command line launch options which allow for easier automation without service connect.
If you still want to leverage other tools in the receiving interface, such as printouts, labels, etc, I might approach this through a customization on the serial number selection screen. Here you could either browse for a csv to load into custom logic that would parse the serial numbers into the selectedserialnumbers dataset, or you could create QR codes in batches of 200 with a separator to do the same. I don’t believe using tab/enter separators between serials will work, because the screen might miss keystrokes while creating serials.
If you don’t have this expertise in house, I might DMT, then open the created receipt to access these.
1 Like
Yes, I think we will end up having to have something custom made for the Serial input screen. The DMT would work but I don’t want to give access to it to the inventory folks and would prefer it be something they can do easily and still be able to check the input before saving. Thanks!
Scott Thompson
IT Manager/Webmaster
Advanced Wireless Communications
Yes, I thought about that one too but don’t want to give access to the inventory folks. It needs to be something they can import and check visually before saving. Likely will need to be a customization of the serial input form. Thanks though!
Scott Thompson
IT Manager/Webmaster
Advanced Wireless Communications
Scott we wrote a customization to do this for a customer who received
printed circuit boards, thousands at a time, each with a unique serial
number and no specific range that we could use as well. It required the
vendor to send a pack slip in a excel format. We added a button and then
imported the pack lines with the serial numbers
Mark Wagner
Sr. Partner
Capstone Alliance Partners 888.597.2227 Ext. 71
<888.597.2227%20Ext.%20714>2 | 904.412.6847 mwagner@capstoneap.com (cell)
| www.capstoneap.com
Perfect would love to see it and get pricing! Thanks
Scott Thompson
IT Manager/Webmaster
Advanced Wireless Communications
You could write a VB macro that would script DMT, import the data, and close DMT. Since the macro can be encrypted, your inventory personnel would never know the password. We have done this for many customers.
Yes, that would work too but we’re hosted and use the SSL Client normally so might be hard to work out the details of that. But, thanks, that is a good idea!
Scott Thompson
IT Manager/Webmaster
Advanced Wireless Communications