Warehouse Transfers

Warehouse transfers let you move inventory from one warehouse to another using a single operation.

List Warehouse Transfers

readByQuery

<readByQuery>
    <object>ICTRANFER</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Optional string Use ICTRANFER.
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100).

Get Warehouse Transfer

read

<read>
    <object>ICTRANFER</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use ICTRANSFER.
keys Required string The warehouse RECORDNO to get.
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create Warehouse Transfer

create

Transfer 200 widgets from warehouse WH101 to warehouse WH102.

<create>
    <ICTRANSFER>
        <TRANSACTIONDATE>07/27/2017</TRANSACTIONDATE>
        <DESCRIPTION>Moving widgets to Warehouse WH102</DESCRIPTION>
        <ICTRANSFERITEMS>
            <ICTRANSFERITEM>
                <IN_OUT>O</IN_OUT>
                <ITEMID>x2</ITEMID>
                <WAREHOUSEID>WH101</WAREHOUSEID>
                <QUANTITY>200</QUANTITY>
                <UNIT>Each</UNIT>
                <LOCATIONID>100</LOCATIONID>
            </ICTRANSFERITEM>
            <ICTRANSFERITEM>
                <IN_OUT>I</IN_OUT>
                <ITEMID>x2</ITEMID>
                <WAREHOUSEID>WH102</WAREHOUSEID>
                <QUANTITY>200</QUANTITY>
                <UNIT>Each</UNIT>
                <LOCATIONID>100</LOCATIONID>
            </ICTRANSFERITEM>
        </ICTRANSFERITEMS>
    </ICTRANSFER>
</create>

Parameters

Name Required Type Description
ICTRANSFER Required object The object to create.

ICTRANSFER

Name Required Type Description
TRANSACTIONDATE Required string Date of the transfer.
REFERENCENO Optional String Reference number for the transfer.
DESCRIPTION Optional string Description.
ICTRANSFERITEMS Required ICTRANSFERITEM[] Warehouse transfer lines. Must be one or more matched pairs (with one outgoing and one incoming ICTRANSFERITEM).

ICTRANSFERITEM

Name Required Type Description
IN_OUT Required integer Specifies whether this side of the pair represents the warehouse sending the inventory (outgoing) or the warehouse receiving the inventory (incoming). Use O for outgoing and I for incoming.
ITEMID Required string Item ID for the inventory to transfer.
WAREHOUSEID Required string Warehouse ID.
MEMO Optional string Memo.
QUANTITY Required number Quantity.
UNIT Required string Unit of measure to base quantity off.
LOCATIONID Optional string Location ID.
DEPARTMENTID Optional string Department ID.
PROJECTID Optional string Project ID.
CUSTOMERID Optional string CUSTOMER ID.
VENDDORID Optional string VENDOR ID.
EMPLOYEEID Optional string Employee ID.
CLASSID Optional string Class ID.

Update Warehouse Transfer

Update the transfer to move fewer (only 50) widgets and change the description.

update

<update>
    <ICTRANSFER>
        <RECORDNO>3</RECORDNO>
        <DESCRIPTION>Reducing the number of widgets to transfer</DESCRIPTION>
        <ICTRANSFERITEMS>
            <ICTRANSFERITEM>
                <IN_OUT>O</IN_OUT>
                <ITEMID>x2</ITEMID>
                <WAREHOUSEID>WH102</WAREHOUSEID>
                <QUANTITY>50</QUANTITY>
                <UNIT>Each</UNIT>
                <LOCATIONID>100</LOCATIONID>
            </ICTRANSFERITEM>
            <ICTRANSFERITEM>
                <IN_OUT>I</IN_OUT>
                <ITEMID>x2</ITEMID>
                <WAREHOUSEID>WH101</WAREHOUSEID>
                <QUANTITY>50</QUANTITY>
                <UNIT>Each</UNIT>
                <LOCATIONID>100</LOCATIONID>
            </ICTRANSFERITEM>
        </ICTRANSFERITEMS>
    </ICTRANSFER>
</update>

Parameters

Name Required Type Description
ICTRANSFER Optional object The object to update.

ICTRANSFER

Name Required Type Description
RECORDNO Required integer Record number of the warehouse transfer.
TRANSACTIONDATE Optional string Date of the transfer.
REFERENCENO Optional String Reference number for the transfer.
DESCRIPTION Optional string Description.
ICTRANSFERITEMS Optional ICTRANSFERITEM[] Warehouse transfer lines. Must be one or more matched pairs (with one outgoing and one incoming ICTRANSFERITEM).

ICTRANSFERITEM

Name Required Type Description
IN_OUT Required integer Specifies whether this side of the pair represents the warehouse sending the inventory (outgoing) or the warehouse receiving the inventory (incoming). Use O for outgoing and I for incoming.
ITEMID Required string Item ID for the inventory to transfer.
WAREHOUSEID Required string Warehouse ID.
MEMO Optional string Memo.
QUANTITY Required number Quantity.
UNIT Optional string Unit of measure to base quantity off.
LOCATIONID Optional string Location ID
DEPARTMENTID Optional string Department ID.
PROJECTID Optional string Project ID.
CUSTOMERID Optional string CUSTOMER ID.
VENDDORID Optional string VENDOR ID.
EMPLOYEEID Optional string Employee ID.
CLASSID Optional string Class ID.

Delete Warehouse Transfer

delete

<delete>
    <object>ICTRANSFER</object>
    <keys>1</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use ICTRANSFER.
keys Required string The warehouse RECORDNO to delete.

Provide feedback