Easy Ways to Create Custom KPIs in SAP Business One

SAP B1 allows you to create custom KPIs that are integral to your business and are engineered toward measuring specific targets for your business. Usually, there are four kinds of KPIs in SAP Business One to choose from—Financial, Customer, Process, and HR and Innovation.

Let Us Look at Them in Detail:

Financial KPI

Financial KPI focuses on the financial performance of the organization. It is used to analyze financial data.

Customer KPI

Customers are the most important aspect of a business. Their experience, preferences, complaints, requests, and performance are some key insights that every business should collect. The Customer KPI in SAP B1 enables them to focus on this data and enhance customer experience.

Process KPI

Process KPI measures the performance of internal business processes and operations of an organization. It provides insight into which processes are working better than others and any scope for improvement.

HR and Innovation KPI

Employee-level training, performance, achievement, salary, and everything resource-related is taken care of through the HR and Innovation KPI.

Creating a Simple KPI

For creating a simple KPI, you have to use the SAP HANA Fiori-style dashboard. Once you are on the dashboard, navigate to the ‘Tools’ option in the main menu. Then choose the ‘Pervasive Analytics’ option and open the ‘Pervasive Analytics Designer’. There are several KPIs already mentioned in the system as a standard practice under the ‘My KPIs’ section. Any new KPI created will be automatically added to the list.

Also Read: Analytics and Reporting in SAP Business One

Creating a Custom KPI

Click on the ‘New KPI’ button to start creating a KPI. This allows you to manually create a new KPI from the scratch. However, for this instance, we will stick to working with preconfigured KPIs described above.

Choose a preconfigured KPI as per your choice. Click on it and open it in the KPI designer. The first step is to change the name of the KPI and make it as per your use case such as ‘Sales orders with Deposits’. Preexisting queries of the KPI are present in the system and will come up on the left column of the KPI Designer. These can be used as the base for a new KPI. You can also view the SAP HANA Calculation views on the column that are usually available out of the box. These are ready for use as well.

By selecting a query, like the ‘Sales Order Without Deposit’ query, you’ll be prompted with a list of fields associated with the query. These will show parameters such as ‘Count’, ‘Sales Order No.’, ‘Customer Code’, ‘Customer Name’, ‘Total Amount of Order’, ‘Due Date’, ‘Document Data’, and more.

Also Read: How SAP Business One Helps in Improving Sales and Marketing?

If you’re unable to find the ‘Sales Order Without Deposit’ query in the KPI window, you can navigate to the Tools > Queries > Query Manager > System option. This will prompt a list of ‘Sales Orders Linked to Deposits’ available in the SAP Business Over version of SAP HANA.

Also Read: SAP Business One on MS SQL vs. HANA – A Detailed Comparison

Setting the KPI Value

Setting KPI values in SAP Business One is quite easy. You can start with the first column where the ‘Value Settings’ tab is present. You can drag the fields you want from the left column and drop them into the KPI box to set the KPI value easily. If you want to remove any field, just click on the X button on the KPI value and start again. This dragging and dropping mechanism makes it easier for anyone to assign values to their KPIs.

KPIs are often looked at during a given time dimension such as a week, month, year, or any other finite period. If you choose the month, for instance, you’ll need to specify this in the drop-down menu that comes up after clicking on the responsible field for the KPI in question. SAP B1 has a very fast in-memory analytics platform that allows it to fetch results in real time if you change the month into a year.

There are several ways of filtering the data available under the Filter and Parameters column. Users can filter data by customer name or any other parameter. They can even combine two separate KPIs into one by using the composite KPI tab.

The ‘Set KPI Goal’ option present below the ‘Set KPI Values’ box allows you to set your own goals for the KPI. You can mention the KPI trend you want to track from the same window. This can happen over a month over same-month basis or on a month-over-month basis. It will have different KPI values depending on the Document Date.

There is a checkmark icon above the query field column which you can click to save the KPI. You can then return to the main screen by clicking on the home button and you’re done.

Conclusion

This was a concise introduction to how you can create your own KPIs in SAP Business One. Goals give you the visibility of where your business is heading and what changes should be introduced to achieve those goals.

Also Read: How this Pune-based ERP Solutions Provider is Helping SMEs Achieve their Business Goals?

Setting efficient KPIs is crucial for business growth and ensuring its sustainability. If you’re a budding startup that’s looking for ways to improve your performance using constructive KPIs, then Praxis Info Solutions can help you. We have helped many businesses across sectors to achieve their goals and enhance their performance by developing and implementing the most effective KPIs. So, what are you waiting for? Contact us today.