Projects

PROJECT OVERVIEW


Sapient NetSuite projects often have a good balance of configuration and customisation tasks, helped greatly by NetSuite's flexibility and technology stack.


Sapient have recently carried out a series of complex projects for the Zoopla Property Group (ZPG), London and Global Student Accommodation, Dubai.  These investments have seen the Accounts Receivable (Order To Cash process) module of NetSuite enhanced considerably.  Allowing buinses units and country operations use a common set of worldwide processes across AP, AR and GL.

Sapient use a flexible set of methodologies that are 'cherry picked' from the best parts of Prince 2 and Agile. By being flexible it is more appealing to stakeholders that do not wish to have their hands tied by bureaucracy, meaning the project control can be tailored and targeted.


It's rewarding to see client teams motivated, by making a valued contribution.  NetSuite lends itself to quickly showing users how the system can be configured and enhanced to provide quick returns for eager minds and itchy fingers.

Here is just one project LinkedIN recommendation "I have worked with Chris for 2 years on a number of projects integrating businesses into NetSuite finance system. He has great knowledge of the platform & excellent project management skills. He takes the time to fully understand the needs of the business & what is required. The technical specifications Chris puts together are detailed & to the point. He is great to work with & goes above & beyond to achieve what is required & delivers deadlines"

PROJECT DETAILS

 

When a website will take a large volume of online worldwide bookings then digesting these sales through to an automated NetSuite backend 'Order To Cash' process, requires careful technical design on how best to configure and enhance NetSuite.

 

A recent Sapient project saw the need to connect NetSuite via a custom set of API RestLet events, allowing a Worldwide online bookings platform to function for Students looking for Accommodation.

The booking platform will see students selecting a bed within a series of worldwide properties, all within close proximity to universities.  Once the booking is confirmed then via set of hand-built API's the data will pass Realtime to NetSuite at the backend. Through a set of carefully crafted designed NetSuite scripts the data digestion will create in the correct sequence NetSuite Customers, Sales Order, Invoices, Customer Payments, Credit Memos and Refunds.

The student can and will change their mind, when in residence and these booking amendments need to be managed back into NetSuite.  The results can be a cancelled Sales Orders, voided invoices, un-applying of payments, raising of Covid credits and in some instances providing refunds.  NetSuite allows the business structure to be represented via Subsidiaries, Locations, Classes, Custom segments, providing a single unified worldwide NOI report.

PROJECT DETAILS

 

When processing volumes are high and timescales tight, then it takes a technical re-think on how best to configure and enhance NetSuite.

 

A recent Sapient project saw the need to process and send out, via email, over 10,000 monthly pdf invoices.  These invoices had a pro-rate calculation element based on start and end dates.  There was a need to consolidate the invoice lines by department and class, due to there been over 1000 lines per invoice.  NetSuite has a 1000 line limit.  A view of the invoice prior to consolidation was needed to support credit control enquiries.

By using suitecloud plus licences and Datacenter Premium Tiers (Tier 3, Tier 2 and Tier 1) the solution could be given greater processing band width.  This was crucial to bring down the processing times from an estimate of 5 days to just 6 hours of processing, meaning that bills dated today could be sent out that night via email.

By using Report 360 it means that a pdf view of the invoice, prior to consolidation, can be prepared and attached to the invoice transaction.  This means the 1000 line limit has been overcome and the online invoice transaction is now more easily viewable in say 12 lines rather than over 1000.  A win-win for everyone.

PROJECT DETAILS

 

There are very few worldwide projects where NetSuite has been used in Pharmaceuticals.


A recent Sapient project saw us actively involved in designing for a start-up clinical trials therapeutics pharmaceutical business a supply chain process, involving out-sourcing.

The materials for the injectable product are purchased and sent to many distributed inventory locations.  The material once approved are sent via transfer orders to the manufacturing out-sourced plants.  Once the materials are inspected then they can be managed by works orders, where issuing and back flush consumption can take place across the manufacturing process to produce the finished product.   Through a further series of transfer orders and distribution networks the supply chain process sees the product pass to vial filling organisation.  The finished quantity during the main manufacturing injectable process can see a yield that is variable in many dimensions.  This is a challenge for any automated computer process.

The clinical trial recruits are then sent the injectable product ready for treatment.

 

Sapient with 16 years of Pharma Computer Systems Validation/GAMP experience are equipped to manage such a challenging project

 

NetSuite's latest Manufacturing and Supply Chain modules are used throughout the process.  NetSuite have significantly enhanced their solution, Sapient were able to combine inventory locations and item supply chain planning, with Distribution Networks, Bills of Material, Demand Planning, new little MRP 'playpen' planning for material planners, and shop floor automation.  A comprehensive SCP process from demand, to item supply plans, to buying, distribution, making, and finally selling is now ready for implementation.

PROJECT DETAILS


NetSuite 'out of the box' does not offer a volume Direct Debit (DD) processing solution, there are limits that need to be overcome to have one continuous process that does not contain multiple bank files.  Having a solution that can collect millions of pounds in one robust process is key to building user confidence and managing cash flow.


The project challenge reached over 8000+ customers that required a single DD collection, on a specific date, to meet bank DD regulations, time to put on the Sapient thinking cap.  There are often other external websites involved when you consider validating bank details (Auddis) and PT-X Bacs for automated bank processing of files.  Remember as well there maybe DD rejections, when the money is not available in the business bank account.  A procedure to deal with rejections is key, to allow follow up and swift debt collection.

Again, suitecloud plus licences can help here to speed up the processing time and create over 8000+ DD payment transactions. When DD file before and after reconciliations are required for audit purposes then this does offer up some careful technical solution consultancy.

Often the customer has several invoices to collect in one single payment.  Here save searches at detailed and summary levels can help create a UI, supported by suitescript that can allow swapping between levels, providing a great user experience.