Microsoft Dynamics 365 Case Study

Japan Business Systems, Inc.

Advancing Operation Transformations by Implementing Business Processes for Complex Client License Management Operations in Microsoft Dynamics 365

Microsoft Dynamics 365 導入事例 日本ビジネスシステムズ株式会社
Industry JBS Showcase
Introduction Solution Operation Improvement Service for Dynamics 365
Problem SFA CRM
Product And Service Microsoft

From left, Yohei Sogawa Business Planning Div. Microsoft Support Center Nonoka Takahashi, Megumi Yoshikawa Business Solutions Div. CRM Solutions Dept.

Dramatically shorten development processes by sharing information by group chat and agile processes
Build business applications that realize operations in a short time frame

Japan Business Systems, Inc. develops business applications to streamline internal operations on Microsoft Dynamics 365 (hereinafter “Dynamics 365”). In this case study, we review an internal development case in which a business application was implemented in a short time frame using only the basic functions of Dynamics 365. We also introduce business applications implemented through Dynamics 365.

[System Overview]
Implementation of a task-based business application to manage license information on Dynamics 365

Tell us about the business application developed on Dynamics 365.

We built a business application on the CRM function of Dynamics 365 for task-based management of the software license contract renewal operations for software purchased by customers from JBS. It is a system that is not simply limited to the ledger database of license information, but can comprehensively manage everything from the history of individual customer care through to to-do tasks.

Specifically, what kind of functions were implemented?

This application has functions that prompt customers to renew their licenses at the appropriate timing without missing any or report to application vendors by automatically creating annual tasks that differ depending on the license and displaying the deadline for each stage.

The main functions implemented this time are as follows.

Base entity: contract information
Function name Overview
Basic license information management Management of information for individual licenses such as the contract number for license contracts, contract anniversary dates, and length of contract. The upsell ratio and several other items for which calculation is necessary are automatically calculated.
Control of items displayed The items entered and mandatory items change automatically depending on the license type.
Management of information related to licenses A dedicated table is created for the basic contract number, which is the basis for the license contract, and managed linked with the contract information.
Automatic generation of tasks arising according to the contract year The tasks necessary for each year are automatically generated depending on the license type and contract period, which can be checked on the contract management screen.
License contract company management Companies related to contracts are divided into contract companies, transaction companies, and contract use-related companies and managed accordingly. This improves the interpretation of the complex relationships between companies.
Related license contract management The relationships between licenses such as new license contracts and renewal destination and renewal source / aggregation destination and aggregation source are expressed in five methods.
Automatic display of online service conditions Based on version information linked to the management number, applicable online service conditions are automatically displayed.
Attachment of contract certificates The contract certificate is saved on the license contract management page with a message.
To-do list The history of to-do items related to the contract itself and care provided for the to-do items are managed.
Base entity: contract tasks
Function name Overview
Display of flows by task The operational flows which differ for each task are displayed and the steps that need to be taken at each stage are visualized. By attaching a “completed” mark, it is possible to check whether a task has been processed or not.
Display of stage deadlines The starting date and ending date are automatically calculated from the contract anniversary date and displayed according to each operational flow stage. Cases can also be handled in which the deadlines are different by year or renewal. Because the number of days after the ending date is automatically calculated, this helps to prevent delays or ameliorate further delays.
Automatic calculation of days until the deadline The number of days to contract completion are automatically calculated and the deadline specified by the vendor to prevent delays.
Displayed item change The display of necessary items for the management screen which differ according to each flow can be switched on and off automatically.
To-do list related to tasks The to-do items and next actions are entered for each task. Messages for only a certain year, etc., are managed here.
Display of the current stage Progress status can be checked on the details screen and list of tasks screen.

[Background to Implementation]
A Structure to Manage Sharply Increasing License Information in a Unified and Efficient Way Is Necessary

How was customers’ license information managed up until now?

Dynamics 365に実装している ライセンス管理システムの画面例

Example of a license management system screen
implemented in Dynamics 365

On the license management side, information was registered on Microsoft SharePoint Online and managed in what could be described as a sort of ledger. The license management side was the contact for reporting to application vendors and inquiries from vendors. Additionally, in some cases account executives received inquiries and information was provided or account executives were encouraged to handle the inquiries.

Each account executive knew the license information for their accounts, but there was no systematic structure to manage the information and it was left up to the individual’s discretion.

What was the aim of overhauling the license management system?

The license structure was complex and the timing for license renewal or extension were all different depending on the product or contract type. The number of items to manage including past history could be 100 per week, drastically increasing the burden on the persons in charge of license management.

Additionally, we started to see cases in which the handling of license information became a burden for the account executives.

In a negative scenario, if this situation were to continue it could result in delays to the timing of license renewal, causing problems on the customer side to secure a budget. It could also lead to customers being stolen by JBS competitors.

We decided that it was necessary to have a structure to manage license information in a unified and efficient manner by systematizing the business logic for prompting customers to renew and continue license contracts at an appropriate timing from the perspective of process management, without having to depend on management by account executives. So we rebuilt this license management system.

[Reasons for selection]
Adopted Dynamics 365 as System Infrastructure to Implement Applications in a Short Time Frame with No Coding

What was the reason you adopted Dynamics 365?

Dynamics 365 is being used in various scenarios within JBS and it is customizable without coding. This allows us to implement functions that are suitable for practical use in a short period with minimum resources. We decided to adopt it as it makes it possible to expand functions easily while curbing development costs.

Additionally, data linkage is easily done in Dynamics 365 and we can easily import not only existing customer databases, but also Microsoft Excel graph data, etc., and manage the data using the implemented CRM functions. So it was the optimum application platform for developing business applications to manage licenses in accordance with operational flows such as in this case.

日本ビジネスシステムズ株式会社 事業企画本部 MS 統合サポートセンター 十川 洋平

Yohei Sogawa Business Planning Div. Microsoft Support Center Japan Business Systems, Inc.

Without coding, wouldn’t it cause problems in replicating operations or cause functional limitations?

Developing the application without using program codes makes it easier to conduct agile development. In simple terms, we can operate the prototype then and there to add or change displays or functions. So even if there is a function that would be difficult to implement with only standard functions, we can realize a similar function by changing the way we think or the procedure, or determine whether to cover such a function through operation or manually.

It might be a “limitation” if we tried to replicate all the ideal operational models, but if we determine the time and cost to implement a function, its impact on operations, and priority of the function itself, we can view it as a “specification.” This time, we decided to prioritize releasing the system without spending too much time and money rather than faithfully replicating the ideal operational model spending a lot of time and money. The sooner we can start using a new system, the sooner we can enjoy its benefits. We will continue to reorganize the system and add functions, so even if there is a function that we gave up implementing at the current point, we can develop the system to become even better as we use it. That is the basic idea.

If you change the specifications while developing the system, wouldn’t it create deviations or inconsistencies between the specifications and functions?

日本ビジネスシステムズ株式会社 ビジネスソリューション本部 CRM ソリューション部 吉川 めぐみ

Megumi Yoshikawa Business Solutions Div. CRM Solutions Dept. Japan Business Systems, Inc.

We didn’t prepare a specification document in advance. Instead, we pushed development forward through repeatedly communicating our needs, such as the flow of operations we wanted to realize or make the output “shown in a screen like this” or “have a function like this,” then operate the prototype, before communicating more changes and needs, and have them implemented. This may make it seem as if we were developing the system in haphazard way, but basically we decide on specifications or aggregate ideas using Microsoft Teams (a team collaboration tool).

This allows us to exchange opinions and share information using not only written elements, but also images and memos without wasteful discussions such as who said or didn’t say something. And even if there was a member who started participating midway through the project, it would be easy for that person to check not only the latest specifications, but the development up to that point. So no deviations or inconsistencies appeared between the specifications and functions. Additionally, on Teams, since it was possible to aggregate the various ideas and knowledge of other members in-house, rather than those of specific persons in charge, even if problems or challenges emerged, we were able to overcome them smoothly.

[Effects]
It Took One Engineer about Two Months to Implement the Complex Operational Processes

How much time and development resources did it actually take to implement the functions?

There was one engineer who was mainly in charge of development and it took about two months. However, because the engineer in charge had little development experience in Dynamics 365, experienced engineers provided support on the technical side.

Tell us about the effects of implementing the license management system.

In terms of functions, we were able to create tasks of the operations that were managed by people up until then and automate the operational processes. This reduced mistakes and omissions. It also realized a high quality license selling environment while minimizing the burden on account executives.

Additionally, by aggregating information on customers who were already using Dynamics 365 as SFA, we were able to unify the management of information that crossed over departments such as license management and sales, enabling us to create an environment in which it became easy to access data and tasks. Improving quality of customer care companywide was also one of our goals.

Were there any things that you struggled with when developing the system?

We put a lot of effort into the information management structure so that it would be a system that was easy to manage not only for license managers, but so that the license management function would also provide added value to account executives and other users who were already using Dynamics 365.

Additionally, for a customer project, there would normally be a project manager overseeing the whole operational process, but this time, since it was an internal project, we had the users manage the linkage between parts as well as the overall flow and the development side was able to concentrate on developing individual parts and securing consistency with existing functions.

By creating loose relationships between parts, we were able to minimize individual revisions and impacts of additional parts. Moreover, we didn’t need any major reworking even if the specifications changed. It made us recognize anew that it was important to maintain independence between parts, which leads to flexible and swift development.

Because linkage between applications is easy, if we consider applications developed on Dynamics 365 as single parts, we think that it will be possible to link multiple applications and develop them into a large-scale system.

日本ビジネスシステムズ株式会社 ビジネスソリューション本部 CRM ソリューション部 髙橋 野乃佳

Nonoka Takahashi Business Planning Div. Microsoft Support Center Japan Business Systems, Inc.

[Future Outlook]
Develop Various Business Applications on Dynamics 365

What are your plans for the future?

For license management operations, we intend to identify priority functions and work on each gradually, such as functions for which we pushed back implementation and functions for which improvement requests have emerged after using them in actual operations, such as expanding the scope of automatic task generation, adding items, revising language, and attaching files to documents other than license contracts.

Additionally, JBS has already implemented various functions on Dynamics 365, but we hope to add further new functions going forward.

Already implemented
Function name Overview
Pipeline management Management of various types of information such as order amounts in connection with customers, to be mainly used in the process stage of sales projects. This ensures a degree of certainty and project progress status to be checked at a glance.
Customer database Management of customer information on an account manager-basis. With information on other linked functions and documents made browsable, this contributes to unifying customer information.
Linkage of sales and other applications Creation of estimates, etc., in linkage with other applications developed by JBS.
Sales management by field Sales information, which had been managed on Excel, was migrated to CRM. This allows assessment of sales by field for each customer and enables focus on future sales.
Research information management Creation of a database that allows import of credit information, etc., received from research companies without modification. Using this information, calculations previously done by the operations section by hand were automated.
JBS service master management The masters for all services offered by JBS were built on CRM. Linked to pipeline management, this allows browsing of which services are provided to a project by service.
Approval workflow management Information related to meetings for project management conducted individually in-house was migrated from SharePoint Online to CRM. Separating the operable domains by sales, technology, and office/team in charge helps to balance security and convenience.
MA linkage Linkage with marketing automation (MA) allows management of leads. Customers from whom inquiries were received are automatically registered in Dynamics 365.
Inquiry management The list of inquiries from the website was migrated from e-mails to CRM. This reduces the time from checking details to assigning a person in charge, improving response speed to customers.
Business card management service linkage In linkage with a business card management service, information on business cards are automatically registered on CRM.
To be implemented
Function name Overview
Dashboard creation Creation of a dashboard that aggregates information that individuals from the manager class to account executives want to check respectively. This will function as an entry point to CRM and contribute to improving the usage rate.
Orders received data linkage Linking data on orders received to Dynamics 365, the dashboard will allow people to check their own budget progress at a glance.
Visualization and management of targets Visualizing an individual’s budget as well as the achievement rate to date and target figure will make tasks clear.
FS elimination and SPO migration Migrating from file servers to SharePoint Online, by linking to Dynamics 365 will enable checking of relevant information from customers.
Contract management While switching from saving contracts and contract-related documents from the current file servers to SharePoint Online, customer information on CRM will be made browsable to aggregate information.
Event management Conducting management of participation in events hosted by JBS will allow smooth operation of the events.

Published: 2019.09.02

To top of this screen