This topic contains 1 reply, has 1 voice, and was last updated by Matt Pease 5 years, 11 months ago.
-
Posts
-
Hi!
I am trying to save time by transferring serialized inventory from one bin to another using a CSV import, but have not been able to figure out how to do this. Below is the field mapping that I have setup. The error I keep getting is “Transaction type specified is incorrect.” Anyone have an idea what I’m doing wrong, and what fields I need to make this happen? Any help is appreciated.
Thanks,
Matt
<table id=”mapperpane_obj_table” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; font-size: medium; text-align: center; background-color: #fafafa; width: 331px;” cellspacing=”0″ cellpadding=”0″>
<tbody style=”box-sizing: border-box;”>
<tr id=”1526909158380″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=””>Internal ID</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”>
</td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer : Internal ID”>Inventory Transfer : Internal ID</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158380″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>Location</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer : From Location”>Inventory Transfer : From Location</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158381″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><i style=”box-sizing: border-box; color: #333333 !important;”>5/20/2018</i></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer : Date”>Inventory Transfer : Date</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158381″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>Item</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer Items : Item”>Inventory Transfer Items : Item</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158381″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>FromBin</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer Items – Inventory Detail : Bin”>Inventory Transfer Items – Inventory Detail : Bin</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158382″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>qty</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer Items – Inventory Detail : Quantity”>Inventory Transfer Items – Inventory Detail : Quantity</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158382″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>Serial</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer Items – Inventory Detail : Receipt Inventory Number”>Inventory Transfer Items – Inventory Detail : Receipt Inventory Number</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
</tr>
<tr id=”1526909158382″ class=”bg” style=”box-sizing: border-box; background-color: #ffffff; border-bottom: 1px solid #999999; height: 30px;”>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; width: 10px; border: 0px;”></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 0px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Choose Reference Type: Names”>ToBin</span></td>
<td style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; border-bottom: 1px solid #999999; width: 30px;” align=”center”></td>
<td class=”text” style=”box-sizing: border-box; font-family: ‘Open Sans’, Helvetica, sans-serif; color: #000000; font-size: 8pt; width: 115px; border-bottom: 1px solid #999999; padding: 0px 3px;”><span style=”box-sizing: border-box; color: #333333 !important;” title=”Inventory Transfer Items – Inventory Detail : To Bins”>Inventory Transfer Items – Inventory Detail : To Bins</span></td>
</tr>
</tbody>
</table> -
Hopefully this looks a little better
Internal ID – Inventory Transfer : Internal ID **NOT SURE WHAT THIS VALUE IS SUPPOSED TO BE
Location – Inventory Transfer : From Location
Date – Inventory Transfer : Date
Item – Inventory Transfer Items : Item
FromBin – Inventory Transfer Items – Inventory Detail : Bin
qty – Inventory Transfer Items – Inventory Detail : Quantity
Serial – Inventory Transfer Items – Inventory Detail : Receipt Inventory Number
ToBin – Inventory Transfer Items – Inventory Detail : To Bins- This reply was modified 5 years, 11 months ago by Matt Pease.
You must be logged in to reply to this topic.