Forums › Cached › CSV Import

Tagged: ,

This topic contains 1 reply, has 1 voice, and was last updated by Matt Pease 6 years, 6 months ago.

  • Author
    Posts
  • May 21, 2018 at 8:36 am #16417

    Matt Pease
    Member
    @matt_pease

    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>

  • May 21, 2018 at 8:45 am #16418

    Matt Pease
    Member
    @matt_pease

    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 6 years, 6 months ago by Matt Pease.
  • Author
    Posts

You must be logged in to reply to this topic.