Proposal Summary

This proposal outlines the development and implementation of enhancements to incorporate document/transaction numbers into the existing two-way sync between NetSuite and the website for Corp Design-USA-NS/SCA. The objective is to map document numbers for transactions such as sales orders,Itemfulfillment, invoices, cash sales, RMAs, and estimates from NetSuite to Website ensuring seamless tracking and alignment with predefined integration requirements. This proposal also covers the engagement scope of Jobin and Jismi, as official implementation partner Of Oracle NetSuite.

 

Requirement

The Client needs to implement an enhancement to the existing two-way sync mechanism between NetSuite and the website for Corp Design-USA-NS/SCA. The primary objective is to incorporate document/transaction numbers from NetSuite into the Website, ensuring these numbers are made available on the website. This enhancement will cover the following transaction types:

• Sales Orders
• Item Fulfilment
• Invoices
• Cash Sales
• RMAs
• Estimates

The client requires seamless tracking of these transaction numbers to improve operational efficiency and ensure accurate data representation across both systems.

Additionally, the implementation must align with predefined integration requirements while maintaining data integrity and system performance.

 

Deliverables

The implementor has reviewed the requirement thoroughly and please find below the deliverables we propose.

We will be considering following sync on NetSuite-Magento integration:

●      Estimate/Quote SYNC

●      Order SYNC  

●      Item Fulfillment SYNC

●      Invoice SYNC

●      Cash Sale SYNC

●      RMA SYNC

  Estimate/Quote Sync:

The real-time script ‘JJ UE Quote Update Delete sync CDUS-1136’ deployed on quote records in NetSuite, requires an update to send the document number whenever a quote is created or updated for Adobe orders.

The script will be enhanced to trigger automatically whenever a quote record is added or modified in NetSuite, specifically for Adobe-related transactions.

This update will ensure the document number is included in the API response, enabling seamless real-time synchronization with the website.

Sample Payload

{

   “quote_id”: “adobequoteId”,

   “items”: “Itemdetails”,

   “subtotal”: “Subtotal_Value”,

   “tax”: “Tax_Value”,

   “quote_status”: “Quote_Status_ID”,

   “expiry_date”: “Expiry_Date”,

   “grand_total”: “Grand_Total_Value”,

   “discount”: “Discount_Total_Value”,

   “first_name”: “First_Name”,

   “last_name”: “Last_Name”,

   “street”: “Shipping_Street”,

   “country”: “Shipping_Country”,

   “state”: “Shipping_State”,

   “city”: “Shipping_City”,

   “postcode”: “Shipping_Zip_Code”,

   “telephone”: “Shipping_Telephone”,

   “po_number”: “PO_Number”,

   “memo”: “Memo”,

   “spiff_person”: “Spiff_Person”,

   “ship_date”: “Ship_Date”,

   “shipping_amount”: “Shipping_Cost”,

   “shipping_method”: “Shipping_Method”,

   “ship_from_warehouse”: “Shipping_Location_ID”,

   “pdf”: “External_URL”

}

  Order Sync:

A scheduled script is used to sync orders from Magento to NetSuite. Once the scheduled script creates a Sales Order in NetSuite, a real time script ‘JJ UE SO SYN CDUS-4088’ is triggered on the Sales Order.

Implement this script to  call the Sales Order Update API and includes the Sales Order document number in the response to the website along with other predefined fields, ensuring seamless tracking of the order and its associated document number.

Order Update Payload

 {

“entity”: {

“base_currency_code”: ‘USD’,

“base_grand_total”: ‘total’,

“base_subtotal”: fieldId: ‘subtotal’,

“entity_id”: adobeCommerceOrderId,

“customer_firstname”: customerFirstname,

“customer_lastname”: customerLastname,

“customer_group_id”: magentoPriceLevel,

“created_at”:’trandate’,

“global_currency_code”: ‘USD’,

“grand_total”: ‘total’,

“order_currency_code”: ‘USD’,

“shipping_amount”:  ‘shippingcost’ ,

“shipping_description”:shippingMethodText,

“status”: “closed” / “pending”,

“store_currency_code”: ‘USD’,

“store_id”: 1,

“subtotal”: ‘subtotal’,

“tax_amount”:’taxtotal’,

“total_due”: ‘total’ ,

“items”: items,

“billing_address”: billingAddress,

“status_histories”: [],

“extension_attributes”: {

“shipping_assignments”: [

{

“shipping”: {

“address”: shippingAddress,

“method”: shippingMethod_Name

}

}

],

“memo”: saleorder_memo

“ship_date”: salesorder_shipdate

“spiff_person”: spiff_Name,

“ship_from_warehouse”: location,

“pdf”: externalUrl,

“discount_price”: discounttotal,

“po_number”:  ‘otherrefnum’ ,

}

}

};

 

  Item Fulfillment Sync:

The real-time script ‘JJ UE Item Fulfillment sync CDUS-1140’, deployed on item fulfillment records in NetSuite, needs to be enhanced to send the document number whenever an item fulfillment record is created for Adobe orders.

The updated script should automatically trigger upon the creation of an item fulfillment record in NetSuite, specifically for Adobe-related orders.

This enhancement will modify the script to include the item fulfillment document number in the API response, ensuring real-time synchronization with the website.

The update will ensure that the document number is promptly available on the website, improving order tracking and fulfillment processes.

 

  Invoice Sync:

The real-time script ‘JJ UE Adobe Invoice Sync 1142.js’ deployed on invoices in NetSuite needs to be updated to send the document number whenever an invoice is created for Adobe orders.

The script should trigger whenever an invoice is created in NetSuite, specifically for Adobe orders.

The updated script will include the invoice document number in the response, ensuring that it is sent to the website in real-time.

This update will ensure that the invoice document number is immediately available on the website for accurate tracking and order management.

Sample payload

{

 “capture”: true,

 “invoice_document_number”: Invoice Document number, 

 “items”: [

   {

     “order_item_id”: “1327”,

     “qty”: 3

   }

 ],

 “notify”: true

}

  Cash sale Sync:  

Implement a real time script for syncing Cash Sale details to the custom API provided by the website.

This Script in NetSuite that triggers on the creation of a Cash Sale for adobe orders and sends the document number along with other necessary details to the custom API provided by the website.

 

 RMA Sync:

The real-time script ‘JJ UE RMA To Adobe Sync CDUS-4166’ deployed on RMA in NetSuite needs to be updated to send the document number whenever an RMA  is created for Adobe orders.

The script should trigger whenever an RMA is created in NetSuite, specifically for Adobe orders.

The updated script will include the RMA document number in the response, ensuring that it is sent to the website in real-time.

This update will ensure that the RMA document number is immediately available on the website for accurate tracking and order management.

Sample Payload

{

 “customer_id”: _adobe_customer_id,

 “dealer_id”: “dealer_id”,

 “status”: “rmaStatus”,

 “order_id”: “adobe_order_id”,

 “po_number”: “poNumberLookup”,

 “memo”: “memoLookup”,

 “pdf”: “externalUrl”,

“documentnumber”:”RMA_document_number”

 “items”: “[{“item_id”: “item1”, “quantity”: 10}, {“item_id”: “item2”, “quantity”: 5}]”

}

Assumptions

The implementor assumes that the

The transaction document_number will be automatically generated and available at the time of the  creation. This number will be included in the API response to the website for real-time synchronization.

Real-time API calls will ensure synchronization with the website immediately after the creation of the transactions in NetSuite.