Requirement 

OX Tools USA would like to create an SSCC or GS1-128 Barcode label print for US-based Item fulfilments in the bulk print page as shown below:

Our Solution

• The requirement can be achieved by adding a button called “SSSC/GS1 Label” on the Bulk Print Custom page for IF. 
• Users will select the IFs from the list in the custom page and should click the “SSSC/GS1 Label” button. The script will generate the pdf in the below layout format on the button click.
• The page size is Size 4” x 6”. 
• Will generate one document for each button click (PDF of multiple IFs will be included in the same file if the user selected multiple IFs).

Field Mapping:

Blocks/ Labels	Netsuite Field	Specification
FROM	SHIP FROM VBU (Field ID : custbody36) this number will have like If “Ship From VBU” {custbody36} = “107308” use this address: OX TOOLS USA, 1000 N. County Line Rd., Elmhurst, IL 60126.If “Ship From VBU” {custbody36} = “112285” use this address: OX TOOLS USA, 500 Frith Drive, Building A, Ridgeway, VA 24148.	Height of block = 1 and width = 1.25
TO	Ship To RDC Number (Field ID : custbody32) thenShip To Address(Field ID : shipaddress)	Height of block = 1
SHIP TO POST	Post Code: in the Ship To Address under shipping tab of IF (Field ID : Zip), Bar code (optional) – is generated from the Post code value	Height of block = 1 and width = 2.5
CARRIER	“Shipping Carrier” (Field ID : custbody_ctl_carrier)PRO (not required)B/L name change to BLL: “Tracking Number” field in each Pallet (in Pallet information)
PO	PO: “Customer Po Number” field in IF (Field ID : custbody_ozlink_purchaseorder)Dept #: 14 (is fixed value that can be hardcoded)Dept Name : DEPARTMENT NAME  (Field ID : custbody44)	Height of block = 1 and width = 4Font size: 16 – 20 (format as shown)
FOR	Barcode & number referred from the field “Final Destination Store Number” (Field ID : custbody33) If no value in the “Final Destination Store Number” this area can be excluded	Height of block = 1 and width = 2.5The number should have 4 digits (if 3 add 0 before it) with a prefix of (91)Barcode will have 6 digits including the prefix.
(Right to FOR block)	The address should be populated according to the the excel sheet mapping where the “Final Destination Store Number” field value refers to the Store NumberText = Columns in Excel (Name, Store Number, Shipping Address, City, State, Postal code. If no value in the “Final Destination Store Number” this area can be excluded
SSCC	A column will be added in the pallet information sublist with Name: SSCC Barcode (Field ID: jj_sscc_barcode). Number – Value and format as entered by user (Manual entry)Barcode need to be generated from this number	20 digit number (Format as entered by user)
Page Size	–	4” x 6”

• The number of IFs in the print document will be based on the number of IFs selected in each pagination.
• And the print will have multiple pages for the same IF based on the number of pallets in  the Pallet information sublist. 
• Need to add an additional column in the bulk print page to see the postal code.
• We have to make custom records for each mapping provided in the excel.
• Script will look up the custom record for the related datas (Store Number) matching to the Final Destination Store Number (netsuite field) value.

Assumptions

• The print has multiple pages with mapping & specifications provided for the given layout.
• The number of IFs in the print document is based on the number of IFs selected in each pagination.
• The page size is 4” x 6”.
• The fields for generating Barcodes are always integers.
• All the three barcodes are of Code-128 type.
• Exactly the same content in the excel mapping is populated in the print on matching the Store Number(Column Name in excel) and Final Destination Store Number (Netsuite Field).
• All the other manual input datas follow the exact format as entered in the Netsuite Records
• SSCC Code will be imported to the Pallet Information Column field upon IF creation and this will be used in the Print
  

Risks 

• PDF creation will be delayed based on the number of transaction be to be processed
• Here we proposed a custom button to create the provided print. The new layout can be taken from the print button option only.
• The script is a little complicated and there can be chances of exceeding script execution time limit when taking print for 75 numbers in a single button click. In that case we will split up the document instead of having one single document with 75 IFs. We can only confirm the number of IF splitted into seperated documents while developing. 
• The Print will follow the order of PO number. 
• SSCC code Auto generation is not considered in this scope