Sage 50 US Inventory XML
Export Inventory allows you to export All, Modified and New inventory records from Sage 50 US. As its possible to change the Id of inventory items in Sage we would recommend to store the Key field in third party systems as well as the Id so these changes can be handled.
Tasks
XML
Any Sage fields not documented below are not supported with our imports/exports, if there are additional fields you need contact us at [email protected].
Current limitations
- SalePrice - We export the sale price from Price Level 1. If the price level is based on a calculation e.g. cost price you will need to manually recalculate pricing in the Sage program for us to export the new prices.
- QtyOnHand - This field is only applicable to certain item types. The value is the total stock currently held (including stock currently allocated against sales orders).
- QtyAvailable - This field is only applicable to certain item types. The value is the total stock currently available (the quantity on hand, minus the quantity currently allocated against sales orders). Depending on your Sage settings, it may also include the quantity currently on purchase order.
Sample file for the various inventory types:-
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>656c5b6b-b372-4bd8-ac37-70922f3eb9c9</Key>
<Id>FRIEGHT-EQ</Id>
<PartNumber />
<Type>NonStockItem</Type>
<Description>Freight on equipment</Description>
<Category />
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>0.00</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales />
<DescriptionForPurchases />
<BuyerReference />
<COGSAccountReference>50000-EQ</COGSAccountReference>
<Location />
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalaryAccountReference>57500-EQ</SalaryAccountReference>
<SalesAccountReference>40000-EQ</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference />
<Weight>0.00</Weight>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>9683178a-43f4-4c47-b27f-e6e9f45dc8c3</Key>
<Id>AVRY-10110</Id>
<PartNumber />
<Type>StockItem</Type>
<Description>Bird House-Pole 14 Ft.</Description>
<Category>SUPPLY</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>49.99</SalePrice>
<QtyAvailable>53.00</QtyAvailable>
<QtyOnHand>58.00</QtyOnHand>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Three-Section pole that will place the bird house 12 ft. above ground</DescriptionForSales>
<DescriptionForPurchases>Catalog #B11225: Bird House-Pole 14 Ft.</DescriptionForPurchases>
<BuyerReference />
<COGSAccountReference>50000-AV</COGSAccountReference>
<Location>AISLE 1</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-AV</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference>DEJULIA</VendorReference>
<Weight>0.00</Weight>
<CostingMethod>FIFO</CostingMethod>
<InventoryAccountReference>12000-00</InventoryAccountReference>
<MinimumStock>6.00</MinimumStock>
<ReorderQuantity>6.00</ReorderQuantity>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>77b5a228-d976-4d9b-96ad-62fffa5fa06e</Key>
<Id>TOOL-35600</Id>
<PartNumber />
<Type>AssemblyItem</Type>
<Description>Garden Hoe Kit</Description>
<Category>SUPPLY</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>39.99</SalePrice>
<QtyAvailable>5.00</QtyAvailable>
<QtyOnHand>6.00</QtyOnHand>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Garden Hoe Kit</DescriptionForSales>
<DescriptionForPurchases>Catalog #S100425: Grass Shears</DescriptionForPurchases>
<BuyerReference />
<COGSAccountReference>50000-HT</COGSAccountReference>
<Location>AISLE 5</Location>
<SalesAccountReference>40000-HT</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference>DEJULIA</VendorReference>
<Weight>0.00</Weight>
<CostingMethod>FIFO</CostingMethod>
<InventoryAccountReference>12000-00</InventoryAccountReference>
<MinimumStock>3.00</MinimumStock>
<ReorderQuantity>6.00</ReorderQuantity>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>6ead2e83-e48d-4799-b4ee-b7305bff2017</Key>
<Id>LAND-17100</Id>
<PartNumber />
<Type>ServiceItem</Type>
<Description>Landscaping Service - Weekly</Description>
<Category>SERVICE</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>false</IsTaxable>
<SalesTaxType>2</SalesTaxType>
<SalePrice>49.99</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Weekly Landscaping Service</DescriptionForSales>
<DescriptionForPurchases />
<COGSAccountReference>57000-LS</COGSAccountReference>
<Location />
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalaryAccountReference>77500-00</SalaryAccountReference>
<SalesAccountReference>40000-LS</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference />
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>a78f63d8-6dff-4b93-bd1e-361cfd650793</Key>
<Id>NURS-21100</Id>
<PartNumber />
<Type>LaborItem</Type>
<Description>Nursery Labor</Description>
<Category>LABOR</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>39.99</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Nursery Prep and Labor</DescriptionForSales>
<DescriptionForPurchases />
<COGSAccountReference>57000-NU</COGSAccountReference>
<Location />
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalaryAccountReference>77500-00</SalaryAccountReference>
<SalesAccountReference>40000-NU</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference />
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>684a25e8-391e-47e6-8548-aeff0e737375</Key>
<Id>B&W COPY</Id>
<PartNumber />
<Type>ChargeItem</Type>
<Description>B&W Plan Copy</Description>
<Category />
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>25.00</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Black and white copy of Scale Plan</DescriptionForSales>
<Location />
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-MI</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>22e93413-1a84-4837-b9cf-bcbfbf5e4f81</Key>
<Id>ADMIN-01000</Id>
<PartNumber />
<Type>ActivityItem</Type>
<Description>Bookkeeping/Administrative</Description>
<Category>ADMIN</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>false</IsTaxable>
<SalesTaxType>2</SalesTaxType>
<SalePrice>0.00</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>(Internal) Bookkeeping and Administrative Duties for Front Office</DescriptionForSales>
<Location />
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-00</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>cde56043-fbbc-4086-9421-361a7756613c</Key>
<Id>AVRY-10050</Id>
<PartNumber />
<Type>MasterStockItem</Type>
<Description>Prefabricated Birdhouse</Description>
<Category>SUPPLY</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>59.99</SalePrice>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Prefabricated Birdhouse</DescriptionForSales>
<DescriptionForPurchases />
<BuyerReference>MTROTTER</BuyerReference>
<COGSAccountReference>50000-00</COGSAccountReference>
<Location>Row 9</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-AV</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<VendorReference>ABNEY</VendorReference>
<Weight>1.60</Weight>
<CostingMethod>FIFO</CostingMethod>
<InventoryAccountReference>12000-00</InventoryAccountReference>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>156707c3-b236-4584-9bb7-37f3a558466d</Key>
<Id>AVRY-10050-LG-CSL</Id>
<PartNumber>15675</PartNumber>
<Type>SubStockItem</Type>
<Description>Prefabricated Birdhouse</Description>
<Category>SUPPLY</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>79.99</SalePrice>
<QtyAvailable>0</QtyAvailable>
<QtyOnHand>0</QtyOnHand>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Prefabricated Birdhouse-Large Castle</DescriptionForSales>
<DescriptionForPurchases />
<BuyerReference>MTROTTER</BuyerReference>
<COGSAccountReference>50000-00</COGSAccountReference>
<Location>Row 9</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-AV</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC>2323460</UPC>
<VendorReference>ABNEY</VendorReference>
<Weight>2.30</Weight>
<CostingMethod>FIFO</CostingMethod>
<InventoryAccountReference>12000-00</InventoryAccountReference>
<MinimumStock>10.00</MinimumStock>
<ReorderQuantity>15.00</ReorderQuantity>
<MasterItemID>AVRY-10050</MasterItemID>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>6ccaec2e-59ed-46e2-ab39-62aff21f997e</Key>
<Id>EQLW-14200</Id>
<PartNumber />
<Type>SerializedStockItem</Type>
<Description>Riding Mower-14 HP</Description>
<Category>SUPPLY</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>2899.00</SalePrice>
<QtyAvailable>0</QtyAvailable>
<QtyOnHand>0</QtyOnHand>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Order</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Riding Lawn Mower - 14 Horse Power</DescriptionForSales>
<DescriptionForPurchases />
<BuyerReference>VANSELL</BuyerReference>
<COGSAccountReference>50000-EQ</COGSAccountReference>
<Location>AISLE 4</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-EQ</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference>SOGARDEN</VendorReference>
<Weight>0.00</Weight>
<CostingMethod>SpecificUnit</CostingMethod>
<InventoryAccountReference>12000-00</InventoryAccountReference>
<MinimumStock>5.00</MinimumStock>
<ReorderQuantity>2.00</ReorderQuantity>
</Inventory>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExternalId />
<Key>8a74d71d-4af7-45c4-9f17-9be239b2b34f</Key>
<Id>MOWER-184W</Id>
<PartNumber />
<Type>SerializedAssemblyItem</Type>
<Description>18" Reel Mower with Tracking</Description>
<Category>MANF</Category>
<Note />
<IsInactive>false</IsInactive>
<IsTaxable>true</IsTaxable>
<SalesTaxType>1</SalesTaxType>
<SalePrice>239.99</SalePrice>
<QtyAvailable>0</QtyAvailable>
<QtyOnHand>0</QtyOnHand>
<CustomFields>
<CustomField>
<Name>Alternate Vendor</Name>
<Value />
</CustomField>
<CustomField>
<Name>Substitution</Name>
<Value />
</CustomField>
<CustomField>
<Name>Special Note</Name>
<Value />
</CustomField>
</CustomFields>
<DescriptionForSales>Classic 18" reel mower with fingertip height control. Dual wheel tracking handles rough terrain.</DescriptionForSales>
<DescriptionForPurchases />
<BuyerReference />
<COGSAccountReference>50000-MF</COGSAccountReference>
<Location>F200</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<SalesAccountReference>40000-MF</SalesAccountReference>
<SubjectToCommission>false</SubjectToCommission>
<UPC />
<VendorReference />
<Weight>0.00</Weight>
<CostingMethod>SpecificUnit</CostingMethod>
<InventoryAccountReference>12150-00</InventoryAccountReference>
<MinimumStock>10.00</MinimumStock>
<ReorderQuantity>5.00</ReorderQuantity>
</Inventory>
</ArrayOfInventory>
In each of the following sections most of the XML has been omitted to make the samples easier to read. The sections have been broken up into the various sections of the inventory record as viewed within Sage 50 US.
Header Fields
The following fields can be specified at the header level of an inventory item record.
| Sage Field | XML Field | Example | Field Type | Field Length | Input |
|---|---|---|---|---|---|
| - | ExternalId | 1354155 | string | 255 | Optional |
| Item ID | Id | TEST0001 | string | 20 | Required |
| Description | Description | Bird House-Pole 14 Ft. Stock | string | 30 | Optional |
| Item Class | Type* | StockItem | enum | - | Required when using auto generate settings |
| Inactive | IsInactive | false | bool | - | Optional |
| Subject to Commission | SubjectToCommission | false | bool | - | Optional |
- *Type - Valid values: NonStockItem, StockItem, DescriptionOnly, AssemblyItem, ServiceItem, LaborItem, ActivityItem, ChargeItem, MasterStockItem, SubStockItem, SerializedStockItem, SerializedAssemblyItem
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Inventory>
<ExternalId>1354155</ExternalId>
<Id>TEST0001</Id>
<Description>Bird House-Pole 14 Ft. Stock</Description>
<Type>StockItem</Type>
<IsInactive>false</IsInactive>
<SubjectToCommission>false</SubjectToCommission>
</Inventory>
</ArrayOfInventory>
General Tab
The following fields can be specified on the 'General' tab of an inventory item record.
| Sage Field | XML Field | Example | Field Type | Field Length | Input |
|---|---|---|---|---|---|
| Description (For Sales) | DescriptionForSales | Three-Section pole... | string | 160 | Optional |
| Description (For Purchases) | DescriptionForPurchases | Catalog #B11225... | string | 160 | Optional |
| Price Level 1 | SalePrice* | 49.99 | decimal | - | Optional |
| Last Unit Cost | LastUnitCost | 25 | decimal | - | Optional |
| Cost Method | CostingMethod* | Average | enum | - | Optional |
| UPC / SKU | UPC | TEST0001 | string | - | Optional |
| Part Number | PartNumber | 1354155 | string | - | Optional |
| Item Type | Category | Garden | string | - | Optional |
| Location | Location | AISLE 1 | string | - | Optional |
| Stocking U/M | StockingUnitOfMeasure | Each | string | - | Optional |
| Weight | Weight | 5.60 | decimal | - | Optional |
| GL Sales Acct | SalesAccountReference | 4000 | string | - | Optional |
| GL Inventory Acct | InventoryAccountReference | 1200 | string | - | Optional |
| GL Cost of Sales Acct | COGSAccountReference | 5000 | string | - | Optional |
| Item Tax Type | SalesTaxType | 1 | int | - | Optional |
| - | IsTaxable | true | bool | - | Optional |
| Minimum Stock | MinimumStock | 6.00 | decimal | - | Optional |
| Reorder Quantity | ReorderQuantity | 6.00 | decimal | - | Optional |
| Preferred Vendor ID | VendorReference | ALDRED | string | 20 | Optional |
| Buyer ID | BuyerReference | ACA01 | string | 20 | Optional |
- *SalePrice - The
SalePriceelement will be ignored if aPriceLevelscollection is provided. See Price Levels for more information about thePriceLevelscollection. - *CostingMethod - Valid values: Average, FIFO, LIFO, SpecificUnit
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Inventory>
<DescriptionForSales>Three-Section pole that will place the bird house 12 ft. above ground</DescriptionForSales>
<DescriptionForPurchases>Catalog #B11225: Bird House-Pole 14 Ft.</DescriptionForPurchases>
<SalePrice>49.99</SalePrice>
<LastUnitCost>25</LastUnitCost>
<CostingMethod>Average</CostingMethod>
<UPC>TEST0001</UPC>
<PartNumber>1354155</PartNumber>
<Category>Garden</Category>
<Location>AISLE 1</Location>
<StockingUnitOfMeasure>Each</StockingUnitOfMeasure>
<Weight>5.60</Weight>
<SalesAccountReference>4000</SalesAccountReference>
<InventoryAccountReference>1200</InventoryAccountReference>
<COGSAccountReference>5000</COGSAccountReference>
<SalesTaxType>1</SalesTaxType>
<IsTaxable>true</IsTaxable>
<MinimumStock>6.00</MinimumStock>
<ReorderQuantity>6.00</ReorderQuantity>
<VendorReference>ALDRED</VendorReference>
<BuyerReference>ACA01</BuyerReference>
</Inventory>
</ArrayOfInventory>
Price Levels
The following fields can be specified on the 'Price Levels' screen of an inventory item record.
| Sage Field | XML Field | Example | Field Type | Field Length | Input |
|---|---|---|---|---|---|
| Level | Name | Price Level 1 | string | - | Dependant - Either Name or Level must be provided |
| Level | Level | 2 | int | - | Dependant - Either Name or Level must be provided |
| Price | UnitPrice | 49.99 | decimal | - | Optional |
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Inventory>
<PriceLevels>
<PriceLevel>
<Name>Price Level 1</Name>
<UnitPrice>49.99</UnitPrice>
</PriceLevel>
<PriceLevel>
<Level>2</Level>
<UnitPrice>48.00</UnitPrice>
</PriceLevel>
</PriceLevels>
</Inventory>
</ArrayOfInventory>
Custom Fields Tab
The following fields can be specified on the 'Custom Fields' tab of an inventory item record.
| Sage Field | XML Field | Example | Field Type | Field Length | Input |
|---|---|---|---|---|---|
| Custom Field Label | Name | Special Note | string | - | Required |
| Value | Value | Large item | string | - | Optional |
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfInventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Inventory>
<CustomFields>
<CustomField>
<Name>Special Note</Name>
<Value>Large item</Value>
</CustomField>
</CustomFields>
</Inventory>
</ArrayOfInventory>