kit components

Kit Components Tree

Hello Everyone!

We’ve just developed a new way of looking at your KIT components in a more user friendly manner.

As you can see in the picture below KIT5 is made of KIT1 which is made of inventory items INVN-1 and INVN-2. In a simple scenario where a KIT is made only of inventory items you could easily find and access them from the item tab. In a complex case where your KIT is made of multiple KITS which in turn are made of multiple items you would have to dig different levels and open many tabs to be able to access the information and then use the information to create a complete list of the components.

Luckily, we at KeyStone Data developed a custom high level visual map which is available at the KIT level and lets you navigate through all the components of your KIT. The way we do this is through an IFRAME which access a SUITELET. The SUITELET finds out the children of your particular KIT and returns it in a HTML format.


If you are interested about this bundle please give us a shout.


Hope this helps, Have a nice day!

KeyStone Data





Netsuite Available Kit Quantity

Hello people of NETSUITE land!

Today’s issue that we at Keystone Data tackled was to have the available kit quantity easily accessible for internal (client access-backend) and external(available on website-fronend) purposes. For example we need to calculate the available KIT A quantity which consists of 1 inventory ITEM GREEN,  1 YELLOW and 1 ORANGE each with their respective quantities.


In the above example the quantity for KIT A should be 2 because we only have 2 YELLOW items, thus we can only create 2 KITs. Another important step is to make that quantity easily accessible.

Our first solution is just a simple three steps process.

1.Create a customised item field (ex: Available KIT quantity) which will be available to all the KITs created by our customer.



2.Write a scheduled script which will calculate the available KIT quantity based on its components quantities.

3.Make the script post into the customised field created at step 1.

This way the user can see the available quantity at all times at the kit level and also can use the field as a transaction column.


The Second solution is just to create a saved search which returns the available quantity for each kit item.


Depending on your preference and client needs you can opt for one or the other.

If you need more clarification don’t hesitate to contact us, thank you everyone and have a nice day!

Keystone Data out!


Work Order Withdrawals – Putting stock back into NetSuite

Standard NetSuite functionality does now allow over-allocated items in a work order to be returned back into stock. We recently developed a solution for one of our clients to bring items back into stock. This functionality is available after a work order has been saved:




Component 1 of this work order was over-allocated; the work order required a quantity of 10 of component 1, but the pack is only available in quantity of 20’s, thus we will bring back 10 of component 1.





Notice that component 1 was initially picked from 2 bin locations. The ‘returned to bin’ field contains the bin number that the components were removed from, thus we can return some of component 1 to one bin and to another bin.

When entering the returned quantity, notice the check box ticks automatically.




Click save on the work order withdrawal. At this point, an inventory adjustment is posted. The work order withdrawal status remains at ‘pending’ until the work order is closed. The account postings shown on the lines tab do not post until the work order withdrawal status is complete.






Clicking on the ‘inventory adjustment’ brings up the standard inventory adjustment functionality in NetSuite. This screen cannot be edited to remove the risk of the work order withdrawal and inventory adjustment quantities being changed separately. To adjust the inventory adjustment, the work order withdrawal amounts must be edited.




Back on the Work Order, related Work Order Withdrawals can be found on the related records tab:




When work order is closed, the work order withdrawal is posted to the WIP account. If you’d like to find out more about this feature, please do not hesitate to contact us:

Eassy Composites

Easy Composites go live

Easy Composites, the Stoke-based supplier of a huge range of advanced composite materials with associated services to businesses and end users has gone live with its NetSuite implementation project.

This project included the using our JCatalogue product to re-site their website integrated with NetSuite and customisation functions.

The customization included a range of tailored user interfaces in the warehouse and customized dashboard information. Because Easy Composites supply products that fall under the Dangerous Goods Act we also included customizations to auto calculate suitable packaging for orders containing dangerous goods and auto generates highly accurate Dangerous Goods notes and Commercial Invoices.


Three new clients

Over the last few months we have won business with three new clients.


Lloyd & Barnes based in Cwmbran are an insurance advisor for whom we are developing a front end to NetSuite to handle their insurance brokerage business.


Thames Distribution based near Reading are a distributor of electronic parts and equipment for whom we have provided a tailored link between their invoices and email.


Abacus Direct based in Harrogate are a manufacturer and distributor of bathroom and heating products who have appointed Keystone Data to redesign and build their websites linking them to their new NetSuite implementation.

wholesale distribution

2015.2 for Wholesale Distributors & Manufacturers

The latest version of NetSuite which will be rolled out to all users in the next few months includes three features specifically targeted to meet the needs of Wholesale Distributors and Manufacturers.

Group Average Costing

Group average costing enables you to track one average cost for an item across multiple locations within a defined group.

Group average costing is available only when you have enabled the Multi-Location Inventory feature. Group average costing is available for inventory items and assembly items.

Each time an inventory related transaction with costing impact is processed for a location costing group member, a group average cost is recalculated. The single average cost is calculated by dividing the total inventory value across locations by the total quantity across all locations. This calculated cost is synced within the group and is used in costing calculations for all locations.

All inventory and assembly items within a location that are assigned the Group Average costing method are included in the location costing group assigned to that location.

If an item is assigned the Group Average costing method, but one or more of its locations are not included in a costing group, then for those locations, the item’s costing method is effectively Average, not Group Average because no grouping calculations are done for those locations.

New procurement dashboard

Whilst NetSuite allows for and provides the tools to allow the creation of any role with specific authorities and a user designed dashboard it is more straightforward requiring less thought or work to use ‘out-of-the-box’ roles and dashboards.

This dashboard gives KPIs, reminders, reports and searches specific to procurement, allowing a procurement manager to then drill down into any areas causing concern or requiring action. Examples of what are provided: vendors’ on-time delivery performance or reminders when purchase contracts get close to expiration.

Simpler requisitions for dealing with preferred vendors


The order requisitions page will now be populated with all pre-approved vendor contracts with associated pricing to enable a buyer to select the best vendor for any one order. For an item that does not have a preferred vendor, alternative items can be shown that do have a preferred vendor to ensure that a buyer always has the information available to purchase the most cost-effective item.

Order Requisition Enhancements

Previously, the Order Requisitions page grouped requisition lines on a purchase order based on all requisition lines having the same transaction date.

Now, on the Order Requisitions page, you can add multiple order lines to a purchase order regardless of the entry date or expected receipt date. The number of lines consolidated onto a single purchase order is limited only by the maximum identified in the Maximum Requisition Lines to Consolidate preference.

Improved warranty and repair

NetSuite now support the processing of warranties associated with items sold through indirect channels. Previously this was only possible through a third party product or bespoke addition to NetSuite. Information about warranty registrations can be added either manually or via an import feature.

The process of managing warranties has also been simplified in terms of both finding a warranty quickly and entering it, reducing the need to re-enter information.



Another New NetSuite implementation project

dangerous goodsWe are delighted to have recently signed another NetSuite implementation project for a company based in Stoke on Trent that supplies a range of advanced composite materials to consumers, businesses and other organisations. This project includes introducing new processes throughout the organisation, developing various specific warehousing and shipping features to suit the dangerous materials industry fully integrated into NetSuite and re-implementing their web site to be fully integrated with NetSuite.

It is expected to take three to five months to complete and we should be able to announce the client’s name once the initial phase is successfully implemented.

We are very excited to be running such a project and developing our knowledge in the dangerous goods area.