Version: eXtendPS-SE 1.3.6 and above
Audience: Administrator
Applicable to: Live Inventory 2.0.0
Configuration
To display the future availability of items in the live inventory 2.0.0 response, you can enable this feature in the eXtendPS-SE Inventory etup screen. Simply enable the checkbox labeled "Show Future Availability For Items". Additionally, you can configure the date that will be shown along with the future availability total by using the "Show Future Availability Item Receipt Date" field, as shown in the screenshot below.
Feature Details
The future availability of items is determined by the purchase orders placed for the specific item.
For example, if you have an item named "29M- M-Classic Pink" in your NetSuite account and you want to check its future availability, follow these steps:
- Navigate to your item record.
- Go to the "Item Status Details" subtab.
- Under the "Items on Order" sublist, you will find all the open purchase orders for the item.
- The sublist will display the item quantity, location, received quantity, and receipt date, as shown in the screenshot below:
Note: This subtab/sublist is available depending on your implementation of NetSuite. If this particular subtab/sublist is now available in your NetSuite environment it can be configured by your NetSuite Administrator.
Considering the data shown above, the future quantities will be as follows:
- For line 1: The future quantity of this item for location "New Jersey" will be 15,000 units, calculated as the difference between the quantity ordered (15,000) and the quantity received (0). The expected receipt date for this item is 06/06/2019.
- Similarly for line 2: The future quantity of this item for the location "San Francisco" will be 4,000 units, calculated as (Quantity Ordered - Quantity Received) i.e. (10,000 - 6000). The expected receipt date for this item is 06/05/2019.
- Similarly for line 3: The quantity for this item in "San Francisco" will be 41,999 units, calculated as (Quantity Ordered - Quantity Received), which is (50,000 - 8001). The expected receipt date for this quantity is 06/10/2019.
- Similarly for line 4: The quantity for this item in "San Francisco" will be 15,000 units, calculated as (Quantity Ordered - Quantity Received), i.e., (15,000 - 0), which equals 15,000. The expected receipt date of 06/09/2019.
- In other words, the quantity in the "Qty Open" column represents the future quantity for the item in location, which is planned to be received by the specified receipt date.
Now, if you view the live inventory response for this item, you will see the future available quantity based on location and their receiving date.
Note: We have configured the item receipt date field as {expectedreceiptdate} in this example. Details regarding this configuration are in the previous Configuration section.
Below is the XML response for the item "29M- M-Classic Pink", which includes the quantity of future availability.
<?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>