Warehouse Transfers

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

List Warehouse Transfers

readByQuery

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

Parameters

Name Required Type Description
object Required string Use ICTRANSFER
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 Custom page size between 1 and 1000 items (Default: 100)

Get Warehouse Transfer

read

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

Parameters

Name Required Type Description
object Required string Use ICTRANSFER
keys Required string 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>

Transfer 200 widgets between warehouses with different base currencies using a custom exchange rate:

<create>
    <ICTRANSFER>
        <TRANSACTIONDATE>07/27/2017</TRANSACTIONDATE>
        <DESCRIPTION>Moving widgets to Warehouse WH102</DESCRIPTION>
        <EXCH_RATE_DATE>10/16/2017</EXCH_RATE_DATE>
        <EXCHANGE_RATE>1.9</EXCHANGE_RATE>
        <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 Use ICTRANSFER

ICTRANSFER

Name Required Type Description
TRANSACTIONDATE Required string Date of the transfer
REFERENCENO Optional String Reference number for the transfer
DESCRIPTION Optional string Description
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Do not use if EXCHANGE_RATE is set. (Default: Intacct Daily Rate)
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy (Default: TRANSACTIONDATE)
EXCHANGE_RATE Optional currency Exchange rate with precision up to 10 decimals. Do not use if EXCH_RATE_TYPE_ID is set.
ICTRANSFERITEMS Required ICTRANSFERITEM[2...n] 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 on which to base quantity
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 Required object Use ICTRANSFER

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
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Do not use if EXCHANGE_RATE is set. (Default: Intacct Daily Rate)
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy (Default: TRANSACTIONDATE)
EXCHANGE_RATE Optional currency Exchange rate with precision up to 10 decimals. Do not use if EXCH_RATE_TYPE_ID is set.
ICTRANSFERITEMS Optional ICTRANSFERITEM[2...n] 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 on which to base quantity
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 Warehouse transfer RECORDNO to delete

Provide feedback