Version: eXtendPS-SE 1.4.4 and above
Audience: Administrator
Applicable to: Live Inventory 2.0.0

Overview

Live Inventory 2.0.0 can return future availability for an item based on open purchase orders in NetSuite. This helps you see what quantity is expected to be received and when.

Prerequisites

  • Live Inventory 2.0.0 is enabled and working for your account.
  • Your NetSuite account shows open purchase orders for the item you’re testing.

Configuration

To include future availability in the Live Inventory 2.0.0 response, enable the setting in eXtendPS-SE Inventory Setup.

  1. Go to eXtendPS-SE Inventory Setup.
  2. Enable Show Future Availability For Items.
  3. Set Show Future Availability Item Receipt Date from the purchase order to control which item receipt date field is used in the response.
  4. If some purchase orders don’t have a value in the receipt date field, set Future Availability Offset Days (2.0 only). This adds the specified number of days to today’s date so a valid PromoStandards response can still be returned.


Usage (how future availability is calculated)

Future availability is determined from open purchase orders for the item.

Example: If you have an item named “29M- M-Classic Pink” and want to verify the values being returned:

  1. Open the item record in NetSuite.
  2. Select the Item Status Details subtab.
  3. In Items on Order, review the open purchase orders for the item.
  4. Use the quantity and receipt date values from the sublist to confirm what you expect to see in the Live Inventory response.


In the example screenshot above, the Qty Open value represents the future quantity planned to be received by the listed receipt date.

Sample response

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
	xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
	xmlns:tns="http://www.promostandards.org/WSDL/Inventory/2.0.0/"
	xmlns:ns="http://www.promostandards.org/WSDL/Inventory/2.0.0/SharedObjects/"
	xmlns:ns1="http://www.codesynthesis.com/xmlns/xsstl">
	<soap:Body>
		<getInventoryLevelsResponse>
			<Inventory
				xmlns="http://www.promostandards.org/WSDL/Inventory/2.0.0/SharedObjects/">
				<productId>29M : 29M- M-Classic Pink</productId>
				<PartInventoryArray>
					<PartInventory>
						<partId>29M : 29M- M-Classic Pink</partId>
						<mainPart>true</mainPart>
						<partColor>Classic Pink</partColor>
						<labelSize>M</labelSize>
						<partDescription>description</partDescription>
						<quantityAvailable>
							<Quantity>
								<uom>EA</uom>
								<value>111701</value>
							</Quantity>
						</quantityAvailable>
						<manufacturedItem>false</manufacturedItem>
						<buyToOrder>true</buyToOrder>
						<attributeSelection>Material: 29M : 29M- M-Classic Pink</attributeSelection>
						<InventoryLocationArray>
							<InventoryLocation>
								<inventoryLocationId>2</inventoryLocationId>
								<inventoryLocationName>01: San Francisco</inventoryLocationName>
								<postalCode>94403</postalCode>
								<country>US</country>
								<inventoryLocationQuantity>
									<Quantity>
										<uom>EA</uom>
										<value>111701</value>
									</Quantity>
								</inventoryLocationQuantity>
								<FutureAvailabilityArray>
									<FutureAvailability>
										<Quantity>
											<uom>EA</uom>
											<value>4000</value>
										</Quantity>
										<availableOn>2019-06-05T07:00:00.000Z</availableOn>
									</FutureAvailability>
									<FutureAvailability>
										<Quantity>
											<uom>EA</uom>
											<value>41999</value>
										</Quantity>
										<availableOn>2019-06-10T07:00:00.000Z</availableOn>
									</FutureAvailability>
									<FutureAvailability>
										<Quantity>
											<uom>EA</uom>
											<value>15000</value>
										</Quantity>
										<availableOn>2019-06-09T07:00:00.000Z</availableOn>
									</FutureAvailability>
								</FutureAvailabilityArray>
							</InventoryLocation>
							<InventoryLocation>
								<inventoryLocationId>1</inventoryLocationId>
								<inventoryLocationName>02: Boston</inventoryLocationName>
								<postalCode>02101</postalCode>
								<country>US</country>
								<inventoryLocationQuantity>
									<Quantity>
										<uom>EA</uom>
										<value>0</value>
									</Quantity>
								</inventoryLocationQuantity>
							</InventoryLocation>
							<InventoryLocation>
								<inventoryLocationId>310</inventoryLocationId>
								<inventoryLocationName>New Jersey</inventoryLocationName>
								<country>US</country>
								<inventoryLocationQuantity>
									<Quantity>
										<uom>EA</uom>
										<value>0</value>
									</Quantity>
								</inventoryLocationQuantity>
								<FutureAvailabilityArray>
									<FutureAvailability>
										<Quantity>
											<uom>EA</uom>
											<value>15000</value>
										</Quantity>
										<availableOn>2019-06-06T07:00:00.000Z</availableOn>
									</FutureAvailability>
								</FutureAvailabilityArray>
							</InventoryLocation>
							<InventoryLocation>
								<inventoryLocationId>3</inventoryLocationId>
								<inventoryLocationName>Overstock</inventoryLocationName>
								<country>US</country>
								<inventoryLocationQuantity>
									<Quantity>
										<uom>EA</uom>
										<value>0</value>
									</Quantity>
								</inventoryLocationQuantity>
							</InventoryLocation>
						</InventoryLocationArray>
						<lastModified>2019-06-10T13:39:21.417Z</lastModified>
					</PartInventory>
				</PartInventoryArray>
			</Inventory>
		</getInventoryLevelsResponse>
	</soap:Body>
</soap:Envelope>

Frequently Asked Questions (FAQs)

Q: Why am I seeing an error when attempting to view future inventory for an item?
A: If the receipt date field you’ve configured is blank for an item, the response may not have a date to return. Set Future Availability Offset Days (2.0 only) to calculate a date so a valid response can still be returned.
Q: Where does the future availability quantity come from in NetSuite?
A: It’s based on open purchase order lines for the item (quantity ordered minus quantity received), as shown in Items on Order on the item record.