Encompasses the details about an item that is used in Inventory Control, Order Entry, and/or Purchasing.


List Items

readByQuery

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

Parameters

Name Required Type Description
object Required string Use ITEM
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)

query

Name Required Type Description
ITEMTYPE Optional string Item type. Use I for Inventory, NI for Non-Inventory, NP for Non-Inventory (Purchase only), NS for Non-Inventory (Sales only), K for Kit, or SK for Stockable Kit.
COST_METHOD Optional string Cost method. Use S for Standard, A for Average, F for FIFO, or L for LIFO.
VSOECATEGORY Optional string VSOE category. Use PSD for Product - Specified, SFW for Software, PUS for Product - Unspecified, UUS for Upgrade - Unspecified, USD for Upgrade - Specified, SVR for Services, or PCS for Post Contract Support(PCS).
VSOEDLVRSTATUS Optional string VSOE default delivery status. Use D for Delivered or U for Undelivered.
VSOEREVDEFSTATUS Optional string VSOE default deferral status. Use I for Defer until item is delivered or B for Defer bundle until item is delivered.
REVPOSTING Optional string Kit revenue posting. Use I for Component Level or K for Kit Level.
REVPRINTING Optional string Kit print format. Use I for Individual Components or K for Kit.
TERMPERIOD Optional string Periods measured in. Use D for Days, W for Weeks, M for Months, or Y for Years.

Get Item

read

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

Parameters

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

Get Item by Name

readByName

<readByName>
    <object>ITEM</object>
    <keys>I1</keys>
    <fields>*</fields>
</readByName>

Parameters

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

Release Changes
2018 Release 4 Added ENABLE_REPLENISHMENT, DEFAULT_REPLENISHMENT_UOM, REPLENISHMENT_METHOD, SAFETY_STOCK, MAX_ORDER_QTY, REORDER_POINT, REORDER_QTY, FORECAST_DEMAND_IN_LEAD_TIME, VENDORINFO, WAREHOUSEINFO
2018 Release 3 Added ENABLELANDEDCOST and LANDEDCOSTINFO

create

Create an item:

<create>
    <ITEM>
        <ITEMID>I1</ITEMID>
        <NAME>hello world</NAME>
        <ITEMTYPE>Inventory</ITEMTYPE>
    </ITEM>
</create>

Create an item with landed costs:

<create>
    <ITEM>
        <ITEMID>I1</ITEMID>
        <NAME>TESTING</NAME>
        <ITEMTYPE>Inventory</ITEMTYPE>
        <ENABLELANDEDCOST>true</ENABLELANDEDCOST>
        <LANDEDCOSTINFO>
            <ITEMLANDEDCOST>
                <METHOD>Volume</METHOD>
                <VALUE>2</VALUE>
                <ACTIVE>true</ACTIVE>
            </ITEMLANDEDCOST>
            <ITEMLANDEDCOST>
                <METHOD>Weight</METHOD>
                <VALUE>1</VALUE>
                <ACTIVE>true</ACTIVE>
            </ITEMLANDEDCOST>
        </LANDEDCOSTINFO>
    </ITEM>
</create>

Create an item with replenishment features. For this example, warehouse WH01 has a shorter lead time (3 days) for parts ordered from the nearby Snap Hardware distributor. For other warehouses, the lead time would be taken from the vendor entry under VENDORINFO.

<create>
    <ITEM>
        <ITEMID>Hex bolt-033</ITEMID>
        <NAME>Hex bolt 2 inch</NAME>
        <ITEMTYPE>Inventory</ITEMTYPE>
        <!-- Apply across vendors (Vendor history tab) -->
        <ENABLE_REPLENISHMENT>true</ENABLE_REPLENISHMENT>
        <REPLENISHMENT_METHOD>Reorder point</REPLENISHMENT_METHOD>
        <DEFAULT_REPLENISHMENT_UOM>Each</DEFAULT_REPLENISHMENT_UOM>
        <REORDER_POINT>12</REORDER_POINT>
        <REORDER_QTY>24</REORDER_QTY>
        <SAFETY_STOCK>6</SAFETY_STOCK>
        <!-- end -->
        <WAREHOUSEINFO>
            <ITEMWAREHOUSEINFO>
                <WAREHOUSEID>WH01</WAREHOUSEID>
                <!-- Apply for warehouse/vendor combo (General tab, Warehouse, VENDOR ENTRIES) -->
                <ITEMWAREHOUSEVENDORENTRIES>
                    <VENDORID>Acme</VENDORID>
                    <STOCKNO>163</STOCKNO>
                    <LEAD_TIME>5</LEAD_TIME>
                    <ECONOMIC_ORDER_QTY>36</ECONOMIC_ORDER_QTY>
                </ITEMWAREHOUSEVENDORENTRIES>
                <ITEMWAREHOUSEVENDORENTRIES>
                    <VENDORID>Snap Hardware</VENDORID>
                    <STOCKNO>x993</STOCKNO>
                    <LEAD_TIME>3</LEAD_TIME>  <!-- Short lead time from Snap Hardware to WH01 -->
                </ITEMWAREHOUSEVENDORENTRIES>
                <!-- end -->
            </ITEMWAREHOUSEINFO>
        </WAREHOUSEINFO>
        <VENDORINFO>
            <!-- Apply for this vendor for all except warehouse WH01 (Vendor history tab, Vendor entries) -->
            <ITEMVENDOR>
                <VENDORID>Bosco Parts</VENDORID>
                <STOCKNO>167</STOCKNO>
                <REORDER_POINT>24</REORDER_POINT>
                <REORDER_QTY>12</REORDER_QTY>
                <SAFETY_STOCK>6</SAFETY_STOCK>
            </ITEMVENDOR>
            <ITEMVENDOR>
                <VENDORID>Snap Hardware</VENDORID>
                <STOCKNO>x993</STOCKNO>
                <LEAD_TIME>7</LEAD_TIME>
            </ITEMVENDOR>
            <!-- end -->
        </VENDORINFO>
    </ITEM>
</create>

Parameters

Name Required Type Description
ITEM Required object Object to create

ITEM

Name Required Type Description
ITEMID Required string Item ID to create
NAME Required string Item name
ITEMTYPE Required string Item type. Use Inventory, Non-Inventory, Non-Inventory (Purchase only), Non-Inventory (Sales only), Kit, or Stockable Kit.
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive. (Default: active)
PRODUCTLINEID Optional string Product line ID
COST_METHOD Optional string Cost method. Use Standard, Average, FIFO, or LIFO.
EXTENDED_DESCRIPTION Optional string Extended description
PODESCRIPTION Optional string Purchasing description
SODESCRIPTION Optional string Sales description
UOMGRP Optional string Unit of measure group. Use Area, Count, Duration, Length, Numbers, Time, Volume, or Weight (or an existing custom group name)
NOTE Optional string Note
SHIP_WEIGHT Optional decimal Shipping weight
GLGROUP Optional string Item GL group name
STANDARD_COST Optional currency Standard cost
BASEPRICE Optional currency Base price
TAXABLE Optional boolean Taxable. Use false for No, true for Yes. (Default: true)
TAXGROUP Optional object Item tax group
DEFAULTREVRECTEMPLKEY Optional string Default rev rec template ID
INCOMEACCTKEY Optional string Revenue GL account number
INVACCTKEY Optional string Inventory GL account number
EXPENSEACCTKEY Optional string Expense GL account number
COGSACCTKEY Optional string COGS GL account number
OFFSETOEGLACCOUNTKEY Optional string AR GL account number
OFFSETPOGLACCOUNTKEY Optional string AP GL account number
DEFERREDREVACCTKEY Optional string Deferred revenue GL account number
VSOECATEGORY Optional string VSOE category. Use Product - Specified, Software, Product - Unspecified, Upgrade - Unspecified, Upgrade - Specified, Services, or Post Contract Support(PCS).
VSOEDLVRSTATUS Optional string VSOE default delivery status. Use Delivered or Undelivered.
VSOEREVDEFSTATUS Optional string VSOE default deferral status. Use Defer until item is delivered or Defer bundle until item is delivered.
REVPOSTING Optional string Kit revenue posting. Use Component Level or Kit Level.
REVPRINTING Optional string Kit print format. Use Individual Components or Kit.
SUBSTITUTEID Optional string Substitute item ID
ENABLE_SERIALNO Optional boolean Serial tracking enabled. Use false for No, true for Yes. (Default: false)
SERIAL_MASKKEY Optional string Serial number mask
ENABLE_LOT_CATEGORY Optional boolean Lot tracking enabled. Use false for No, true for Yes. (Default: false)
LOT_CATEGORYKEY Optional string Lot category
ENABLE_BINS Optional boolean Bin tracking enabled. Use false for No, true for Yes. (Default: false)
ENABLE_EXPIRATION Optional boolean Expiration tracking enabled. Use false for No, true for Yes. (Default: false)
UPC Optional string UPC
INV_PRECISION Optional integer Inventory unit cost precision
SO_PRECISION Optional integer Sales unit cost precision
PO_PRECISION Optional integer Purchasing unit cost precision
ENABLELANDEDCOST Optional boolean Enable landed costs for Inventory item. Use false for No, true for Yes. (Default: false)
LANDEDCOSTINFO Optional ITEMLANDEDCOST[1...n ] Information about landed cost mechanisms. ENABLELANDEDCOST must be set to true.
HASSTARTENDDATES Optional boolean Item has start and end dates. Use false for No, true for Yes. (Default: false)
TERMPERIOD Optional string Periods measured in. Use Days, Weeks, Months, or Years.
TOTALPERIODS Optional integer Number of periods
COMPUTEFORSHORTTERM Optional boolean Prorate price allowed. Use false for No, true for Yes. (Default: false)
RENEWALMACROID Optional string Default renewal macro ID
ENABLE_REPLENISHMENT Optional boolean Enable replenishment for this item in the Vendor history. Use true to enable, otherwise use false. (Default: true)
DEFAULT_REPLENISHMENT_UOM Optional string Units of measure default for base units for inventory replenishment for this item in the Vendor history. For example, with the Count unit of measure group, you can specify each, dozen, or pair. See the information about unit of measure groups in the Sage Intacct product help.
REPLENISHMENT_METHOD Optional string Replenishment method for this item in the Vendor history. Specifies how the amount to reorder is calculated. Use Reorder point to base calculation on a specific reorder quantity and optional safety stock quantity, use Demand forecast by single value to base calculation on lead time for the vendor, use Demand forecast by statistical account to base calculation on statistical journal entries for a statistical account (statistical account must be configured for inventory). See the information about replenishment methods and calculations in the Sage Intacct product help. (Default: Reorder point or as configured for inventory)
SAFETY_STOCK Optional integer Safety stock for this item in the Vendor history. Extra quantity held in inventory to reduce the risk of stock outs due to uncertainty in supply and demand. (Default: 0)
MAX_ORDER_QTY Optional integer Maximum order quantity for this item in the Vendor history. Largest amount you can order in any one order. The value you provide may be affected by the economic order quantity and/or unit of measure set on the vendor. (Default is 0, meaning no maximum)
REORDER_POINT Optional integer Reorder point specifying the quantity of inventory that you don’t want to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. Use blank or positive integers. Applies when the replenishment method is Reorder point. (Default: 1)
REORDER_QTY Optional integer Reorder quantity for this item in the Vendor history. As an example, if 12 units are needed according to other replenishment calculations, a reorder quantity of 50 would cause the generated purchase order to be for 50. Applies when the replenishment method is Reorder point. (Default is 0, meaning no suggestion)
FORECAST_DEMAND_IN_LEAD_TIME Optional integer Forecast demand in lead time. Specifies the quantity of this item expected to be sold during the lead time. Valid values are blank, 0, and positive integers. Only applicable when the replenishment method is Demand forecast by a single value.
WAREHOUSEINFO optional ITEMWAREHOUSEINFO[0…n] Item Warehouse information. These parameter values override the replenishment values specified for the item in the Vendor history.
VENDORINFO optional ITEMVENDOR[0…n] Container for Vendor entries in Vendor history.
Custom fields Optional varies Custom fields. For a multi-pick-list custom field, implode multiple field values with #~#.

TAXGROUP

Name Required Type Description
NAME Required string Tax group name

ITEMLANDEDCOST[1...n]

Name Required Type Description
ITEMID Required string Item ID
METHOD Required string Landed cost mechanism. Use Volume, Weight, or Count.
VALUE Required string Value for the landed cost
ACTIVE Optional boolean Status. Use false for inactive, true for active.

ITEMWAREHOUSEINFO

For the given warehouse, these parameter values override any replenishment values specified for the item in the Vendor history.

Name Required Type Description
WAREHOUSEID Required string Warehouse ID for an existing warehouse.
ENABLE_REPLENISHMENT Optional boolean Enable replenishment for this item and warehouse combination. Use true to enable, otherwise use false. (Default: true)
REPLENISHMENT_METHOD Optional string Replenishment method. Specifies how the amount to reorder is calculated. Use Reorder point to base calculation on a specific reorder quantity and optional safety stock quantity, use Demand forecast by single value to base calculation on lead time for the vendor, use Demand forecast by statistical account to base calculation on statistical journal entries for a statistical account (statistical account must be configured for inventory). See the information about replenishment methods and calculations in the Sage Intacct product help. (Default: Reorder point or as configured for inventory)
SAFETY_STOCK Optional integer Safety stock. Extra quantity held in inventory to reduce the risk of stock outs due to uncertainty in supply and demand. (Default: 0)
MAX_ORDER_QTY Optional integer Maximum order quantity allowed in any one order. The value you provide may be affected by the economic order quantity and/or unit of measure set on the vendor. (Default is 0, meaning no maximum)
REORDER_POINT Optional integer Reorder point specifying the quantity of inventory that you don’t want to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. Use blank or positive integers. Applies when the replenishment method is Reorder point.
REORDER_QTY Optional integer Reorder quantity for this item. As an example, if 12 units are needed according to other replenishment calculations, a reorder quantity of 50 would cause the generated purchase order to be for 50. Applies when the replenishment method is Reorder point. (Default is 0, meaning no suggestion)
ITEMWAREHOUSEVENDORENTRIES optional ITEMWAREHOUSEVENDORENTRIES[0...n] Vendor Entries. Provides replenishment parameters for this item according to given warehouse and vendor combinations. These parameters override the values for the Vendor entries in the Vendor history. Multiple ITEMWAREHOUSEVENDORENTRIES elements may be passed.

ITEMWAREHOUSEVENDORENTIES

For the given warehouse, these entries override any Vendor entries in Vendor history.

Name Required Type Description
VENDORID Required string Vendor ID of an existing vendor that ships the item to this warehouse
PREFERRED_VENDOR Optional boolean Preferred vendor status. Use true to designate as preferred, otherwise use false. There can only be one preferred vendor. (Default: true for the first vendor in the list (the lowest record number), false for the others)
STOCKNO Optional string Stock number the vendor uses for the item
LEAD_TIME Optional string Lead time in days when ordering this particular item. Valid values are blank, 0, and positive integers. (Default: lead time for the vendor)
FORECAST_DEMAND_IN_LEAD_TIME Optional integer Forecast demand in lead time. Specifies the quantity of this item expected to be sold during the lead time. Valid values are blank, 0, and positive integers. Only applicable when the replenishment method is Demand forecast by a single value.
ECONOMIC_ORDER_QTY Optional integer Economic order quantity. Specifies the number of units per order to minimize the total costs of inventory—such as holding costs and order costs (Default: 1)
MIN_ORDER_QTY Optional integer Minimum order quantity allowed (Default: 1)
UOM Optional string Unit of measure that the vendor sells this item in—should match the UOM used for the Purchase Order. (Default: Base unit of the item’s UOM group for inventory replenishment.)

ITEMVENDOR

These entries apply when there are no corresponding warehouse-specific Vendor entries.

Name Required Type Description
VENDORID Required string Vendor ID of an existing vendor that ships the item from this warehouse
PREFERRED_VENDOR Optional boolean Preferred vendor status. Use true to designate as preferred, otherwise use false. There can only be one preferred vendor. (Default: true for the first vendor in the list (the lowest record number), false for the others)
STOCKNO Optional string Stock number the vendor uses for the item
LEAD_TIME Optional string Lead time in days when ordering this particular item. Valid values are blank, 0, and positive integers. (Default: lead time for the vendor)
FORECAST_DEMAND_IN_LEAD_TIME Optional integer Forecast demand in lead time. Specifies the quantity of this item expected to be sold during the lead time. Valid values are blank, 0, and positive integers. Only applicable when the replenishment method is Demand forecast by a single value.
ECONOMIC_ORDER_QTY Optional string Quantity of units per order to minimize the total costs of inventory—such as holding costs and order costs. (Default: 1)
MIN_ORDER_QTY Optional integer Minimum order quantity allowed (Default: 1)
UOM Optional string Unit of measure that the vendor sells this item in—should match the UOM used for the Purchase Order. (Default: Base unit of the item’s UOM group for inventory replenishment)

Create Item (Legacy)

create_item

<create_item>
    <itemid>I1234</itemid>
    <name>hello world</name>
    <itemtype>Inventory</itemtype>
</create_item>

Parameters

Name Required Type Description
itemid Required string Item ID to create
name Required string Item name
status Optional string Status. Use active for Active otherwise use inactive for Inactive. (Default: active)
itemtype Required string Item type. Use Inventory, Non-Inventory, Non-Inventory (Purchase only), Non-Inventory (Sales only), Kit, or Stockable Kit.
enable_bins Optional boolean Bin tracking enabled. Use false for No, true for Yes. (Default: false)
extended_description Optional string Extended description
productlineid Optional string Product line ID
substituteid Optional string Substitute item ID
ship_weight Optional decimal Shipping weight
taxable Optional boolean Taxable. Use false for No, true for Yes. (Default: true)
cost_method Optional string Cost method. Use Standard, Average, FIFO, or LIFO.
standard_cost Optional currency Standard cost
base_price Optional currency Base price
glgroup Optional string Item GL group name
note Optional string Note
inventory_precision Optional integer Inventory unit cost precision
purchasing_precision Optional integer Purchasing unit cost precision
sales_precision Optional integer Sales unit cost precision
upc Optional string UPC
hasstartenddates Optional boolean Item has start and end dates. Use false for No, true for Yes. (Default: false)
term_period Optional string Periods measured in. Use Days, Weeks, Months, or Years.
defaultnoofperiods Optional integer Number of periods
computepriceforshortterm Optional boolean Prorate price allowed. Use false for No, true for Yes. (Default: false)
itaxgroup Optional string Item tax group name.
revenue_posting Optional string Kit revenue posting. Use Component Level or Kit Level.
vsoecategory Optional string VSOE category. Use Product - Specified, Software, Product - Unspecified, Upgrade - Unspecified, Upgrade - Specified, Services, or Post Contract Support(PCS).
vsoedlvrstatus Optional string VSOE default delivery status. Use Delivered or Undelivered.
vsoerevdefstatus Optional string VSOE default deferral status. Use Defer until item is delivered or Defer bundle until item is delivered.
incomeaccount Optional string Revenue GL account number
invaccount Optional string Inventory GL account number
expenseaccount Optional string Expense GL account number
cogsaccount Optional string COGS GL account number
offsetoeglaccount Optional string AR GL account number
offsetpoglaccount Optional string AP GL account number
defrevaccount Optional string Deferred revenue GL account number
uomgrp Optional string Unit of measure
customfields Optional customfield[0...n] Custom fields

customfield

Name Required Type Description
customfieldname Optional string Custom field ID
customfieldvalue Optional varies Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#.

Update Item

Release Changes
2018 Release 4 Added ENABLE_REPLENISHMENT, DEFAULT_REPLENISHMENT_UOM, REPLENISHMENT_METHOD, SAFETY_STOCK, MAX_ORDER_QTY, REORDER_POINT, REORDER_QTY, FORECAST_DEMAND_IN_LEAD_TIME, VENDORINFO, WAREHOUSEINFO
2018 Release 3 Added ENABLELANDEDCOST and LANDEDCOSTINFO

update

<update>
    <ITEM>
        <RECORDNO>12</RECORDNO>
        <NAME>hello world</NAME>
    </ITEM>
</update>

Parameters

Name Required Type Description
ITEM Required object Object to update

ITEM

Name Required Type Description
RECORDNO Required integer Item RECORDNO to update
NAME Optional string Item name
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive.
PRODUCTLINEID Optional string Product line ID
COST_METHOD Optional string Cost method. Use Standard, Average, FIFO, or LIFO.
EXTENDED_DESCRIPTION Optional string Extended description
PODESCRIPTION Optional string Purchasing description
SODESCRIPTION Optional string Sales description
UOMGRP Optional string Unit of measure group. Use Area, Count, Duration, Length, Numbers, Time, Volume, or Weight (or an existing custom group name)
NOTE Optional string Note
SHIP_WEIGHT Optional decimal Shipping weight
GLGROUP Optional string Item GL group name
STANDARD_COST Optional currency Standard cost
BASEPRICE Optional currency Base price
TAXABLE Optional boolean Taxable. Use false for No, true for Yes.
TAXGROUP Optional object Item tax group
DEFAULTREVRECTEMPLKEY Optional string Default rev rec template ID
INCOMEACCTKEY Optional string Revenue GL account number
INVACCTKEY Optional string Inventory GL account number
EXPENSEACCTKEY Optional string Expense GL account number
COGSACCTKEY Optional string COGS GL account number
OFFSETOEGLACCOUNTKEY Optional string AR GL account number
OFFSETPOGLACCOUNTKEY Optional string AP GL account number
DEFERREDREVACCTKEY Optional string Deferred revenue GL account number
VSOECATEGORY Optional string VSOE category. Use Product - Specified, Software, Product - Unspecified, Upgrade - Unspecified, Upgrade - Specified, Services, or Post Contract Support(PCS).
VSOEDLVRSTATUS Optional string VSOE default delivery status. Use Delivered or Undelivered.
VSOEREVDEFSTATUS Optional string VSOE default deferral status. Use Defer until item is delivered or Defer bundle until item is delivered.
REVPOSTING Optional string Kit revenue posting. Use Component Level or Kit Level.
REVPRINTING Optional string Kit print format. Use Individual Components or Kit.
SUBSTITUTEID Optional string Substitute item ID
ENABLE_SERIALNO Optional boolean Serial tracking enabled. Use false for No, true for Yes.
SERIAL_MASKKEY Optional string Serial number mask
ENABLE_LOT_CATEGORY Optional boolean Lot tracking enabled. Use false for No, true for Yes.
LOT_CATEGORYKEY Optional string Lot category
ENABLE_BINS Optional boolean Bin tracking enabled. Use false for No, true for Yes.
ENABLE_EXPIRATION Optional boolean Expiration tracking enabled. Use false for No, true for Yes.
UPC Optional string UPC
INV_PRECISION Optional integer Inventory unit cost precision
SO_PRECISION Optional integer Sales unit cost precision
PO_PRECISION Optional integer Purchasing unit cost precision
ENABLELANDEDCOST Optional boolean Enable landed costs for Inventory item. Use false for No, true for Yes. (Default: false).
LANDEDCOSTINFO Optional ITEMLANDEDCOST[1...n ] Information about landed cost mechanisms. ENABLELANDEDCOST must be set to true.
HASSTARTENDDATES Optional boolean Item has start and end dates. Use false for No, true for Yes.
TERMPERIOD Optional string Periods measured in. Use Days, Weeks, Months, or Years.
TOTALPERIODS Optional integer Number of periods
COMPUTEFORSHORTTERM Optional boolean Prorate price allowed. Use false for No, true for Yes.
RENEWALMACROID Optional string Default renewal macro ID
ENABLE_REPLENISHMENT Optional boolean Enable replenishment for this item in the Vendor history. Use true to enable, otherwise use false. (Default: true)
DEFAULT_REPLENISHMENT_UOM Optional string Units of measure default for base units for inventory replenishment for this item in the Vendor history. For example, with the Count unit of measure group, you can specify each, dozen, or pair. See the information about unit of measure groups in the Sage Intacct product help.
REPLENISHMENT_METHOD Optional string Replenishment method for this item in the Vendor history. Specifies how the amount to reorder is calculated. Use Reorder point to base calculation on a specific reorder quantity and optional safety stock quantity, use Demand forecast by single value to base calculation on lead time for the vendor, use Demand forecast by statistical account to base calculation on statistical journal entries for a statistical account (statistical account must be configured for inventory). See the information about replenishment methods and calculations in the Sage Intacct product help. (Default: Reorder point or as configured for inventory)
SAFETY_STOCK Optional integer Safety stock for this item in the Vendor history. Extra quantity held in inventory to reduce the risk of stock outs due to uncertainty in supply and demand. (Default: 0)
MAX_ORDER_QTY Optional integer Maximum order quantity for this item in the Vendor history. Largest amount you can order in any one order. The value you provide may be affected by the economic order quantity and/or unit of measure set on the vendor. (Default is 0, meaning no maximum)
REORDER_POINT Optional integer Reorder point specifying the quantity of inventory that you don’t want to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. Use blank or positive integers. Applies when the replenishment method is Reorder point. (Default: 1)
REORDER_QTY Optional integer Reorder quantity for this item in the Vendor history. As an example, if 12 units are needed according to other replenishment calculations, a reorder quantity of 50 would cause the generated purchase order to be for 50. Applies when the replenishment method is Reorder point. (Default is 0, meaning no suggestion)
WAREHOUSEINFO optional ITEMWAREHOUSEINFO[0…n] Item Warehouse information. These parameter values override the replenishment values specified for the item in the Vendor history.
VENDORINFO optional ITEMVENDOR[0…n] Container for Vendor entries in Vendor history.
Custom fields Optional varies Custom fields. For a multi-pick-list custom field, implode multiple field values with #~#.

TAXGROUP

Name Required Type Description
NAME Required string Tax group name

ITEMLANDEDCOST[1...n]

Name Required Type Description
ITEMID Required string Item ID
METHOD Required string Landed cost mechanism. Use Volume, Weight, or Count
VALUE Required string Value for the landed cost
ACTIVE Optional boolean Status. Use false for inactive, true for active.

ITEMWAREHOUSEINFO

Name Required Type Description
WAREHOUSEID Required string Warehouse ID for an existing warehouse.
ENABLE_REPLENISHMENT Optional boolean Enable replenishment for this item and warehouse combination. Use true to enable, otherwise use false. (Default: true)
REPLENISHMENT_METHOD Optional string Replenishment method. Specifies how the amount to reorder is calculated. Use Reorder point to base calculation on a specific reorder quantity and optional safety stock quantity, use Demand forecast by single value to base calculation on lead time for the vendor, use Demand forecast by statistical account to base calculation on statistical journal entries for a statistical account (statistical account must be configured for inventory). See the information about replenishment methods and calculations in the Sage Intacct product help. (Default: Reorder point or as configured for inventory)
SAFETY_STOCK Optional integer Safety stock. Extra quantity held in inventory to reduce the risk of stock outs due to uncertainty in supply and demand. (Default: 0)
MAX_ORDER_QTY Optional integer Maximum order quantity allowed in any one order. The value you provide may be affected by the economic order quantity and/or unit of measure set on the vendor. (Default is 0, meaning no maximum)
REORDER_POINT Optional integer Reorder point specifying the quantity of inventory that you don’t want to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. Use blank or positive integers. Applies when the replenishment method is Reorder point.
REORDER_QTY Optional integer Reorder quantity for this item. As an example, if 12 units are needed according to other replenishment calculations, a reorder quantity of 50 would cause the generated purchase order to be for 50. Applies when the replenishment method is Reorder point. (Default is 0, meaning no suggestion)
ITEMWAREHOUSEVENDORENTRIES optional ITEMWAREHOUSEVENDORENTRIES[0...n] Vendor Entries. Provides replenishment parameters for this item according to given warehouse and vendor combinations. These parameters override the values for the Vendor entries in the Vendor history. Multiple ITEMWAREHOUSEVENDORENTRIES elements may be passed.

ITEMWAREHOUSEVENDORENTIES

Name Required Type Description
VENDORID Required string Vendor ID of an existing vendor that ships the item from this warehouse
PREFERRED_VENDOR Optional boolean Preferred vendor status. Use true to designate as preferred, otherwise use false. There can only be one preferred vendor. (Default: true for the first vendor in the list (the lowest record number), false for the others)
STOCKNO Optional string Stock number the vendor uses for the item
LEAD_TIME Optional string Lead time in days when ordering this particular item. Valid values are blank, 0, and positive integers. (Default: lead time for the vendor)
FORECAST_DEMAND_IN_LEAD_TIME Optional integer Forecast demand in lead time. Specifies the quantity of this item expected to be sold during the lead time. Valid values are blank, 0, and positive integers. Only applicable when the replenishment method is Demand forecast by a single value.
ECONOMIC_ORDER_QTY Optional integer Economic order quantity. Specifies the number of units per order to minimize the total costs of inventory—such as holding costs and order costs (Default: 1)
MIN_ORDER_QTY Optional integer Minimum order quantity allowed (Default: 1)
UOM Optional string Unit of measure that the vendor sells this item in—should match the UOM used for the Purchase Order.. (Default: Base unit of the item’s UOM group for inventory replenishment.)

ITEMVENDOR

Name Required Type Description
VENDORID Required string Vendor ID of an existing vendor that ships the item from this warehouse
PREFERRED_VENDOR Optional boolean Preferred vendor status. Use true to designate as preferred, otherwise use false. There can only be one preferred vendor. (Default: true for the first vendor in the list (the lowest record number), false for the others)
STOCKNO Optional string Stock number the vendor uses for the item
LEAD_TIME Optional string Lead time in days when ordering this particular item. Valid values are blank, 0, and positive integers. (Default: lead time for the vendor)
FORECAST_DEMAND_IN_LEAD_TIME Optional integer Forecast demand in lead time. Specifies the quantity of this item expected to be sold during the lead time. Valid values are blank, 0, and positive integers. Only applicable when the replenishment method is Demand forecast by a single value.
ECONOMIC_ORDER_QTY Optional string Quantity of units per order to minimize the total costs of inventory—such as holding costs and order costs. (Default: 1)
MIN_ORDER_QTY Optional integer Minimum order quantity allowed (Default: 1)
UOM Optional string Unit of measure that the vendor sells this item in—should match the UOM used for the Purchase Order. (Default: Base unit of the item’s UOM group for inventory replenishment)

Update Item (Legacy)

update_item

<update_item itemid="I1234">
    <name>hello world</name>
</update_item>

Parameters

Name Required Type Description
itemid Required string Item ID to update
name Optional string Item name
status Optional string Status. Use active for Active otherwise use inactive for Inactive.
enable_bins Optional boolean Bin tracking enabled. Use false for No, true for Yes.
extended_description Optional string Extended description
productlineid Optional string Product line ID
substituteid Optional string Substitute item ID
ship_weight Optional decimal Shipping weight
taxable Optional boolean Taxable. Use false for No, true for Yes.
standard_cost Optional currency Standard cost
base_price Optional currency Base price
glgroup Optional string Item GL group name
note Optional string Note
inventory_precision Optional integer Inventory unit cost precision
purchasing_precision Optional integer Purchasing unit cost precision
sales_precision Optional integer Sales unit cost precision
upc Optional string UPC
hasstartenddates Optional boolean Item has start and end dates. Use false for No, true for Yes.
term_period Optional string Periods measured in. Use Days, Weeks, Months, or Years.
defaultnoofperiods Optional integer Number of periods
computepriceforshortterm Optional boolean Prorate price allowed. Use false for No, true for Yes.
itaxgroup Optional string Item tax group name.
revenue_posting Optional string Kit revenue posting. Use Component Level or Kit Level.
vsoecategory Optional string VSOE category. Use Product - Specified, Software, Product - Unspecified, Upgrade - Unspecified, Upgrade - Specified, Services, or Post Contract Support(PCS).
vsoedlvrstatus Optional string VSOE default delivery status. Use Delivered or Undelivered.
vsoerevdefstatus Optional string VSOE default deferral status. Use Defer until item is delivered or Defer bundle until item is delivered.
incomeaccount Optional string Revenue GL account number
invaccount Optional string Inventory GL account number
expenseaccount Optional string Expense GL account number
cogsaccount Optional string COGS GL account number
offsetoeglaccount Optional string AR GL account number
offsetpoglaccount Optional string AP GL account number
defrevaccount Optional string Deferred revenue GL account number
uomgrp Optional string Unit of measure
customfields Optional customfield[0...n] Custom fields

customfield

Name Required Type Description
customfieldname Optional string Custom field ID
customfieldvalue Optional varies Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#.

Delete Item

delete

<delete>
    <object>ITEM</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use ITEM
keys Required string Item RECORDNO to delete

Delete Item (Legacy)

delete_item

<delete_item itemid="I1234"></delete_item>

Parameters

Name Required Type Description
itemid Required string Item ID to delete

Provide feedback