send feedback

❮ Previous Next ❯

Item sort by size

About Item Sort by Size

The Item Sort feature is used to gather information from Purchase and Transfer Orders and provide that information as an ordered list. This list is specifically defined by size order, smallest to largest. Implementing this feature can affect all documents in the process, so there is no one specific service definition.

Note:The Item Sort feature was originally created specifically for Rally House use.

The Item Sort feature was written in NetSuite and calls GET and POST business functions to generate a size-sorted list whenever a document with items is retrieved. The process is designed to provide custom interaction, which uses non-serialized, non-binned items.

Name	Function Name	Description
NetSuite RESTlet	DSI_RH_RecordLookup	The RESTlet is the script running server side to NetSuite that returns information.

The Item Sort feature will return the additional item list for transaction records within the NetSuite system.

Transaction Types

Purchase Orders
Transfer Orders
Sales Orders
Item Receipts
Item Fulfillments

Environment Considerations

The Item Sort feature is designed to support a single instance of NetSuite and allows items, as presented to the users, to be viewed in order of garment size. The sorted items appear in their own list, separate from the item list native to NetSuite.

Each item in both lists is given a sort number to allow numeric sorting. The sorted list and sort numbers are not saved in any NetSuite record. The messages for a loss in communication or an issue with data entered in the Application, will be identical to other interfaces used to retrieve transactions.

Use Item Sort with NetSuite

Item Sort has no corresponding application in NetSuite. This functionality can only be performed in the NetSuite User Interface with the use of custom sub list fields and custom scripting set up by the System Administrator.

Data Structure

Item Sort retrieves the extra data using a single output structure containing one or more items. The output for each item includes all fields in the NetSuite item list which contain data. No additional input variables are required.

The following is an example item structure from a Transfer order.

Type	Field	Description	Param
Array	sorteditems	A list of one or more items	Output
String	amount	Dollar amount of the transaction	Output
String	description	Human readable description of the item	Output
String	expectedshipdate	Expected Shipping Date	Output
String	item	A structure containing the next two fields	Output
String	Item.internalid	Internal ID of the item	Output
String	Item.name	Name/Number of the item	Output
String	quantity	The quantity of this item on the transaction	Output
String	quantitybackordered	The portion of the quantity of this item that is currently in back ordered status	Output
String	quantityfulfilled	The portion of the quantity of this item that is currently in fulfilled status	Output
String	quantityreceived	The portion of the quantity of this item that is currently in received status	Output
String	sortnum	Numeric value representing the ordinal of this item's garment size	Output

Process Item Sort

The addition of this feature to the record views does not require any additional required fields. The generation of the sorted list is entirely transparent to the calling service.

Sorting Method

Items are sorted by size through the use of a hard-coded list of sizes. This list contains sizes for infants, children, men and women in size order, from the smallest preemie infant up to 6XL. The list does not differentiate between men's and women's sizes with the same name as that information is contained in the parent item record.

Error Codes

No additional error codes are returned by this feature. The list below contains the standard error codes.

Communication Error

The user will receive this error is the communication between the Advanced Inventory Feature and the NetSuite Feature fails and should allow the user to restart the process.

Input Error

The user will receive this error if the input data has been entered incorrectly and should allow the user to restart the process.

Not Found Errorr

The user will receive this error if the input data is not found during request/processing.

Interaction between the DSI interface and NetSuite

The information below describes the actions of the Advanced Inventory interface and the NetSuite interface.

DSI interface

The Advanced Inventory interface is designed to allow the user to perform the required steps to pull information and present it in both the standard format and a sorted format. The user is prompted to enter identifying data parameters to select the transaction to be retrieved. The Advanced Inventory Interface provides the user with the following options and input capabilities, and captures the following data points.

Advanced Inventory Interface Login Details

The user will login the Interface and the system will capture the following user login in data.

User Name
Password
Login Date / Time

Transaction Lookup Parameters

The transaction parameters entered by the user will be unchanged from the standard interfaces. The following list contains typical identifying parameters.

Transaction Type
Transaction Internal ID
Transaction Document Number / Name
Transaction Body Fields as Name-Value pairs
Transaction Sublist Fields as Name-Value pairs
NetSuite User Login Details

NetSuite interface

When a user connects to the NetSuite interface, the input parameters are used to perform a search of transactions stored in NetSuite. All possible data is retrieved from the transactions matching all the parameters provided. A list of items is produced sorted by size and appended to the standard data returned to the user. In order for the user to be able to access the information, they must be logged into NetSuite.

The Advanced Inventory interface will perform the following actions when the user connects to the NetSuite interface.

Logs the Advanced Inventory Interface user into NetSuite using the assigned and stored NetSuite user login information.
Accepts the input parameters that the user has stored within the Advanced Inventory Interface.
Performs a search of transactions within NetSuite matching all the criteria indicated in the parameters.
Retrieves the matching transaction and all its fields that contain data.
Transaction Sublist Fields as Name-Value pairs
Sends a success or error message response to the user.
Provides the user with all transaction data retrieved including the sorted list appended to the transaction data via communication protocols with the Advanced Inventory Interface.

Test Scenarios for Item Sort

It is important to test the Item Sort feature to ensure that the applicable Advanced Inventory app is communicating properly with the NetSuite interface.

To test and verify your use of Item Sort, perform one or more of the following test scenarios in the applicable Advanced Inventory app on a device.

Log into the applicable Advanced Inventory app on a device.
To view a transfer order, complete the following substeps.
1. Enter the internalid, document number or other criteria of the desired transfer order.
2. Process the record lookup.
3. Examine the data returned to find the sorted list appended to the end.
To view a purchase order, complete the following substeps.
1. Enter the internalid, document number or other criteria of the desired purchase order.
2. Process the record lookup.
3. Examine the data returned to find the sorted list appended to the end.
To view an item fulfillment, complete the following substeps.
1. Enter the internalid, document number or other criteria of the desired item fulfillment.
2. Process the record lookup.
3. Examine the data returned to find the sorted list appended to the end.

There was a problem loading this topic

Mobile Enterprise Platform