Sage 200 Online Stock Level XML

All stock within Sage 200 regardless of type (Stock, Service/labour, or Miscellaneous), require a holding location. The location indicates where an item is stored and the stock level settings for each product in the warehouse i.e. the re-order level, the minimum and maximum stock levels. Items with a type of 'Stock' have levels recorded for each warehouse location and the levels are used when allocating, issuing and receiving stock. Further information can be found on the Sage 200 Online Warehouse Holdings API Documentation.

Tasks

Zynk does not currently support uploading stock levels directly, but can be used within Sage 200 Online Stock Record XML as part of the download or upload of stock records.

• Exporting Stock Levels From Sage 200 Online
• Exporting Stock Records From Sage 200 Online
• Importing Stock Records To Sage 200 Online

Fields for Download and Upload

warehouse_id

Read Only
Warehouse record Id, will also return warehouse data.

Type	Example	XML
integer(int64)	1	<warehouse_id>1</warehouse_id>

product_id

Read Only
Product record Id, will also return product data.

Type	Example	XML
integer(int64)	27256	<product_id>27256</product_id>

reorder_level

Optional
Reorder stock level.

Type	Example	XML
number(decimal 5dp)	2.00000	<reorder_level>2.00000</reorder_level>

minimum_level

Optional
Minimum stock quantity level.

Type	Example	XML
number(decimal 5dp)	1.00000	<minimum_level>1.00000</minimum_level>

maximum_level

Optional
Maximum stock quantity level.

Type	Example	XML
number(decimal 5dp)	0.00000	<maximum_level>0.00000</maximum_level>

Fields for Download Only

id

Read Only
Warehouse holding record Id.

Type	Example	XML
integer(int64)	27336	<id>27336</id>

confirmed_qty_in_stock

Read Only
Confirmed stock quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<confirmed_qty_in_stock>0.00000</confirmed_qty_in_stock>

unconfirmed_qty_in_stock

Read Only
Unconfirmed stock quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<unconfirmed_qty_in_stock>0.00000</unconfirmed_qty_in_stock>

quantity_in_stock

Read Only
Total confirmed and unconfirmed stock quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<quantity_in_stock>0.00000</quantity_in_stock>

quantity_allocated_stock

Read Only
Allocated stock quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<quantity_allocated_stock>0.00000</quantity_allocated_stock>

quantity_allocated_sop

Read Only
Allocated sales order quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<quantity_allocated_sop>0.00000</quantity_allocated_sop>

quantity_allocated_bom

Read Only
Allocated bill of materials quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<quantity_allocated_bom>0.00000</quantity_allocated_bom>

quantity_allocated

Read Only
Total Allocated stock, sop and bom quantity.

Type	Example	XML
number(decimal 5dp)	0.00000	<quantity_allocated>0.00000</quantity_allocated>

date_time_updated

Read Only
The date and time this entity was last updated (UTC).

Type	Example	XML
datetime	2017-06-05T09:56:51.967	<date_time_updated>2017-06-05T09:56:51.967</date_time_updated>

Expandable Fields

Related information linked to stock levels are also included in the downloaded XML.

warehouse

Read Only
The warehouse related to the stock level, see Sage 200 Online Warehouse XML.

Download example showing related information

<warehouse>
    <id>1</id>
    <name>HOME</name>
    <date_time_updated>2017-05-15T16:04:40.42</date_time_updated>
</warehouse>

product

Read Only
The product related to the stock level, see Sage 200 Online Stock Record XML.

Download example showing related information

<product>
    <id>27256</id>
    <date_time_updated>2017-06-05T10:00:53.483</date_time_updated>
    <code>BOARD001</code>
    <name>Whiteboard - Drywipe (900 x 1200)</name>
    <description>Magnetic steel drywipe whiteboard.Complete with marker tray.Compatible with most rail systemsDimensions: 900 x 1200</description>
    <barcode />
    <allow_sales_order>true</allow_sales_order>
    <product_group_id>14910</product_group_id>
    <tax_code_id>2</tax_code_id>
</product>

Example XML

<?xml version="1.0" encoding="utf-8"?>
<WarehouseHoldings
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <WarehouseHolding>
    <id>27336</id>
    <warehouse_id>1</warehouse_id>
    <product_id>27256</product_id>
    <reorder_level>2.00000</reorder_level>
    <minimum_level>1.00000</minimum_level>
    <maximum_level>0.00000</maximum_level>
    <confirmed_qty_in_stock>0.00000</confirmed_qty_in_stock>
    <unconfirmed_qty_in_stock>0.00000</unconfirmed_qty_in_stock>
    <quantity_in_stock>0.00000</quantity_in_stock>
    <quantity_allocated_stock>0.00000</quantity_allocated_stock>
    <quantity_allocated_sop>0.00000</quantity_allocated_sop>
    <quantity_allocated_bom>0.00000</quantity_allocated_bom>
    <quantity_allocated>0.00000</quantity_allocated>
    <warehouse>
      <id>1</id>
      <name>HOME</name>
      <date_time_updated>2017-05-15T16:04:40.42</date_time_updated>
    </warehouse>
    <product>
      <id>27256</id>
      <date_time_updated>2017-06-05T10:00:53.483</date_time_updated>
      <code>BOARD001</code>
      <name>Whiteboard - Drywipe (900 x 1200)</name>
      <description>
      Magnetic steel drywipe whiteboard.
      Complete with marker tray.
      Compatible with most rail systems
      Dimensions: 900 x 1200</description>
      <barcode />
      <allow_sales_order>true</allow_sales_order>
      <product_group_id>14910</product_group_id>
      <tax_code_id>2</tax_code_id>
    </product>
    <date_time_updated>2017-06-05T09:56:51.967</date_time_updated>
  </WarehouseHolding>
</WarehouseHoldings>