iVend Retail - Reporting and Dashboard with Subsidiary

With the Subsidiary functionality enabled in an iVend Environment, there are changes that affect the look of the reports and dashboards that come built-in with the iVend solution. In this article we will look at how the reports and dashboards are provided with a new selection runtime parameter of Subsidiary and how the reports and dashboards will be presented post selection of the Subsidiary.

Reports

First, we will look at the Reports, to understand. We use an example of the Sale by Item report

Figure 1 Sale By Item

In the above screen image, we see a new field in the runtime parameters for Subsidiary. This field will only show in the runtime parameters of reports when the Subsidiary functionality has been enabled in the system.

Subsidiary Field: The radio […] button will allow the user to select a Subsidiary based on where you are viewing the report from, i.e. at the Enterprise (Head Office) or at the Store. If at Enterprise, then the user will be able to see all the subsidiaries configured in the system and select whichever one they please. Whereas, if it is at the store, then only the Subsidiary with which the store has been mapped will be available and will be displayed by default.

The Show Detail option will produce a report with the detailed data (refer to screenshot below)

The Show data in base currency option is available at the Enterprise and at the Store. If you want to see the data in base currency then you can select this checkbox.

The following screen image shows the report in Summary and in Base Currency with no Subsidiary selected.

Figure 2 Sales Transaction by Item

The following report is from the Store with the options Show Details and Show data in base currency checked.

Figure 3 Sales Transaction by Item

The following report has been run at the Enterprise with Show Details and Show data in base currency checked.

As can be seen, the report displays data for all the Subsidiaries configured in the system as no Subsidiary was selected in the filter criteria.

It can be seen that the report is in $ which is the base currency of the Enterprise.

Figure 4 Sale Transaction by  item

Dashboards

Let us look at a dashboard as an example, Sales Top Performers at the Enterprise with different Subsidiaries configured in the system.

Note:

· The dashboard at the Enterprise will always be in Base currency.

Figure 5 Sales Top Performers

· At the Store, the Sales Top Performers dashboard will display data in Subsidiary’s local currency, which in the following example is Euros.

Figure 6 Sales Top Performers

To better understand exactly what is going on, let us let us look at the Exchange Rate screen with the conversion rate details:

· Net Sales at the Store is 415 Euro

· Net Sales at the Enterprise for the same store is 465 USD

To arrive at this figure of 465 USD, the system multiplies with the rate factor of 1.12 (see the rate entered below in the following screen image), i.e. 415 * 1.12 = 465 USD

Hence in above screen images of the dashboards, we see the Net Sales for the Subsidiary ACME-FR at the Store showing 415 Euro and when we view the same dashboard at the Enterprise, we see that it shows 465 USD, which is the default currency of the Enterprise that has been multiplied by the exchange factor, again which has been set at 1.12

​

Figure 7 Exchange Rate