What’s New

Good news for all report builders!

We now support the Excel-function Merge & Center in expanded rows and columns in the portal.

 

 

Previously, this function was only supported in Report Designer, and in the portal in instances where groups did not expand.

 

 

This change will affect existing reports (if Merge & Center is in use) as well as all new reports.

NOTE: There might be instances in certain report designs where Merge & Center is still not supported. Create a support-ticket through the partner portal or Support.osr@visma.com if you experience this issue.

 

---

More Release Notes will come by the end of the month!

What’s new

• User Roles and Report Labels
  • Distribution setting: Use labels to filter reports
  • Change Distribution setting
  • Reporting Labels
  • Reports distributed from OneStop Reporting NO
  • View labels set on reports
  • Add labels to Reports
  • Roles for Distribution
  • Create roles
  • Add users to Roles
  • Use Case example
• New version of Report Designer
  • Enhanced performance for Visma Business/Business NXT
  • Create reports with Initial parameters
  • What will happen if a user with an older version of Report Designer edits a report previously saved with the latest version?
  • Convert existing reports on historic customer and supplier transactions
  • Expressions
  • New OneStop Reporting logo
• Tenant settings moved to New Administration
• Integration-specific fixes
• Bugs fixes and feature requests per integration

 

---

User Roles and Report Labels

With Roles and Labels it is possible to distribute specific reports to specific users.

Report labels are selected for each report and role, then users are added to roles.

Which reports the user will have access to depends on the user’s role.

 

Distribution setting: Use labels to filter reports

NOTE: Only administrators at the top (customer) level are able to edit this setting.

To turn on the functionality for Roles and Labels, the setting must be selected at the customer level. Before the setting is selected, Roles and Labels will have no effect.

In this way, you can create roles, add users to roles and add labels to reports without it affecting your OneStop Reporting environment before you are ready.

NOTE: If labels are not added to reports and users are not given roles, reports will not be available for users if the setting is selected.

 

Change Distribution setting

1. Go to the New Administration module.
2. Click the top level in the organization tree.
3. On the Customer settings tab, click ✏️ to edit Distribution settings.
4. Select ✅ the Use labels to filter reports checkbox.

 

 

Reporting Labels

Reports distributed from OneStop Reporting NO

All reports distributed from OneStop Reporting have predefined labels which cannot be changed. These labels are determined by Visma Software in the country where you purchased OneStop Reporting.

 

View labels set on reports

1. Go to Reporting or Distribution
2. Click Options on a report template
3. Click View details.

 

 

Add labels to Reports

NOTE: Only administrators can add labels to reports. The Administrator must be an administrator at the same level or a higher level than the report is distributed.

Consequently, if a report is only distributed to one tenant, a tenant administrator can add labels to the report, if a report is distributed to a group, a group administrator can add labels, and if a report is distributed at top level only a top level administrator has access to add labels.

To add labels to reports;

1. Go to Reporting or Distribution
2. Click Options.
3. Click View details.
4. Click ✏️ Edit.
5. Add labels and click Save.

 

Roles for Distribution

NOTE: Only top-level administrators can create roles for distribution.

 

Create roles

1. Go to the New Administration.
2. Click the top level in the organization tree.
3. Click Roles.
4. Click Actions.
5. Click New Role.
6. Give the role a suitable Name.
7. Add Labels. NOTE: By turning on the Include all… switches , you can select all labels.
8. Click Save.

 

Add users to Roles

NOTE: Administrators at all levels (top, group, or tenant) can add users to roles.

1. Go to the New Administration
2. Go to the level in the organization tree where you want to add users.
3. Click Roles.
4. Click on an existing role.
5. Under Members, click ✏️ Edit.
6. Select the users to add by searching in the Search bar.
7. Click the user’s name.
8. Click Save.

 

Which reports will a user have access to based on the labels of the report and the role?

For a report to be visible to a user, the labels of the user’s role must at least have one matching label in all of the four types. The different types are: Budget type, Internal/external, Period type, and Report type.

An example is shown in the picture below.

In this example, the user will not have access to the report as none of the labels match the report type. If one of the labels Budsjett, Hovedbok, or Kunde is added to the role, this report would be visible to the user.

 

Use Case example

In the picture below, a role for all sales employees in a company is created.

The reason why the particular labels and label settings are selected is explained below.

 

 

The setting Include all labels in group is selected on Budget Type and Period Type.

This is because all sales employees should have access to all reports regardless of the type of budget and periods being used. If more budget or period types are added to reports in the future, the sales employees will also have access to these as long as the reports fit the other criteria.

It is further chosen that the sales employees should only have access to reports with the labels: Internal, Project, Sales, and Hour. If more labels are added to these groups in the future, the sales employees will not automatically gain access.

 

---

New version of Report Designer

We have released a new version of Report Designer. The new version contains:

• functionality for building reports with enhanced performance for Visma Business and Business NXT
• better management of deleted expressions for all integrations
• new logo.

NOTE: Remember to download the latest version of Report Designer to take advantage of new functionality.

You can always find the latest version of Report Designer here. Alternatively, you can open Report Designer and click Yes on the popup message that opens.

 

 

Enhanced performance for Visma Business/Business NXT

The reports with enhanced performance are built on new factsets for historical customer- and supplier transactions.

 

What’s New?

We have added a new type of parameters called Initial parameters. Using Initial parameters makes Report Designer able to only request data that is relevant for the specifics of the report the user is making. In the case of the historical customer- and supplier transactions, this is based on the historical date. Previously, Report Designer retrieved larger amounts of data, then cleaned it to only include the necessary data.

The functionality for Initial Parameters is supported in the following factsets:

1. Historic Customer Transactions
2. Historic Supplier Transactions

 

 

These factsets are duplicates of the old factsets and these are now named Historic Supplier Transactions DEPRECATED and Historic Customer Transactions DEPRECATED.

In this way, this release will not affect any customized reports.

Reports distributed from OneStop Reporting NO will be converted on an ongoing basis.

 

Create reports with Initial parameters

1. Open a report in Report Designer.
2. Select the option to download the new version of Report Designer.
3. Drag and drop an attribute from the factsets Historic Customer Transactions or Historic Supplier Transactions.

 

 

When you drop the attribute in the sheet, you will get the following options:

 

 

NOTE: This dialog will only appear the first time an attribute is used from a factset supporting Initial parameters in a report.

• If you select the Create the filter and add a report parameter option, a filter with a parameter is automatically added to the sheet. This is what enhances the performance of the report. Which value should be used in the parameter is decided when the report is run like any other parameter. This option will be the preferred option in most cases.
• If you select the Create the filter and use the default value option, a filter with the default value is added to the sheet. In this case, the default value will be today’s date (SqlDate), the date on which the report is run.
• If you select the Create the filter without any value set option, an empty filter is added to the sheet. If the report is run without any value to the filter, an error message will appear as no value is not a valid date. You can add a value or parameter to the filter later on.

The Initial parameter filter will be created based on the attribute Historic Date (the date you want to see the status of the historic transaction for).

4. .Click Create the filter and add a report parameter.

5. Create a group based on the selected attribute in the normal manner.

 

 

NOTE: From this point, you can continue building the report as normal.

6. Go to the Sheet filters in the Layout Editor.

 

 

7. Click Initial Filter.

 

 

The Initial Filter tab is new. On this tab, the initial parameters enhancing the performance will appear.

Initial parameters will always appear on the sheet level and cannot be added to groups on columns, rows, or cells.

It is not possible to delete these filters from the Layout Editor manually.
The filters will automatically disappear if the report no longer contains any attributes from the factsets supporting Initial parameters.

To edit the parameter of the initial filter, continue with the following steps:

8. Click OneStop Reporting on the ribbon.

 

 

9. Click Report Parameters.

 

10. Click to 📝 Edit the Initial Parameter.

 

 

11. Write a suitable Prompt text and continue editing the filter as normal.

 

12. Finish your report and enjoy the enhanced performance!

 

What will happen if a user with an older version of Report Designer edits a report previously saved with the latest version?

Users with an older version of Report Designer will not be able to save reports that have previously been edited and saved in the latest version of Report Designer.

It is therefore recommended that all users in the same OneStop Reporting environment update to the latest version so all users will be able to edit and save reports as normally.

NOTE: Users with an older version will be able to open and edit reports in Report Designer, but will not be able to save the changes (As long as the report in question has been opened and saved by a user with the latest version).

 

Convert existing reports on historic customer and supplier transactions

To convert reports to run on the new factsets with enhanced performance, all data based on attributes from the old factset must be replaced with the same attributes from the new factsets. Among others, this includes fields used as filters, Grouping/ Sorting, parameters, and directly in the Excel sheet.

NOTE: Best practice is to duplicate the original report before you make any changes. By making a duplicate, you will always have a copy of the original.

If elements from the old factsets are used in the report, it will not be possible to save the changes. It might be useful to build the report from scratch using the new facets to avoid saving issues if not all old elements are replaced.

NOTE: Because it is not possible to save changes in reports including elements from the old factsets, the report must be converted before you make any changes. The naming of the old factsets is shown in the picture below.

 

 

Expressions

We have added new functionality to better manage deleted expressions in Report Designer.

Previously, reports containing deleted expressions would fail when clicking Run without much information on how to solve the problem.

How does it work now?

When deleting an expression in use, the user will get the following warning message.

 

 

If the Expression is deleted anyways and the user saves the report, a warning will occur informing the user of what expression should be removed from the report definition.

 

 

This warning message will also be presented whenever opening a report in Report Designer which includes a deleted expression.

When looking at filters in the report, the filter of a deleted expression will be presented as shown in the picture below:

 

 

The user has two options to fix the issue:

1. Delete the invalid expression filter and use other filters. This should be done in every report where the expression is in use.
2. Create a new expression with the exact naming of the old expression.

When using this solution, the deleted expression will return in every invalid expression filter of the expression in question.

 

 

When running reports that include deleted expressions in the portal, the following message of error will be displayed.

 

 

New OneStop Reporting logo

We have updated the OneStop Reporting logo in Report Designer.

 

 

 

---

Tenant settings moved to New Administration

We have added the following edit options to Tenant settings in the New Administration:

• Name
• Description
• Tenant Level
• Multi-Company

 

 

---

Integration-specific fixes

Visma.net

Data Manager: We have fixed an issue where, for some users, the extension fields would show in the Lookup for multiple companies.

 

Tripletex

Data Import: We have increased the maximum number of days the user is allowed to use in scheduled data-import jobs from 100 to 200. The user will have to update their import jobs for this change to take effect. This should help companies that are struggling with fetching older data being changed.

 

---

Bugs fixes and feature requests per integration

 

Bugs & Feature Req.	Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Bug	Tripletex		DimProject		Fixed an issue where projects older than 30 days were not updated properly (e g name, project customer, project category et c)
Feature Request	Business NXT API	General Ledger	Voucher		Added Voucher (WaVo). New factset in General Ledger.
Feature Request	Visma Business	Group Reporting	Global Orders		Added Orders to MCL. New Factset in Group Reporting.
Bug	Visma Business, Business NXT API, Business NXT Live	Multiple			Fixed an issue where the drilldown would be duplicated due to Voucher Series
Bug	Visma.net	Project Management			Improved Workhours endpoint by adding the LastChange and FromTime filter. Added deletion workhours endpoint to include deleted entries.
Bug	Visma Business	Group Reporting			Fixed an issue where the MCL setup would fail on OSRTransactionTypeMCL.
Bug	Visma Business, Business NXT API, Business NXT Live	Multi-Company Reporting	Global Products		Fixed the link between Global Product and Product Transaction
Feature Request	Visma.net	PM	Project		Added new endpoint Project Keywords linked to Project Dimension
Feature Request	Visma.net		Inventory		Added Intrastat details to Inventory Dimension

 

 

 

What’s New

• Say hello to our new logo! 
• Distribution: Decide which OneStop Reporting reports to distribute
• Administration: Functionality moved to the New Administration 
• Workflow: Administrators can now edit and delete all workflows
• Live Budgeting for Business NXT
• Fixes

 

---

Say hello to our new logo!

We are proud to present our new logo for OneStop Reporting! The new logo is designed to fit in with Visma Software’s family of cloud products. The new logo has a simple and elegant design that signals our affiliation with Visma and our ambition to deliver the best solutions for reporting and budgeting in the cloud.

The new logo will be visible on all our products and services, including our website, our apps, and our reports. We hope you like the new logo as much as we do!

 

 

---

Distribution: Decide which OneStop Reporting reports to distribute

It is now possible for customers to decide which of OneStop Reporting reports to distribute.

Previously, distribution was an all-or-nothing solution, where all OneStop Reporting reports would be distributed or none of the reports would be distributed.

 

Distribution settings

The new settings can be found in New Administration on two different levels; top level (Customer settings) and tenant level (Tenant settings).

The distribution settings affect how actions made in the distribution module will behave.

If the setting Allow receiving reports from OneStop Reporting is switched ON at the customer level, it will override the setting for all tenants.

If it is turned OFF at customer level, it is still possible to turn it ON for specific tenants.

If the setting has been set ON at tenant level, and the customer setting is later turned OFF, the setting of the tenant will not be affected. Meaning that Allow receiving reports from OneStop Reporting will still be ON for the tenant.

In other words:

If the setting at the tenant level has never been edited, it will always follow the setting on the customer level.

 

Top (Customer) level

NOTE: To edit the settings for the top level, you must be a top level (customer) administrator.

 

 

Click the pencil to edit the settings:

 

 

The setting Allow receiving reports from OneStop Reporting is by default turned on for all new customers since the setting was created. The setting provides access to reports distributed from OneStop Reporting.

 

Tenant level

NOTE: Top level, group level, and tenant administrators are able to edit this setting.

 

 

Click the pencil to edit the settings.

 

Only selected reports will be available if the mode Only distribute selected reports is set by a top level administrator.

 

Include/exclude OneStop Reporting Reports from distribution

NOTE: You need to be a top level administrator to determine which OneStop Reporting standard reports should be distributed in your OneStop Reporting environment..

To determine which OneStop Reporting reports should be available in your OneStop Reporting environment do the following steps:

 

1. Click Distribution   .
2. Go to the OneStop Reporting level .
3. Click Report Options 
4. Click to Include/Exclude the report from distribution .

 

You can easily get an overview of which reports are included and excluded based on the appearance of the report; included reports appear as normal while the excluded reports are grayed out.

Important: If the Distribution mode Distribute all reports is active, it will have no effect if reports are included or excluded in the Distribution module. All reports will be visible for users accessing the Reporting module either way.

 

 

 

In the picture above, the reports “0.1 Månedlig rapportpakke” and “1.0.1 Full oversikt – Denne perioden” are included and therefore visible for users with access to the Reporting module.

The reports “0.1 Månedlig rapportpakke med OSR budsjett” and “1.0 Nøkkeltallsanalyse” are not included in the distribution and are not visible to any users in the Reporting module.

 

---

Administration: Functionality moved to the New Administration

As you may have noticed, we are currently working on a completely new administration page that caters to easier management of users, tenants, groups, and customers in OneStop Reporting. While we are working on the new features, we have released a preview of the new administration page.

In this release we have moved the following functionality to the New Administration page:

• Settings for customer and tenant levels, such as distribution settings.
• Security settings; MFA and Azure Active Directory.
• Usage overview
• Company and user list reports

 

 

---

Workflow: Administrators can now edit and delete all workflows

In the past, only the owner of a workflow could edit or delete that workflow. We have now made it possible for administrators to edit and delete workflows created by other users.

 

---

Live Budgeting for Business NXT

It is now possible to budget with the Visma Business NXT Live integration. Previously, it was only possible to budget with the Visma Business NXT integration.

 

What is the difference between the integrations and which one should I use?

With Visma Business NXT Live you can run reports for individual companies on live data as well as do budgeting. If you have no need for group reporting, we recommend that you only use this integration.

You should use the Visma Business NXT integration if you need to do group reporting. The integration is connected to the API of Visma Business NXT and data is retrieved every night, provided that nightly import jobs have been set up. Note that it is possible to set up the data sync manually at other times. Budgeting is now also available with this integration. Nevertheless, it is recommended to use the Visma Business NXT Live integration for budgeting, so that actual figures are displayed in real-time. The possibility to budget with the Visma Business NXT integration will be removed in the future.

 

What do I do with my budget saved with the Business NXT integration?

In Business NXT, budget data is stored in OSR Budget Foundation, not in Budget lines. OSR Budget Foundation is OneStop Reporting’s own budget tables and contains extended functionality.

Budget lines is the budget table from Visma Business and Business NXT.

 

 

If you have saved your budget with the Visma Business NXT integration to OSR Budget Foundation, you will need to move the budget data before continuing the budgeting process. OSR Budget Foundation is available from the Live integration as well, but data is stored in two different locations. With the Visma Business NXT integration, data stored in OSR Budget Foundation is saved in OneStop Reporting and with the Live integration, data is stored in OSR Budget Foundation in Business NXT.

If you need assistance, please contact konsulent.konsulent.osr@visma.com.

If you have customized budgeting templates, contact konsulent.osr@visma.com for assistance with converting the templates to the Business NXT Live integration.

 

What to be aware of when budgeting for group companies?

If you are doing your budget at group level, budget data should be stored in Budget Lines with the Visma Business NXT Live integration. Then data can be fetched and shown at group level with the Visma Business NXT integration.

 

What should I be aware of when using dimensions from Data Manager for reporting and budgeting?

The dimensions available in the Data Manager module contain OneStop Reporting extension fields. These fields can be used to add additional information to existing dimensions such as Account, or to create new tables, for example, for handling currencies.

 

 

If you don’t need group reporting, you can use dimensions from Data Manager with the Live integration for budgeting and reporting.

If you are going to use dimensions from Data Manager for group reporting as well as reporting on individual companies with the Live integration, input in the dimensions must be maintained in both integrations. This is because data stored with the Business NXT integration is stored in OneStop Reporting, while data stored with the Business NXT Live integration is stored in Business NXT.

If you are only using the dimensions for group reporting, you currently only need to maintain the dimensions in the Business NXT integration. It is still recommended to maintain the same input in the Visma Business NXT Live integration, as storage through the Visma Business NXT integration will be removed in the future.

 

---

Fixes

Publisher: We have fixed an issue where summer/winter time could disrupt the publishing time of reports.

Reporting: We have fixed an issue where options and report information didn’t show in Listview and in Favorites under the Reporting module.

 

 

---

Bugs fixes and feature requests per integration

Bugs & Feature Req.	Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Bug	Visma.net	PM	FactInvoiceRows / Workhours	Quantity	Fixed link connection between Invoice, Invoice Row and Workhours and Project Fees. Now user can display quantity from Workhours and Project Fees and group it by Invoice Row Description and Invoice Number,
Bug	Visma.net	Inventory	Inventory Units		Fixed problem with Inventory Units, now all units sets (from, to) are displayed for each inventory. Please note that full import is needed for Inventory Unit job
Bug	Visma.net	PM	Project		Fixed issue with Invoice Total attribute in Project Dimension
Bug	Visma.net	PM	Project Forecast		Fixed problem with Project Forecast, now the forecast amounts display correctly for each project
Bug	Visma.net	Project Budget	Project Accounting		Fixed an issue where Project Tasks would be linked to wrong projects.
Bug	Visma Business	Multiple	Multiple		Removed duplicated Finish Date attribute
Feature Request	Power Office GO	Multiple	Project		Added FixedPrice (Fastpris) and Billable Rate (Timepris) to the Project dimension
Feature Request	Visma Business, Business NXT	System			Added link to OSRCompany for Global LockedDate
Feature Request	Power Office GO	GL Transactions	Outgoing Invoice Lines		Added new fields to Outgoing Invoice Lines
Feature Request	Visma Business	Finance	General Ledger		Added Voucher Series table and linked to the voucher number
Feature Request	Visma Business, Business NXT Live	Multiple	Multiple		Added new fields (GenAcNo, VoNo. JNo and EntNo) to Historical Supplier and Customer Transactions

What’s New

• Created dimensions for all GL fields (free fields) in Xledger
• Budgeting now available in Business NXT Live
• Added end of subscription warning message
• Administration – Updated Delete tenants warning message
• Fixes
• Archive – Fixed drill-down issue
• Reporting – Fixed issue with duplicated reports (for Visma Business)
• Administration/Data Manager – Dimensions with same name (for Visma Business/Business NXT)
• Bugs and feature requests per integration

---

Created dimensions for all GL fields (free fields) in Xledger

All GL fields are now created as dimensions in Report Designer and can be used to edit and build templates. NOTE: This change will not affect any existing reports.

Previously, only GL1 and GL2 were available in OneStop Reporting as dimensions, while GL3–GL5 were only available as attributes.

By using dimensions as parameters in templates, users will be able to view additional information about the particular GL field.

 

 

 

How to start using the new dimensions

 

Import GL data

1. Go to the Get Data module.
2. Click Data import jobs.
3. Edit the existing nightly import job to include the endpoint GL Objects.
4. Click Next.
5. Click Save and Run.

 

Open a report in Report Designer

The GL fields that are in use by the company will show up as dimensions in Report Designer.

The naming of the fields is dependent upon how the customer has named the fields in Xledger. If GL3 is named Cost Center in Xledger, the name of the dimension will be GL 3 Cost Center in OneStop Reporting.

NOTE: The old GL attributes used in existing templates can now be found under More Fields.

 

 

Add information about the GL dimensions

It is possible to add information to the GL dimensions beyond what’s available from Xledger.

To do so;

• Go to Data Manager and add the information in the OneStop Reporting Extension fields (EXT Free fields).

 

 

NOTE: If OneStop Reporting Extension fields are in use in the old dimensions and you want to switch, the information added in the old extension fields must be added to the new dimension manually.

 

Budgeting now available in Business NXT Live

We are pleased to announce that budgeting is now available in the Business NXT Live integration. This update also includes storage of budget data directly to Business NXT.

 

Added end of subscription warning message

We have added a warning message to all users when there is an end date for their subscription. This is an important message because after the subscription has ended, the customer will no longer have access to OneStop Reporting. If you get this message and suspect that this is an error, please contact your OneStop Reporting administrator.

 

 

Administration – Updated Delete tenants warning message

We have also updated the warning message users get when they are deleting a tenant. The new message includes more information about the consequences of deleting the tenant.

 

 

---

Fixes

 

Archive – Fixed drill-down issue

After last month’s update of SpreadJS, some users experienced that the Drill-down tool to see underlying transactions was not working. We have fixed the issues and drill-down is now working properly.

 

Reporting – Fixed issue with duplicated reports (for Visma Business)

We have fixed an issue where Visma Business users have experienced that after duplicating a report in Reporting, the duplicated report would run slowly.

 

Administration/Data Manager – Dimensions with same name (for Visma Business/Business NXT)

Dimensions names for Department (Avdeling R1) and Projects (Prosjekt R2) have had the same name appear when selecting a dimension in Data Access filter (in Administration) or Data Manager. This issue has now been fixed and the dimensions have new distinct names.

 

---

 

Bugs and feature requests per integration

Bugs & Feature Req.	Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Feature Request	Tripletex	Invoice	SupplierInvoice	Multiple	Added Supplier Invoice Order Lines Factset linked to Supplier Invoice, to get more details about e.g. count (Antall) Dimension: Supplier Invoice (Leverandør faktura) Module: Invoice (Faktura)
Bug	Visma.net	PM			Fixed an issue where hours in PM did not update correctly for some customers.
Bug	Visma.net	PM			Fix to incorrect project cost (fields total Product Cost -> Factset: Project Fees and total Personal Cost -> Factset: Workhours have been added to get the correct sum of Project Cost) Module: Project Management
Bug	Tripletex	Logistics/Warehouse	Product		Fix where Warehouse/Logistics module didn’t show product information
Feature Request	Visma.net	Financials	FactSupplierDocument	Multiple	Voucher Link added to FactSupplierDocument
Bug	24SO	Multiple	Transaction Type	Description	Fixed an issue where Description of Transaction Type did not match data from 24SO
Bug	PowerOffice Go	GL	Account		Fixed issue where Account Number didn’t show up in drilldown
Feature Request	Visma Business	Group Reporting			Fixed a translation error with Lock Date in group reporting
Bug	Xledger	Data Manager			Renamed GL dimension(s) in Data Manager
Bug	Tripletex	Customers / Suppliers			Fix where some payment information for Customers and Suppliers was missing
Feature Request	Visma Business,, Business NXT Live	Multiple	Voucher		Added voucher table (WaVo) for not updated vouchers

 

What’s New

• Budgeting – Fixes
• Reporting – Updated report engine
• Data Manager – Fixes
• New Administration – Updated warning message
• Data Manager – Fixes for specific integrations
• Bugs and feature requests per integration

 

---

Budgeting – Fixes

We have fixed an issue where duplicated templates would get incorrect names in List view. NOTE: This did not happen to users who were using the default Card view.

 

Reporting – Updated tool for report viewing in the portal

We have upgraded our report viewing tool to SpreadJS version 16.

 

Data Manager – Fixes

We have fixed an issue where the error message for saving did not appear.

 

New Administration – Updated warning message

We have updated the warning message users receive when deleting tenants. The new message has more information about the consequences of deleting tenants.

 

 

Data Manager – Fixes for specific integrations

 

Visma.net:

• Fixed problem with saving data in extension fields in Data Manager for the Free Segment dimensions.
• Fixed problem with saving data in Data Manager for the Companies dimension.

 

Business NXT:

• Fixed problem with saving data in Data Manager for the Companies dimension.

 

Bugs and feature requests per integration

 

Bugs or feature	Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Feature	Business NXT Live, Visma Business, Business NXT	General Ledger	Period	Multiple	Created calculation for periodID in cases where the value of period was 0.
Feature	Tripletex	Invoice	SupplierInvoice	Outstanding Amount	Added Outstanding amount for supplier invoices.
Feature	Tripletex	General Ledger	Parent Project -> MainProjectNumber-Name	N/A	Fixed an issue where dimensions would have equal names in some instances. This was related to language issues.
Feature	PowerOffice Go	Multiple	Project	Multiple	Improved performances of some reports that timed out related to the Project dimension.
Feature	PowerOffice Go	Multiple	Department ->Project Department (Prosjektavdeling) Employee ->Project Manager (Prosjektleder) Employee ->Budget Manager (Budsjettansvarlig)	N/A	Changes names of dimensions with equal names to make it easier to distinguish dimensions in Data access filters.

What’s New

• Distribution: View standard reports
• Distribution: Added details to report cards
• New Administration: Added support to manage user details
  • Edit user
• New Administration: Added search filter
• Administration: Made it possible for tenant administrators to add integrations
• Administration: Replaced drag-and-drop functionality in Set Access Filters
• Reporting: Changed names in user interface
• Bugs and feature requests per integration

 

---

Distribution: View standard reports

Top-level administrators can now view the standard reports available from OneStop Reporting in the Distribution module. Which reports are available depends on the integrations activated in the OneStop Reporting environment as well as the country of the top level.

 

The reports shown at the country level in Distribution are the same reports that get distributed by turning on the switch in the Administration module.

 

 

NOTE: Reports from the country level cannot be directly distributed in the Distribution module. It is, however, possible to create copies of the reports and thereby distribute the copies.

 

Distribution: Added details to report cards

We have added details to all reports in Distribution.

To read more about a report;

1. At any level in Distribution, click on the report card.
2. Click View details.

 

---

New Administration: Added support to manage user details

Administrators can now edit user details in New Administration.

 

 

Edit user

1. Click Administration.
2. Click New Administration.
3. Click on top, group, or tenant level.
4. Click the user name.
5. Click Edit.
6. Edit user name or change user level.
7. Click OK.

 

New Administration: Added search filter

In New Administration, we have also added a search filter to the dialog that appears if it is not possible to delete companies due to budget assignments or workflows.

 

---

Administration: Made it possible for tenant administrators to add integrations

Users with administrator rights in a tenant can now add integrations to the tenant.

Add integrations

1. Click Administration.
2. (If more than one tenant) Click the tenant.
3. Go to the Overview tab.
4. Under Integrations, click Add.
5. In the Select integration list, select the integration.
6. Click Save.

The selected integration is now available when setting up a connection in Import data.

 

 

Administration: Replaced drag-and-drop functionality in Set Access Filters

In the past, you would drag and drop the modules or dimensions you wanted to filter on in Set Data Access Filters. Now, this is replaced by simply clicking the desired modules or dimensions you wish to filter on.

Learn more about settings data access filters here.

 

 

---

Reporting: Changed names in user interface

We have changed the names of Parameters to Historic Parameters and History to Log.

 

 

---

Bug fixes and feature requests per integration

 

Bugs or feature request	Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Bug	Visma Business NXT	Responsible dimensions	Multiple	Multiple	Fixed an issue where using the responsible dimension could give the wrong amount
Bug	Tripletex	N/A	Project	N/A	Removed possibility to store and change non-extension values under the project dimension in Data Manager
Bug	Project Management	N/A	N/A	N/A	Fixed an issue where deleted hours in Project Management did not update correctly
Feature request	Visma.net	Multiple	Inventory, Inventory ID – unit	Multiple	Added the endpoint Inventory Units containing information like from unit, to unit, unit rate and multiplication/division. For reporting purposes, the endpoint must manually be added to the data import.
Feature request	Visma.net	Multiple	Multiple	Multiple	Created a link between Sales Order Lines and Purchase Order Lines with Sales order and Purchase Order respectively
Feature request	Visma Business NXT, Visma Business NEXT Live, Visma Business	Products	Product transactions	Multiple	Added R attributes
Feature request	Visma Business, Visma Business NXT Live	Customers	Open Customer Entries	Multiple	Added fields for AutoCollect
Feature request	Visma Business	Group Reporting	OSR Budget Foundation/MultiCompany	N/A	Added OSR Budget Foundation to the MCL setup. A new Factset based on a view has been added.
Feature request	Visma.net	Multiple	Multiple	Active	Added the attribute Active for all segments dimensions and renamed OSR extension attribute Active to Ext. Active

What’s new?

• New integration for live reporting with Visma Business NXT 
  • How to start using Visma Business NXT Live? 
  • Which reports can be run with Visma Business NXT Live? 
  • How to use group reporting and or budgeting? 
• New Administration: New features 
  • Added tenants to the tree structure 
  • Delete multiple companies in bulk 
  • List of users 
  • Added CSV-export option 
• Administration: Added column for “Accounting Office Employee” in User report 
• Fixes 
• Integration-specific fixes and features 

 

---

New integration for live reporting with Visma Business NXT

We have created a new integration for live reporting with Visma Business NXT. With the new integration, Visma Business NXT Live reports can be run for single companies on live data. Group Reporting and budgeting will still be executed with the integration Visma Business NXT (not live).

 

How to start using Visma Business NXT Live?

To start using Visma Business NXT Live, the integration must be added to the tenant (The company environment). This can be done by a OneStop Reporting administrator in the following manner:

1. Open Administration .
2. Click on the tenant .
3. Under Integrations, click +Add .
4. Go to the Data connection module .
5. Click +New to create a new connection .
6. Click to authenticate the Visma Business NXT Live integration.
7. Click Next and select the companies you want for live reporting.

 

Which reports can be run with Visma Business NXT Live?

All reports that you want to run with the live integration must be built on this specific integration.

 

How to use group reporting and or budgeting?

To use live reporting with group reporting and/or budgeting, two integrations are needed for the tenant in question (Visma Business NXT and Visma Business NXT Live).

Visma Business NXT should only be used for group reporting and budgeting.

 

 

---

New Administration: New features

Added tenants to the tree structure

You can now select tenants in the tree structure in the New Administration.

 

 

Delete multiple companies in bulk

You can now delete multiple companies in one operation.

1. Click Administration.

2. Click Go to the new Administration.

3. Select the level of which you want to delete companies in the tree structure (Top, group og tenant level).

4. (If group or top level is selected) Click Companies.

5. In the Company name list, select the companies you want to delete.

6. Click Actions.

7. Click Delete companies.

8. In the Delete companies dialog, in the text field, enter the name of the first company exactly as it is spelled in the text field box.

9. (If one of the selected companies contains workflow or budget assignments) Click Show companies in the dialog.

10. Go to the company/companies in the list and delete workflow and/or budget assignments to continue with the bulk delete. NOTE: Only the owner of the workflow and/or budget assignments can do this.

 

 

List of users

In the New Administration, you can now get a list of users at the customer, tenant, or group level. In the list, you can see a user’s level and you can use the Search field to search for users or use the filter to filter on user levels.

 

 

Added CSV-export option

We have added a CSV-export option when a user is trying to delete a company, but is not able to due to existing workflows or budget assignments.

 

 

---

Administration: Added column for “Accounting Office Employee” in User report

We have added a column for Accounting Office Employes in User report. NOTE: The Accounting Office Employee label is only available for Accounting Office customers.See User administration for more information.

To create a user report;

1. Click Administration.
2. Click the top/customer level.
3. Go to the Reports tab.
4. Next to User list, click Download as CSV.

 

---

Fixes

Reporting:

• We have fixed an issue where the error message would give the reference number “null”.

 

---

Integration-specific fixes and features

Visma.net

• New Module – Fixed Assets: Users are now able to create reports with Fixed asset transactions. We have added dimensions: Fixed Assets, Asset Class, and Asset Property Tax Group. In order to use the data the endpoint has to be manually added to the data import jobs.

 

• Data Manager:  We have fixed an issue where some customers were not able to access Segment 2 from Data Manager due to a translation error.
• Chart of Accounts: For Danish customers, we have changed the display name of “Finansielle Poster” to “Aktier”.

 

Visma Business NXT

• Reporting: We have fixed an issue where not all voucher types would show correctly.

 

Visma Business NXT/Visma Business

• Budgeting: Fixed an error where it was not possible to use spreading in Line Item Details if the Department dimension was used with sheet per value and the sheet name was not equal to Department.

 

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Project Management	Project Management	Project Management	Multiple	Increased decimal count of all quantity fields.
Visma.net	Accounts Receivables	Customer Invoice Lines	Multiple	Added SalesOrderNo, SalesOrderType, and ShipmentNo to CustomerInvoiceLine with appropriate links.
Visma Business				Fixed an inadequate Danish translation of Seller/buyer.
Visma Business NXT	Multiple	Multiple	N/A	Fixed an issue where R-Dimensions did not work for Group Reporting.
Visma Business	Finance	OSR Budget Foundation/Account	Multiple	Fixed an issue where budget transactions without an Account would not be visible in Data Manager.
Visma Business NXT Live	Multiple	Multiple	N/A	Fixed an issue where the drilldown would fail for Historic Customers/ Supplier Transactions.
Visma.net	Period Functions	N/A	N/A	Fixed an issue where the Swedish translations for the period functions; Entire Year in 2 Years and Entire Year in 3 Years were swapped
Visma.net	Multiple	Period	Period in Year	Fixed an issue where Periods in future financial years would get Period in Year=13. 5 years ahead is the current maximum.
Visma Global	Period Functions	N/A	N/A	Fixed a translation issue where the period function Last Period Last Year appeared twice in Norwegian.

What’s New

• Reporting: Mark reports as favorites
• Mark report as a favorite
• View favorite reports
• Administration: Delete multiple tenants in bulk
• In-app guiding available for all OneStop Reporting users
• Administration – Group information in Company list reports
• Administration – Changed text of user permission
• Reporting – Improved sorting of report packages
• Fixes
• Integration-specific fixes

 

---

Reporting: Mark reports as favorites

You can now mark reports as favorites in Reporting.

Mark report as a favorite

1. Click Reporting.
2. Click the ⭐Star button. The report(s) is now marked as a favorite.

 

View favorite reports

1. Click Reporting.
2. Click the Favorites tab. Here you get an overview of the reports you have marked as favorites.

 

 

 

Administration: Delete multiple tenants in bulk

You can now delete multiple tenants in one operation.

1. Click Administration.
2. Click Go to the new Administration.
3. (If more than one customer) Select top level.
4. In the Tenant name list, select the tenants you want to delete.
5. Click Actions.
6. Click Delete tenants.
7. In the Delete tenants dialog, in the text field, enter the name of the first tenant precisely as it is spelled in the text field box.
8. Click Delete to confirm the deletion.

NOTE: Deleting a tenant will delete all data related to the tenants.

 

 

In-app guiding available for all OneStop Reporting users

In-app guides have been available for our Norwegian customers for some time now, and we are glad to announce that this service is now available for all customers! The guides are available in Norwegian and English.

 

 

 

Administration – Group information in Company list reports

We have added group information for each company in the Company list report.

To create reports;

1. Click Administration.
2. Click Top level.
3. Click Reports tab.
4. Click Download as CSV or Export to Excel.

 

Administration – Changed text of user permission

Because we have removed the Get report templates button from Reporting, we have changed the name of the permission that allows users to download templates to Can download budgets from get templates as budget templates are the only templates that are available for download.

NOTE: Report templates are now distributed either from OneStop Reporting if the Allow receiving reports from OneStop Reporting setting is activated or by an admin user from Distribution.

 

 

Reporting – Improved sorting of report packages

We have improved the sorting for report packages so that reports show up in the order users displayed during the editing.

 

---

Fixes

Reporting

We have moved the “Ready to download” popup to the right lower side corner so it does not block the download button.

Administration

We have fixed an issue where it was not possible to mass update tenant level to Complete if another language than English was selected as the language for the portal.

 

---

Integration-specific fixes

Integration	Module	Factset/Dimension	Attribute/Measures
Visma Global	GL	OSRBudgetFoundation	Multiple
PowerOffice Go	Sales	Invoice Journal Sales Lines	Multiple
Xledger	Finance	Multiple/Cost Center	Ext. Free 3

 

 

What’s New

• Administration – Usage
• Data Manager
• Reporting – New sorting for invoices
• Fixes
  • Data Manager
  • Budgeting
  • Reporting
  • Distribution
  • Reporting and Budgeting
  • Get Data
• Integration-specific fixes

---

 

Administration – Usage

You now get an overview of the number of Auditors and Accounting Office Employee (available for accounting office customers) users in Administration – Usage.

 

 

Data Manager

We have replaced the drag-and-drop functionality in Data Manager with a + button next to the field name.

 

 

To use the Data Manager;

1. Click Select company and choose from the list.
2. Click Factset or Dimension to expand the lists.
3. Select a factset ( ) or dimension ( ) to view the available fields.
4. Click Refresh to populate the spreadsheet with data.
5. In the field list on the left-hand side, you have the following options:
   • Deselect ( ) a field to hide it in the spreadsheet.
   • To change the order of the fields, click next to a field and drag it to another position.
   • Click + next to a field name to add it to the spreadsheet header to filter the spreadsheet. You can add multiple filters.
6. Edit the spreadsheet.
   • Some columns are linked to lists, where you can select a value.
   • Some database fields (such as “changed date”) cannot be edited.
   • (only for Factset and OSR dimensions) Click Add row and Delete rows to add or remove rows from the spreadsheet.
7. Use the Pinned value field to pin/freeze one or more columns in the spreadsheet. Pinned columns will always be visible when you scroll horizontally.
8. Click Save when you are done.

NOTE: Be careful when you edit or delete Factsets data, because the changes cannot be undone.

 

Reporting – New sorting for invoices

Updated sorting of vouchers so that invoices generated by Visma.net shows first in the list of vouchers.

---

Fixes

 

Data Manager

• Fixed an issue where Data Manager would be empty in some instances where a tenant was hosting only one company.

 

Budgeting

• Fixed an issue where it was not allowed to store values starting with “0” when cell format was set to “text”.
• Fixed an issue where the description of budget templates would not show in some instances.
• Fixed an issue where copying values by dragging cells was not allowed in some instances.
• Fixed an issue in Line Item Details where historic reference data would show data for the wrong year when using expanding sheets per value.

 

Reporting

• Enhanced performance of reports using INDIRECT formula with a second parameter when “Replace indirect references” was selected.
• Fixed an issue where it was not possible to run reports with the date range parameter.

 

Distribution

• Fixed an issue where it was not possible to scroll in the tenant list of the Confirmation dialog box.

 

Reporting and Budgeting

• Fixed an issue where it was allowed to run a report with “*” for all values even though the Allow multiple selections setting was not selected.

 

Get Data

• Fixed an issue where Open customer or supplier transactions would not update correctly after nightly import.

 

Integration-specific fixes

 

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Visma.net	Sales	Shipment/Location		Fixed an issue where Warehouse location gave the wrong value
Visma Business NXT	Finance	OSR BudgetFoundation	Scenario	Added Scenario to OSR BudgetFoundation.
Xledger	Multiple	Multiple	Multiple	Fixed an issue where data would not update correctly.
Visma.net	Multiple	Customer	Created date time	Changed datatype of Date attribute.
Visma Business NXT	System	This company	Multiple	Fixed an issue where Company number and Company name were not displayed in reports.
Visma Business NXT	Multiple	Company No	Nm	Fixed an issue where tables for group reporting would be empty in some instances.

What’s New

• Administration: New feature for mass updating tenant levels.
  • Mass-update tenant levels
• New Distribution page
  • Top level, groups, and tenants
  • See which reports you have distributed
  • Where can I see where reports are distributed from?
  • Get report templates from OneStop Reporting
  • Distribute reports to the top (customer)level
  • Distribute reports to the group level
  • Distribute reports to the tenant level
  • Delete report templates
• Administration: Settings for OneStop Reporting report templates
  • Allow users to receive reports from OneStop Reporting
• Consequences of the new Administration and Distribution pages
  • Considerations
• Integration-specific Fixes

 

---

Administration: New feature for mass updating tenant levels

NOTE: Only visible for administrators at the top (customer) or group level

We are currently working on a completely new Administration page for easily managing your users, tenants, groups, and customers in OneStop Reporting. While we are working on the new features, we have released a preview of the new administration page where you can mass update the tenant levels.

We will continue to add more features to the new Administration page, so please come back to check for more updates. In time, this new Administration page will replace the current Administration page.

 

Mass-update tenant levels

1. Go to Administration.

2. On the Overview tab, click the Go to the new Administration button.

3. Select tenants.

4. Click the Change tenant level button.

5. In the Change tenant level dialog, select tenant level from the list. NOTE: You can see which tenants you selected by clicking the blue text.

WARNING: By upgrading the tenant level, there may be an additional cost to your subscription. By downgrading the tenant level, there might be reports that are removed, report packages that will have their reports removed as well as Publisher jobs that will lose their reports. For more information about the tenant level, see User and tenant level. For information about distributing reports to users, see the section below about the new Distribution page.

6. Click Confirm. The tenant levels for the selected tenants are now changed.

NOTE: If you accidentally downgraded a tenant to the Start level, you can get the removed reports back if you upgrade the tenant within ten days. (Eventually, this period will be shorter.)

NOTE: You can also change the tenant level per tenant in the same manner as you could before.

 

---

New Distribution page

We have created a new page for distributing reports in OneStop Reporting. The new Distribution page offers easy sharing of report templates by allowing users to move or copy report templates between tenants in just a few clicks.

NOTE: You need to be a top or group level administrator to see the Distribution page.

 

Overview: Distribution

Top level, groups, and tenants

On the left-hand side of the page, you see your top level (if you are a top-level administrator), groups (if any), and tenants. The structure is the same as on the Administration page.

NOTE: Start level tenants are not shown in the tree structure and they can only receive reports distributed from the top (customer) level.

1. Top level
2. Group level
3. Tenant level
4. Import report templates

 

See which reports you have distributed

The reports shown to the right are distributed reports that are distributed from that specific level.

Reports distributed to the “North” group are in turn distributed to the tenants in the group.

 

Where can I see where reports are distributed from?

In Reporting, you can see where your reports are distributed from.

 

Get report templates from OneStop Reporting

1. Click Administration.
2. On the Overview tab, under Settings, turn ON the Allow receiving reports from OneStop Reporting switch. You can do this for all tenants by turning on the switch at the top level, or you can turn the setting on for individual tenants.
   If you have turned on the switch for the top level, all users in all tenants will receive the standard OneStop Reporting report templates in their Reporting library. If you have turned the switch on for a specific tenant, only the users in that tenant will receive these templates.

NOTE: The Get reports button is now removed from Reporting.

NOTE: Only administrators at the top level can access the Distribution settings.

 

 

Distribute reports to the top (customer)level

By distributing reports to the top level, you distribute the report(s) to all tenants under that level. NOTE: Only administrators at the top (customer) level can distribute reports to all tenants.

1. Click Distribution.
2. In the tree structure, click the top level.
3. Click the Import button.
4. In the Import from list, select the tenant or group you want to distribute the reports from.
5. (If not already selected.) In the Import to list, select the customer (top level) you want to distribute reports to.
6. In the Templates list, select the report template(s) you want to distribute.

NOTE: By performing this action, you will remove or replace the report(s) from the source tenant or group and there will only be one version of the report(s). The report is now owned by the target destination which in this case is the top level (customer). Any changes made to the report(s) will be reflected in all tenants that have this report.

If you would instead like to have copies, you can select the Import copies checkbox to create copies. In this instance, there will be two versions of the report(s) and they are not connected. This means that any changes to one of them will not be reflected in the other one.

 

7. Click Import.

8. Are you sure you want to move report? dialog, click Confirm.
NOTE: You can see which tenants you are distributing the report(s) to by clicking the blue tenant text. Keep in mind that reports distributed to the Top (customer) level are automatically distributed to Start level tenants, even though you cannot see these in the Import to list.

 

Distribute reports to the group level

By distributing reports to the group level, you distribute the report(s) to all tenants under the group level. NOTE: You need to be a top-level administrator or Group administrator to see the Distribution page.

1. Click Distribution.
2. In the tree structure, click the group you want to import reports to.
3. Click the Import button.
4. In the Import from list, select the level you want to import reports from.
5. (If not already selected.) In the Import to list, select the group you want to distribute reports to.
6. In the Templates list, select the report template(s) you want to distribute.

NOTE: By performing this action, you will remove or replace the report(s) from the source tenant or group and there will only be one version of the report(s). The report is now owned by the target destination which in this case is the group you selected to import to. Any changes made to the report(s) will be reflected in all tenants that have this report.

If you would instead like to have copies, you can select the Import copies checkbox to create copies. In this instance, there will be two versions of the report(s) and they are not connected. This means that any changes to one of them will not be reflected in the other one.

7. Click Import.

8. In the Are you sure you want to move report? dialog, click Confirm.
NOTE: You can see which tenants you are distributing the report(s) to by clicking the blue tenant text. Keep in mind that reports distributed at the group level are not distributed to Start level tenants, as they can only get reports from the top level.

 

Distribute reports to the tenant level

By distributing reports to the tenant level, you move the report(s) to those specific tenants.

NOTE: You need to be a top-level administrator or Group administrator to see the Distribution page.

1. Click Distribution.
2. In the tree structure, click the tenant you want to import reports to.
3. Click the Import button.
4. In the Import from list, select the level you want to import reports from.
5. (If not already selected.) In the Import to list, select the tenant you want to distribute reports to.
6. In the Templates list, select the report template(s) you want to distribute.

NOTE: By performing this action, you will remove or replace the report(s) from the source tenant or group and there will only be one version of the report(s). The report is now owned by the target destination which in this case is the tenant you selected to import to.

If you would instead like to have copies, you can select the Import copies checkbox to create copies. In this instance, there will be two versions of the report(s) and they are not connected. This means that any changes to one of them will not be reflected in the other one.

7. Click Import.

8. In the Are you sure you want to move report? dialog, click Confirm.
NOTE: You can see the tenant you are distributing the report(s) to by clicking the blue tenant text.

 

Delete report templates

1. Click Distribution.
2. In the tree structure, select the level you want to delete the report template from.
3. In the Templates list, select the report template(s) you want to delete.
4. Click Delete.
5. In the Delete report confirmation dialog, click Yes.

 

Administration: Settings for OneStop Reporting report templates

We have added a new setting for allowing tenants to receive reports from OneStop Reporting. For existing customers, this switch is turned OFF by default. For new customers, this will be turned ON for all tenants. The setting can be applied at the top (customer) level for all tenants, or you can adjust the setting for each tenant.

NOTE: Only visible for administrators at the top (customer) level.

 

Allow users to receive reports from OneStop Reporting

1. Click Administration.
2. Select the top, group, or tenant level for which you want to apply the changes.
3. On the Overview tab, turn on the Allow receiving reports from OneStop Reporting switch.

You now allow users to receive the standard OneStop Reporting reports to their libraries.

---

 

Consequences of the new Administration and Distribution pages

Considerations

Upgrading or downgrading your tenant levels:

By upgrading the tenant level, there may be an additional cost to your subscription.

By downgrading the tenant level, there might be reports that are removed, report packages that will have their reports removed as well as Publisher jobs that will lose their reports. For more information about the tenant level, see User and tenant levels.

 

Should you turn on the “Allow receiving reports from OneStop Reporting” switch for your tenants?

Turning on the switch allows your users to receive the standard OneStop Reporting reports from Distribution. This may lead to duplicate reports in your users’ report library. They will have one that is affected by any changes made to the standard report, and one that is autonomous and only resides in that specific tenant’s library. This is even the case if the report in question is a standard OneStop Reporting report that you downloaded in the past from the Get templates marketplace in Reporting. Please note that you can see from where the report is distributed on the report card.

 

Check your Reporting library, Publisher jobs, and report packages

After changing any tenant level, we strongly encourage you to check your reports in Reporting in the various tenants.

In addition, you may want to check Publisher jobs as well as report packages to check that they include the reports you expect.

 

Editing report templates

Same as before, you can edit reports in Report Designer. You select the report, click Edit, make your changes in Report Designer and save it. The report will now get a Draft status and only you can see the changes. If you click Publish, the changes can be seen by anyone using the report, including report packages and Publisher jobs. NOTE: You need to have administrator rights at the same level as the report is distributed from to be able to edit distributed reports. For example, if you are a Group administrator, but the report is distributed from the top level, you will not be able to edit that report.

 

What happens to my Categories?

Distributed reports cannot be categorized. Consequently, if the administrator has moved a report so that it is now distributed from the top or group level, the report will be removed from the category.

However, your local reports can be categorized and shared in the same way as before.

 

Publisher jobs and distributed reports

When selecting report templates for your Publisher job, you can now see where the template is distributed from.

 

What happens if a report is removed from Distribution that is part of a Publisher job or a report package?

The owner of the Publisher job or report package will receive an email stating which report(s) is removed. If there are no reports in the Publisher job, the job will fail and the owner will be notified.

 

How about budget templates?

Budgeting templates are not affected by the new Distribution page. That means you get budget templates in the same manner as before.

 

---

Integration-specific Fixes

 

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Visma.net	Account Receivable	CustomerInvoiceLine	Cost	Added a measure field for Cost. Users will now be able to make KPIs (for example profit) per invoice line.
Visma.net	Purchase	PurchaseOrderLines		Fixed an issue where Fixed Project would not give values in PurchaseOrderLines.
Visma Global	Sales	Customer Order Copy Lines/Article		Added Article as a dimension in Customer Order Copy Lines.
Visma.net	Multiple	Multiple	Amount	Fixed issue where credit notes didn’t show up in the Amount Measure, only in “Amount Currency”.
Visma Business	Group Reporting	Global Budget Transactions	Text	Added text attribute.
Visma Business	Group Reporting	Global Open Customer/Supplier Transactions’	Value Date	Added date attribute.
Visma Business	Group Reporting	Multiple/Cap Asset Class No.	Cap. Asset Account	Added attribute for capital asset account in factsets Order lines and Global Capital Asset Transactions.
Xledger	Multiple	Multiple	Ext. Free	Fixed an issue with parameter filter that showed incorrect values.
Xledger	General Ledger	Purchase Order Detail.	Multiple	Added factset Purchase Order Detail.

What’s New

 

New e-learning platform released: Visma Learning Universe

We have released a new learning platform for OneStop Reporting e-learning courses. Visma Learning Universe will replace the current solution (hosted by Litmos). Like before, users can access the e-learning platform from the OneStop Reporting portal, from Learning Universe.

During the fall of 2022, our Norwegian customers will get access to courses on all other Visma products from Visma Learning Universe.

 

 

Please note that to be able to access, you must have a Visma Home (Connect) user (https://home.visma.com/home). If you do not have a Visma Home user, you can follow the lower link to create a user.

 

 

The next time you log in, use the Sign in with Visma link to automatically get access:

What’s New

• What’s New
  • User settings: Choose start page in the OneStop Reporting portal
  • Change start page
  • Customer info is added to the invitation to tenant e-mail
  • Search for workflows
  • Visma Business NXT integration released
• Fixes
  • Reporting: Fixed error related to showing % format in portal
  • Budgeting: Fixed error when trying to change line/field in Budget templates
  • Budgeting: Expanded the width of the Line Item Details fields
• Integration-specific fixes

---

User settings: Choose start page in the OneStop Reporting portal

Users can now choose the start page in the portal. The setting follows the user regardless of which customer or tenant the user accesses.

The available pages to choose from are:

• Dashboards
• Reporting
• Budgeting
• Archive
• Assignments
• Workflows
• Administration

 

Change start page

1. In the top right corner, click your user name, then click My profile.
2. From the Start Page drop-down list, select the page you prefer as your start page.

 

 

Customer info is added to the invitation to tenant e-mail

When a user is added to a tenant, they receive an invitation email. We have now included the customer name in addition to the tenant name in the invitation email.

 

Search for workflows

We have added a Search box in Workflows so users can search for workflow names.

 

 

Visma Business NXT integration released

We are pleased to announce that OneStop Reporting is now available for Visma Business NXT users.

 

---

Fixes

Reporting: Fixed error related to showing % format in portal

Some users have experienced that when they try to run the report with the %-format in the portal, it cuts decimals and removes the percentage symbol from the text string. The issue has now been resolved.

 

Budgeting: Fixed error when trying to change line/field in Budget templates

Some users have experienced that when they used the mouse to change fields in a budget in the portal, they had to double click when they previously only needed to click once. This issue is now fixed.

 

Budgeting: Expanded the width of the Line Item Details fields

Some customers have reported that the widths of the Line Item Details fields are too narrow when they have numbers with more than six digits. To make the user interface more user-friendly, we have made these fields wider.

 

---

Integration-specific fixes

 

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Visma Business NXT	System	This Company	–	Fixed an error where Company Name under This Company gave the wrong value.
Visma Business	Finance	OSR Budget Foundation	–	Fixed an issue where Currency Budget Amount was not updated when storing to Cur Debit Amount.
XLedger	General Ledger	General Ledger	–	Fixed an issue where the drilldown in General Ledger would show duplicate transactions.
Visma Business	Sales Orders	Order	–	Fixed an error where Invoice Customer No (InvoCust) would show up as invalid.
Visma Business	Mutiple	Multiple	–	Fixed an error where some date fields were missing in MCL.

What’s New

• Administration: New license administration
  • Tenant levels
  • User levels
  • Create a new tenant and select tenant level
  • Change tenant level
  • Create users in a tenant
  • Change user level
  • Overview of license usage
• Publisher – Changes in handling of deleted reports used in Publisher jobs
• Publisher – Possible to publish jobs weekly
• Administration: Added search for Auditors in the Search users dialog
• Integration-specific fixes

 

---

Administration: New license administration

We have changed the licensing system in OneStop Reporting. In the past, administrators had to order the number of licenses for the various user types and then distribute them between their users, either via the Module settings or the Licenses tab in Administration.

Now, administrators can set the levels for the tenant level and the user level. The Licensing tab and Modules settings have been removed.

We have also added a new Usage tab where users can get an overview of their number of users and the user levels as well as the number of tenants and the tenant levels.

In addition, users no longer need to order a specific economy system for their tenants, as all systems are now available when creating a new tenant.

 

Tenant levels

At the tenant level, administrators select whether the tenant should be Smart or Complete. NOTE: During the fall of 2022, there will also be a Start level.

• Smart includes all modules except for Budgeting and Workflow.
• Complete includes all modules.

 

User levels

At the user level, these levels are now available:

• Basic user
• Reporting user
• Budgeting user
• Design user

What users get access to depend on both their user level and the level of the tenant. Please refer to the table for detailed information:

User level	Start*	Smart	Complete
Basic user	View Archive items	View Archive items	View Archive items Perform Assignments tasks
Reporting user	View Archive items Execute default reports	View Archive items Execute default reports Execute custom reports	View Archive items Perform Assignments tasks Execute default reports Execute custom reports
Budgeting user	View Archive items Execute default reports	View Archive items Execute default reports Execute custom reports	View Archive items Perform Assignments tasks Execute default reports Execute custom reports Execute default budgets Execute custom budgets
Design user	View Archive items Execute default reports	View Archive items Execute default reports Execute custom reports Create/edit custom reports	View Archive items Execute default reports Execute custom reports Create/edit custom reports Execute default budgets Execute custom budgets Create/edit custom reports Create/edit custom budgets

*The Start level will be released in the fall of 2022.

 

 

Create a new tenant and select tenant level

1. At the top level (your company) , or at the group level, click New tenant.
   HINT: A tenant is a separate portal environment. You can think of it as a separate portal, where only added users have access.
2. In the New tenant dialog box, fill in these fields:

• • • Name
    • Description (optional)
    • Level (Smart or Complete)
    • Integration (accounting system)

3. Click Create. The tenant is added. You can add as many tenants as you need.

4. Click Close when you are done creating the tenants you need.

 

 

Change tenant level

1. Click Administration.
2. Click a tenant. At the top of the page, next to Description, you can see which level the tenant has.
3. Next to the tenant name, click Edit.
4. In the Edit dialog, in the Level list, select Smart or Complete.
5. Click Save.

 

 

Create users in a tenant

On the Users tab for the tenant, you can manage existing users and add new users.

1. Click the Users tab. Existing users are displayed in the list. NOTE: In the Search field, you can search for existing users.
2. Click + Add users button.
3. In the Enter email address field, either type in or paste in the email addresses separated by spaces, line breaks, commas, or semicolons. You can add up to 50 email addresses at the same time.
   NOTE: There is a validation process happening when you have added the email addresses. If an email address has the wrong format, it will appear in the Error field to the left. Hover over the Information icon to see the cause of the error. If the error is due to an invalid email address(es), you need to fix the address before you can move to the next step.
4. Select User level, Role, Access permissions, System permissions, and Data accesses:
   • User level: Select between Basic user, Reporting user, Budgeting user, or Design user.
   • Roles: If the user(s) you want to add should belong to a role, turn on the switch for the role.
   • Access permissions: Use the switches to select the access permissions your user(s) should have.
   • System permissions: Use the switches to select system permissions.
   • Data access: Click the + Add button to give access to companies. Click Edit to limit the access permissions.
   • Other: It is possible to mark a user as an Auditor. The advantage of this is, for example, if users want to add temporary users and be able to easily identify such users.
     NOTE: Marking a user as an Auditor does not give the user any particular permissions or access rights.
     NOTE: Inherited permissions from roles: If you have added the user(s) to a role, you will see the inherited permissions and accesses, and the switches are deactivated.
5. Click Create.

 

 

Change user level

1. Click Administration.
2. (If more than one tenant) Click a tenant.
3. Click the Users tab.
4. In the list, click a user.
5. Next to the user name, click the Edit button.
6. In the list, click Edit user.
7. In the Edit user dialog, in the User level list, select the user level; Basic user, Reporting user, Budgeting user, or Design user.
8. Click Save.

 

 

Overview of usage

To get an overview of users’ usage, we have added a Usage tab in Administration.

To access;

• In Administration, at the top level (Customer level), click the Usage tab.

 

---

 

Publisher – Changes in handling of deleted reports used in Publisher jobs

If a report template that is part of a Publisher job is deleted (from Reporting), it is also removed from the Publisher job. Then, the owner of the job is notified either via e-mail or in Notifications. NOTE: If the deleted report is the only report in the Publisher job, the job will not be deleted.

 

Publisher – Possible to publish jobs weekly

It is now possible to schedule publisher jobs weekly.

 

 

---

 

Administration: Added search for Auditors in the Search users dialog

It is now possible to search for users who are Auditors in the Search users dialog box.

To search for users who are labeled as Auditor:

1. In Administration, click the Search users button.
2. In the Search for users field, enter is:auditor. Users who are labeled as Auditors are marked with A.

 

---

Integration-specific fixes

 

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Visma.net	Sales	Shipments	–	Added link between Period and ShipmentDate
Visma.net	Multiple	Multiple/Employee, Department, Project	–	Fixed an issue where dimensions with the same display name would be mixed up
Visma.net	Multiple	Multiple/Inventory	–	Fixed an issue where inventory attribute values with a blank description would not show up
Visma.net	General Ledger, Budget	OSR Budget/ Project Account Group	–	Added dimension Project Account Group
Visma Business	Multiple	Multiple/Country	–	Added dimension Country and linked it with Customer, Supplier, and Employee
Xledger	General Ledger	General Ledger	GL Object Values 3,4 & 5	Added attributes
Visma Global	Logistics	Stock History	–	Added factset
Visma Global	Logistics	Stock History	–	Fixed an issue causing drilldown to fail on factset
24SO	Multiple	Multiple/Project	Multiple	Added multiple ext. fields on dimension
Tripletex	Multiple	Multiple/Project Category	–	Fixed an issue where Project Category dimension did not work in multi-company reporting
Tripletex	Multiple	Multiple	–	Fixed an issue where multiple dimension did not work in multi-company reporting
MS Dynamics AX	Multiple	INVENTABLE	Multiple	Fixed attribute types from measure to group

 

 

What’s New

 

• OneStop Reporting Light users automatically upgraded to standard OneStop Reporting
• Improved notification routine when a data import job fails
• Improved parameter search
• Chart of Accounts
• Data Manager
• Integration-specific fixes

 

---

OneStop Reporting Light users automatically upgraded to standard OneStop Reporting

From March 25, 2022, OneStop Reporting Light (OSR Light) no longer exists. All former Light customers will instead have access to the standard OneStop Reporting version. The Customers have been transferred with the number of portal users and companies they had in OSR Light and they do not have to take any actions as the upgrade takes place automatically.

 

Improved notification routine when a data import job fails

In the past, only the owner of the data import job would get a notification if a data import job failed. Now, users with the Can import company data permission, Full data access, or data access to all companies in the import job will get a notification when an import data job fails.

 

Improved parameter search

We have implemented three significant improvements to the Search functionality for parameters:

• Users can now choose between searching in a certain column for a dimension or associated attributes in a parameter.
• Users can now perform a search with only one character (in the past you had to enter at least three characters).
• Users can now use these special characters for wildcard searches:
  • ‘project = items including project
  • !project = items that do not include project
  • ^project = items that starts with project
  • !^project = items that do not start with project
  • project$ = items that end with project
  • !project$ = items that do not end with project

 

 

Chart of Accounts

We have made some changes to the Chart of Accounts

• For Visma Business and Visma.net, we have split between Financial Income and Financial Expenses in expressions for Danish companies.
• For all accounting systems, we have updated the account interval for the Udisponert Resultat expression in the Chart of Accounts for Norwegian companies.
• For Visma Business, we have added the following new expressions* for Norwegian companies:

 

*NOTE: The new expressions are available when designing reports and are not linked to any of the standard report templates.

 

Data Manager

In Data Manager, we have made some changes for the Xledger integration:

• Added the Project dimension.
• Made it possible to use Cost Center as an extension dimension.

 

Integration-specific fixes

Integration	Module	Factset/Dimension	Attribute/Measures	Comment
Visma.net	Multiple	Multiple/Customer,Project, Project Manager Id	–	Link from Project to Customer and Project Manager Id dimensions
Visma.net	Finance	General Ledger/ Customer, Supplier	–	Link dimension in factset
Visma.net	Multiple	Multiple/Inventory	Price Class ID, Price Class Description	Added attributes
Visma.net	Finance	General Ledger	Reversing Entry	Added attribute
Visma.net	Inventory	Inventory Transaction	Multiple	Added endpoint KitAssembly to several attributes and measures in factset
Visma.net	Inventory	Inventory Transaction/Component Id, Kit Inventory Id	–	Added dimensions
Visma.net	Project Accounting	Multiple/Project, Project Task	–	Fixed link between dimensions which led to duplicated results in drilldown
Visma Business	Customers, Suppliers	Hist.Cust.Trans., Hist.Sup.Trans.	Voucher Date (VoDt), Valuation Date (ValDt)	Added VoDt and updated translation on VaDt
Visma Business	Finance	Actual Transactions	Free1, Free2, Free3, Free4	Added measures
Visma Business	Group Reporting	OSR Actual Transaction/OSR Account	Gr 10	Fixed attribute name
Visma Business	Customers, Suppliers	Hist.Cust.Trans., Hist.Sup.Trans.	Invoice Date (InvoDt)	Added attribute
Visma Business	Customers	Open Customer Entries	Last Reminder Date (RemRnNo)	Fixed data type on attribute
Visma Business	Customers, Suppliers	Hist.Cust.Trans., Hist.Sup.Trans.	Max Date	Fixed data type on attribute
Xledger	Multiple	Multiple/Cost Center, OSR Cost Center	–	Added link between the dimensions
Xledger	General Ledger	OSR Budget Transactions/Project	–	Fixed dimension link which led to storing errors on Project
Visma Global	Finance	General Ledger Transactions	Entry Date	Fixed naming and translation of attribute
Tripletex	Multiple	Multiple/Period	–	Fixed issue which led to dimension disappearing in group reports

 

What’s New

 

• Added Balance Dashboard for Denmark
• Integration-specific fixes 
  • Visma.Net
  • Visma Business
  • Tripletex
  • Power Office GO

---

Added Balance Dashboard for Denmark

We have added a Balance Dashboard for Danish customers. This dashboard includes:

• Working capital: Working capital is the money you need to support short-term operations. It is this focus on the short term that distinguishes working capital from longer-term investments in fixed assets or R&D. Working capital is the difference between current assets and current liabilities. “Current” again refers to the fact that these items fluctuate in the short term, increasing or decreasing along with operating activities. Generally, these are assets that can be converted into cash within the next 12 months or operating cycle, such as inventory and accounts receivable. Current assets include cash, short-term investments, accounts receivable, and inventories.
• Current ratio: The current ratio is a popular metric used across the industry to assess a company’s short-term liquidity with respect to its available assets and pending liabilities. In other words, it reflects a company’s ability to generate enough cash to pay off all its debts once they become due. It’s used globally as a way to measure the overall financial health of a company.
• Acid-Test Ratio: The acid-test ratio, commonly known as the quick ratio, uses a firm’s balance sheet data as an indicator of whether it has sufficient short-term assets to cover its short-term liabilities.

 

---

Integration-specific fixes

Visma.Net

• Added fields and changed display names in the Sales module: To make it easier for users to select the correct field when building new reports we have changed some of the filed names:
  • Ext Price (Line Amount – Discount) has been changed to Ext Price Currency (Line Amount – Discount)

 

 

• • DiscountAmount has been changed to Discount Amount in Currency.

 

 

• • Added a new field Net amount base currency: This is a sum of: FactSalesOrderLine: LineAmountInBaseCurrency – OSRGet(FactSalesOrderLine:DiscountAmount)

• Project Accounting: We have added the Project Task and Project Task Description attributes.

 

 

• Added link to Project Manager in the Project dimension: We have added a link between the ProjectManagerId attribute and the DimEmployee attribute.
• Fixed issue where it was not possible to get Postal Code from Shipment endpoint.
• Added the Lot Serial Number attribute to the Inventory Transactions FactSet and fixed a translation issue of the Inventory dimension in Norwegian.

 

 

• Added the LotSerialNumber and ExpirationDate attributes to the Purchase Receipt FactSet.

 

 

Visma Business

• Added dimension VWWorkflowTask to Documents and General Ledger FactSets.
• Added the WfId attribute to the General Ledger FactSet.
• Updated data type to DateTime in several attributes and FactSets.

 

Tripletex

• Fixed some translation issues for several dimensions: Due to some translation issues, customers have experienced that these cause duplicates in Data Manager.
• Changed OSR Budget FactSet name from Budget Transactions to OSR Budget Transactions. In this way, users will know which FactSet comes from OSR and which comes from Tripletex.

 

 

Power Office GO

Fixed issue with link between the Project and Project Manager dimensions.

What’s New

• Archive: Archive items independent of their report template
• Budgeting settings
• Publisher: Possible to select date +/- days relative to running date of publishing job
• Report Designer: Added the period functions “This Period 2 Years Ago” and “This Period 3 Years Ago”
• Fixes
• Integration-specific fixes

 

---

 

Archive: Archive items independent of their report template

Now you can send reports to your own or another user’s archive without the previously archived reports disappearing or changing when deleting or adjusting the report templates. The Archive now behaves more like your email inbox. Previously, archived reports changed if a user deleted or adjusted the original template. Now, the reports are static and will retain their original values when they are archived.

 

 

Budgeting settings

Using the Budgeting Settings, users can now decide if they want to show their last run budget in Budgeting. NOTE: The setting is turned on by default.

To access the Budgeting Settings;

1. Click Settings.
2. Click Budgeting.
3. Use the Show the last run budget automatically switch to decide whether you want to show your last run budget in Budgeting or not the next time you enter the report player. NOTE: The setting is valid for all of your tenants and customers (if you have access to multiple).

 

 

Publisher: Possible to select date +/- days relative to running date of publishing job

When setting up a publishing job, users now have three different options* for setting the date parameter:

• Specific date
• Date of running job
• Relative to running job

 

When selecting the Relative to running job option, the user can select -/+ days relative to the date of running the publishing job.

 

 

*NOTE: These options are only available for date parameters that are set up with the Date Selector option in the Report Parameters Wizard in Report Designer.

 

 

Report Designer: Added the period functions “This Period 2 Years Ago” and “This Period 3 Years Ago”

We have added two new period functions to all integrations; This Period 2 Years Ago (TP2YAgo) and This Period 3 Years Ago (TP3YAgo).

 

 

Fixes

Administration: “Remove tenant” only available when the “Overview” tab is selected

To remove the risk of deleting a tenant when, for example a user is attempting to remove a user, we have removed the Remove tenant option from the other tabs in Administration. Now it is only visible if the user is on the Overview tab.

 

Integration-specific fixes

 

Visma Business

• Added two more extension fields in “Company in group” (“Selskap i konsern”): Value 1 and Value 2 with data type decimal. This change makes it easy to add values or rates at the company level.
• Added attributes RemRnNo, WfId and WbPg to Historic Customer Transactions and WfId and WbPg to Historic Supplier Transactions.
• Added support for viewing vouchers for Historical Customer/Supplier factsets.

 

Visma Global

Added new dimensions – Terms of pay: We have added new dimensions based on the tables Termsofpaycustomer and Termsofpaysupplier including relevant fields in this table (e.g. customer/supplier and number of days). The new dimensions are linked to the Customer/Supplier dimensions.

 

 

VismaNet

Dashboard – Fix for “Arbeidskapital”: We have fixed an issue where the numbers for Arbeidskapital (NO and SE) were in positives. The numbers are now in negatives.

 

What’s New

• Dashboards are now available for Denmark and Finland 
  • Make adjustments to the dashboards
• New layout for Norwegian Visma.net reports
• Dashboards for Visma.net: View data for Branches
• Fixes

---

Dashboards are now available for Denmark and Finland (for Visma.net)

We are happy to introduce Dashboards to our Finnish and Danish Visma.net customers.

Dashboards include a set of predefined dashboards that will give you an at-a-glance overview of your company’s economic situation.

There are two categories of dashboards:

• Profit & Loss
• Customers & Suppliers

 

Make adjustments to the dashboards

• To change period for all dashboards; In the top right corner, click  Period and select period from the list.
• (If applicable) To change company for the dashboards; In the top right corner, click  Companies and select company from the list.
• See actual values; Hover over the graphs.
• Drill down; Click the graph and click the transaction data, such as General Ledger.
• Hide/Show data series in the chart; In the Legend, click the period and select Hide series or Show series from the list.
• Change the dimension on your x-axis; Click the list below the chart and select dimension, such as Department.
• Move the legend; Click in the upper right corner of the legend and drag to desired position.
• Hide/Show legend; Click ⁝ Options and select Hide/Show legend.
• See chart as table; Click ⁝ Options and select View as table.
• Download chart as SVG or CSV; Click ⁝ Options and select Download SVG or Download as CSV.

 

Dashboard categories

 

Profit & Loss

Profit

Profit is all total income of a business within a given period.

Profit consists of all the income that the business has had during an accrued time frame. As a rule, this involves earnings from invoiced goods and services, cash sales, and other income.

Accumulated profits

Accumulated profit is the sum of previous periods, plus the current period.

Profit before taxes

In the income statement, all operating revenues and operating expenses for the current financial year are set up. By calculating the difference between all income and all expenses, you arrive at the annual result before tax.

Accumulated profits before tax

Accumulated profit before tax is the sum of previous periods, plus the current period before tax.

 

Customers and suppliers

Age-distributed balance list customers – overdue

This age-distributed balance list shows all overdue items per customer.

Age-distributed balance list customers – non-overdue

This age-distributed balance list shows all non-overdue items per customer.

Open customer records Top 10 today’s date

This report shows the company’s ten largest customers.

Age-distributed balance list suppliers – overdue

This age-distributed balance list shows all overdue items per supplier.

Age-distributed balance list suppliers – non-overdue

This age-distributed balance list shows all non-overdue items per supplier.

Open Vendor Items Top 10 Today’s Date

This report shows the company’s ten largest suppliers.

 

TIP: You can change the Chart of Account to suit your business needs.

 

New layout for Norwegian Visma.net reports

We have updated the layout for all Norwegian Visma.net reports to a new modern design. In addition, the new reports allow for Chart of Accounts filtering.

 

Dashboards for Visma.net: View data for Branches

(for Swedish and Dutch customers only)

If you have set up branches in Visma.net, it is now possible to filter the data for your branches in the Dashboards.

To filter your dashboard to view data for a specific branch:

• In the top right corner, click   Branch and select branch from the list.

 

---

Fixes

 

Data Manager: Fixed issue with copying OSR-dimensions

We have fixed an issue where users would get an error message when attempting to copy and paste OSR Dimensions, such as Scenario, Transaction type, Transaction Type, OSR Currency type.

 

What’s New

• Reporting: Ability to download drilldown results to Excel
• Download drilldown result
• User menu: New design
• Integration-specific fixes

---

Reporting: Ability to download drilldown results to Excel

Users can now download drilldown results to Excel.

 

Download drilldown result

In a run report template in Reporting;

1. Right-click the cell where you want to drill down.
2. In the Choose drilldown menu, select the drilldown item.
3. Click the Export to Excel button. The report along with the drilldown sheet is downloaded and can be opened in Excel.

 

 

User menu: New design

We have refined the user menu in this latest release. The changes have been made to make the menu more user-friendly, for example by grouping the Tenants and Customer menus (for users that have more than one tenant/customer) and the My Profile and About options.

 

 

Integration-specific fixes

Tripletex

• Added and linked the Employee Category dimension with the Employee dimension.

 

Power Office GO

• Added the period function “This Quarter Last Year”.

 

Visma.net

• Added a parameter for Branch in Dashboards for Swedish customers.

 

Visma Business

• Added the fields ExtRef1-3 and Txt2 to Group Reporting.
• Added InvoNo to Group Reporting.

 

What’s new

• New version of Report Designer
• Help available in Dutch and Finnish
• Integration-specific fixes

 

---

New version of Report Designer

We have released a new version of Report Designer, available for download here.

 

Report Designer: Possible to use several expressions in the same filter group

We have made it possible to use several expressions in the same filter group in Report Designer. For example, you can now have multiple Chart of Account expressions in a single group.

 

Report Designer: Disabled “Save as” button

We have disabled the Save as button in Report Designer as users should use the Save button to upload the report to the OneStop Reporting portal.

 

Help available in Dutch and Finnish

We are happy to announce that we now offer the Help pages in Dutch and Finnish.

 

To access the Help;

• In any module in OneStop Reporting, click Help. The help page appears in a new pane to the right.

If you want to open the help page in the browser, scroll down to the bottom and click Open in browser.

 

 

Integration-specific fixes

Visma Business

• Added a new link between the OSRProp and OSRPropCI dimensions in the Fixed Asset factset in Group Reporting.
• Added the Main Rx dimension and linked it with the Rx dimensions.

 

Tripletex

• Added the FixedPrice and isFixedPrice attributes in the Project dimension.

 

Visma eAccounting

• Added the ArticleLabels dimension and linked it with the Article dimension.

 

24SevenOffice

• Fixed a bug that generated duplicates for the dimensions on factsetJournal_SubEntry.

• What’s New
  • In-app learning for Norwegian customers
  • Report Designer: New version released
    • Report Designer available in Finish
    • Report Designer: Improved translations for Dutch, Norwegian, Swedish, and Danish
    • Report Designer: Option for replacing INDIRECT formulas
    • Report Designer: Removed possibility to edit Chart of Accounts
  • Chart of Accounts: Expression sorting order
  • Chart of Accounts: Expressions in Norwegian
• Integration-specific fixes

 

What’s New

 

In-app learning for Norwegian customers

We are thrilled to announce an enhanced experience in OneStop Reporting to help our Norwegian customers get started faster, discover more value, and find help when needed.

Our in-app learning can walk users through tasks step-by-step or provide instant, contextual help. We will also use the in-app learning guide to let users know when we launch new features and functionality.

When you log in, you will find the in-app guide by clicking the hat icon in the top right corner.

 

Video in Norwegian only:

 

Report Designer: New version released

We have released a new version of Report Designer. The new version includes these new features:

 

Report Designer: Option for replacing INDIRECT formulas

We have added an option to remove INDIRECT formula calculations for specific report templates. By selecting the new Replace indirect references option, indirect references, that is, INDIRECT() are replaced with direct references. This will improve performance in formulas. NOTE: This will not work for complex reference arguments to INDIRECT. Also note that this option will affect budget templates.

To access;

1. On the OneStop Reporting tab, click Report Properties.
2. Go to the Reporting tab.
3. Select the Replace indirect references checkbox to replace the INDIRECT formulas in the report.

 

Report Designer: Removed possibility to edit Chart of Accounts

After introducing the Chart of Accounts feature, the possibility to edit CoA in Report Designer has become redundant as it introduces a potential risk of creating duplicate versions of the CoA (though only visible and active in Report Designer). We have therefore now removed this option in Report Designer.

 

Report Designer available in Finish

We have added Finnish translations to the Report Designer user interface.

 

Report Designer: Improved translations for Dutch, Norwegian, Swedish, and Danish

We have added missing translations for Dutch, Norwegian, Swedish, and Danish in the Report Designer user interface.

 

Chart of Accounts: Expression sorting order

To better get a better overview of all expressions,we have changed the sorting order so it is based on account groups. In this way, all balance expressions are grouped together – and all result expressions are listed together.

 

Chart of Accounts: Expressions in Norwegian

We have renamed several expressions in Norwegian.

 

Integration-specific fixes

 

Visma.net

• Added the AccountClassNumber attribute.
• Added the FactCustomerContract factset.
• Added ExchangeRate in the SalesOrders and SalesOrderLines factsets.
• Added a new Currency dimension in several factsets.
• Added a This Quarter Last Year period function.

 

Visma Business

• Added SalesOrdersLines factset to Group Reporting.
• Added the CurrencyName attribute to ThisCompany dimension.
• Added ValDat attribute to Group Reporting.
• Added the WorkflowStatus dimension to the Document factset
• Added several attributes to the CapitalAssetNumber dimension.

 

Business Central

• Added the OSRBudgetFoundation factset.

 

Tripletex

• Added the FactGetLedgerVoucherNonPosted factset.
• Fixed issue where access rights limited on the ProjectCategory caused templates to crash if budget lines were part of the template.
• Fixed issues with wrong data type in the InvoiceDueDate attribute in the Supplier Invoice factset.

 

Visma Administration

• AddedOSR Budget.

 

What’s new

• What’s new 
  • New: Settings – Show last run report
  • Notification settings: Moved to Settings
• Fixes 
  • Reporting/Administration – Improved Search functionality
  • Publisher – ‘Send as PDF’ issue fixed
  • Workflow – Date picker issue fixed
• Integration-specific fixes 

 

---

New: Settings – Show last run report

Using the new Settings, users can now decide if they want to show their last run report in Reporting.

NOTE: The setting is turned on by default.

To access the Reporting Settings;

1. Click Settings.
2. Click Reporting.
3. Use the Show the last run report automatically switch to decide whether you want to show your last run report in Reporting or not the next time you enter the report player. NOTE: The setting is valid for all of your tenants and customers (if you have access to multiple).

 

 

Notification settings: Moved to Settings

We have also moved the Notifications settings under the new Settings menu.

The Notifications functionality allows you to know when certain events occur in the OSR Portal. For example, when someone shares a report with you, you will see a red circle on the Notifications button

To access the Notifications settings;

1. Click Settings.
2. Click Notifications.

NOTE: The Notifications settings can also be accessed directly from Notifications > Notifications settings.

These settings have two levels;

• The options under Notifications control all notifications, across all modules in the Portal.
• The options under Archive, Assignments, Get Data, Archive, and Publisher control the notification settings for the specific modules.

 

Enable email notification

Email notifications are by default turned off. If you want to receive emails with your notifications, you must enable the Email notification functionality;

1. Click Notification.
2. Click the Notifications settings menu option.
3. Under Notifications, turn on the Send me email switch.

 

Disable the notification banner

The notification banner functionality is by default switched on. To disable;

1. Click Notification.
2. Click the Notifications settings menu option.
3. Under Notifications, turn off the Show notification banner switch .

 

Enable notification for mobile and devices

The notification for mobile and devices functionality is by default switched off. To enable;

1. Click Notification.
2. Click the Notifications settings menu option.
3. Under Notifications, turn on the Show on mobile and devices switch.

 

 

Fixes

 

Reporting/Administration – Improved Search functionality

We have improved the search for companies in Reporting and Administration.

 

Publisher – ‘Send as PDF’ issue fixed

We have fixed an issue where users who have selected to send Publisher jobs as PDFs and attempting to edit the job would not have the “Send as PDF” checkbox selected. The checkbox will now remain selected after opening the publisher job for editing.

Workflow – Date picker issue fixed

We have fixed an issue where the date picker sometimes would get cut off in the Workflow user interface.

 

Integration-specific fixes

 

Visma Business

• Added the SAF-T attribute to the Account dimension.
• Added CompanyName attribute to ThisCompany dimension in Group Reporting.
• Added R-dimensions to Capital Asset factset.
• Added link between Customer and OrderLines and OrderDocumentLines.
• Added the InvoiceCustomer dimension in Sales Orders factsets.
• Added link between PropNo and ComapnyID in Group Reporting.

 

Xledger

• Added the Project Status attribute to the Project dimension.

 

Tripletex

• Added link between the Department and Project dimensions.
• Added the SupplierInvoice factset.
• Added the ProjectParent dimension and links to the Project dimension.

 

Visma eAccounting

• Fixed issue with inability to store Project, Customer, Supplier in OSR Budget Transactions.

 

Visma.net

• Added Branch dimension to SupplierInvoiceLines and CustomerInvoiceLines factsets.
• Added the ExchangeRate attribute to SalesOrderLines factset.

 

Visma Global

• Added the StockSurveyTotals factset to the Logistics module.

 

What’s New

• OneStop Reporting now available in Finnish
• Dashboards now available in Swedish
• Fixes
• Integration-specific fixes

 

---

OneStop Reporting now available in Finnish

We have translated the user interface of the portal to Finnish. In a short while, there will also be help available in Finnish.

 

Dashboards now available in Swedish

Dashboards are now available in Swedish for Visma.net and Visma Business customers.

 

---

Fixes

Report Designer: Fixed issue for budgets when applying Sum OSRRef when there are two expansions

We have fixed an issue where users attempting to sum all IF cells using SUM(OSRRef) where there were two expansions would get incorrect sums or blank sum cells.

 

Report Designer: Fixed issue for reports with “Static mode” containing sheet referencing

Report Designer has an option for removing formulas in complex reports to improve performance when running the report. However, some users have reported that Static mode reports that contained sheet referencing would fail. We have now fixed this issue. NOTE: To read more about Static mode/Keep formula, see Static mode for reports: Remove or keep formulas in run report.

 

Fixed wrong date picker format

Due to an update, the date format picker changed to US format (MM/DD/YYYY and week starting on Sunday instead of Monday) for all users. We have now changed to the DD/MM/YYYY and week starting on Monday format for Norwegian users.

 

---

Integration-specific fixes

 

Visma Net

• Branch added as a parameter in Dashboards for Dutch users.

 

Visma Business

• Added the StockBalance factset to Group Reporting.
• Added the VoucherType dimension to Group Reporting.
• Implemented handling of incorrect date format for DueDate, InvoiceDate and PayedDate. This will help avoid conversion errors when running reports with DueDate, InvoiceDate, and PayedDate

 

Visma PM

• Added two new factsets: Project Forecasts and Team Productivity
• Added the Work Contracts dimension
• Fixed several Price fields that did not give any values. This bug occurred due to a change in the API.

 

 

What’s New

 

• Assignments: New user interface
• OneStop Reporting Light: Enabled Chart of Accounts
• Fixes
  • Dashboards: Fixed issue when changing year
  • Budgeting: Fixed issue for Line Item Details (LID) when using sheets per value
  • Reporting: Improved error message for failed reports
• Integration-specific fixes
  • Visma Business

 

---

Assignments: New user interface

We have made great improvements to the Assignments module. The new user-friendly design has all user budget assignments in a list as opposed to the old assignment cards. Assignments can be assigned to users from the Workflow module or directly from Budgeting.

An assignment can contain multiple budgets to work on. If users are assigned budgets with Let user decide parameters, they can generate their own assignments from the Generate assignment cards. The generated assignments are then included in the list of budget assignments.

 

There are two sections in Assignments:

 

1

Generate assignment cards: If the assignment allows you to select parameters for the budget, you can generate assignments from the assignment cards on top. You can generate as many budget assignments as you need. NOTE: If the user assigning the budget to you has set all parameters for the budget, you will not see the Generate assignment cards. Therefore, you will only see the Generate assignment cards if the assignment is created with the Let user decide option.

2

Assignment list: Here you find your assignments to work on.

 

 

Generate assignments

This step is only applicable if the assignment allows you to select the budget parameters.

NOTE: For assignments with Let the user decide parameters, you can generate as many budget assignments as you need.

NOTE: If the assignment has a start date in the future, you will see the start date on the Create assignment card. You must wait until the start date before you can generate an assignment.

To open the assignment and work on the budget:

1. On the Create assignment card you want to work on, click Open.
2. Select the relevant parameters. If the parameter fields are grayed out, the person who created the assignment has already defined these parameters. They cannot be changed.

NOTE: Under Already created assignments, you can view assignments and parameters for previously created assignments.

 

 

3. In the top right corner, click Create assignments. The assignment is now added to the Assignments list and you can work with your assignment.

NOTE: Under Already created assignments you can see assignments you have already created.

 

 

View information about the assignment

In the top right corner of the Create assignment card, click Options.

Here you find the following information:

• Name of the budget
• Name of the workflow
• Company
• Task status
• Start and due date
• Parameters

 

 

 

 

Work with assignments

Assignments that are assigned to you from the Workflow or Budgeting module, are displayed in the Assignments list.

To open and edit the budget:

1. Click Assignments.
2. In the Assignments list, click on the budget you want to open and edit.
3. (if applicable) Select the relevant parameters. If the parameter fields are gray, the person who created the assignment has already defined these parameters. They cannot be changed.
4. Click Run to update the spreadsheet with updated data.
5. Edit the budget. See Edit budget data for more information about the available editing options.
6. Click Save data to save your work.
7. Click Complete assignment when you are

NOTE: Your finished assignments are saved under Completed assignments. To see your completed assignments, you need to filter on Show completed assignments.

 

 

 

 

Use the Activity log

You can use the activity log to add or view comments about the budget. This can be useful when the workflow includes a reviewer and/or an approver.

1. Click   on the Activity log bar. By default, all activities (states and comments) are displayed.
   • Click Statuses or Comments to filter the activities list.
   • Enter text in the search field to search for comments or states. The list is automatically updated.
2. Enter text in the textbox and click Add to add a comment to the budget template.

 

View the status of a workflow in progress

To view information about the workflow;

• On the assignment, click Options.

Here you can monitor the progress of the workflow.

 

 

The Workflow Status pane provides the following information:

• Name of the budget.
• Name of the person who started the workflow.
• Current status of the workflow with a list of tasks assigned to the workflow participants.
• Parameters for the budget.
• At the bottom, you find your progress in the workflow.

 

---

OneStop Reporting Light: Enabled Chart of Accounts

In OneStop Reporting, we have a default chart of accounts, however, you can customize these to suit your business needs. The changes you make to the chart of accounts are reflected in your reports in OneStop Reporting.

You can customize the chart of accounts at the top-, tenant-, or company level. If you, for example, make changes at the tenant level, all companies under that tenant will get the customized chart of accounts.

Note that you must be an administrator at the top, group, or tenant level to be able to access the Chart of Accounts tool, and the levels you have access to customize depend on which level you have administrator rights for.

For the top- and tenant level, the Chart of Account tool always performs a validation of the accounts against one of your companies. If you want to change the reference company for this validation, use the Reference company drop-down list in the upper right corner to change.

If you see a ‘Not mapped’ notification in a yellow box, it means you have accounts that are not part of the chart of accounts. We strongly recommend that you fix the issues, however, this warning will not prevent you from customizing your chart of accounts.

 

To customize the Chart of Accounts;

1. Open Chart of Accounts.
2. (If applicable) Select integration if you have access to multiple integrations.
3. (If applicable) Select country the new chart of accounts will apply for.
4. Select the level for which you want to change the chart of accounts, such as for a company, all companies in a tenant, or all companies under the top level. NOTE: If you select the top- or tenant level, all companies under that level will get the new chart of accounts.
5. Click the Customize switch.
6. Click Yes to start customizing.
7. In the Filters column, select the appropriate filters. (See explanation for Filters and Operators below.*) Use the Add button in the Action column to add more filter criteria.
8. Use the Lookup to select accounts. TIP: You can use the Search field to search for accounts.
9. Click Use value.
10. Click Save.

Your new chart of accounts is saved and the changes are reflected in your dashboards, reports, and budgets in OneStop Reporting.

 

*Filter and Operator options:

 

In the first drop-down box, these two options are available:

Option	Function
Where	Will include all data inside the specified filter.
Where not	Will include all data outside the specified filter.

 

If there are multiple filters in the same group, these options will also be available in the first drop-down box:

Option	Function
And	Will filter the first condition AND the second condition.
Or	Will filter the first condition OR the second condition.
And Not	Will filter the first condition AND NOT the second condition.
Or Not	Will filter the first condition OR NOT the second condition.

 

In the second drop-down box, select Account or other account attributes such as Account type, Account description, or External Code.

In the third drop-down box, these filter operators are available:

Option	Function
In	account is In… (the selected parameters)
<>	account is Not equal to… (the selected parameters)
<	account is Less than… (for numerical values)
>	account is Greater than… (for numerical values)
<=	account is Less than or equal to… (for numerical values)
>=	account is Greater than or equal to… (for numerical values)
Begins with	account Begins with… (for any phrase contained in the dimension)
Ends with	account Ends with… (for any phrase contained in the dimension)
Contains	account Contains… (any part of the phrase contained in the dimension)
Like	OneStop Reporting will retrieve any data using “LIKE …” in SQL.*

 

 

For information about the Chart of Accounts (Kontoplan) in Norwegian, see Brukerdokumentasjon OneStop Reporting Light.

 

---

Fixes

 

Dashboards: Fixed issue when changing year

We have fixed an issue where the dashboards would show the wrong year when customers changed the year for the dashboard.

 

 

 

Budgeting: Fixed issue for Line Item Details (LID) when using sheets per value

The issue would occur when a parameter was set to Sheet per value in a budget template, such as, for a department or project. Then, the Comparable data per sheet in the Line Item Details would still be equal to the total of the selected department or project. This issue is now fixed.

 

Reporting: Improved error message for failed reports

We have improved the error mea\ssages users receive when a report fails. Now, users will get an error message with a reference number they can use when contacting Support.

 

---

Integration-specific fixes

 

Visma Business

• Fixed issue with wrong data type on attribute VoucherDate in Group Reporting the General Ledger factset.

 

What’s New

• New design of budget and report templates cards 
• Fixes 
  • Reporting: Improved error messages when reports fail
• Integration-specific fixes 
  • Visma Global
  • Xledger
  • Tripletex
  • Visma.net
  • Visma Business

---

New design of budget and report templates cards

We have redesigned the design of the budget and report template cards to improve the functionality. The changes cater for easier access to the report/budget template settings by implementing a new Options menu. From this menu, you can change name and ownership of the budget/report template, and access the thumbnail settings and view report/budget details.

 

 

In addition, the way you select and run reports/budgets has slightly changed. We have implemented a checkbox for ( ) selecting reports to access the tools for the report/budget template.

 

 

Click anywhere on the report/budget card to run.

 

 

Change name of reports

1. In Reporting, in the upper part of the report card, click Options.
2. Click Rename.
3. In the dialog box that opens, enter the new name and click Change.

 

View and change ownership of reports

Reports created or uploaded by a user are owned by this user. Only the owner of a report can change the name and delete reports. Therefore, it can be useful to change the ownership of reports. If, for example, someone decides to leave the company, the owner of the reports should give the ownership to someone else.

NOTE: Only the owner of the report can change the ownership.

1. In Reporting, in the upper part of the report card, click Options.
2. In the list, click Change ownership.
3. In the dialog box that opens, use the search box or use the drop-down list to enter å new user.
4. Click Change.

NOTE: The new owner must be a user in your system.

 

 

View details

1. In Reporting, in the upper part of the report card, click Options.
2. In the list, click View details.
   In the pane that opens, you get a description of the report, and information about when the report was created, modified and the author of the report. NOTE: The information in the description section comes from Report Properties in Report Designer.

 

---

Fixes

 

Reporting: Improved error messages when reports fail

In order for users to be able to solve issues when a report fails in Reporting, we have improved the error messages they receive. The error messages come with a suggestion for fixing the issue.

 

Integration-specific fixes

 

Visma Global

• Fixed issue with wrong data type in the DeliveryDate attribute in the CustomerOrder factset.

 

Xledger

• Added the Budget Detail (ERP budget) factset.
• Added link between dimensions Project and Product in the CustomerTransaction factset.

 

Tripletex

• Fixed issue with wrong data type on attributes regarding Cost- and Price fields in the Order and InvoiceOrderLines factsets.
• Added the ProjectOrderLines factset in the Sales module.

 

Visma.net

• Fixed VoucherLink for group reports.
• Added the TransactionType attribute to the General Ledger factset.

 

Visma Business

• Added R-dimensions in the HistoricCustTrans and HistoricSupTrans factsets.

 

 

What’s New

• Dashboards
• Chart of Accounts
• New integration with Visma.net Project Management
• Fixes

 

---

Dashboards

NOTE: Dashboards are released to Visma Business, Visma.net ERP, PowerOffice Go, Tripletex, 24SevenOffice, and Xledger.

Countries: Norway and the Netherlands

We are excited to introduce Dashboards to OneStop Reporting. Dashboards include a set of predefined dashboards that will give you an at-a-glance overview of your company’s economical situation.

 

There are three categories of dashboards:

• Profit & Loss: Profit, Profit before tax, Accumulated profits, and Accumulated profits before tax.

 

 

• Balance: Working capital, Current ratio, and Acid-test ratio.

 

 

• Customers & Suppliers

 

 

You can change the period for the dashboards and which company to see information for.

 

 

You can hover the chart to read the actual values.

 

 

You can even click on a data series to drill down to the transactions to see the actual numbers.

 

 

From this transaction table you can even drill down to see the actual voucher.

 

 

In your dashboard, you can easily change the category on your x-axis. For example, you can select to view Project instead of period.

 

 

You can also view the dashboard as a table, or download as SVG or CSV.

 

 

If you want to move or hide the legend, just click and drag, or click Options and click Hide legend.

 

For more information about Dashboards, see Dashboards.

 

 

---

Chart of Accounts

NOTE: Released for Visma Business, Visma.net (NL, NO), Visma Global, Tripletex, PowerOffice GO, and Xledger.

 

In OneStop Reporting, we have a default chart of accounts, however, you can now customize these to suit your business needs. The changes you make to the chart of accounts are reflected in your dashboards, reports*, as well as budgets* in OneStop Reporting. (*You need to set up Expressions in your reports/budget templates in order for this to work.)

You can customize the chart of accounts at the top-, tenant-, or company level. If you, for example, make changes at the tenant level, all companies under that tenant will get the customized chart of accounts.

Note that you must be an administrator at the top, group, or tenant level to be able to access the Chart of Accounts tool, and the levels you have access to customize depend on which level you have administrator rights for.

For the top- and tenant level, the Chart of Account tool always performs a validation of the accounts against one of your companies. If you want to change the reference company for this validation, use the Reference company drop-down list in the upper right corner to change.

 

 

If you see a ‘Not mapped’ notification in a yellow box, it means you have accounts that are not part of the chart of accounts. We strongly recommend that you fix the issues, however, this warning will not prevent you from customizing your chart of accounts.

 

To customize the Chart of Accounts;

1. Open Chart of Accounts.
2. (If applicable) Select integration if you have access to multiple integrations.
3. (If applicable) Select country the new chart of accounts will apply for.
4. Select the level for which you want to change the chart of accounts, such as for a company, all companies in a tenant, or all companies under the top level. NOTE: If you select the top- or tenant level, all companies under that level will get the new chart of accounts.
5. Click the Customize switch.
6. Click Yes to start customizing.
7. In the Filters column, select the appropriate filters. ( See Chart of Accounts for more detailed description of the filters. ) Use the Add button in the Action column to add more filter criteria.
8. Use the Lookup to select accounts. TIP: You can use the Search field to search for accounts.
9. Click Use value.
10. Click Save.

Your new chart of accounts is saved and the changes are reflected in your dashboards, reports, and budgets in OneStop Reporting.

 

 

---

New integration with Visma.net Project Management

Applies to Visma.net Financial and Project Management customers

 

With the new Visma.net Project Management (PM) integration you can now create reports comparing information you have in PM with your Visma.net Financials data.

Prerequisites:

• Customer must use PM together with Visma.net Financials (the same company must exist in both systems).
• Customer must specify in which tenant (in OneStop Reporting) they want the PM integration, if they have several tenants.
• Customer must have activated the REST API in their PM application (We have made documentation that you will receive when ordering for how this is done).

How to order the Project Management integration?

Existing customers:

Email salesorders.osr@visma.com, with the following information:

• Customer name
• OSR tenant (s) customer must have the PM integration

 

New customers:

Order OneStop Reporting with Visma.net from the price calculator, add in the comments field that the customer wants Visma.net Project Management.

 

---

Fixes

Administration – User report

We have fixed an issue where data displayed in the User report would show incorrect data. Learn more about creating reports in Administration here.

 

What’s New

 

• New integration: Visma.net Project Management
• Administration: Possibility to set country for companies
• Help page for OneStop Reporting Light (Visma Business users): 
• Integration-specific fixes 

 

---

 

New integration: Visma.net Project Management

We are happy to announce our new integration to Visma.net Project Management. An integration to Project Management allows you to compare the information you have in Project Management with your Visma.net Financials data and you can create the reports you need from Project Management.

However, this integration comes with a few limitations;

• You must use Project Management together with Visma.net Financials and the same company must exist in both systems.
• You must specify in which tenant (in the OneStop Reporting portal) you want the Project Management integration if you have multiple tenants.
• You must have activated the REST API in your Project Management application. You will receive documentation on how to set this up when ordering.

 

Please contact your vendor if you are interested in the Visma.net Project Management integration.

 

 

Administration: Possibility to set country for companies

In preparation for upcoming releases of OneStop Reporting with Dashboards and customized Chart of Accounts, we have made it possible to specify a country for companies in Administration.

To set country for a company:

1. In Administration, click the appropriate tenant.
2. Click the Companies tab.
3. In the Country column, select country from the list.

 

Help page for OneStop Reporting Light (Visma Business users):

We have created a help page (in Norwegian) for our OneStop Reporting Light solution for Visma Business.

 

---

Integration-specific fixes

 

Visma Net

• New module: Project Accounting is now released:

• Fixed an issue where the Warehouse endpoint failed for some customers.
• Added Account Type and External Code 1 to the Lookup display. This change was done so customers can use these fields when setting their Chart of Accounts.
• Import on LastModifiedDate is now implemented for CustomerPaymentLines.

 

Tripletex

• Added result budgets for Company and Department levels. The new factset in the Tripletex integration is called Budget Transactions (budsjett-transaksjoner), and the old Budget factset is renamed to OSR Budget Transactions.

 

PowerOffice GO

• Added more parent fields to the RecurringInvoiceLines factset.
• Added more fields to the RecurringInvoiceLines factset.
• Added the VoucherDate and DueDate attributes to OutgoingInvoiceLines.
• Added index to speed report
• Fixed wrong links for the Department, Project, and Product dimensions in the RecurringInvoiceLines factset.
• Added the CurrencyRate attribute and corresponding amount measures in the OutgoingInvoice factset.

 

Visma Lønn

• Expanded the period table. Users should now be able to see periods after 2020.

 

Business Central

• Expanded the base model with new factsets and dimensions. Some highlights include: Payable/Receivable Transactions, Sales Invoices, and Items.

 

Visma Business

• Added the PrvCntDt (Forrige telledato) attribute to the Stock Balances (lagersaldo) factset.
• Fixed an issue where ChDt would store incorrectly in Budget Lines (Visma Business budsjett-tabell)
• Fixed issue with multiple week/year attributes in SalesOrder.

 

Xledger

• Added support for period 13.
• Added a fix for CostCenter storage.
• Added the AllowPosting attribute to the CostCenter dimension.

Fixes

Reporting – Date range picker issue: We have fixed an issue where users have experienced that the date range picker was clipped by the browser window.

Increased years generated by OSR Periods (PowerOffice GO and other relevant): Some integrations with deviating fiscal year use the OSR Periods function to generate period tables. However, OSR Periods is set to only generate periods 10 years back, and some users have data going longer back causing for example balance reports not to be correct. To remedy this, we have increased the period span.

Reporting: Fixed issue with Comment sheet: Some users have experienced issues when adding Comments sheets to reports when named styles are missing in the report. We have now fixed this issue.

Administration: Add extensions: We have made Add extensions available for administrators in a tenant. In the past, it was only administrators at the top (customer) level who could add extensions.

 

Integration-specific fixes

 

Visma Business:

• Fixed collation error in Multi-Company Setup.

 

Visma Net

• Fixed link between the DimProjectTask and DimProject dimensions.

 

AX2012 R2/R3:

• Budgeting: Added OSR Budget Foundation and several OSR dimensions to the model. Please note that the user has to run Budgeting setup before they can use these dimensions in Budgeting.

 

XLedger

• Data Manager – Issue with OSR Budget Transaction dimension: We have fixed an issue where users would get an error message when editing the OSR Budget Transaction dimension in Data Manager.

What’s new

• Possibility to mark a user as Auditor
• Mark user as Auditor
• Search for Auditor
• Administration: Possibility to add Light tenants
• OneStop Reporting now available in Dutch
• Budgeting/Reporting: Added search for templates in “Get templates”
• Last used tenant is remembered
• Fixes
• Integration-specific fixes

 

---

Possibility to mark a user as Auditor

 

It is now possible to mark a user as an Auditor. The advantage of this is, for example, if users want to add temporary users and be able to easily identify such users.

NOTE: Marking a user as an Auditor does not give the user any permissions or access rights.

 

Mark user as Auditor

1. Open Administration.
2. (If more than one tenant) Click a tenant.
3. Click the Users tab and click on a user.
4. Under Other, turn on the Auditor switch.

 

Search for Auditor

You can easily search for users who are labeled as Auditor:

• Either at the Customer or Group level, in the Search field on top of the tenant/group tree, enter is:auditor. Users who are labeled as Auditors are marked with A.

 

 

Auditors will also appear in the User report under Reports.

 

 

Administration: Possibility to add Light tenants

For Visma Business customers, it is now possible to add Light tenants for our OneStop Light version.

 

 

OneStop Reporting now available in Dutch

We are pleased to announce that the OneStop Reporting portal is now available in Dutch. We have started the process of translating the user interface of the Report Designer and hope to release in near future.

 

 

Budgeting/Reporting: Added search for templates in “Get templates”

It is now possible to search for report- and budget templates in the Get templates marketplace.

 

 

Last used tenant is remembered

We have implemented a change so the system remembers which tenant the user was last in the next time the user logs on to the portal.

 

---

Fixes

The Feedback button is reintroduced: For a while, the Feedback button was removed. We have now reintroduced it and really urge users to use it to give us feedback. We read the comments and suggestions you provide as this enables us to improve our products and services.

 

 

Fixed issue when selecting values in lookups when there is a horizontal scrollbar: Some users have experienced that they were not able to select the last item in a lookup when there was a horizontal scrollbar in the lookup. We have now fixed this issue.

Fixed issue with list of users when changing ownership of reports/budgets: In the past, some users have experienced that they are not able to see all users in the list when they change ownership of a report or budget. This issue has now been fixed.

Report Designer – Hyperlinks in reports: It is now possible to use hyperlinks in report definitions, both to external pages and to link between Excel sheets.

Fixed issue of incorrect data displayed in Data Manager when filtering on empty period: In the past, when users filtered on empty Period in Budget Transactions in the Data Manager, they would get transactions with periods but the period field would be empty. This issue has now been fixed.

Fixed translation issue with the date range calendar picker: In the past, users have experienced that the date range picker in languages other than English would select incorrect ranges, such as starting on a Sunday and ending on a Saturday when the users had selected a week. This has now been fixed. In addition, we have also translated the date ranges.

 

---

Integration-specific fixes

 

VismaNet

• Drilldown setup error for Sales Order Lines: We have fixed an issue where users would get an error message when trying to edit the drilldown setup for Sales Order Lines.
• Multi-Factor Authentication issue resolved: We now have support for users who have set up MFA in the Visma Net system and have had issues with data import jobs.
• Added Project and ProjectTask to CustomerInvoice/Lines, CreditNotes/Lines, and DebitNote.
• Changed the attribute type of Cost in SupplierInvoiceLine to measure. This field will now be aggregated in reports.
• Added Supplier Payment head and lines
• Added Customer Payment Lines
• Added ProjectTask to Budget
• Added voucher to Customer Document
• Added AutoConditon to several endpoints

 

Visma Business

• Updated a link in Actual transactions (hovedbok) which should result in better performance for drilldown.
• Changed the default drilldown-order for Open Customer Entries and Open Supplier Entries. More relevant information should now come first in the drilldown.
• Changed the attribute type of Purchase (Kjøp) in Supplier Transactions to measure. This field will now be aggregated in reports.
• Added Gr and Inf fields to Global Supplier and Customer. Added VoTp (bilagsart), VoNo (bilagsnummer) and some missing amount fields to Global Supplier Transactions and Global Open Supplier Transactions.
• Added AcSet

 

AX2012R2

• Fixed an issue where setting up a gateway connection fails.

 

MS Dynamics Business Central

• Expanded the model with new dimensions, links, and terms.
• Fixed drilldown in General Ledger

 

24SevenOffice

• Fix for error in Hours import

 

XLedger

• Added a fix for Timesheet import

What’s new

 

Publisher: Administrators can view all existing Publisher jobs in a tenant

Administrators can now see all Publisher jobs created in a tenant, including jobs created by other users. In this way, administrators can get an overview of all publisher jobs and can view the log for all jobs. They can also delete jobs created by other users.

NOTE: An administrator cannot edit Publisher jobs created by other users.

 

Reporting: Improved sorting options when using List view

We have improved the sorting options for reports in List view. Users can now sort based on type, when the report was created as well as when the report was last modified.

 

 

Administration: Customizing the integration by adding extension files

In Administration for a tenant, it is now possible to add an extension file. The extension file can be used to customize the integration by adding, for example, dimensions, attributes, factsets, and modules that go beyond the standard integration to the ERP system we normally provide.

Please note that this is an advanced tool that requires you to contact our support team and the customization file is then created by our integration team.

 

 

New blog site published for OneStop Reporting (Norwegian only)

For our Norwegian customers, we have created a new blog. Please take a look: https://onestopreporting.com/blogg/

 

Fixes

Budgeting – Remember cell position when saving budget: In the past, users have experienced that the system does not remember in which cell they were after saving a budget. The issue has now been fixed.

Reporting- Print vouchers that span multiple pages in one operation: In the past, users had to print vouchers that spanned multiple pages one page at a time. This issue has now been fixed and users can print such vouchers in one operation.

Fixed array formula issue causing reports not to run properly in the portal: Some users have experienced that reports that run perfectly in Report Designer have issues when running in the portal. The issue is caused by array formulas added to the OSR formulas. This bug has now been fixed.

Fixed bug for the Recent filter: We have fixed an issue where reports would be sorted alphabetically even though the user had selected the Recent sorting.

 

 

Translation of user interface issue resolved: Previously, if the user had chosen to let the browser automatically translate the user interface, the user would see some incomprehensible texts in the portal. We have now fixed this issue by blocking the translation option. To properly change the language of the user interface, click your user name in the upper right-hand corner, select Profile and then select the desired language from the Language list.

Administration – Improved performance in Customer/Group/Tenant tree: We have improved the performance for the Customer/Group/Tenant tree for customers with large amounts of customers.

Added pop-up window when there is a new version of OneStop Reporting: Users will now get a message when there is a new version available asking them to refresh the page.

Administration – Not moving all Publisher jobs: In the past, when you moved a user’s content to another user, all Publisher jobs in the tenant were moved to the destination user regardless who owned them. Now, we only move jobs that are owned by the user you are moving content from.

 

Integration-specific fixes

 

24SevenOffice

• Increased decimal count of Price in Time_Hours to counter error on import jobs.

 

Visma Business

• Added more fields to BudgetLines.
• Changed Orders from measure to group in Price fields: To be able to group by price fields, we have changed the Price, Dprice, PriceF, and CCstPr fields in the OrdLn factset from measures to group.

 

PowerOffice GO

• Added CurrencyRate and Calculate Amount fields to the InvoiceJournal factsets.
• Fixed issues with incorrect dates for Time Tracking.

What’s new

 

We’ve just launched a new look for the OneStop Reporting portal

In November, we are introducing a fresh new look-and-feel of the portal. The redesign brings a clean look that incorporates Visma’s Nordic Cool Design language and icons.

We have kept the same functionality as before, so it should feel very familiar to you.

 

As part of the new design, we have decluttered the left-hand side menu to match the clean-cut and content-focused new design. But same as before, you find your reports, budgets, and administration tools in the menu to the left. However, you may see that we’ve hidden some of your least used tools under a More menu.

These changes are just the start of many new exciting things in OneStop Reporting.

---

 

Fixes

Reporting – Fixed issue when printing vouchers: Recently, some users have experienced to get a large OneStop Reporting logo on voucher printouts that would cause the printout to span over multiple pages. We have now fixed this issue.

Increased performance for reports containing Named Ranges (OSRRef): We have reduced the number of NameRanges (OSRRef) in run reports. In this way, reports will open faster.

 

Integration-specific fixes

 

Visma.net

• Added extension fields to Companies for Group Reporting (CGR): CGR will now show up as a dimension in Data Manager. Here, users can add information regarding their companies and use it in their reports. For instance, users may set up a group structure.
• Added a distinct filter to Customer CreditNotes: With this fix, the data import errors related to this endpoint are resolved.
• Changed datatype of ShipOn in SalesOrderLines to Date and time: Performing a lookup on the ShipOn attribute will now display a calendar, instead of a list of dates.
• Added Project attributes to the Project dimension.

 

Visma Business

• Added period to the Orders factset in Sales Orders.
• Added Changed Date to OSR Budget Foundation: The Changed Time will allow the users to get information about who and when a transaction is changed. For this change to take effect, the customer must run the Budgeting setup.
• Changed SalesRt in the Currency dimension to Group type: This change will cause the data in SalesRt fields to no longer be aggregated in reports.
• Added storage type Key to AcNo in Budget: We have fixed storage in Data Manager with filter on Budget Model.

 

Visma Global

• Multi-Company setup: We have fixed an issue where the Multi-Company setup failed to install.
• Added invoice history information: We have added CustomerOrderCopy and SupplierOrderCopy. In this way, customers have access to see invoice history.

 

XLedger

• Improved performance for General Ledger: To increase performance for reports built on General Ledger transactions, we have added an index to the General Ledger dimension.

 

Tripletex

• Added link to Contact and Employee in TimesheetEntry: We have added a link to Contacts and Employees in the Timesheet dimension.

 

Fixes

• Fixed issue when copying/pasting in Data Manager: We have fixed an issue where users have not been able to copy and paste in Data Manager.
• Fixed issues with touch screen devices: We have fixed an issue where users have experienced problems when selecting dates using touch screens.
• Reintroduced icons for report packages: Due to a bug, the icons for the tools for report packages were not visible. The issue is now resolved and all icons are now visible for users.

 

Integration-specific fixes

 

Visma Admin

• Support for deviant fiscal year: We have added support for Fiscal Year that is less than 12 months.
• Fixed wrong IB for Group Reporting: We have fixed an error where some users would get double values for IB-values when creating and running reports for Group Reporting.

 

Visma.Net

• New dimension in the Sales module: We have added the Cash Sales dimension under the Sales module so users can build reports based on their Cash Sales.

• Fixed wrong formula for Account Type: Some users have experienced not getting any values when using the Account Type in reports. This issue is now fixed by correcting the underlying formula.
• Fixed bug when storing to extension fields for the Account dimension.
• Budgeting – Possible to store to the Project dimension: We have fixed an error where users were not able to store to the Project dimension in budgets.

 

Visma Business

• Budgeting – Changed attribute type of some fields: Customers have experienced that prices are aggregated and are not able to group by certain Price fields, such as, Price, Exchange rate, and Discount rate. These fields are no longer measure fields, and will not be aggregated in reports and budgets.

 

Visma Global

• Budgeting data fields: We have fixed certain fields to they will appear correctly in Data Manager. The fields in question are: Created, Created by, Updated, and Updated by. For this change to take effect, the user must rerun the Budgeting setup.
• Added dimensions for budgeting: We have added these fields to OSR Detailed Budget: Free Date, Tex, and Amount.

---

 

Big changes ahead: New user interface

In November, we are introducing a new look and feel of the portal, with new colors and new icons.

The functionality will be the same, so it should feel quite familiar to you.

For more information, please see: Coming: OneStop Reporting new user interface

What’s new

• Add multiple users to a tenant
• Administration: Changes to terms in Licenses and Module access
• Fixes
• Integration-specific fixes

 

Add multiple users

You can now add up to 50 users at the same time. In the new Add users dialog, you can copy a list of email addresses separated by spaces, line breaks, commas, or semicolons.

NOTE: This feature is only available at the tenant level.

To add users;

1. Click Settings > Administration.
2. (If applicable) Click tenant.
3. Click Users tab.
4. Click + Add users.

5. In the Enter email address field, either type in or paste in the email addresses for the new users.

NOTE: There is a validation process happening when you have added the email addresses. If an email address has the wrong format, it will appear in the Error field to the left. Hover over the Information icon to see the cause of the error. If the error is due to an invalid email address(es), you need to fix the address before you can move to the next step.

6. Select Role, Access Permissions, System Permissions, Data Accesses, and Module Accesses:

• • Roles: If the user(s) you want to add should belong to a role, turn on the switch for the role.

• • Access Permissions: Use the switches to select the access permissions your user(s) should have. For an overview of the various permissions, see User administration.

• • System permissions: Use the switches to select system permissions.

• • Data accesses: Click the + Add button to give access to companies. Click Edit to limit the access permissions.
  • Module access: Use the switches to select module accesses.

Inherited permissions from roles: If you have added the user(s) to a role, you will see the inherited permissions and accesses, and the switches are deactivated.

7. Click Create. NOTE: If you have insufficient licenses, you will get a warning message. The user(s) will be created, but you must manage licenses individually.

 

Administration: Changes to terms in Licenses and Module access

For users with Norwegian language in the portal, there have been some changes to the terms of the user licenses. The changes are made so they match the license terms when the licenses are bought.

 

For more information (in Norwegian), see:

For Cloud integrations: https://help.onestopreporting.com/nb/help/settings/administration/organization/administrasjon-for-leiere/administrere-lisenser-for-leieren/brukerlisenser-roller-og-modultilgang/?type=cloud

For Cloud Agent integrations:

https://help.onestopreporting.com/nb/help/settings/administration/organization/administrasjon-for-leiere/administrere-lisenser-for-leieren/brukerlisenser-roller-og-modultilgang/?type=hybrid

 

Fixes

Fixed date formatting in reports in the portal

Users have reported that even when they change language to a language other than English and refresh the page, the date formatting switches back to English date formatting. We have resolved this issue now.

 

Live Reporting: Remember category after running report

Users have experienced that after selecting a Category in Live Reporting and running a report, the category is not remembered when returning to the report library. The issue is now fixed and the category is still selected after running a report.

 

Integration-specific fixes

Visma Business

Added dimensions: We have added the following items so users can create reports that distinguish transactions for products at the order line level:

• CreDt, CreTm, CreUsr to Actual Transactions.
• OrdLnNo to Product Transactions.

Fixed drill-down error: We have fixed an error in drill-down involving Stock-Balance, where users would receive error messages when drilling down in reports built using this dimension. The issue is now resolved.

Stock-Balance: Adjustments to some amount fields so users can group the amounts: We have made some changes to some of the fields under Stock-Balance so the amounts can be grouped and not be aggregated in reports as they would in the past. The changes include these Amount fields:

• Last FIFO-price
• Max stock in days
• Min. stock
• Min. stock in days
• FIFO price

Price Matrix: Adjustments to some amount fields so users can group the amounts: Similarly to the fix described above, we have also made changes to the Sales Pr 1 – 7 amount fields under PriceMatrix so the amounts can be grouped and not be aggregated in reports.

 

Visma Administration

We have added support for extended fiscal years.

 

Visma.Net

We have added Purchase Receipt (varemottak) to Purchase.

 

PowerOffice GO

Fixed error when using the Active attribute for Accounts: Some users would receive error messages when running reports with the Account dimension when the Active attribute was being used. We have fixed the issue.

What’s New

• Changes to data import time intervals (for Cloud integrations)
• Live Reporting, Budgeting, and Archive: Excel headers are turned off by default
• New liquidity overview report for Visma.net, Visma Business, Visma Global, TripleTex and PowerOffice GO (BETA)
• Fixes
• Integration-specific changes

---

 

Changes to data import time intervals (for Cloud integrations)

We have made changes to the options for time intervals in Get Data > Data import jobs.

In the past, users had multiple options for setting up and scheduling data import jobs, such as Last Quarter, Last Week, etc.

We have now made it easier by reducing the number of options to these four:

• All time (Full import)
• Custom Date Interval (NOTE: This is a rename of Custom Date)
• Days
• Last Year

For scheduling data import jobs, users can now only use the Days option, and the number of days can be no more than 100. However, the other data import job date options may be manually run at any time.

 

New column for Data import period

We have also added a new column that shows the data import period:

 

Effects on existing data import jobs

These changes will affect all existing data import jobs. Existing import jobs will be migrated to corresponding days, or set to 100 if they exceed the allowed number of days.

NOTE: The previous import jobs called Today and Yesterday are migrated to Days (1), and the job called Last Month is migrated to Days (40).

It might be a good idea to check your existing data import jobs to see if they are still suited to your needs. You may also want to check the names of your jobs. Go to Get Data and click Data import jobs. Here, you find the complete list of your data import jobs. In the Data import period column, you can see the period the job covers. If you want to edit the job, click Edit. To delete a job, click Delete.

 

Live Reporting, Budgeting, and Archive: Excel headers are turned off by default

As most of our customers do not need to see the Excel headers in the reports, we have disabled the headers from the default view. We have done this to improve the visualization of the reports. However, you can turn on the headers if you want. To do so;

• In an open report, click the View/Hide Excel headings button.

 

 

 

New liquidity overview report for Visma.net, Visma Business, Visma Global, TripleTex and PowerOffice GO (BETA)

We have created a new report that gives users an overview of the company’s liquidity from today and 30 days ahead. The report only shows data from the financial system and is built on a standard Norwegian chart of accounts. The report contains a separate tab that provides a detailed explanation of the report definition. This is the beta report, so if you discover errors or you see that something is missing, please report this to konsulent.osr@visma.com.

 

Fixes

Live Reporting: Fixed issue with hidden sheets in report packages

We have fixed an issue where users have experienced issues with packaging reports that include hidden sheets. The hidden sheets would not be included in the package and these might include important calculations for the report to work.

 

Integration-specific fixes

Visma Net

• Voucher viewer: Recently, some users have experienced slow performance when viewing vouchers from the drilldown. We have now fixed the underlying issue and users should experience significantly improved performance.

 

24 SevenOffice

• Voucher viewer: We have fixed an issue where users would get an error message when using drilldown to view vouchers.

 

Xledger

• Drilldown for Timesheet Transaction dimension: We have fixed an issue where some users have experienced issues when trying to drill down in Timesheet Transactions.

 

What’s New

• Live Reporting and Budgeting: Added last modified date for templates in List view
• Fixes
• Integration-specific fixes

 

---

Live Reporting and Budgeting: Added last modified date for templates in List view

We have added a column in List view that shows the last modified date for report and budget templates.

To access list view;

• In Live Reporting or Budgeting, click List view.

 

Fixes

Report Designer – Report Parameter Wizard: Limit data range when lookup filter is applied

We have received feedback that when users are applying a filter to the lookup in report templates, the filter would not be effective when they run the report for all data (*) or a range.

The issue has now been fixed.

To limit data displayed in the Lookup, take the following steps in Report Designer;

1. On the OneStop Reporting tab, click Report Parameters.
2. In the Report Parameters dialog, click the Edit button for the parameter you want to limit the data selection for.
3. In the wizard that opens, click Next, and then Next.
4. In the Parameter Value section, in the Lookup filter field, enter the parameter selection, or use the Lookup button to make your selection.

5. Click Finish.

The next time users run the report in Live Reporting, they are only allowed to select from the parameters you have selected in the Lookup filter field.

 

Budgeting: Implemented warning message when uploading a budget template with a pre-existing name

We have implemented a warning message when users attempt to upload a budget template with a name that already exists.

 

Workflow: Dates entered manually in the date field when editing workflows

Users have experienced that when editing the date for a workflow, the dates are not changed if they enter the date manually in the From – To date field (and not using the Date selector and clicking Apply). The issue is now resolved and the dates are changed after clicking Republish.

 

Integration-specific fixes

Visma Net

• Data Manager: We have fixed an issue where users would get an error message when attempting to store to Extension fields for Inventory, Customer, and Supplier.

 

Xledger

• Data Manager: We have fixed an issue with storage error for extension fields for the Account dimension.

 

Power Office GO

• Data Manager: We have fixed an issue where users would get an error message when attempting to store to Extension fields for Supplier.

What’s new

• New report for top (customer) level: User list
• Budgeting: Added Save data button in full-screen mode
• Live Reporting/Budgeting: Widened the parameter drop-down field
• New e-learning courses
• New pricing model for partner accounting firms in Norway
• Integration-specific fixes

---

New report for top (customer) level: User list

We have released a new report for administrators on the top level. This report contains information about tenants, companies, users, and features.

To access the report;

1. Click Settings.
2. Click Administration.
3. Click Top level.
4. Click Reports tab.
5. Click User list.
6. Click Download as CSV.

 

 

Fixes

 

Budgeting: Added Save data button in full-screen mode

We have added the Save data button when users enter full-screen mode in Budgeting.

 

 

Live Reporting/Budgeting: Widened the parameter drop-down field

We have widened the parameter drop-down list field so customers with parameters with long names can see the whole text when making a selection.

 

New e-learning courses

 

Report Designer Tips&Tricks – Report Parameters: In this course, we take a look at how the report parameters work for report definitions in Report Designer. Users learn how Report Parameters is one of the components in OneStop Reporting that allows designers to create a dynamic report so that the same report template can be used for multiple reports with minimal adjustments. More specifically, users learn how to create new parameters, edit existing parameters, how they can be used to create sheet per value, and how to hide parameters and insert a default parameter value.

 

Best practices for creating consolidated reports (For Cloud Agent version): In this course, users will learn how to run the MCL script to prepare their system for consolidation, and how to create consolidated reports, including suggestions for elimination methods.

 

New pricing model for partner accounting firms in Norway

New pricing model for our partner accounting firms in Norway is now released on My Page (Min side). To view the new pricing model, click here . You need to be an admin or partner user to be able to log in and view this page.

 

 

Integration-specific fixes

 

Visma.net

• Changed data import routine for scheduled data import jobs: In the past, we have imported data based on Transaction Date, and thus, requiring us to import a vast amount of data from the past to ensure the inclusion of all pertinent data. We have now changed this routine. Now, we will import data based on the Last Modified date from the past week. By making this change, we are limiting the amount of data retrieval, and the import jobs should execute considerably faster. Essentially, this means that your scheduled data import jobs will now retrieve data from Last Week based on the Last Modified date.
• Added notes to Sales order and Sales-order lines: We have added notes from sales orders so users can get additional information when they create reports on sales orders.

 

Visma Business

• Added link to Line Item Details in OSRBudgetFoundation. This enables users to apply OSRBudgetFoundation in the Spreading tool.
• Added possibility to report on tax code information (avgiftskode). We have added a link to the tax code dimension in AcTr which enables users to report on tax code.
• Added several attributes for group reporting script:
  • For the AcTr dimension:
    • TxCl
    • TxStNo
  • For the TxCd dimension:
    • VatNo
    • TxInf

 

Visma Administration

Added budget data to multi-company reports: Visma Administration users can now see budget data in their multi-company reports.

 

PowerOffice GO

Currency: We have added the OSRCurrency dimension

 

24SevenOffice

Added unique company codes: In the past, companies in 24SevenOffice were identified according to the user that established a connection to them. In other words, companies were associated with the user. That meant that if, for example, two users imported data from the same company, OneStop Reporting would regard these as two different companies. With this new release, we have added unique company codes and they are added to all new as well as existing companies for 24SevenOffice integrations.

 

Uni Economy

Uni Economy update requires re-authentication of OneStop Reporting

Due to an update made by Uni Economy, all OneStop Reporting customers with a Uni Economy connection are required to re-authenticate the connection. The changes were released on June 29^th.

1. Go to Get Data > Connections.
2. Click the connection and click Edit.
3. In the Connect to Uni Economy dialog, click Edit Authorization.
4. Enter your credentials and click Next.

What’s new

• Publisher: Send reports as PDFs
• Administration: Add information about companies
• Administration: Create report for Top (customer) level
• Administration: Search for tenants, companies, and users in the data tree
• New e-learning course
• Fixes
• Integration-specific fixes
• Sunset announcement: End of support for Internet Explorer

---

Publisher: Send reports as PDFs

Users can now send reports as PDFs from Publisher.

1. In Publisher, click New or Edit.
2. Under Recipients, click the Destinations tab.
3. Under User’s email, select the Send reports as PDF checkbox.

NOTE: To get proper PDF formatting, check that the print area is set correctly in the report template. For more information, see Page setup for reports

 

Administration: Add information about companies

On the Companies tab at the tenant level, administrators can now add information about the companies, such as company code, internal project number, or other free text information. Later, the information can be used when using the new reporting tool described below.

To add company information;

1. Click Settings.
2. Click Administration.
3. Click tenant.
4. On the Companies tab, in Free 1, Free 2, or Free 3 fields, enter your free text information.

 

Administration: Create report for Top (customer) level

There is now a new Reports tab for administrators on the top level where they can create a Company List report. Administrators can use information they have added to the Companies tab at the tenant level to create the report.

1. Click Settings.
2. Click Administration.
3. Click Top level.
4. Click Reports tab.
5. Click Download as CSV or Export to Excel.

Example of report exported to Excel

 

Administration: Search for tenants, companies, and users in the data tree

Administrators can now search for users and companies, in addition to the existing search for tenants.

NOTE: You must have access to at least two tenants to be able to see the Search box.

To search for users, companies, or tenants;

1. Click Settings.
2. Click Administration.
3. In the Search box, enter at least three characters to search for users, tenants, or companies. For users, you can search by display name or e-mail address.

 

New e-learning course

We have recently released a new Report Designer Tips & Tricks course, where we take a look at how the property hierarchy works for report definitions in Report Designer; that is, the relationship between sheet, row, column, and cell level.

 

Fixes

 

Publisher: Drop-down lists

We have fixed an issue where some users have reported that sometimes they cannot see the drop-down lists for templates and/or users.

 

Budgeting: Values for reference data in Line Item Details

We have fixed an issue where some users have received wrong reference data values in the Line Item Details. The issue was reported for Visma Business in reports with double expansions on rows where accounts were grouped per information fields. In these circumstances, the system would retrieve totals for all accounts within the selected information fields. The issue is now solved.

 

Integration-specific fixes

 

Visma.NET

• Fenistra integration: We have now created a new integration for Fenistra. The new integration is an extension for Visma.NET users, where they can retrieve data from Fenistra. Please contact Sales for more information about licenses and user access.

 

Xledger

• Added employee code in Lookup display for Employee: When doing a lookup on the Employee dimension, you will now see that the employee code has been added after the name. We have made this change so users are able to distinguish between employees that have the same name, but different codes.

 

24 SevenOffice

• Added Project Leader Employee name instead of a number: Previously, the employee number was displayed instead of the name. This has now been corrected.

 

 

Sunset announcement

End of support for Internet Explorer 11 (from July, 2020)

To align with Visma compatibility guidelines, OneStop Reporting will end its support for Internet Explorer (IE11) on July, 1st 2020, for the version 5 product line. Version 5 product line consists of both the current Cloud version and the OnPremise version. Please note that the 4.x product line is not affected by this.

If you use IE11 we suggest that you switch to another browser, such as Microsoft Edge, Firefox, Safari or Chrome.

What does this mean?
As a result of this end of support, OneStop Reporting will no longer test for or guarantee that you can use OneStop Reporting in Internet Explorer.

Question?
If you have any questions, please contact Customer Success: support.osr@visma.com

 

What’s new

• Single sign-on for Visma users
• OneStop Reporting available from Visma Home
• Visma Business: New open entries report templates
• New e-learning course: Administration – Change ownership of content
• Fixes: Get Data – Changed texts for Data Import Job options
• Integration-specific fixes

---

Single sign-on for Visma customers

Visma users can now sign in to OneStop Reporting using their Visma account. On the sign-in screen, there is now a Sign in with Visma option.

 

OneStop Reporting on Visma Home page

After users have used the Sign in with Visma option, OneStop Reporting will appear on their Visma Home screen. The link will take users directly to the portal without having to sign in.

 

 

OneStop Reporting is now also available from Visma Integrations.

 

Visma Business: New open entries report templates

For our Norwegian customers, open entries report templates for Accounts Receivables and Payables, for customers and suppliers, are now available in the Marketplace ( Get templates). These reports are built on the new Visma Reporting History Customer and Supplier (‘historiske åpne poster’) logic we implemented last month. Please refer to Release Notes for April 2020.

1. In Live reporting, click Get templates.
2. Under Category, filter on Open entries (Åpne poster).
3. Select report templates.
4. Click Install.
5. Click Close.

 

New e-learning course: Administration – Change ownership of content

We have created a new course in OneStop Reporting e-Learning. In this course, users learn how they can transfer content from one user to another.

 

Fixes

 

Get Data: Changed texts for Data Import Job options

Some of our customers have reported that they found the texts for the import options a bit unclear, such as understanding that when using the option Last month, this would import data for the past month until today. We have therefore changed some of the texts in the Select Data dialog box, accessed either from the Data Import wizard or from Get Data > Data Import Jobs > New/Edit. We have changed the text to read “Import data from” and added “and onwards”. In addition, we have changed some of the date option texts for added clarity.

 

Integration-specific fixes

 

Visma.NET

• We have added Total Amount and Total Cost to Inventory Transactions.
• We have fixed an issue when users entered date intervals for Sales Orders. The issue was caused by a wrong datatype for Sales Order Lines (Request On and Requested On).

 

Visma Business

• Voucher viewer – Xml-files ignored: Some customers have experienced getting several xml-files when they drill-down in reports and click to view vouchers. The xml-files are now ignored and only the picture file is visible.
• Added WebPg to Multi-Company Loading

 

Xledger

• We have added Keys to Account CurrencyCode.

 

PowerOffice GO

We have added the Order endpoint to data import jobs again. To avoid too much traffic on the PowerOffice GO API, customers are strongly advised to only set up nightly import jobs that retrieves data for the past month.

 

 

What’s new

• Change ownership of content
• Administration: New Can get templates permission
• New e-learning courses
• Fixes
• Integration-specific fixes

---

Change ownership of content

It is now possible to move content in OneStop Reporting from a user to another user. This ‘change ownership’ functionality can be useful for transferring content, for example, when a user is removed/deleted from a tenant in the portal. A typical situation where this functionality is applicable is when a user ends their employment and another user should inherit their work in the portal.

NOTE: You can only transfer content at the tenant level. Consequently, if the original user is a group user, you must move content from the user for each tenant in the group.

Examples of content that can be moved:

• Reports/Budgets:
  • Reports, Budgets, Report Packages, Categories, Shared Reports to user.
• Workflows:
  • Workflows, assignments, reviewers, and approvers. NOTE: The removed user’s Activity log is not transferred. In that way, comments made by the removed user will not be taken over by the new user.
• Publisher jobs:
  • Publisher job definitions.
• Connections
  • The credentials for the connections are removed and ownership taken over by the receiving user.

 

Steps

Remove user from a tenant and move content to another user

NOTE: There are a few things to consider when moving content: You need to make sure the receiving user has the appropriate licenses, roles, permissions and data accesses or the user might not see all the moved content. Also note that all history of reports and jobs will be removed. If you want to keep historic runs of a report, you need to first send it to the archive, before moving the content.

1. Click Administration.
2. (If you have more than one tenant) Click the tenant.
3. Click Users tab.
4. Click user.
5. Next to the user’s name, click the Options menu.
6. Click Remove user.

NOTE: If the user is a Group user, there will be no option to remove user, only to transfer content. The group user must be removed from the group level.
The Confirm remove user dialog box opens. You will see a list of content that exists on the user’s profile.

7. In the Move content and remove user dialog box, select the Move content before removing user checkbox.

8. (For cloud connections) Clear cloud data connection credentials checkbox.

• • Selected : Removes credentials for existing data connections. If you select this option, the receiving user must reauthenticate (set new password) the data connection. Otherwise, the data import jobs will not be run.
  • Deselected : The current credentials are kept.

NOTE: For both options described above, the receiving user will be able to see all companies that those connections have access to in the connected systems.

9. Under Move content to, select the user you want to transfer content to.

10. Click Next.

11. In the Confirm action dialog box, confirm the action by entering the name of the user being removed.

12. Click the Start moving button.

 

 

Move content to another user

You can also move content to another user without removing the user.

NOTE: There are a few things to consider when moving content: You need to make sure the receiving user has the appropriate licenses, roles, permissions and data accesses or the user might not see all the moved content. Also note that all history of reports and jobs will be removed. If you want to keep historic runs of a report, you need to first send it to the archive, before moving the content.

1. Click Administration.
2. Click tenant.
3. Click Users tab.
4. Click user.
5. Next to the user’s name, click the Options menu.
6. Click Move content.

7. (For cloud connections) In the Move content dialog box, Clear cloud data connection credentials checkbox.

• • Selected : Removes credentials for existing data connections. If you select this option, the receiving user must reauthenticate (set new password) the data connection. Otherwise, the data import jobs will not be run.
  • Deselected : The current credentials are kept.

NOTE: For both options described above, the receiving user will be able to see all companies that those connections have access to in the connected systems.

8. Under Move content to, select the user you want to transfer content to.

9. Click Next.

10. In the Confirm action dialog box, confirm the action by entering the name of the user being removed.

11. Click the Start moving button.

 

Receiving user takes over content from user

The receiving user will get an email from the system, informing that he or she has received content in OneStop Reporting.

NOTE: If the Clear cloud data connection credentials checkbox was selected when moving the content, all credentials for data connections to the cloud ERP system has been cleared. You must reauthenticate them to be able to import data.

 

Live Reporting/Budgeting

• Categories taken over from another user is labeled with a truck icon.
• Reports/budget templates taken over from another user is marked with “Moved from” on the report card.

 

Publisher

• Publisher jobs taken over from another user will still run as scheduled by the original user.
• Publisher jobs (definitions) taken over from another user shows the original user in the Moved from column.
• The new user can edit the publishing jobs they have taken over, and can reschedule, add/remove users from the jobs, etc.

 

Get data

• Connections: Credentials for the connection are removed and ownership changed to the receiving user.

 

Workflow

Workflows, assignments, reviewers, approvers are moved. The moved workflows are shown with the name of the previous owner in the Moved from column.

 

Assignments

The receiving user might get new assignments if the previous content owner had assignments in a moved workflow, such as reviewer or approver. The workflow card will then show the user the workflow assignment is moved from.

 

 

Administration: New Can get templates permission

We have added a new permission for users; Can get templates. In this way, administrators have more control over which users can download budget- and report templates form the Marketplace. Users with this permission switched on will see the Get templates button in the Live reporting and Budgeting modules.

NOTE: Users with the Live Reporting, Budgeting and Report Designer licenses will have this permission by default.

 

New e-learning courses

We have created two new e-learning short videos for administrators:

Administrators at different levels: In this video, we show you what rights and accesses administrators at different levels have in OneStop Reporting. We look at how the administration page looks like for an administrator at the top level, the tenant level, and the group level. We will also go through rights and at which level they can manage users.

Limit users’ data access: In this video, you learn how you can limit the data access for a user.

 

Fixes

Publisher: We have fixed an error that sometimes would occur when running Publisher reports that included certain Date parameters.

Administration: We have extended the number of characters users can enter in Role names. In this way, users can have role names with up to 50 characters.

 

Integration-specific fixes

 

Visma Business

• After several of customer requests, we are pleased to announce that we have finally implemented Visma Reporting History Customer and Supplier (‘historiske åpne poster’) logic. This means you can now create reports that retrieve open entries for Accounts Receivables and Payables back in time. In addition, we will soon have reports using this logic available in the Marketplace (in Norwegian). Subsequently, the previous historical factsets will be removed. Reports built with these will still run successfully; however, no new reports can be built on these factsets.
• We have fixed an issue where budget lines would fail when storing on currency.

 

Visma Global

• We have added OSR Currency to the integration.

 

VismaNet

• We now support Logistics in VismaNet.
• We have implemented some missing attributes to Customer Credit Notes. In this way, users can create reports that retrieves all invoices and credit notes per product.

 

Tripletex

• We have added date of birth and email to the Employee dimension.

 

What’s New

 

Drilldown layout

You can now customize the default drilldown view to display fields of your choice and in the order of your preference.

NOTE: You need the Can customize drilldown layout permission to customize the drilldown view.

 

NOTE: The drilldown view you specify is global (within a company). If you, for example, drill down to General Ledger transactions, the drilldown view will look the same in all reports.

 

Icon	Description
	Dimensions: These are dimensions from the ERP system, such as General Ledger, Sales, etc.
	Fields: These are fields from the selected dimension, such as Account, Account Name, Status, etc.
	Amounts

 

 

Customize the drilldown layout

1. Click Settings.
2. Click Drilldown layout.

 

 

3. (If you have access to more than one company.) From the Select company menu, select the company you want to edit the drilldown for.

4. Under Select dimension, select the module for which you want to edit the drilldown view. For example, if you want to customize the drilldown for reports on General Ledger transactions, click the General Ledger folder.

5. Under the module folder, select a dimension, such as, General Ledger Transactions.
Now, two panes open:

• • Available fields: These are the fields you can select to include in your custom drilldown.
  • Drilldown layout: Here you perform the editing of the drilldown view.
    NOTE: Use default is the default drilldown layout provided by OneStop Reporting.

 

 

6. To start customizing the drilldown view, click the Customize button.
NOTE: When you click the button, you will see a new field in the Drilldown layout list; Field being drilled down. This is the field in the report where the end users click to drill down from. Usually, this will be an amount, such as Net Amount.

7. Edit the drilldown as you want:

• • To add fields to the drilldown; under Available fields, open a fields folder, such as Account, and click Add.
  • To remove a field from the drilldown; under Drilldown layout, click Remove.
  • To change the order of the fields; under Drilldown layout, drag and drop the fields.

8. Click Save.

 

 

Revert to default drilldown layout

1. Click Settings.
2. Click Drilldown layout.
3. (If applicable) From the Select company menu, select the company you want to edit the drilldown for.
4. Under Select dimension, select the module for which you want to edit the drilldown view.
5. Under the module folder, select a dimension.
   NOTE: The customized drilldown dimension is marked with (customized).
6. Under Drilldown layout, click Use default.
7. Click Save. The drilldown layout is changed back to the default layout.

 

 

Example: Change drilldown layout

In this example, we have a default drilldown view as shown in Figure 1.

In the figure, you can see how the default setup looks in the Drilldown layout editor, and in the drilldown view from a run report. As you can see, the order of the columns matches the order in the Drilldown layout section.

NOTE: The dimensions and fields may have different names in your ERP system.

 

Figure 1 Default drilldown view

 

We want to make the following changes to the drilldown layout for reports based on General Ledger Transactions.

• Remove the Region field.
• Move the Net Amount after Description.
• Add Status field.

 

We take the following steps:

1. Click Settings.
2. Click Drilldown layout.
3. Under Select dimension, click General Ledger folder, then click General Ledger Transactions.
   NOTE: The module, dimensions, and fields may have different names in your ERP system.
4. Under Drilldown layout, click Customize.

 

5. Under Drilldown layout, next to Region, click Remove to remove the Region column from the layout.

 

6. Under Drilldown layout, move Net Amount after Description.

 

7. Under Available fields, open the Account folder and next to Status, click Add.
The Status column is added to the drilldown layout.

 

8. Click Save.

If we now run a report in Live Reporting, such as a Profit and Loss report, and drill down, we can see the following effects of the customizing in the figure below:

• the Region column is removed
• the Net Amount column is moved
• a Status column is added.

 

Drilldown before customizing

 

Drilldown after customizing

 

---

Fixes

Long customer names display: Customers who have long customer names have experienced that the name in Administration will only display 30 characters, and thus, will not show the entire customer name. We have fixed this by allowing users to see the whole name by mousing over the customer name.

 

What’s New

• Sign in with Microsoft
• Fixes

 

Sign in with Microsoft

We have now enabled a Microsoft sign-in option for users when signing in to the OneStop Reporting portal.

Users can now choose to use their OneStop Reporting password, or click Sign in with Microsoft to use their Microsoft password.

NOTE: The first time you use Sign in with Microsoft, you must approve this as a sign-in method.

 

Administrators can also require all users to use Microsoft to sign in. See Require Azure Active Directory (AAD) sign-in for all users below.

 

Require Azure Active Directory (AAD) sign-in for all users

1. In the portal, click Settings then Administration.
2. On the Overview tab, under SECURITY > AZURE ACTIVE DIRECTORY, enter the domain(s) to require Microsoft sign-in for all users. NOTE: The domain(s) you enter here, must be an Azure Active Directory domain(s).
3. Click Add.

Now all users are required to use their Microsoft account password to sign in to OneStop Reporting and can no longer use their OneStop Reporting password.

NOTE: If users have access to multiple tenants where one requires Microsoft sign-in and another does not, then they are required to sign in again when switching to the tenant that requires Microsoft sign-in.

 

User signs in with Microsoft account when domain requires Microsoft sign-in

When an administrator has entered a domain under Require Azure Active Directory (AAD) sign-in for the given domains, users will get a Sign in menu where they are asked to select a Microsoft account.

 

Fixes

Cloud Agent: Icon indication status of connection: For a short period, customers have not been able to see the status icon for the connection. This issue is now fixed, so the icon is visible again.

 

 

What’s New

• New Budgeting user license
• Access to Data Manager is now a Permission
• Users are notified when they are added to a tenant
• Playlists in Archive are now sorted by date
• Budgeting: Line Item Details – Expand columns
• Use user’s language when exporting report as PDF

 

Administration: Budgeting user license

We are now introducing a new Budgeting license. Users with this license will have the possibility to budget directly in the Budgeting module. In the past, users were required to have a license for Report Designer to have access to the Budgeting module, but this is no longer necessary.

In addition to budget directly in the portal, they can download budget templates from the Marketplace, and then download the budgets locally if they want. Furthermore, they can assign budget templates to other users and roles. NOTE: This license does not allow users to upload or create budget templates.

Users with the Budgeting license will also get access to the Assignments and Workflow modules.

 

 

NOTE: If given the Can edit data from Data Manager permission, they also have access to Data Manager. For more information, see the section below.

 

Administration: Access to Data Manager is now a Permission

Users can now control access to Data Manager from Permissions in Administration.

To grant a user access to Data Manager;

1. Click Settings > Administration.
2. Click the relevant tenant.
3. On the Users tab, click the user.
4. Under Permissions, turn on the Can edit data from Data Manager switch.

 

Administration: Users are notified when they are added to a tenant

When existing users are added to a tenant, they are notified with information about the user that added them to the tenant.

 

Archive: Playlists now sorted by date

Playlists in Archive are now sorted by date. In the past, users would see their unread playlists at the top of the list. We have changed this because most of our users are primarily interested in their most recent reports.

 

Fixes

 

Budgeting: Line Item Details – Expand columns

Users can now expand columns in Line Item Details if they have large numbers that show a number sign, #, due to lack of space in the column.

Live Reporting: Use user’s language when exporting report as PDF

In the past, some users have experienced that the language of their report changes to English when they export a report to pdf. This is now fixed, and reports will now have the same language as the user has set as their language.

 

More to come…

What’s New

 

Static mode for reports: Remove or keep formulas in run report

Some of our users have very large reports, containing numerous cells with formulas, many that are referring to other cells and functions. This might cause performance issues when running reports in the portal. Therefore, we have made it possible to run reports in “static mode”. This means that all formulas are removed in the workbook and the values are replaced with actual cell values.

Users can control the formula settings for a report template from the Report Properties in Report Designer. On the Reporting tab, there is now a Keep formulas in run report checkbox. If this checkbox is deselected, the formulas are removed from the report.

• The default setting for existing reports is selected (True).
• The default setting for new reports is deselected (False).

NOTE: This option will not have any impact on budgets.

 

Keep formulas in run reports

1. In Report Designer, on the OneStop Reporting tab, click Report Properties.
2. Click the Reporting tab.
3. Select the Keep formulas in run report checkbox.
4. Click OK.

All formulas in the generated report are kept during processing.

 

Remove formulas in run reports

1. In Report Designer, on the OneStop Reporting tab, click Report Properties.
2. Click the Reporting tab.
3. Clear the Keep formulas in run report checkbox.
4. Click OK.

All formulas in the generated report are now removed during processing, and the values are replaced with actual cell values. When formulas are removed from a report, it is no longer possible to make calculations in run reports in Live Reporting.

When formulas are removed from the report template, the drilldown will function as normal.

 

NOTE: For reports that contain advanced formulas, such as IF and INDIRECT in the same formula or when referring to other sheets, it is safest to select the Keep formulas in run report checkbox to ensure the formulas work as intended in the portal.

 

 

Local date format

In the past, there have been issues when using, for example, the Norwegian standard date format; day, textual month, and year. The issue has now been solved and the following setting can be used:

 

Help in current language from Report Designer

In the past, users clicking the Help button in Report Designer would get the default language English. Now, users are redirected to the help in Norwegian, Danish or Swedish depending on their language settings.

 

Integration-specific fixes

Visma.net

Last month we implemented changes on how we retrieved data from certain endpoints for Visma.net. The changes entailed retrieving data based on the LastModifiedDate parameter instead of transaction date where it was possible. However, due to limitations in the information we can retrieve from the Visma.net API, we must roll back these changes. All data are now retrieved based on transaction date.

 

Xero

• Drill-down details: Users can now see contact name in the drill-down and not only the description.

 

Tripletex

• Included IsClosed during the accounting period in Tripletex by adding the Ledger/Accounting Period endpoint.

 

PowerOfficeGO

• Added BudgetService endpoint.

What’s New

 

Introducing Multi-Factor Authentication in OneStop Reporting

To enhance user security in OneStop Reporting, we have made it possible to use Multi-Factor Authentication (MFA) when signing in to the portal.

MFA is an enhanced security system that verifies a user’s identity by requiring two or more forms of authentication. Rather than just asking for a username and password, MFA requires additional credentials, such as a code from the user’s smartphone.

MFA is an effective way to provide increased security. Usernames and passwords can be stolen, and they have become increasingly susceptible to brute force attacks. MFA creates multiple layers of security to help increase the confidence that the user requesting access is actually who they claim to be.

With MFA, even if an attacker manages to learn the user’s username and password, it is useless without also having possession of the additional authentication method. In OneStop Reporting, MFA works by requiring two authentication methods:

• Something you know (username and password)
• Something you have (an authenticator app on your mobile device)

 

 

What is an authenticator app and how does it work?

An authenticator app is usually installed on a smartphone and you scan a barcode or enter a key to create an account. After the account is created, the authenticator app generates a 6-8 digit passcode every 30 seconds. The passcode can, for example, be used for login as an extra authentication method in addition to a username and password.

The passcodes are generated from a secret code that is shared between the service you are using, such as OneStop Reporting, and your device, as well as the current time.

 

Google Authenticator app example

 

Where can I get an authenticator app and which one should I use?

There are a variety of authenticator apps you can download to your phone from Google Play and the IOS App Store, but we recommend that you use Google Authenticator or Microsoft Authenticator, as those are the ones we have fully tested our MFA solution on.

Authenticator apps in Google Play

For more information about installing and setting up an Authenticator app, see Install and set up an Authenticator app

 

---

How can I get MFA in OneStop Reporting?

In OneStop Reporting, users can set up MFA from their user settings. In addition, administrators can enforce an MFA policy for all end users. See the user procedures below for more information:

• User enables and sets up Multi-Factor Authentication
• Administrator at top level enables Multi-Factor Authentication policy for all users

 

 

---

(Option 1) User enables and sets up Multi-Factor Authentication

1. Take one of these actions:

• • Click Settings > User settings.
  • On the Home screen, in the upper right-hand corner, click User options > Profile.

1. On the My profile tab, under Security, turn on the Enable Multi-Factor Authentication switch.
2. Install an authenticator app on your mobile device.
   NOTE: You can, for example, use Microsoft Authenticator or Google Authenticator from Google Play or App Store.
3. Scan the image on the screen into your authenticator app.
   NOTE: If you cannot scan the image, you can enter the code you see under If you are unable to scan….
4. In the Code field, enter the code from your authenticator app.
5. Click Verify.

 

You have now set up MFA for your OneStop Reporting user profile. The next time you log in to OneStop Reporting portal, you must enter your username and password, and then enter a verification code from your authenticator app.

Click here for video on how to set up MFA on your account:

 

 

User logs into OneStop Reporting with Multi-Factor Authentication

1. In the Username/Email field, enter your email or username.
2. In the Password field, enter your password.
3. In the Verification code dialog, enter the code from your authenticator app.
4. Click Verify.

If you do not have a verification code, click the Do not have a code? link to read more about the MFA setup.

 

---

 

(Option 2) Administrator at top level enables Multi-Factor Authentication (MFA) policy for all users

1. Click Settings > Administration.
2. On the Overview tab, under Security, turn on the Require Multi-Factor Authentication for all users switch.

NOTE: You can click the More information link to read more about Multi-Factor Authentication (MFA).

Multi-Factor Authentication (MFA) policy is now enabled for this organization. All users must use MFA to sign into the underlying tenants and groups.

 

 

User sets up MFA

If your administrator has enabled a Multi-Factor Authentication (MFA) policy for your organization, you will receive a message:

Your organization’s security policy requires you to set up Multi-Factor Authentication (MFA) for your account.

1. Click Next.
2. Install an authenticator app on your mobile device.
   NOTE: You can, for example, use Microsoft Authenticator or Google Authenticator.
3. Scan the image on the screen into your authenticator app.
   NOTE: If you cannot scan the image, you can enter the code you see under If you are unable to scan….
4. In the Code field, enter the code from your authenticator app.
5. Click Verify.

 

 

You have now set up MFA for your OneStop Reporting user profile. The next time you log in to OneStop Reporting portal, you must enter your username and password, and then enter a verification code from your authentication app.

 

User logs in to OneStop Reporting with Multi-Factor Authentication

1. In the Username/Email field, enter your email or username.
2. In the Password field, enter your password.
3. In the Verification code dialog, enter the code from your authenticator app.
4. Click Verify.

If you do not have a verification code, click the Do not have a code? link to read more about the MFA setup.

 

---

---

Administration: Changes to Group User permissions

We have added an option in Administration for Group Users, so that users can be added with full access permissions in all subtenants (data access, drilldown, etc.) without being administrators.

The three options for Group Users are now:

• If you want to grant a user Group Administrator rights, turn on the Group Administrator switch. A Group Administrator can manage group users, and create new tenants and subgroups. In addition, they can manage licenses for users and manage the connections for the tenants in the group.
• If you want to grant a user rights to manage users only for the tenants in the group, turn on the Manage users switch. This permission allows the user to see the Administration pages for the tenants in the group. Users with this permission will also automatically get All permissions.
• If you want to grant a user all permissions for all tenant in the group, turn on the  All permissions switch. This permission gives the user all Access Permissions in the tenants, such as full data access, importing company data, drill-down, etc. without having administrator rights. These users will not be able to see the Administration pages under Settings.

 

 

Assignments: Download budget from assignment

It is now possible to download a budget as an Excel file from an assignment in Assignments. The Download functionality is available both for single assignments from Budgeting and assignments in a workflow.

 

Fixes

 

Assignments

We have fixed an issue where some users have experienced getting error messages when selecting parameters for their assignments (when the Let User Decide option is selected for parameters in Workflow).

 

eLearning

We have fixed an issue that would cause some users not to be able to log in to the eLearning portal.

 

Integration-specific fixes

 

PowerOffice GO

• Added Parent.Department and Parent.Location to the Project dimensions.
• Fixed an issue where import would fail for Customer on Recurring Invoice.
• Added Vat Number to Companies for Group Reporting so users can get Company Id in reports.
• Changed order for drill-downs in reports: We have changed the order of the voucher links to always be displayed in the first column.

 

QuickBooks

• Fixed an issue where accounts were stored as blank when using subaccounts.
• Fixed an issue where General Ledger reports would fail on import.

 

VismaNet

• Added attributes Quantity and Inventory Number to Journaltransactions. In this way, users can create reports that extract cost per item.
• Fixed an issue with Customer Invoices where some users have experienced to receive duplicate values.

 

VismaBusiness

• Added Capital Asset Transactions to group reporting.

 

Visma eAccounting

• Fixed an issue with Supplier truncate error.

What’s New

 

Live Reporting/Budgeting: Upload, duplicate, create new, and download report or budget templates directly to Categories

If you have ( ) selected a Category in Live Reporting or Budgeting, and select to upload, duplicate, create new, or download report/budget template(s) from the Marketplace, the report(s) is automatically added to the selected Category.

NOTE: You can select multiple categories to add report/budget templates to.

NOTE: Click here to learn more about managing categories in Live Reporting, or here to learn about managing categories in Budgeting.

 

Example: Automatically add new report templates to a Category or categories:

1. In Live Reporting, in the Search & Filters pane, select the Category or categories you want to add report templates to.
2. Click Get templates.
3. Select ( ) the report templates from the list.
4. Click INSTALL.
5. Click Cancel.

The report templates are added to the Category/categories you have selected.

 

Live Reporting – Using the mouse to select range of parameter values in the lookup

In the past, users had to press Ctrl/Shift to select multiple values in the parameter lookup. Now, users can click a value, then click again and scroll to select a range of values.
NOTE: This only applies to reports that allow multi-selection for parameters.

 

 

Report Designer: Changes to Conditional storage Settings on the Budgeting tab

Store even unchanged cells has changed name to Store unchanged cells. The logic remains the same: This option will force data from this cell to always be stored. The application will not do a check whether the input cell has changed its value or not.

Ignore cell value 0 has changed name to Delete transactions if cell value is 0, and will now have the following logic:

• If the option is selected and the cell value is 0 (either entered or calculated), the underlying record will be deleted.
• If the option is deselected and the cell value is 0 (either entered or calculated), the number 0 will be stored in the underlying record.
• If the Delete transactions for empty cells checkbox is selected, and the user clears the cell by pressing delete or backspace (or by formula), the underlying record will always be deleted regardless of whether the Delete transactions if cell value is 0 option is selected or not.

Suppress delete has changed name to Delete transactions for empty cells. The logic remains the same: If this option is selected, the value is used to update existing/insert a record in the storage dimension. This will also apply to transactions where there has been a value that has now been set to 0/blank/deleted.

 

 

Fixes

Report Designer: Improvements to Expressions and KPI functionality

For this release, we have worked on improving the KPI and Expressions functionality in Report Designer. Specifically, we have implemented the following fixes:

• Possible to create KPIs based on multiple factsets
• KPI and Expression filters now only require quotes if datatype is a string
• Filters now support operators for strings (begins with, ends with, like, contains)
• Possible to use KPIs with multiple expressions.

 

Report Designer: Groups automatically set to None when a user deselects the Expanding checkbox

We have fixed an issue where users have experienced that the grouping on the Grouping/Sorting tab would still be active even if they deselected the Expanding checkbox. This would cause the group to still expand. The issue is now fixed, so that when a user deselects the Expanding checkbox, the grouping is now automatically set to None.

 

 

 

 

Integration-specific fixes

 

Visma Net

• VAT amounts: We have fixed an issue where VAT amounts added to every Invoice Line would cause summation errors.
• Reporting on cost of goods sold per unit: We have added the InventoryReceiptLines factset so users can report on the cost of goods sold per unit.
• Drill-down in reports: We have changed the order of the voucher links to always be displayed in the first column.

 

 

Tripletex

• Companies for Group Reporting issue: We have fixed an issue where the Companies for Group Reporting would not work when using the Activity dimension under Time Sheets. This issue is now fixed.
• Added Department Number (Avdelingsnummer) to Department (Avdeling): In this way, users can create reports based on department numbers.
• Drill-down in reports: We have changed the order of the voucher links to always be displayed in the first column.

 

 

Xero

• Calculation of unrealized currency: We have fixed an issue where the calculation of unrealized currency gains would fail when account numbers and names were changed.
• Data Manager – Deleting values from Line Item Details: We have fixed an issue where users deleting a value from one of the extension fields for a dimension or factset would cause reports to fail.

 

24SevenOffice

• Drill-down in reports: We have changed the order of the voucher links to always be displayed in the first column.

 

What’s New

 

Get Data: Option to lock connections

We have now made it possible for users to make a connection private in Get Data > Create new connection/Edit connection. This can be very useful for users that have multiple companies in a connection and want to prevent users with the Can manage connections permission from editing the connection. Even if a connection is locked, the users with the Can manage connections permission will still see the connection, and are able to create data import jobs for the connection (for companies they have data access to), but it will be locked for editing.

NOTE: Administrators at the top level can still manage all connections, even locked connections made by other users.

 

When you first set up a connection, or if you click Edit on an existing connection, you will now see a Allow other users to edit this connection switch. The switch is off by default.

• If you turn off the switch, only you can edit a connection, such as adding other companies etc. All users with the Can manage connections permission will see the connection, but the connection will be shown with a Lock icon next to it. Please note that they can still create data import jobs for the locked connection.

 

• If you turn on the switch, all users with the Can manage connections permission are able to edit the connection.

 

IMPORTANT: If a connection is not private, users with the Can manage connections permission can see all companies in the connections, even companies they do not have data access to.

NOTE: All existing connections will be locked to the user who created the connection initially.

 

Changes to Connections display in Get Data

As mentioned above, the new lock connections option also affects how connections are displayed in the Get Data > Connections list.

In the past, the Connections list was filtered, for example, according to which companies users had data access to. Now, we have changed this, and users with the Can manage connections permission will see all connections that exist in a tenant, even connections they cannot edit (that are locked ). If a connection has the Allow other users to edit this connection switch turned on, users that are allowed to manage connections will also see companies they do not have data access to.

NOTE: Now that users with the Can manage connections permission can see all connections, they can also see all Connection names. Users creating connections should therefore be careful when they select connection names.

 

Edit budget templates in published workflows

It is now possible to edit a budget template in a published workflow.

When you edit a budget template that is part of a workflow, you will receive the following message:

“This budget template is used in assignments or workflows. If you choose to edit this budget template, these assignments or workflows will be updated.
Please be aware that any changes you make may affect the budgeting process.
NOTE: Make sure you do not change any report parameters as this will prevent you from publishing your changes.”

 

 

To edit the budget template, click Edit anyway.

You can edit most aspects of the budget templates apart from report parameters. If you attempt to edit the report parameters, you will not be able to publish and must undo the edit.

To undo the edit;

1. In Budgeting, click in the top right corner to show details of the budget template.
2. Click Undo edit.

 

 

After you have edited a budget template that is part of a workflow, the assignees must rerun any templates they have run before.

If they have the budget template open, they will receive a message from the system that the template is updated. If they run the template, they will lose any changes they have done since they last saved.

 

User administration: Added Download to Excel as a permission

We have added a new permission in the user settings to allow administrators to control whether a user should be allowed to download a report in Archive as an Excel file or not. If a user does not have this permission, the report can only be downloaded as a pdf.

This can be useful if there are parts of a report, such as hidden data, that you do not want other users to see.

 

 

• If users have the switch turned on in their Permissions, they are allowed to download reports as Excel files in Archive.
• If users have the switch turned off in their Permissions, they are only allowed to download reports as pdf files in Archive.

 

 

Get Data: Search & Filter menu open by default

To make it easier for users to find the Search & Filter menu in Get Data, we have made it open by default the first time a user enters the screen. If a user collapses the menu, the Search & Filter menu will be collapsed the next time the user enters the Get Data module.

To collapse the Search & Filter menu;

• Click .

To expand the Search & Filter menu;

• Click .

 

Fixes

 

Data Manager: Prompt to confirm action when leaving page without saving

Users will now get a Confirm action dialog box if they leave or refresh the Data Manager without saving their work.

 

 

Data Manager: Possible to use comma as a decimal separator

We have made it possible to use comma as a decimal separator in Data Manager when users have selected a portal language in which comma as a decimal separator is the standard. In the past, Data Manager would disregard commas as a decimal separator and, for example, change 0,1 to 1 when numbers were saved.

 

Archive: Fix for toggle vertical/horizontal when opening multiple reports

Some users have experienced that the Vertical/Horizontal toggle button has disappeared when they open multiple reports in Archive. The issue has now been fixed.

 

 

All new report templates in Marketplace now have information again

All report templates in the Marketplace (Get templates) should have information about the reports. Recently, there has been some report templates missing this information. The issue has now been fixed.

To get information about the report template;

1. In Live Reporting, click Get templates.
2. Mouse over a report template card until you see a question mark.
3. Click the Question mark.
4. Click X to close the Information box.

 

 

Live Reporting: Scrollbar in Marketplace

For customers with a large number of Categories in the Marketplace, we have added a scrollbar.

 

 

Get Data: Improved performance for viewing the log data import jobs

We have improved the performance when viewing the log for data import jobs. For customers with a large number of data import jobs, some users have experienced slow performance when viewing the logs.

 

Report Designer: Improved performance

We have implemented fixes to improve the performance and stability of Report Designer. Customers should experience fewer crashes and faster performance after upgrading to the newest version of Report Designer.

 

Report Designer: Improved Norwegian translations

We have improved the Norwegian translations in Report Designer for 24SevenOffice, VismaNet, and PowerOfficeGO.

 

Integration-specific fixes

 

Xledger

Important changes in the Account dimension

We have seen the need to make changes to the Account dimension for Xledger. The reason for the change is that there may be multiple accounts with the same account number in Xledger, and OneStop Reporting will use these values when users save budget transactions.

Specifically, we have created a new dimension that is a combination of account number and account name. The new dimension will be called “Account Unique”. The existing dimension called “Account” is moved down and becomes an attribute of this new dimension.

 

What are the consequences?

The old Account field will disappear from the user’s budget solutions and will need to be replaced by the new Account Unique field under Storage rules.

 

 

24SevenOffice

Changes to the Sales module

We have changed the logic for Sales Orders and Order Lines under the Sales module which may have consequences for our 24SevenOffice customers.

Previously, these Factsets have shown the same information, but there has been a difference in the logic regarding invoice date and order date:

• Sales Orders had the following logic: First, it looked at Invoice Date, and if it had no value, then it looked at the Order Date.
• Order Lines: Here it was the other way around; first it looked at Order Date, and if it had no value, then it would look at Invoice Date.

We have now changed OrderLines to have the same logic as Sales Order. This means that it first looks at the Invoice Date, then the Order Date.
As a consequence of this change, customers may find that the figures in reports where OrderLines is used might change the corresponding period.

 

VismaNet

We have added Customer/Supplier/Inventory subfields as attributes so customers are able to do cross-reporting with these fields.