Category: Business Central (Nav/Navision)

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Now that we’ve introduced the chart of accounts we can take a look at the types of G/L Account which can be created.

There are five types of account type in Dynamics BC:

1. Posting – this account type is the one which allows you to post figures to the general ledger. Most of the G/L accounts you will create will be posting accounts.
2. Heading – this is an account which is used to display a heading in the chart of accounts. An example of this would be an account called BALANCE SHEET or INCOME STATEMENT.
3. Total – when you want to add create ad hoc total of some accounts. This is used when you are not creating a sub-section within the chart of accounts, such as when creating an account for the net income which would be a total of the net income.
4. Begin-Total and End-Total – these account types are used in pairs to create section sub-totals in the chart of accounts, Financial Reporting (formerly called Account Schedules) and other reporting tools.

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In the last post of this series, I ran through what account categories and subcategories are and thought I’d give a quick run down on how to maintain them.

To do this use Tell me what you want to do and type acc cat and select the G/L Account Categories entry; when the list page opens click the Edit List button on the action bar which will switch the page out of read-only mode:

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain G/L Account Categories”

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

One of the things I find somewhat unusual with Dynamics BC is that the setup of the chart of accounts, and some related information, isn’t just setup data but is also used to organise and present data. As we saw in the article on the chart of accounts, that list showed the Net Change and Balance of the accounts as well as some of the setup fields. The G/L Account Categories list is no different:

The above screenshot shows the G/L Account Categories list in the Cronus USA, Inc sample company; you can find this by clicking the Tell me what you want to do search button in the top right and type acc cat and select the G/L Account Categories. The list shows not only the categories, which I would expect to see, and the subcategories, but also the G/L Accounts included in the categories and the balance of those G/L Accounts.

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand G/L Account Categories and Subcategories”

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Each ERP system hand;es the chart of accounts in slightly different ways. Coming from an Microsoft Dynamics GP background I am used to the accounts being multi-segment and containing cost centres as well as the general ledger account. So for example, if I had an account for the North region IT department for purchasing of office supplies, I might have an account with a structure of N-300-61400.

Dynamics BC does not work in the same way as this. In Dynamics BC you would have an account of 61400 in the chart of accounts and then the cost centres of Region and Department would be managed as dimensions. The accounts are created through the G/L Account Page.

When you design the chart of accounts in Dynamics BC, you also create headings and totals through the G/L Account Page and can assign categories and subcategories which are used in financial reporting.

When creating the accounts, they need to be numbered in the order in which they should be included in the chart of accounts list, which is important for the totaling of sections for financial reporting.

Below is an example from the top of the Cronus USA, Inc sample company:

As you can see, 10000 is a heading, 10001 is the beginning of a total section and has 10990 as the end total; the value in the Totaling column shows that rows 10001 to 10990 inclusive are included in the total (which it is technically possible to amend the cells included in an End-Total it should not be done as there is an indenting function which will override any changes).

You can also create specific Total rows where you manually specify what should be added together, which is useful for creating a row like Net Income.

Over the next few posts in this series, I’m going to take a look at the process for creating new accounts as well as some of the other data used by them, such as account categories and subcategories, and will then take a look into dimensions.

I have recently started working with Microsoft Dynamics 365 Business Central and have decided to blog about it as I learn; I’ve started a In Microsoft Dynamics 365 Business Central, how do I… series which will include everything, but have also decided to break that down into a set of smaller series on specific areas of Dynamics BC.

This is the series index for the Financial related posts I will be writing. The series index, below, will automatically update as each post in the series goes live so make sure you bookmark this post so you can see keep up-to-date with my journey into Business Central.

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Series Index”

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In an earlier article in this series, I introduced the different types of pages used within Dynamics BC. I thought it might be useful to give a run through of how to use each of the pages; in this post, I’m going to take a look at worksheet pages.

Like document pages, worksheet pages are transaction pages. However, they differ from document pages in that they can hold multiple transactions rather than just a single one.

Due to this difference, a worksheet page is structured differently. They consist of a small number of header fields, such as for a batch number, along with a list page style section for entering multiple data rows. This is sometimes followed by a section containing either additional data fields or totals.

There are many worksheet pages in Dynamics BC, including, but not limited to, general journals, price, pick and put-away worksheets.

An example of a worksheet page is the one for General Journals:

Continue reading “In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Worksheet Pages”

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In an earlier article in this series, I introduced the different types of pages used within Dynamics BC. I thought it might be useful to give a run through of how to use each of the pages; in this post, I’m going to take a look at document pages.

Document pages are used for single documents where there is a header and related document lines. There are many types of documents which use this type of page, including, but not limited to, purchase orders, purchase invoices, sales orders.

To an extent, a document page is like a card page in that you have the action pane at the top, factpane at the right side and the content is split into fasttabs which behave the same as on the card page. The difference on a document page is that there is a section for the document lines:

This section cannot be folded up in the way a fasttab can. The document lines field is a typical listview with one line per document line with a need to scroll side to side-to-see all of the columns contained within.

The document line field has its own action pane which is very like the main one on the window, but all of the actions are specific to the lines; there are duplicates where there are duplicate actions for the document header and lines. One example would be Dimensions.

Continue reading “In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Document Pages”

This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1.

The eighth of the new functionality in the User experiences section is Improved alignment of headers in statistics pages.

The default behavior across Business Central is to right align numeric fields and left align text fields. However, when pages display fields arranged in special tabular layouts, such as customer statistics or on most journal footers, the mixed data types often result in column headers being misaligned with their data. With this update, users benefit from improved readability of data with automatically aligned headers.

Enabled for: Users, automatically
Public Preview: Feb 2023
General Availability: Apr 2023

Feature Details

• Improved readability: When a fixed layout group control is used on a page, Business Central automatically detects the first visible value in a column, and the header is left-aligned or right-aligned accordingly.
• Just works: No additional effort is required from developers to specify alignment.

My Opinion

This sounds like a simple change which will, as advertised, improve visibility by displaying data with a consistent alignment.