Untitled-2

Shipping Integration

In a world where efficiency is a key factor for the success and profitability of a business Keystone Data developed the perfect product to save time and effort. With just one click you will be able to send all the delivery details to your selected carrier and at the same time get back the tracking number assigned to that delivery.

Untitled-2At the point of shipping the order in NetSuite a script will send the shipment details to the carrier. Once the details are in, the carrier will send back the tracking number which will then be displayed on the dispatch e-mail and on the item fulfilment. Also carrier shipping labels will be automatically printed. Say goodbye to manually inputting the delivery details for each order.

Benefits:

  1. The product will speed up the shipment process and make it more efficient.
  2. The client has access to his tracking number withing seconds from the shipment of his order.
  3. Automatic printing of shipping labels for the desired carrier.
  4. Frees up human resources.

 

We encourage you to contact us and get a taste of this product which will change the way you ship items and it will give your business more freedom.

Have a great day!

 

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.

Untitled

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

 

Hope this helps, Have a nice day!

KeyStone Data

 

 

 

images

NetSuite – Aftership Integration

NetSuite as standard is integrated with UPS and FedEx. Also as a NetSuite partner we regularly integrate with other carries such TNT, The Post Office and Parcel Force for our clients.

These integrations allow us to automatically generate carrier labels when goods are scanned out of warehouse and pull tracking no. back into NetSuite. However in order to provide an excellent level of customer service we need to be able to update our customer at any moment in time on where exactly is their order. For example we ship one pencil and we get a tracking no. which we then use to interrogate our carrier website to get the details that we need.

One way of doing this is to create a script in NetSuite for each carrier, or you could use AfterShip www.aftership.com app which will do this for you, thus you will only need to create one NetSuite script which links NetSuite to AfterShip. The result is that you reduce the number of scripts that you have to create/to run in order to have access to all your tracking no. independent of the carrier.

unt

 

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

 

Screenshot_1

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.

img

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.

Screenshot_1

 

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!

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.

keystonedata-reg

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.

 

bladez toyz tile

Bladez Toyz go live

In November 2014 Bladez Toyz signed with Keystone Data to implement NetSuite. The functions included: Accounting, Sales Processing, Purchase Order Processing, Drop Shipping, Stock Control and Electronic Data Interchange (EDI) integration.
By working closely together over about three months (including the Christmas period) we were able to go live before the end of January 2015.

official-bladez-toyz-logo

Another new NetSuite project

We are delighted to have won another project to implement NetSuite for a company in Portsmouth that designs, manufactures and supplies toys.

The implementation will replace existing accounting, order to cash and procure to pay processes in one integrated solution. Work has already commenced on the project and and plan to complete within three months.