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)
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.
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.