One of the enhancements to Bevica, powered by Business Central, included in the recent 2022 Wave 2 update was the renaming of Account Schedules as Financial Reports. In this blog we take a deeper look at this change and how it affects Bevica users who use this functionality.

What are the changes?

Account Schedules have now been renamed Financial Reporting and come with a predefined set of reports ready for you to use and configure. This enhancement has made it much clearer to users that the layout is any combination of Row and Column details.  Row details such as Balance Sheet, Profit and Loss, Campaign Analysis, Cashflow can be set against a range of Column details. Examples include Actual vs Budget, Period on Period, Net Change.

You can also add in additional filters (Dimension Codes) such as Cost Centre, Customer Type, Brand, Product Group, Salesperson, etc. to make the reports more relevant or specific to your organisation.

Details of the new features

  • Authorised users can find Financial Reports using the system wide search feature, within the Finance menu, as well as links from relevant Home pages.
  • Bevica comes with a set of ready-made reports out of the box. You can also amend existing ones, copy and amend, or create brand new ones from scratch.

The Financial Report Page

The Financial Report page now allows you to manage your financial reports in even more detail:

  • Select your date parameter with periods:  Day / Month / Year / Quarter/ Year/ Accounting Period.
  • New functionality added is the ability to set priority lines. Using Show All Lines (set by toggling on or off) you can show/hide selected lines on screen as well as output to excel and printed report.
  • The Dimensions section lets you further analyse your data by, for example, filtering the report’s information to a specific dimension value, cost centre, customer group, event or campaign. You can also add Budgets, at row or column level, with dimensions and this will allow you to compare actuals against budgets.
  • Moving between periods is much easier with the Next / Previous Period buttons.
  • The Export to Excel tab allows you to send the report to Excel, create a new workbook or update an existing one.
  • Each report can be scheduled, so you’ll have them ready and waiting at whatever time and date you set.

Editing Row and Column Definitions

The objects that were previously known as account schedules are now call Row Definitions. Column Layouts have now become Column Definitions.

  • Both Row Definitions and Column Definitions have their own edit functions, Edit Row Definition and Edit Column Definition.
  • You can define a default column layout and an analysis view for Row Definitions.
  • You can now copy column definitions which makes it easier to make variants of a column definition.
  • Each Financial Report has its default Column and Row definitions but you can you mix and match, creating some interesting combinations.

What does this mean for Bevica users?

If you are new to Financial Reports in Bevica, you’ll find them simple and intuitive to use. If you were a fan of using Account Schedules to create user-defined finance reports, the introduction of the Financial Reports functionality will be very popular. The update has improved the overall user experience and made them easier to manage. This is the basic out-of-the-box reporting functionality which is included with Bevica and Bevica Select. For more in-depth reporting there is also Power BI and Jet Reports from insightsoftware.

How we can help you

If you want to know more about Bevica (powered by Microsoft Dynamics 365 Business Central) and how it could help your drinks business, please feel free to contact us to arrange a demo to see how it could be the perfect ERP to help you overcome your business challenges.