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

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®.

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.

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.

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.

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.

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.

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)

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.

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.

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.

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.

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. 

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.

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).

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.

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.

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.

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.

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.