PROPOSAL FOR STORING PRODUCTS QUANTITY FROM SUPERIOR TO NETSUITE

This proposal summarizes the establishment of connecting the Netsuite and Superior Communications using API.

Requirement

The Products quantity from the superior communication needs to be updated in the Netsuite  Quantity of Products shown at Superior will be able to be seen in Netsuite.

Create a connection between NetSuite and Superior through API . Fetch products using the “Retrieve Stock Quantity” API.

We will fetch the quantity for each Superior item from Superior communication and check whether the item is present or not in Netsuite.

 If the item is present then we will update the inventory of the location “Superior Communications TN”

Daily once we will fetch the item quantity from Superior and update it to the location “Superior Communications TN”

.

Assumptions 

• We are planning to update the quantity (QUANTITY ON HAND) for location “Superior Communications TN” daily once using a schedule script.Because we cannot directly change the “QUANTITY ON HAND” field value in the item record. For updating the “QUANTITY ON HAND” value either we receive or sell items in Netsuite.
• For updating the “QUANTITY ON HAND” value for location “Superior Communications TN” we have to create an inventory adjustment record using a schedule script. The script will compare the location quantity, if it is greater or less  than the SPS quantity then we will adjust the quantity of the item using the inventory adjustment record.
• We are assuming that the product code will be unique for all the items in Netsuite, So that we can exactly match the API to the single unique item in Netsuite.
• The average cost of the item will be changed based on the inventory change.This process is automatically done by system. Without affecting the item’s “average cost” value there is only one solution. Create a custom item field and show the SPS quantity in that field.

Question

1. 
   1. Only we will get the ProductCode
   2. DCCode
   3. LocationType
   4. Quantity

These Fields are only accessible using the API call. What do you mean by “Vendor SKU”? Kindly explain the purpose of the “Vendor SKU”  field.