Proposal Summary
This proposal outlines the displaying the distance from business unit location to customer shipping location on Quote/Sales Order at Power Utility Products (hereafter referred as client) by Jobin&Jismi (hereafter referred as Implementer).
This proposal covers the customization to calculates and displays the distance (in miles) between the Business Unit Location and the Customer Shipping Location directly within the Quote or Sales Order entry process. This distance should be displayed dynamically on each sublist line when entering items by location.
Requirement from Power Utility Products
The requirement is to implement a feature in NetSuite that dynamically displays the distance in miles between the Business Unit Location and the Customer’s Shipping Location on each line item of a Quote or Sales Order during the entry process.
Prerequisites:
To determine the distance between two locations, we must use Google Maps APIs.
After the free tier, the Google Maps Platform charges for API usage based on the number of requests made to the Distance Matrix API. The free tier offers a $200 monthly credit, which can cover a significant amount of usage. However, once you exceed this limit, the charges apply as follows: for the Basic tier, which allows up to 100 elements per request, the cost is $5.00 per 1,000 elements. If you require more advanced features, such as handling more than 100 elements per request or incorporating traffic models, the cost increases to $10.00 per 1,000 elements. These charges allow you to calculate travel distances and times efficiently, with costs scaling based on the complexity and volume of your requests.
Deliverables
The deliverables include adding new custom field in sales order and Quote in NetSuite and calculating distance between location using Google Map API.
The implementer has reviewed the requirement thoroughly and find below the deliverables the implementer propose.
Sales Order & Quote Form Customization:
A custom field will be created on the Sales Order and Quote sublist (Items sublist) to display the calculated distance in miles.
Data Source:
- Business Unit Location: The location can be derived from the “fulfillment Center” field on each line item in the Sales Order & Quote.
- Customer Shipping Location: The address will be taken from the Ship-To address on the transaction.
Distance Calculation Logic:
The Google Maps API will be used to calculate the distance based on the provided addresses or geographic coordinates.
The distance between Business Unit Location and the Customer’s Shipping Location will be calculated and set on the custom field in the sales Order/Quote on the save action.
Assumptions
- The address contains details Street Number and Name, City, State, Zip code and country.
Risk
- If the Business Unit Location or the Customer’s Shipping Location are Missing or incomplete, the Distance cannot be calculated.
Notes
The scope and the provided estimate are based on the anticipation, expectation, and understanding through our discussions and email. If the scope change/additional feature development identified during actual development will be treated as change request.