Warehouse Transfers

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

Get Warehouse Transfer Object Definition

lookup

List all the fields and relationships for the warehouse transfer object:

<lookup>
    <object>ICTRANSFER</object>
</lookup>

Parameters

Name Required Type Description
object Required string Use ICTRANSFER

List Warehouse Transfers

query

List the record number and description for each warehouse transfer:

<query>
    <object>ICTRANSFER</object>
    <select>
        <field>RECORDNO</field>
        <field>DESCRIPTION</field>
    </select>
</query>

Parameters

Name Required Type Description
object Required string Use ICTRANSFER
select Required sequence One or more field names and an optional aggregate function such as count or sum. Returning all fields is not supported.
filter Optional object Query filter expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
orderby Optional object Provide an order element with a field name and choose an ascending or descending sort order, for example:
<order>
        <field>RECORDNO</field>
        <descending/>
</order>
options Optional object Set the caseinsensitive element to true for a case-insensitive query:
    <caseinsensitive>true</caseinsensitive>
In a multi-entity company, set the showprivate element to true to query data in private entities:
   <showprivate>true</showprivate>
pagesize Optional integer Custom page size between 1 and 2000 items (Default: 100)
offset Optional integer Point at which to start indexing into records (Default: 0)

List Warehouse Transfers (Legacy)

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. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
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