Our SuiteSolution Intercompany Pack within NetSuite
December 05 2022
Novupack Intercompany Solutions
BackgroundTo facilitate the entry of intercompany invoices and bills, Novutech has set up a package called "Intercompany Package" which allows you to save precious time. This package is composed of two solutions: - Auto-bill intercompany creation. - Intercompany recharging suitelet. This package answers a NetSuite limitation. Indeed, the only transaction that can be created automatically is a sales order (from a purchase order). Thanks to these two solutions, the automation of the creation of intercompany bills and invoices is now possible and easier.
NetSuite standard solutionThe standard NetSuite system allows you to create a sale order from a purchase order. To do this, simply create an intercompany purchase order. Of course, the user must choose an intercompany item (an item for resale) then go to “Manage Intercompany Sales Orders” On this record, you can select the following information: Intercompany customer, the currency, the transaction date, department, location. The intercompany Purchase Order appear on the list: After selecting all the purchase orders that you want to create sales orders from. You click on Generate Sales Order. The record is then processed: The sales order is generated.
Intercompany Bills & Invoices – Automated FlowA custom solution has been developed for the intercompany process in order to start from the bill directly and to avoid using the standard process of starting from the sales order and purchase order. When creating an invoice, after filling the record and clicking on save, a bill transaction is automatically created. You can find the link to the bill in the field “Paired Intercompany transaction” and the “Intercompany status” passing to “Paired’ as below: The Intercompany Vendor is linked to the Intercompany Customer on the entity record so the bill can be created with the appropriate vendor: The bill is then created using this information and linked to the invoice: The intercompany recharging solution: The intercompany recharging solution is a Novutech creation that automates the creation of intercompany bills and invoices. The goal of this solution is to optimise the time spent on the creation of intercompany transactions. It's very quick and easy to use. To use the recharging solution, you go the page “Intercompany Transactions”: From subsidiary: In this field you can put the intercompany vendor. Memo: In this field, you can put the main memo. Date: Date of the transaction. After clicking on next, you arrive on this page: Here, you must determine the customer subsidiary, the segments you want to populate like the department or the location (Other segments can be added), the intercompany item, the line memo, the currency and the exchange rate. After validating these informations the status passes to “In progress”. That means that the transactions are being created. The status changes to completed and the links to the transaction appear. The two transactions are created with the appropriate segmentation. You can also integrate these transactions using a CSV import.
ConclusionThe Intercompany Novupack offers solutions that facilitate the entry of intercompany invoices and thus exceed the limits set by the NetSuite standard. The intercompany solution offers the ability to :
- Easily create an intercompany bill automatically after creating the invoice.
- Link between the intercompany transactions (Invoice vs Bill).
- Automate the creation of the bills and the invoices using the recharging solution.
- Use CSV imports to integrate the intercompany transactions in mass.
Develop online forms in your NetSuite environment
November 29 2022
BackgroundNetSuite offers its users to create and publish online forms available via an external URL. This feature is mostly used in the context of a marketing/CRM follow-up for example customer satisfaction survey. The information received from the online forms will automatically create or update records in your NetSuite account. This feature is therefore only available for the case, client record or custom record created in NetSuite.
Online Custom Record FormsWe are going to present to you a design that we made. The need was to follow the customer satisfaction, but that at the order level. And not just at the customer level as NetSuite offers for example. Therefore we have created a custom record with the appropriate questions for this satisfaction survey, and the field sales order as record is parent to link the custom record and the SO. We have also added a subtab only to show a sublist concerning this custom record. After that we created our online forms linked to our custom record. We have two possibilities either to create a standard online form or to create an online html form. The standard form allows you to quickly create a NetSuite designed form while the online form allows you to create an HTML form template and a linked form. The HTML form means you can develop your own design with a specific CSS for example. Once the template is created and designed, it is necessary to create the online custom form record linked to this template. It is necessary to add all the fields specified on your template design. It is possible to add a return URL once the form is submitted. When the online form is created the external part of this record will show you some info like the number of times it has been viewed and submitted. And very important in our case the url for the external publication. If we come back to our need expressed above, the solution is to send this URL with the SO id to the customer via email during a satisfaction survey campaign. So that when the customer submits the form, the information submitted is directly linked to the SO concerned. ex : https://”id of NetSuite account”.extforms.NetSuite.com/app/site/crm/externalcustrecordpage.nl?compid=”id of your NetSuite account”&formid=3&h=AAFdikaIeK4ck_TKXYS1Xp4rc-CaoITxrrDs-xVBlyk5MJZBgyg&custrecord_nov_so=”id of your SO” And so we will have all the information submitted on the SO concerned in NetSuite.
ConclusionThe solution offered by NetSuite as standard allows you to quickly develop online forms, however the design is a bit simplistic and not very friendly. On the other hand, the possibility to develop your own html template allows you to assign your own graphic style, but it is necessary to have technical knowledge in order to be able to realize this. All this to show you an example of using this online forms feature offered by NetSuite. So that you can come up with a different design yourself.
Novutech and Oracle training programs
November 07 2022
Novutech and Oracle training programs
BackgroundThis article outlines the valuable partnership that exists between Novutech and Oracle, and the opportunities for Alliance Partner members to undertake training programs offered by Oracle. I also describe how Novutech uses this alliance to invest in their employees by ensuring all members grow with the company to better serve their clients. Finally, I conclude this article by sharing my personal experiences of Novutech’s investment in me, and the opportunity I was given when I undertook one of the training programs.
Novutech and OracleNovutech’s partnership with Oracle can be linked to the established values adopted by our company, and the importance in investing in our employees with “Team First and Talent Development”, and “Excellence” in providing strong professional customer service to our clients. These values are built upon the foundations of internal growth, and as such, we have been recognised as an Official NetSuite Partner and an Alliance Partner with Oracle. By strengthening internal growth, Novutech gives both new and established employees the opportunity to become equipped with the latest tools, knowledge, and methodologies for the efficient administration and implementation of NetSuite. For new employees, the alliance with Oracle allows them to discover NetSuite’s capabilities through a range of different training programs offered to alliance partners, and equally for established employees to build upon their already obtained NetSuite knowledge by undertaking other training programs. One of the major advantages of this alliance includes Novutech employees given the chance to earn NetSuite certifications, and thus provide certified expert advice in implementing efficient NetSuite solutions, and bring added-value to our clients. Investment in Novutechos and SuiteLife Campus Being privy to this alliance, my personal experience in recognising the partnership that exists between the two companies was when I joined the team as a Business Analyst at the end of August 2022. Now an official Novutechos, Novutech recommended that I undertake one of the Oracle NetSuite partner enablement training programs called EMEA SuiteLife Campus, knowing how valuable it would become for new joiners like myself, in gaining an understanding of the core competences of NetSuite and obtaining the basics in Administration and ERP fundamentals. I would be registered for the SuiteLife Campus training program on behalf of Novutech, and the sole member of the Novutech team to have participated in this program. The EMEA SuiteLife program was a six-week virtual training program, facilitated by the team at Oracle, and covered fundamental topics for the implementation and foundational understanding of NetSuite’s core processes. From the beginning of the training program, I would discover how dynamic and powerful NetSuite was at implementing effective business process management, but also the alignment between the methodologies used by Novutech and their alliance partner in Oracle. Whilst I had previous experience in ERP management, I would soon realise the professionalism in NetSuite’s processes, in particular the importance in following guidelines for accounting and tax purposes, and how Novutech consults with clients in making clients aware of their obligations on a financial basis. However, even if Novutech does not offer financial advice, we do have an understanding in efficiently implementing NetSuite to manage our client’s business processes more effectively. The alliance that exists between Novutech and Oracle is greatly strengthened by the active collaboration and constant communication between the assigned Oracle member and the Novutech alliance partner. I would soon become aware that Novutech would do everything they can to ensure that I obtained a successful learning experience from the SuiteLife Campus training program, by communicating with the Oracle member pre-training, during training, and post-training. Continuous Alliance The alliance would not end at the conclusion of the training program, with Novutech employees presented with the opportunity to undertake other training programs offered by Oracle. These opportunities, such as undertaking the training program to become a certified ERP Consultant, is made possible thanks to Novutech’s access to the Oracle NetSuite training programs, offered exclusively to alliance partner members. As such, opportunities in implementing NetSuite are made available to new joiners and current Novutechos, and go as far as providing a sound level of expertise in efficient business processes. A word of thanks Thanks to Novutech for giving me the opportunity to undertake the SuiteLife Campus and for the team at Oracle for facilitating the training program in a virtual environment. As a result, I gained a good understanding of NetSuite’s processes and obtained the knowledge for the Administration and ERP functionalities that would become valuable in implementing the NetSuite application for Novutech’s clients. In short
- Values, Investment, Alliance, Growth, Learning, Collaboration, Communication
- Certified training programs to grow the team’s knowledge
Meet Martin - From intern to employee
October 13 2022
My internship at Novutech
BackgroundLast January, I had the opportunity to join Novutech as a Business Analyst intern. A new and exciting adventure for me that ended last April. But it wasn’t the end of my journey as a Novutechos. I joined the team back in September, this time as a full-time Business Analyst. In this article, I will explain to you my journey at Novutech and why I wanted to come back to this company, to this team.
My internshipIt all started on January 31st. It was the first day of my Master’s internship, and I was excited but also a bit anxious. But this anxiety didn't last for long. From the start, everyone welcomed me as a member of the team and helped me feel comfortable. I found a place where I could work and learn to improve myself everyday. I worked on multiple projects early in my internship, which allowed me to display but also improve my skills. People at Novutech really trusted me to make an impact even if I was still an intern. I had the chance to be responsible for my own projects and to work autonomously on them, which allowed me to grow as a person and as a worker, scheduling the tasks on my own and delivering quality results on time. I also realised during these different projects that Novutech offered me a challenging work environment. Indeed, I discovered that working in the ERP sector means I have to carry out projects for multiple customers in various sectors, which allowed me to work on various aspects of a company’s daily operations. This creates a stimulating work environment where you never stop learning. Despite all that, it can happen to feel a little lost, and it is normal as an intern. That is why each intern and each new joiner has a buddy. My buddy was my reference, the person I could contact when I had a question or if I encountered a problem. Weekly meetings were planned with him to discuss my work, how I was feeling, points of improvement, … but I could contact him at any time. At the end of my internship, I realised that I found a great place to work. I had wonderful colleagues, a challenging and stimulating work environment, autonomy and responsibilities. Of course I wanted to continue the adventure!
From intern to employeeA little over a month ago, I came back to Novutech, this time as a Business Analyst. Thanks to my internship, I was ready to work on customer projects from day one. As I was already autonomous and responsible for my work during my internship, the transition is very smooth. I still have a lot to learn, but I feel comfortable working in this environment. The pathway from intern to employee here at Novutech is a great one, allowing a more comfortable adaptation when leaving university for the working world. Being able to start your first job knowing the people you will be working with and the work you will perform is a great luxury to have!
ConclusionTo summarise, Novutech offers a great pathway from intern to employee. As an intern, I had the autonomy and the responsibilities to grow within a challenging working environment. I also had the time to learn and a great buddy to help me on all aspects of my life as a Novutechos. Therefore, as an employee, I came in a more comfortable way with a smoother adaptation.
- As an intern, I had the opportunity to grow with autonomy and responsibilities, with help from my buddy
- This pathway allows a smooth transition from intern to employee
- Join us!
NetSuite Release 2022.2 Overview
October 11 2022
BackgroundAs part of their goal to consistently optimise their customers’ business operations and further automate their financial processes, NetSuite left nothing to chance and carried out a wide variety of improvements ranging from core accounting activities to banking, inventory management or within SuiteAnalytics. Whether you have already familiarised yourselves with the enhanced functionalities in a Release Preview account or not, the following features selection will give you some insight into NetSuite’s upgraded possibilities and how they will help your company grow.
FunctionalitiesWe tested NetSuite’s 2022.2 new or enhanced features and picked a couple of them that we found interesting for you to discover: 1. Multi-Subsidiary Customer Now Compatible With Consolidated Payments Are you currently using multi-subsidiary customers in your NetSuite account? This feature is made for you. NetSuite 2022.2 provides compatibility between the Multi Subsidiary Customer and Consolidated Payments features. To use these features together, all parent customers must have all subsidiaries of their sub customers. If you sell to customers who have subcustomers, the Consolidated Payments feature gives you the flexibility to accept payment for sub customer invoices from either the top-level customer or from the individual sub customer. 2. New 360 Dashboards NetSuite has promised us some exciting new dashboards on SuiteWorld 2021. It looks like we will be seeing the Cash 360 Dashboard and Project 360 Dashboard in this 2022.2 New Release, as they were postponed in the 2022.1. Those dashboards are really nice-looking and providing some nice insights on your business. Nevertheless, we have spotted the following limitations:
- It only shows data for the subsidiary of the currently logged in user.
- Those dashboards are not customizable.
- Inline Editor Sublist Tooltip When you hover over a cell of a sublist, a tooltip will show the name of the column. In the example below, we hovered over the Units cell and the Units tooltip appeared.
- The title bar on the home page contains a menu button on the left with links to the main resources of SuiteAnswers. On the right side there is the NetSuite status logo which displays the current status of available services. Additionally, there are the Contact Support and global Feedback buttons.
- The homepage contains announcements, featured videos, newly uploaded videos and staff picked videos, and content categories.
- The article view includes an estimated reading time, a list of content that other users found useful, and reworked code samples. The Share button allows you to share an article through a link or by sending an email. The email option supports multiple recipients.
Did you know this?
- Each NetSuite Release actually occurs in four phases from Mid-July until the Mid-October for the .2 Release. You typically would also get an email notification sent to the address(es) configured in your administrative notification settings
- Your Release Preview environment is typically made available about one month before your scheduled upgrade. However, from our experience, you can get it earlier in the release cycle by simply requesting (via Setup >> Company >> Release Preview).
- In addition to requesting a Release Preview (RP) account for your Production account, it is also possible to request a separate Release Preview account for each of your Sandbox accounts.
- Similar to the Sandbox refresh, you can request for a fresh snapshot of your Production data to be pushed to your Release Preview environment.
- The Sandbox environment also gets upgraded but typically not on the same day as Production.
- If your account has already been moved to the Oracle Cloud Infrastructure (OCI), you can actually reschedule the Upgrade if required:
Novutech is there to assist you during every new release cycleIf these features tickled your interest, have a look at the more detailed release notes to learn more about the exciting new updates offered in the new release.
How to build a great onboarding process for new employees?
September 28 2022
The onboarding @NovutechAt Novutech, our common mission is to help our customers leverage their business processes to sustain their growth thanks to NetSuite, a flexible, scalable and robust cloud ERP. To achieve this mission, we keep on welcoming new Novutechos, would they be functional consultants, developers or project managers. Today, we are more than 25 Novutechos, all driven by the same passion: to make our customers and users' lives easier. We strive to deliver professionalism and excellence in an organization where everyone is respected and can express its unique skills. Building a strong and efficient team is the key to our success and is a continuous journey that starts during the first days of our new joiners. At Novutech, we have put in place an onboarding program to welcome our new recruits and establish the foundation of a positive and long-term relationship with our organization. We want to make sure that, from the very beginning of their career at Novutech, every single talent is motivated and feels involved in the development of the company. What better feeling for a new joiner than having an incredible experience during his first days that made him think “Yes! I totally made the right decision by joining Novutech and this is going to be so amazing!” Effective onboarding is more important than ever! At Novutech, we are convinced that the successful onboarding of each new joiner is the basis for increasing our team’s cohesion and our customers’ satisfaction, thereby also benefiting Novutech’s business.
The Onboarding program at NovutechPre-Onboarding - Preparation for onboarding: The onboarding of new Novutechos starts weeks before their arrival. It is one of the key elements for a successful integration. Indeed, one week before the arrival of a new joiner, we inform the team about the new joiner, his roles and responsibilities. Our onboarding approach aims at better preparing the new joiner for a smoother jump into our world, team and company. It consists of the following: First of all, a buddy is assigned to each new joiner. The role of the buddy fulfills some aspects of the onboarding process: deliver organizational knowledge, welcome and integrate new joiners into the company’s culture, provide guidance & assistance for any inquiry type during the new joiner’s first months. Secondly, every team member will have the opportunity to book a 1-to-1 meeting with the new joiner in the course of his first week. The goal is to present one topic around what we do at Novutech to introduce the company and to get to know each other. Orientation - New Employee Welcome We pay particular attention to the first day which might be stressful and a bit overwhelming for the new joiner. For this first day we provide a special welcome and take the time needed to successfully integrate our new talent. For example, by sharing breakfast or organizing a lunch with all the team to celebrate our new joiner’s arrival. One of the co-founders of Novutech will invest time to immerse the new employee into our culture. He will present the company (customers, structure, team,..), its vision, mission and values. Afterwards, the new employee will meet his buddy and receive his IT devices and material but also some nice goodies. The idea is that, at the end of this first day, the new Novutechos should be able to understand the way of working of the company. 1st Week - Introduction to company, people & role The first week is a crucial time to help our new joiner make his start as an employee. This is where we empower our new employee with the ability to think independently and offer the best way to make decisions autonomously. At Novutech, when an employee first starts, their direct manager will organize a meeting to define the roadmap for the next few weeks. This gives the employee a clear idea of their objectives and what we are expecting from him. 3rd Month - Training & Feedback This process can overload a new employee with information that’s why we therefore decided to divide this process into different sessions:
- HR Overview
- Company update
- Knowledge & Expertise (Netsuite Knowledge, Business Processes, Industry knowledge, Accounting & Finance,..)
- Consulting training (Communication & Presentation, Productivity, Time Management, It & Tools,..
- Leadership training (Project Management, Customer Management,..)
Advanced Project Budgets
August 17 2022
BackgroundAdvanced Project Budgets enable you to stay on track with cost and revenue for each project. A work breakdown structure (WBS) separates the work on a project into parts, called work items. You can assign cost and revenue budget values to every work item, save the work breakdown structure and convert it to a budget. The budget version you have saved as the baseline budget can then be compared to actuals in the Budget vs. Actual Report.
PrerequisiteYou need to provision and enable the following feature (Setup>Company>Enable Features>Company>Projects): When enabling “Advanced Project Budgets”, the features “Advanced Project Profitability” and “Activity Codes” are also automatically enabled.
Functional SpecificationWith Advanced Project Budgets, you can:
- Create a work breakdown structure (work items) on your project and assign estimated amounts to cost and revenue. The initial work breakdown structure and its future updates will give birth to different types of budgets: Baseline and Estimate to Complete (EAC).
- See actual amounts from real transactions, which are useful for budget evaluation.
- Compare Baseline VS EAC budgets using native NetSuite reporting.
- Report across multiple projects or customers using activity codes or any other custom segment.
- First step is to create an initial work breakdown structure. To do so, on the project record, go to the “Work Breakdown Structure” tab and click the “New WBS” button:
Note that the “Budget” tab is empty waiting for a work breakdown structure to be created:
2. When accessing the Work Breakdown Structure record, there are a few fields on main level that you can populate:
- Description (1): free form text to describe your budget version
- Margin Target (2): insert the intended margin percentage
- Timeline Type (3): you can select:
- Global: Global timeline type is the default option. There is no date restrictions.
- Monthly: Monthly timeline type lets you select a start and end date of the WBS. You are then able to define a cost and revenue budget for each month.
- Name (4): enter a name for each work item of your work breakdown structure
- Project Task (5): link your work item with a project task from your project’s schedule (1 to 1 relationship)
- ETC Cost (6): enter the estimated cost for this work item on the entire project lifetime. Let’s imagine in this example I have been assigned on the project for an estimated duration of 5 hours at a unit cost of 50€, so my total cost budget is 250€
- ETC Cost: (7): enter the estimated revenue for this work item on the entire project lifetime. Let’s imagine in this example I have been assigned on the project for an estimated duration of 5 hours at a unit price of 100€, so my total revenue budget is 500€
- Once you have saved your work breakdown structure, it is now appearing on the Work Breakdown Structure tab of the project’s record:
- Next step is to set the work breakdown structure as a Baseline Budget:
After you have set the work breakdown structure as Baseline Budget, the Budget tab of the project’s record is now populated:
Note that there 3 different subtabs available:
- EAC Budget: it is currently equal to the baseline budget
- Baseline Budget: this is the budget you have set in the previous step
- Budget History: this gives you all the different budget versions created for the project. You can see that for the moment there is only one budget version and it’s set as both EAC and Baseline budgets:
- After you have set your baseline budget, work can start on the project. You’ll be able to follow up on those actuals and compare them with the budget. Let’s imagine that out of the 5 hours I have been assigned on the project, I have already performed and timesheeted for 3 of them:
- If you foresee deviations from your initial (= baseline) budget (e.g. your customer is asking a change request that will increase your workload) you will need to review and update it to align the figures with the project reality. Let’s imagine the change request is 3 hours of work, so that means my total assignment will be 8 hours instead of 5 hours initially planned and I need to reflect that in the budget the following way:
Then under Actions you need to click on “Create New Budget Version”:
There you can update the Cost and Revenue Budget and set that new version as EAC Budget: Note that under Actions you can also set it as Baseline Budget. You would do that when you realize the initial baseline budget was wrongly set-up and you want to use a new baseline budget as reporting basis. Otherwise all amendments made to the baseline budget due to project’s changes (e.g. change request) should be set up as EAC budgets. After I have hit the button “Set as EAC Budget”, I can go back to the project record to have an overview of budgets history:
I have now 2 budget versions: one which is my baseline budget and another one which is my EAC budget. Be aware that NetSuite will keep history of each new budget version that you create, whether it’s marked as Baseline / EAC budget or not. So for example if you want to create one more budget version to reflect extra changes to the project (1 hour extra work), you can do that starting from the existing EAC budget:
Again I have the possibility to set that new version either as a new EAC budget, either as a new Baseline budget. After I have hit the button “Set as EAC Budget”, I can go back once more to the project’s Budget tab to have the overview of all budget versions: You can create as many budget versions as you wish and set them up as Baseline or EAC budgets.
- Standard Project Profitability Reports have also been updated to include Baseline vs. Actual vs. EAC reports:
Identified Pain Points
- Initial budget has to be created from the “Work Breakdown Structure” tab. All updates after that can be done either through the:
- “Budget” tab: in that case a new project budget record is created for each new update but the work breakdown structure is not updated automatically and is thus not aligned with your latest project budget version.
- “Work Breakdown Structure” tab: you can create new baseline or EAC project budgets through the work breakdown structure record. This guarantees that your work baseline structure is in line with your latest project budget version.
- There is no native Baseline VS EAC budget comparison within the project record. There are 2 distinct subtabs (EAC Budget and Baseline Budget) but no one single view that allows to quickly compare them. Project profitability reports exist (see above) but are outside the project record.
- Project Schedule and Budgets / WBS have to be maintained separately. So all changes that you do on one record need to be manually reflected on the other record, which is obviously time consuming.
August 11 2022
BackgroundI started my studies of Business Engineering at UMons 2014. In 2017, I moved to the Louvain-La-Neuve in the Louvain School of Management in order to realize a Master degree with as Major option “Corporate Social Responsibility”. Nevertheless, I have always felt interested in new technologies. I realized some projects and also my thesis in this area. Actually, it is during my Master degree that I met the wonderful ERP world. It is in January 2020 that I’ve been graduated as Business Engineer at the Louvain School of Management. One month later, I was recruited by Novutech to become a Business Analyst for (at that time) this very small company. But beginning 2020 means also the beginning of the COVID pandemic. Because of this, my arrival in Novutech has been delayed for one month. Indeed, instead of beginning in March, I entered inside Novutech’s family in April. So, it is in April 2020 that I start my journey in Novutech.
Why NovutechLet me make a small parenthesis about “Why I chose Novutech ?”. I was directly attracted by the atmosphere in Novutech. Novutech was indeed composed of dynamic people which were ready to be part of a big project and dedicated to it. I always wanted to be part of this kind of project. As a first job, I wanted to join a project where I was directly involved into and not entering in a big company. I wanted to find a company where I feel as a real member of the team. It means not entering in a too big structure. Novutech was a perfect match with this objective.
Novutech’s JourneyStarting working in the business world during a pandemic was not an easy job for me. Not having the opportunity to meet all my new colleagues except behind a screen was a and also to learn a part of the job on my own. This new way of living was not an easy stuff but fortunately, I was well supported by the other team members and I didn’t feel alone during my beginning. At that time, we were only 6 at Novutech, thanks to this, it helps to rapidly be implicated and also adapt myself to the job. Indeed, it allows me to directly deep dive in concrete projects by doing tasks that get me out of my comfort zone. I had been directly put in contact with client, it was a big challenge for me but it helps me to grow up fast on my way of working and being independent in the job. During my first month, I was put on a complete NetSuite implementation for Medi-Market. This project allows me to discover NetSuite especially Finance flow as it was a project which was mainly finance/accounting based. Thus, this project was a good start to jump into the NetSuite water. After that, I have the opportunity to also be part of a big implementation for our client, Solar Screen. This implementation had a broader scope than Medi-Market. Indeed, in addition to integrate all the finance part of the company, we also should implement the Warehouse Management. In this case, I had been confronted to all the Inventory part of the system. As it was a quite new topics for me, I’d made some trainings to discover those topics. Since those two implementations, I had the opportunity to participate in different projects, implementation and support, in various companies (UnifiedPost, Akkermansia Company, OTA Insight, etc.). Those experiences allow me to take more and more on myself and start leading some projects. More than 2 years after my beginning at Novutech, a long journey has been achieved. I am now a Business Consultant and I had the opportunity to work for big projects but also to take the lead of some of them. During those projects, I was mainly driven by the opportunity learning more about various topics, to have responsibilities, to be totally autonomous on the way of managing my work, etc. Thanks to this dynamic and way of working, I was able to grow up very fast and learn a lot from the Business World.
July 12 2022
BackgroundCross-Subsidiary fulfillment is a NetSuite feature available on OneWorld accounts. Once the functionality is enabled, you will have the possibility to fulfill sales orders and receive returns across multiple subsidiaries. Therefore, an order made in the original subsidiary can be sent to different subsidiary at the moment of the fulfillment. It means that you will be able to fulfill sales orders not only from locations belonging to the original subsidiary but also from all the other locations present in your NetSuite environment. If you encounter a shortage of stock for a certain item in the original transaction subsidiary locations, it will be possible to select a location from another subsidiary where some stock is still available. Moreover, this feature allows you to choose more than one location per transaction. It means that a sales order can be fulfilled from locations in multiple subsidiaries and not only one as it is the case when the Intercompany Cross Subsidiary Fulfillment functionality is not activated. Additionally, the return process is also impacted. You can indeed create a return material authorization (RMA) linked to one subsidiary and receive the transaction lines in multiple locations belonging to other subsidiaries.
Cross-subsidiary fulfillment setupBefore using the cross-subsidiary fulfillment functionalities, you will need to enable a couple of features on your NetSuite environment. To do so, log in to NetSuite with an administrator role (you might be able to do it with another role, depending on its permissions). Then, go to Setup > Company > Enable Features. Under the Items & Inventory subtab, check the Multi-Location Inventory and Intercompany Cross-subsidiary Fulfillment boxes. Note: we advise you to make this setup in a Sandbox/demo environment first. Then, specify the Global Inventory Relationships (Lists > Supply Chain > Global Inventory Relationship). Global Inventory relationships are rules that automatically select the locations items should ship from. On the sales order, the cross-subsidiary fulfillment feature will make available two new fields on the item lines:
- Inventory Location
- Inventory Subsidiary
Cross-subsidiary fulfillment walkthroughThe first step is to create a Sales Order (Transactions > Sales > Enter Sales Orders). In this example, we are using a customer belonging to the United Kingdom subsidiary. As you can notice, there is no inventory available in the location (London) for the item in question. Therefore, you need to find another location where the item is available. The cross-subsidiary fulfillment feature allows us to choose a location (Dublin) belonging to another subsidiary (Ireland). Now that you have a sales order with available inventory, you can fulfill the sales order (click on the Fulfill button). On the Item fulfillment generation page, review the relevant information and select the items you wish to fulfill. Then, click Save. Looking at the GL impact on the item fulfillment, you will notice that NetSuite debits the cost of goods sold and credits the inventory. The cost of goods sold are recognized on the subsidiary where the order ships from and not on the subsidiary where the subsidiary was originally placed. After fulfilling the order, you will be able to bill it (click on the bill remaining button on the sales order). Note that the invoice takes place on the original subsidiary and location. Review the information on the invoice and save it. Looking at the GL impact on the invoice, you will see that the trade debtors account is debited and the revenue account is credited. If any VAT was set up, the VAT account will be credited.
Cross-Subsidiary ChargesYou now have revenues in the subsidiary (United Kingdom) where the sale order was placed and costs in the subsidiary where the goods were shipped from (Dublin). Therefore, intercompany cross charges take place. To use the standard intercompany cross charges functionality, go to Transactions > Financial > Manage Intercompany Cross Charges. You will then see the list of transactions ready to be cross charged. You will have the opportunity to generate those using the Generate Transactions button. Once your Cross Charge Workbench is empty, go to your journal list (Transactions > Financial > Make Journal Entries) and find the cross charge journals (Filter the Type to Cross Charge Journal). Note that one cross charge journal per subsidiary involved in the transaction is created. One the one hand, a cross charge journal will be created to recognize revenues in the subsidiary that fulfilled the sales order. One the other hand, a journal will be generated to recognize costs in the invoicing subsidiary. The Cross Charges Workbench is a standard Cross Charges NetSuite process that generates Journal entries for the recognition of intercompany costs and revenues. At Novutech, we can build customized cross charging processes (created via scripts) that generate intercompany invoices and bills. If you wish to recognize cross charges directly on invoices and bills instead of journal entries, do not hesitate to reach out to us. Note: before using the intercompany cross charges, you should set up the NetSuite intercompany features.
ConclusionThe Cross-subsidiary fulfillment feature enables your NetSuite account to handle sales orders and returns across multiple subsidiaries. In other words, you will not be limited to fulfill your sales orders from a location belonging to the originating order subsidiary. Regarding the recognition of your intercompany cross charges, Novutech offers the possibility to customize your process according to your needs. Do not hesitate to reach out to us and visit our website (https://www.novutech.com/) for more information.
- You will have the opportunity to fulfill sales orders and order returns across multiple subsidiaries.
- Novutech offers a custom-made process to recharge, via a set of predefined rules, the right amounts from one subsidiary to another one with intercompany bills and intercompany invoices (and not cross charge journal entries, as the standard functionalities would do).
ERP Implementation Methodology by Novutech
May 31 2022
A decisive strategic decisionImplementing a new ERP is an important decision that will have a huge impact on your organisation in the long term. Whether you make that strategic decision to stimulate the growth of your business and introduce more structure into your processes or to support your already scaling company, you want to make sure to leverage all the benefits of your new ERP and get the most out of your investment. This is why you need to select an implementation partner that understands your needs, has your best interests in mind, and has the required expertise to tailor your environment according to your business processes. If you go for NetSuite, Novutech can be that trusted partner you are looking for. Why? Thanks to our team of experienced consultants and the proven implementation approach we follow for each one of our projects.
Novutech, the partner of choice for your NetSuite implementation projectThe experience When choosing Novutech, you are actually choosing a diverse and experienced team which is able to understand your needs, challenge your processes, and design the best solutions to streamline your operations and boost your business. Currently, our team can rely on 17 functional consultants, with up to 10 years of NetSuite experience in almost all business areas, 5 technical consultants well versed in suitescripts, integrations, and other plug-ins, 1 expert accountant who will resolve any of your localisation issues, and a vast network of trusted partners who make it possible to optimise your NetSuite environment even further. The values Beside our functional and technical experience with NetSuite, we make a point of being fully transparent and building a strong and trusting relationship with our customers. During your project with us, here is what you can expect :
- A focus on a ready-to-go implementation, based on NetSuite’s proven and sound standard capabilities.
- Being challenged to follow NetSuite best practices, based on both NetSuite’s standard design and our own experience resulting from our 20+ implementations in the last 3 years.
- A constant and completely transparent communication throughout the whole project. We will not sugarcoat any obstacles and will always advise you the best we can in order to make sure you reach your objectives and even surpass them.
- Regular status reports and updates about timelines, risks and impacts.
- A lot of flexibility, not only in our services (consulting services, project management, training and support), but also in NetSuite (customisations, add-ons, integrations).
- Architect We organise workshops with your teams in order to dive into your operations and daily activities. We gather all the necessary information in a design document which we continuously amend with you in order to scope the project precisely and sign off on a final architecture.
- Configure and Prototype Based on the workshops and the design document, we build a series of prototypes in a test environment, which we put to the test with your teams to ensure they allow all employees to perform their daily tasks in the most optimal and accurate way. When the final prototype stands the test of process owners, we deploy it in the live environment and prepare for go-live.
The right people for the right jobIn this day and age, implementing an ERP is a necessary step for any company that wants to survive and scale. This is such an important aspect of your growth, and which can prove very costly and painful if done incorrectly, that you need to partner with people that know what they are doing and that have the drive and knowledge to meet your ambitions. Can Novutech be that partner for you? Contact us to make sure!
What does Fast Four bring to the application to enhance the standard NetSuite functionalities?
May 19 2022
BackgroundAt Novutech, we work hand-in-hand with Fast Four, now part of Zone & Co, a full service ERP Partner specialized in NetSuite. They provide many opportunities to extend some of the features of our ERP and there are two in particular that we like to work with. The first SuiteApp, Fast Four Bank Reconciliation, automatically reconciles with bank statements everything from Bills to Invoices as well as Payments, Expense Reports and many more, and relies on a download of a statement or a transaction stream directly from the bank. The second SuiteApp, Fast Four Scan & Capture, automates the entry of Vendor Bills both from PDF Invoices and E-Invoices but also the delivery of E-Invoices to Customers. Let us find out more about them.
FunctionalitiesAt Novutech, we are mainly working with two Fast Four SuiteApps, Bank Reconciliation and Scan & Capture, which we will introduce to you in the following article. Bank Reconciliation The Fast Four Bank Reconciliation SuiteApp allows users to automatically reconcile their bank accounts in minutes and to save hours of manual processing each day. This means less hassle, manual entry and errors. In other words, instead of users wasting hours entering and matching each line of their bank statement, this SuiteApp automatically creates and reconciles all transactions in one easy step. To do this, users simply download statements or set up a transaction flow directly from their bank to automatically create and reconcile transactions across multiple companies, bank accounts, cards, currencies and electronic payment providers. As a result, Bank Reconciliation by Fast Four provides greater control, visibility and focus on using the data rather than entering it. After this short introduction, let us dive into the key highlights of this SuiteApp.
- Automate bank transaction entry and reconciliation
- Resolve complex scenarios with one click of a button
- Reconcile credit cards and payment gateways
- Cancel Direct Debit
- Allow Multi-line Journal Entries
- OCR, Machine Learning and e-Invoice Capture
- Split Screen View and Transaction Dashboard
- Capture Additional Fields and Extend Existing Workflows and Customizations
- Order Matching, Line Recognition and Automatic Vendor Processing
- Support for Virtually any Language and Character Set
ConclusionAt Novutech, we mainly work with the two Fast Four SuiteApps, Bank Reconciliation and Scan & Capture, which we regularly recommend to our customers. We are therefore accustomed to dealing with these applications and are able to provide expertise on their implementation and utilization. Please feel free to reach out with any further information or query.
In ShortSources https://www.suiteapp.com/Fast-Four-Bank-Reconciliation https://www.suiteapp.com/Fast-Four-Scan-Capture
Creating projects from sales transactions
April 26 2022
When you sell a product together with consultancy / professional services, NetSuite allows to create a project from the sale transaction (sale order, opportunity or estimate) you have booked in the system.
That way the sale transaction and the newly created project are linked together and all billing operations will be done directly through the sale transaction.
In this article we will do an end to end flow starting from a sale order creation to the invoicing of the related project work.
The “Create Projects from Sales Transactions” is required to create projects from sales transactions (“Full” level available only):
To be able to create a project from a sale transaction, you need to have a least one item on the sale transaction that is configured correctly.
On the item record:
- The “Create Project” must be checked.
- You also have the ability to either select a default template to be used when creating a project for that item or either define the work breakdown structure of the project directly on the item.
Let’s consider a sale order where you sell a server (hardware) to your customer together with a few hours of professional services (estimate of 4 hours at a unit price of 100€ per hour) for the server installation and configuration:
Now a project should be created to manage the professional services part. For that you can use the “Create Projects from Sales Transactions” page. Go to Transactions > Customers > Create Projects from Sales Transactions.
There you will see all sales transactions (sales orders, opportunities and estimates) that are not in one of the following statuses: canceled, closed or pending approval.
First you need to select the sales transaction(s) you want to create a project for. Then you have the ability to:
- Modify the project name
- Refer a project template based on which the project will be created
- Refer a parent project if you want to establish a specific project hierarchy
- Select a project manager
Once you’re done you can click on “Submit”. You will then be redirected to the list of projects. The newly created project is the most recent one in the list. If you have created it using a template, you might see a yellow banner at the top of the project record alerting you that NetSuite is still busy building the project according to your template. You can click on “Reload” until the banner disappears.
On the Sales Order you can see the link with the newly created project:
Looking at the project record, I have one task where I have assigned a resource to perform the server configuration for a total planned work of 5 hours at a unit price of 120€/hour:
NetSuite automatically created a forecast charge for the assignment I have just made:
You now need to reflect that updated data on your sales order and link it to your forecast charge. To do that you need to edit the sales order and “Refresh Items from Project”:
When clicking that button, NetSuite will first remove all project items and then re-source them from the project to display the most up to date information:
On the forecast charge you can now see that it’s linked to the sales order:
Please be aware that you need to do that before actual charges are generated on your project. If you don’t, actual charges will not be linked to the sales order and you won’t be able to invoice them.
The resource has now finished the configuration and entered 5 hours in his timesheet. An actual charge (charge-based billing project) has thus been created and can be invoiced through the sales order by clicking the button “Next Bill”:
That will redirect you to an invoice record containing the server (hardware) and the charge related to the professional services. You can save the invoice and send it to your customer:
Note that the status of the sales order is now “Billed”:
Let’s now imagine that something was wrongly done during the initial configuration and that 2 additional hours of professional services is required to fix that. You have then updated the assignment to 7 hours of planned work, which updated the forecast charge automatically generated by NetSuite.
The resource has now performed the additional 2 hours and entered them in his timesheet, which resulted in a new actual charge. The Sales Order status is now back to “Pending Billing”:
However you can’t invoice the new actual charge since the button “Next Bill” is not available. That is because the 5 hours displayed on the sales order have already been invoiced, so NetSuite considers there is nothing more to be billed. You have to “Refresh Items from Project” once more to be able to invoice the new actual charge:
Creating Projects from Sales Transactions allows you to combine products delivery and professional services management in an efficient way and have your billing operations handled through one single record. There are still some manuals steps to perform in order to keep the sale transaction in synchronization with the project and allow for a proper invoicing but we can reasonably hope for future improvements of the functionality in the next NetSuite releases.