Projects

Mindfire has strong knowledge and experience in developing Net Suite applications.

  • NetSuite Integration
  • Zoho QuickBook Integration
  • SQL Server to Zoho CRM Integration
  • Kit Item Integration
  • Automatic Incrementation of an ItemID
  • Cash Sale Transaction
  • Sales Order Integration
  • Quote Estimate Integration
  • Auto Mailing of Quotes
  • Quote Record Creation
  • Invoice Processing Application
  • Shipping Method Integration Application
  • Customer Invoice Screen
  • NetSuite Events and Customer Records Integration
  • File Integration with Suitelet
  • Invoice Generation with Suitelet
  • Purchase Order Suitelet
  • NetSuite Shopping Cart
  • NetSuite External Catalog Site
  • Shopping Cart Application for an outdoor sports company
  • NetSuite customer item price customization
  • Rental Project
  • Scheduled CSV updates
  • NetSuite Currency Converter Scripts
  • Netsuite Customization - Custom Price List PDF
  • Sales Order
  • Performance Enhancement with Restlet Conversion
  • Work Order Release System
  • Builders App
  • Info Integration between NetSuite Sites
  • Roof safety Application
  • Automation of Inventory Details in NetSuite
  • Sales Order record Packages
  • Certificate Printing in NetSuite
  • Customizations in Netsuite
  • Netsuite website cutomization
  • Serial Number Lookup
  • Localization In Customer Statements
  • Change Billing Period In Billing Scripts
  • Unit Testing For Billing Scripts
  • QuickBooks File Merge


NetSuite Integration

Industry:
IT Consulting
Technologies:
ASP.NET 2.0, C#, WebService, AJAX Web Extensions, AJAX Control Toolkit Library, MySQL, NetSuite

This is a web based integration system that interacts with the NetSuite ERP through their webservice and helps clients to upload their inventory, employees, customers, Kit Integration Items, non-inventory resale, non-inventory purchase, service sale, service resale, service purchase, other charge sale, etc. The items are sent in bulk CSV or excel formats and the application parses them, recognizes them and sends them to appropriate account in NetSuite®.


Zoho QuickBook Integration

Client:
Customer Relationship Management Company
Industry:
IT Services
Technologies:
C#.Net, WebService, SOAP

This is a webservice to integrate different modules of Zoho CRM such as Account, Contact, Potential, Product,Quote, Sales Order and Invoice with QuickBooks.The Synchronization starts from QuickBooks to Zoho CRM and then back to QuickBooks.



This webservice helps for two way synchronization of Customer Module between QuickBooks and Zoho CRM. Where as for modules such as Potential, Product, Quote, Sales Order and Invoice it provides one way synchronization from QuickBooks to Zoho CRM.



If a change is made to Customer/Account either in QB or Zoho CRM that change is reflected in the other application.  Similarly, if a product is modified in QuickBooks the change are reflected in Zoho CRM. Also if any change is made to QuickBooks Invoice, Sales Order or Quote, those changes are reflected in the corresponding module of Zoho CRM.



The Synchronization between QuickBooks and Zoho CRM can be done manually as well as automatically at regular time intervals set by the user.


SQL Server to Zoho CRM Integration

Client:
Customer Relationship Management Company
Industry:
IT Services
Technologies:
C#.net, SQL Server 2008

This is a window service to integrate data stored in SQL Server with different modules of Zoho CRM such as Leads,Account, Contact, Opportunities, Quote, and Invoice.

This window service runs automatically to synchronize two way between Zoho CRM and SQL Server. The Synchronization starts from SQL Server to Zoho CRM.

If the user modifies any record or adds a new record either in SQL Server or Zoho CRM the change is reflected in the other application.


Kit Item Integration

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

In this application we have implemented the following functionalities:

1. User needs to login first to use this application.

2. After successful login, user can see a form with file Upload facility.

3. Then he can browse the .xls file which has the kit items to be uploaded into Netsuite.

4. On clicking the submit button, all the kit items will be inserted into Netsuite database.


Automatic Incrementation of an ItemID

Client:
Software Service provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

We have implemented the following functionalities in this application:

1. NetSuite Customer Login - List > Accounting > Items > New (Inventory Item).

2. Item Number field – needs an auto generated next number. (The first number needs to be 1600, when the next item get's added (saved) to NetSuite the Item Number field should populate with 1601.

3. Select the "Customize" button on the form and see the "Custom Code" tab.


Cash Sale Transaction

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

This is a onetime historical records load into client's database Problem here NetSuite will only allow 100 records (during peak hours) and 200 records (during non peak hours to be loaded in one batch). We came up with innovative ideas to overcome this limitation and hundreds of thousands records were loaded in record time. All these were NetSuite Cash Sales transactions.


Sales Order Integration

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

We have done the implementation of the following functionalities: 1. This is more like kit integration where we have provided a URL that an end user can browse out to their local workstation and can upload two files i.e. (a) Sales Order Header File & (b) Sales Order Line Item Detail File (The ORDER_ID is the key field that will tie the two files together for importing). 2. This utility will be used on a daily basis to upload sales orders into NetSuite from the two CSV files described above. 3. These will be imported into NetSuite Sales Order transaction type. (Transactions > Sales > Enter Sales Orders)


Quote Estimate Integration

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

This project is to dynamically create customer records, contact records and quote records from an XML file. We gave the client an XML schema , based on XML import file structured and layout. The overall purpose of the this integration is to create a company(customer) record, attach a contact record to that of company record and also create and attach a quote/estimate record to that company. The integration was done from a XML file.


Auto Mailing of Quotes

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

The requirement for this project was to display images on either a NetSuite quote document or a custom quote document and to send this document to proper destination. This is a very huge project. A lot of functionalities, lot of searching of fields was implemented in the HTML Quote document (email) which was  sent to email addresses. Also another challenge was to have the system which can dynamically generate image URLs.


Quote Record Creation

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

Create an opportunity record when end user can create a Quote record from scratch. There will be one opportunity record for each line item within a given quote. The end user can create Quote record from scratch and by using the QuoteEstimate Application. So when he creates or save the Quote records the Opportunity records are created automatically. The number of Opportunity records created equals to the number of line items present in the Quote record.


Invoice Processing Application

Client:
Software Service Provider
Industry:
Sofware Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

The application provided a client-side JavaScript routine which defaulted terms and due date on the customer invoice form to Net 30 or defaulted the terms from the customer master if not equal to blank. It served as the main routine which drove the application.


Shipping Method Integration Application

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

In this application we have done the following implementations:

1.End user can create sales order record from a new web site for a particular customer.

2.When end user checks a check box in the customer record and saves that specific customer then the shipping item from the customer will be automatically overwrite the shipping method in the sales order record which was created previously. 


Customer Invoice Screen

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

The project module displayed all open deposits for the specific customer entered in the SalesOrder (SO)/Invoice in a custom read-only field, on the Customer Sales Order screen and Customer Invoice screen.


NetSuite Events and Customer Records Integration

Client:
Software Service Provider
Industry:
Software Services
Technologies:
ASP.NET 3.5, Web Services, Windows Services, Suitlet Scripts, SQL Server, MySQL

The application provided the client with a hosted integration utility that would allow integration of NetSuite Events and Customer records into NetSuite fields in the excel template and any other requirements. For any file that does not contain all the necessary acceptable data, the acceptable data integrates and an error log/report would be created with information on which records do not integrate.

1. We had to provide a password protected hosted web page that will allow an excel file (template) to be uploaded into the import utility. Can be used as many times as required.

2. The import utility will create new Customer records and update the appropriate interest check boxes.

3. The import utility will also create new Event records and associate all customer records for both new and existing to the newly created events.

4. The import utility will check to see if the same customer record already exists in NetSuite, not create duplicate records, and only update the interest checkboxes. Match based upon the following criterias; first name, last name and zip code (All proper).


File Integration with Suitelet

Client:
Independent Software Vendor
Industry:
NetSuite
Technologies:
NetSuite, JavaScript, Suitelet

This was done as a Suitelet script which is called from another Suitelet script with a text file name. This Suitelet receives the text file name and do searches in NetSuite in the files. It then downloads the text file from a specific location and reads the content. Based on rows and column values it creates File records in NetSuite. It also includes save searches for the file, based on certain criteria. Based on the result it downloads the files and gets the contents and updates some file records in NetSuite if certain criteria matches. Finally it creates Transaction records with exact number of line items equal to the number of files in the save search.


Invoice Generation with Suitelet

Client:
Independent Software Vendor
Industry:
NetSuite
Technologies:
NetSuite, JavaScript, Suitelet

This is a Suitelet script, which is called from another Suitelet page. The other Suitelt downloads a file from file cabinet and posts to this Invoice Suitelet. It then receives the xml file, parses it and stores the content in memory. It then downloads the xml template from file cabinet based on a specific search in NetSuite. It then prepares the new xml file and displays in the page. Invoice dates obtained from Invoice records are transformed and stored in memory. Based on the result it creates Transaction records, Invoice addresses records and address Lines records in NetSuite.


Purchase Order Suitelet

Client:
Independent Software Vendor
Industry:
NetSuite
Technologies:
NetSuite, JavaScript, Suitelet

It is a Suitelet script which is called from another Suitelet script which sends a transaction number as a parameter. Based on the parameter and other specification it creates a xml template which can be shown in the same page.  This xml should be dynamic in nature as there are a number of line items in transaction records. Finally, it posts the constructed xml and get the response and updates the transaction record.


NetSuite Shopping Cart

Client:
Independent Software Vendor
Industry:
NetSuite
Technologies:
NetSuite, JavaScript, Suitelet

This script is called from another Suitelet script. When user clicks the button on the other Suitelet script, it downloads a xml file from file cabinet and  posts to this shopping cart script. It then parse the xml and gets the contents. The xml template is obtained from file cabinet and it creates a xml file and stores that to file cabinet. It then search the Entity records in NetSuite and displays the shopping cart with submit button and cancel button with the values from search. When user clicks the submit button, a page will be displayed with success message and when user clicks the cancel button, another page will be displayed with the cancellation message. Based on the button click, Transactions records will be created in NetSuite.


NetSuite External Catalog Site

Client:
ISV
Industry:
ISV
Technologies:
NetSuite, Suitlet, Suitescript

For this project we had implemented the external catalog feature of the site. The site that was present was a site completely hosted within NetSuite, but for their maintenance and to decrease the number of people that have access to NetSuite account we implemented the external catalog site feature.

In this feature the page where the user can search for items and go through them are developed by us. NetSuite  provides urls for getting specific item details like image, price etc which we integrate with the correct items and they are displayed in the pages created by us. It also provides URL's that we redirect to shopping cart page, or checkout page and login page. On our side we provide URL for redirecting to our pages like when the shopping is cancelled or when the login is complete or checkout is complete.

When the user adds an item we make a post with the itemid, quantity to the shopping cart URL provided by NetSuite and that item is added to cart. Then the complete process of checkout is complete by NetSuite and in the end the user is redirected again to our pages. Later on, using the email address and the date we track the order placed by the user, get all the details and insert them into the local DB.


Shopping Cart Application for an outdoor sports company

Client:
ISV
Industry:
Sports
Technologies:
NetSuite, Suitlet, Suitescript

We have provided the option to add multiple items to the cart at a time. Each item has option for color and size. Textbox will be created dynamically for the item based on its availability(color and size) where the user will enter his quantity. When clicked "Add To cart" button, appropriate message is shown to user if item not available. This is done for both Inventory and Non Inventory items.


NetSuite customer item price customization

Client:
NetSuite ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

To show customer item price list to end users. Created a custom button in customer record in view mode. On click of that button, application starts processing. Here a suitelet works. It searches the inventory items which fall under the marketing segment that customer belongs to. Then it gets the price from items pricing tab as per the price level set in customer record.

Another aspect of this item pricing is that there is a pricing sublist in each customer record. These custom item pricing sublist overrides the actual pricing. Finally a pdf report will be shown to user in browser showing the pricing of all the items belongs to marketing segment of current customer.


Rental Project

Client:
ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

Designed some HTML forms suitelet pages which are interlinked with each other. Here when user enters a Category, Date Range and clicks "Go", the "Rental Availability" framed information will be shown related to that "Category".

When user clicks any of the Stock Number(Ex: E45831), another popup HTML form opens. When user Clicks the "Rental Contract" button, another popup HTML form also opens  to enter new Rental Contract. When user enters a customer name, its customer related information will be populated in some fields and user needs to enter rest of the fields. When user clicks the "Details" tab, it will show the Contract Details information related to that Customer for that Stock Number.


Scheduled CSV updates

Client:
ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

Created scheduled scripts to run in specific time interval from CSV folders. Files were processed by creating/ updating records in NetSuite. The records involve customers, partners, vendors, sales orders etc. If a record was found, then it was updated the same(except sales order record) with the info from csv file.

There are several instances of script which have been created to match the client requirement as frequency of csv files that comes from a different system is high. After successful processing of files, it has been moved to a different folder to "Success folder" or a "Failed folder", if failed during processing. Another instance of script looks into the failed folder to process those files.

Work order Suitelet Workflow and PDF

When any item is updated, its base price gets updated by using Item and its child items field values. Its related Customer record(s) are also updated by adding/updating item(s) and Unit Pricing in Item Pricing sublist of Customer record. When an intermediate item gets updated, its Parent Item(s) also get updated by updating base price after calculation using item and its parent item's field values. When a custom record which is a child record of Customer record gets updated, its Customer record's Item Pricing sublist gets updated by adding/updating Item(s) and its unit price values. In a suitelet form, when a date is selected and submit button is clicked, it will check the selected date depending on various options.

If the date is current, then a list of items with its current price(either base price of item or Unit price in item pricing sublist of Customer record) will be shown in PDF. If selected date is future date, then a List of items with its Future pricing(after calculation) will be shown in PDF.

A option is there to send PDF to a particular mail ID. All these have been done using Scheduled and User Event Scripts. In Work Order record, when a custom button is clicked, it will show a PDF which includes some check boxes, component items(in an sorting order like, the Inventory Items should be shown at first), its Qty, Qty required, Labels, Units, some date fields and some labels in header and footer.


NetSuite Currency Converter Scripts

Client:
NetSuite ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

This NetSuite application we created handled the pricing of items, sales channel, exchange currency, exchange rate and shipping lists. Some events had to capture item record, custom records to trigger the script to update pricing. Also some scheduled scripts had to be developed which run at scheduled time on each day at specific time intervals. 

The app handled four different currencies (US currency, UK currency, AUS currency, Canada currency) based on the current exchange rate.


Netsuite Customization - Custom Price List PDF

Client:
NetSuite ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

This application deals with the list of Customer Price List PDF. Suitescript will be triggered on click a custom button of Customer to generate a PDF.

Based on the 'Market Segment' (custom field in Item record) of Customer, it will identify all the items under the same category and Items in Customer Item Pricing tab. Every information is gathered (headers, logo, item price, description, etc.) and  Price List PDF of Customer was generated.


Sales Order

Client:
NetSuite ISV
Industry:
NetSuite ISV
Technologies:
NetSuite, Suitelet, Suitescripts

This application allow authorized items for selected customer in sales order. When user adds any Item on sales order, then it will verify whether  the item is authorized for selected customer or not. Based on 'Market Segment' (custom field in Item record) of customer, it will fetch all the items under the same category and items in Customer Item Pricing tab.

The selected item in Sales Order should be present in that above item list, otherwise it will not allow to add that Item.


Performance Enhancement with Restlet Conversion

Client:
Energy Company
Industry:
Energy, NetSuite users
Technologies:
NetSuite, Suitelet, Suitescripts, Restlet

This app had two modules SalesOrder module and Shipping Module. In Salesorder module created 4 salesorder RESTlets where salesorder record is either created or update using the data provided from the app. Also customer and contact records are updated or created whenever required. NSInsertSalesOrder_Mfs hence create a single salesorder record using the data provided from the app. And NSUpdateSalesOrder_Mfs updates a single salesorder record using the data provided from the app. Create Multiple SalesOrder Mfs takes a list of salesorders and create them. Update Multiple Sales Order Mf takes a list of salesorders and update them. After creation/updation of the salesorder record , the bill to customer's entity status is restored to the state it was there before the creation of the salesorder record.  

Each of these RESTlet return the following 3 data for a salesorder back to the  app(a list in case of multiple salesorder RESTlets) which include Salesorder Internal Id, Salesorder Transaction Id and New ShipTo Customer Entity Id (if a new customer record if created).

In Shipping Module, Restlet Name is´Ship Sales Order Mfs' where a salesorder record is checked if it has any item backorders. If no backorder, an item fulfillment record is created for that salesorder and some of the fields of salesorder records are updated. It returns a boolean value representing the success status of item fulfillment creation and error message, if any occurs.


Work Order Release System

Client:
Heavy Machines
Industry:
Heavy Machines
Technologies:
NetSuite, Suitlet, Sheduled Scripts

This app deals with frequent coordination and communication with accounting and sales to address credit issues and build priorities. The production team can only produce what is open and must complete those open work orders before more production can occur. Operations are date specific so any new work gets pushed to the next day.

Increased data entry requirements by key personnel - managers are spending an exorbitant amount of time entering work orders and inventory builds because NS does not create them. Data integrity deals with increased date entry leads to more data entry situations. And NS cannot allocate stock inventory first and create the work order for the remaining quantity.

To identify the pool of potential work orders, look at all items on an order that are assemblies that are not fully committed and do not have a work order number. From this pool, assume that they will be produced If raw materials exist (it will ship complete) - then, look back at the order and now determine the inventory threshold. The proposed Work Order Release System will be a user initiated process in NetSuite that will apply the defined rules to the pool of open orders and as a result, assign an order status in NetSuite, namely: Hold product, Hold Credit, Hold Cancel, shipping and production.

We have created a user form (Netsuite Suitelet) for the users of the account with fields to fill up inventory threshold, dollar threshold  and on clicking the "Submit" button, work order release system will be processed accordingly. This script includes a lot of business rules which are mostly dependent upon the threshold values given by user.


Builders App

Client:
Constructions
Industry:
Constructions
Technologies:
CRM2011

A Web-Resource was developed to interact with the CRM database and populate the contact activities on the account form. A settings interface was developed which enabled user to

- Add columns to the grid
- Modify the sequence of the column header
- Change the header text for the columns
- Sort the grid by a corresponding column
GRID Settings Form:

– Grid Setting form allows the users to Add, Edit, Remove and Sort the columns.
– Grid Setting form also allows the users to change the Column Header.


Info Integration between NetSuite Sites

Client:
ISV
Industry:
Netsuite ISV
Technologies:
NetSuite Suitescript, NetSuite Customization

To design a solution to capture the customers who are using his websites(client provides medical facilities to people in US). We have designed an online form with fields related to personal information, address details, working status, social information and to upload document if any etc. Online users/customers need to fill up this form when they want to avail any medical facilities and when submitted, an employee record will be created in netsuite account.

These employee records can be used by the supplier to follow up customers/users with email, phone call etc. Client has 3 different websites running inside one netsuite one world account. We have done this solution for 2 websites. So when online form is submitted from either websites, employee will be created in respective subsidiary account.

This form we have integrated to the client's website content manager so user can feel it as part of website page.


Roof safety Application

Industry:
Service Providers for Roof Safety
Technologies:
MSD CRM Online, SSRS

The requirement was to develop a custom report for Quotes and its associated products. With the existing process, they were finding it difficult to generate a report through the mail merge templates and as a result of which they were looking for some alternate solutions.

The reports are invoked both from the homepage grid and entity forms which are then converted to pdfs/docx files.


Automation of Inventory Details in NetSuite

Client:
ISV
Industry:
ISV
Technologies:
NetSuite, Suitlet, Suitescript 

We developed an application to automate updating the inventory details in Netsuite. The "Inventory Details" of sub record's data from work order screen gets populated in body "Inventory Details" sub record when user builds the work order.

This involves getting sublist item details from Inventory Details sub record of Work Order record such as Serial/Lot Numbered Items, Expiry Date & Quantity component from assembly item for each sublist item and calculates to get the total quantity needed for inventory details record.


Sales Order record Packages

Client:
ISV
Industry:
ISV
Technologies:
NetSuite, Suitelet, Suitescripts

This project is to enter multiple items under one package in a Sales Order record by replacing the previously entered items in the Item sublist. The selection of items will be undergone different steps to choose particular items according to user.

First of all the "Order Menu" button is added in the Custom Action in Customized form of Sales Order record, which will be shown in the Sales Order "Edit" record page. When the Button is clicked, another client script gets executed which gets the Sales Order record info like the internal id, order status, number of items present in that sales order up to now and many more.

After getting all those information it calls a suitelet script with setting the above information as per the parameters. The script is responsible to create an assistant in a new pop up window. An Assistant can select a package, products, subproducts, items and their details. When you select a package a group of radio buttons will be shown with all packages options, where user has to choose any one of them. After selecting any one package, user needs to click the Next button to go to next step of Assistant. At each step user will be provided a button called "Cancel", by clicking this user will be redirected to Home page of Netsuite account.

After selecting a product, user will be given different product as check boxes under that selected Package where user can select any products. User also has to enter value for Quantity and RTB fields.

After selecting any one package, user needs to click the Next button to go to next step of Assistant.

On selecting sub products a user will be provided with different sub products as radio buttons where user needs to select only one in each group.        

After selecting items, user will be provided with different items of each product. All items will be in a multi-select field for each product. User may choose more than one items for each products, but at least one item of each product. User will be provided a list view of all selected items with its quantity, rate and other details. User can change/remove any item details/item. After finalize all items, user needs to click "Finish" button, then a user friendly message will be shown in the assistant window and after sometime the Assistant window will be closed.

Then all the selected items will be populated in parent Sales Order record of that Assistant with all details by replacing the previously selected items before going through the Assistance. So by this way user is able to select multiple Items for some particular package simultaneously.


Certificate Printing in NetSuite

Client:
NetSuite ISV
Industry:
NetSuite ISV
Technologies:
Suitelet. Suitescripts 

When "Print Certificate" button will be clicked from a transaction record, it gets all the information regarding Line Item, Inventory Details sub record information. Then creates a PDF called certificate of compliance with all required information each page contains each Lot Number information.

When Print Label button will be clicked, a suitelet page will be opened with, Assembly Build Number, Item, Lot Number Information, Sales Order Drop down, PO# and Default Package Quantity text box, when user needs to enter No. of packages to be in one label and two buttons called Print Label and Refresh.

By entering any number in Default Package Quantity and clicking Refresh button, number of Labels, number of packages for each label for each Lot Number will be calculated and populated in respected field.

When the Print Label button clicked, the PDF report will be generated for each Lot Number with number of pages equal to number of label.


Customizations in Netsuite

Industry:
IT
Technologies:
Netsuite

We have implemented some scripts for customizations in Netsuite account and generated some reports (pdf, csv format) via the application. This includes Netsuite client scripts, user event scripts, suitelet, scheduled scripts.

1. CheckForDropShipmentItem.js - Script type: - User-event and Client, Purpose :- This script is used in Client (at 'Save Record Function' for Sales Order record.) and User-Event scripts (on After Submit function for Purchase Order record). Client script is used to check all items' created po field value, and according to that, shows alert to the user. User-event script is used to populate 'PO ship to' address of PO record, according to particular SO record.

2. SalesRepReport.js - Script type: - Suitelet, Purpose: - Suitelet script to generate monthly or yearly Sales Activity Report (according to selected month/year in Suitelet form).

3. GetCurrentMonthReportInMail.js - Script type: - Schedule, Purpose :- Schedule script to create PDF file of Sales Activity report for current month and send mail to particular employee(s).

4. SetSOStatus.js- Script type: - User-Event, Purpose: - This script is used to set the status of a particular SO record.

5. ShowAlertForExistingPO.js - Script type: - Client, Purpose: - This script is used in 'Save Record Function' of Client script. This script is used to show a confirm box (message) when PO field value is existed for selected Customer in SO record.

6. SetShippingCarrierOfCustomers.js - Script type: - Schedule and User-Event, Purpose: - This script is used for Schedule script (for existing customers) and User-Event (for new Customer) to set Shipping Carrier field value of Customer record.

7. GetCSVReport.js - Script type: - Suitelet, Purpose: - Suitelet script to generate monthly or yearly Sales Activity Report in CSV file format (according to selected month/year in Suitelet form).


Netsuite website cutomization

Client:
NetSuite ISV
Industry:
eCommerce
Technologies:
NetSuite, Suitelet, Suitescript, HTML, CSS

This website deals with business to business between companies. We have worked on the following functions:

B2B (Business to Business) site

1. Enable ordering from grid for non-matrix items (select qty and then add to cart).
2. Enable ordering from grid for matrix items (e.g. apparel sizes, select quantity for each size variation add all matrix items to cart).

B2C (Business to Consumer) site

3. Extend grid ordering capability for non-matrix items.
4. Disallowing B2B-registered buyers from buying on B2C site.

5. Add/ Remove categories from top bar and left panel in B2B site.
6. Expand sub-categories in the left panel in B2B site.
7. Implement shipping estimator feature in B2C.


Serial Number Lookup

Industry:
Traffic/Transport
Technologies:
Netsuite, Suitelet, Suitescripts, Restlets

A suitelet script is implemented which will be used to give visibility into serial number records and what the unit/component has been through. The serial number record will provide a snapshot of any serialized components history. Here, first the user is allowed to enter the serial number to be searched and if that serial number is present in more than one Inventory number record then a list is shown where the user can select the inventory number with which he wants to continue the lookup search. Then it displays the snapshot of all the related records which uses that serial number.


Localization In Customer Statements

Industry:
Traffic/Transport
Technologies:
Netsuite, Suitelet, Suitescripts, Restlets

Localization was needed in the Customer Statements (an existing suitelet script which generated the statement for a customer on a periodic basis) as per the language specified for that customer in NetSuite. So, a mechanism was implemented in the project which included some resource files based on language and these resource files were then parsed into the XLST file (which contained the statement's layout). Also, a lot of changes were done to the script to adapt this requirement.


Change Billing Period In Billing Scripts

Industry:
Traffic/Transport
Technologies:
Netsuite, Suitelet, Suitescripts, Restlets

The billing period which was implemented in all the billing scripts was earlier set to start and end of the month but later was changed to 25th of previous month to 24th of this month. This required a lot of careful changes to the billing scripts. Also a lot of changes were done to the billing script including the customer statement.


Unit Testing For Billing Scripts

Industry:
Traffic/Transport
Technologies:
Netsuite, Suitelet, Suitescripts, Restlets

Unit testing methods were added for the billing scripts and few of the library scripts which were affected during the above billing period change refactoring process. There was already a unit testing framework present in this script, which we had modified to add unit test cases for the billing scripts.


QuickBooks File Merge

Client:
ISV
Industry:
ISV
Technologies:
Quickbooks, .NET, C#

There are 3 QB files (LA, SAC, NY) located in 3 cities in US, and there is a front end web application which is interacting with these 3 QB files on daily basis. The entity manager application pushes the Invoices, Payments, Bills, Checks, Bill-Payment Checks, Journal entries to the QB files separately. All records are created based on the city, location.

Requirement was to merge all 3 QB files and prepare a master file so that entity manager application will interact with only 1 QB file. Also all accounting entries had to be categorized based on location. This will help accounting people to identify the records, payments based on location in master file. So we had to use "class" in all 3 QB files. We created 3 classes 1. CCS(LA) for LA file 2. CCS(SAC) for SAC file 3. CCS(NY) for NY file and updated all accounting entries with the class respectively.

Then we had to merge all 3 QB files using 3rd party tool. Records merged during the process were Invoices, Payments, Bills, Checks, Bill-Payment Checks, Journal entries, Customers, Employees, Vendors, Items, Templates for all forms used for records etc. Finally we delivered a master file with all data from 3 QB files with "class" updated in accounting entries.


News & Updates

  • January 17

    DDM IT Quiz, Inspired by Mindfire, is Spreading its Wings!

  • December 16

    Santa in a different Avatar- International vacations gifted to All Mindfireans!

Let us Connect!

Related Pages

  • Our Netsuite Skills
  • Our ASP.Net Skills

Awards and Achievements

Red Herringcolor DeloitteFast50 DB ZInnov1   Nascome  DB Stpi

This site uses cookies. We respect your privacy.copyright (c) Mindfire Solutions 2007-2018. Login