Tag: Microsoft Dynamics 365 Business Central 2022 Wave 2

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.

While Dynamics BC allows you to create as many dimensions and dimension values as needed, there is some additional functions which can make entering transactions along with dimensions easier.

These are the Global and Shortcut dimensions which are set on the General Ledger Setup page:

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Global and Shortcut Dimensions”

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.

As mentioned in the last article of this series, Dynamics BC uses dimensions for analysis of postings to G/L accounts. Maintaining them is quite straighforward.

To do this search for Dimin the Tell me what you want to do and select Dimensions; this will open the Dimensions page which will list any existing dimensions:

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

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 an earlier article of this series, on understanding the chart of accounts, I commented that Dynamics BC differed from some ERP systems by only having the GL account itself in the chart of accounts where other systems also include cost centres and other elements required for reporting.

Dynamics BC does allow for reporting on these other elements, but manages them through dimensions rather than the chart of accounts itself.

Microsoft themselves describe dimensions as:

Dimensions are values that categorize entries so you can track and analyze them on documents, such as sales orders. Dimensions can, for example, indicate the project or department an entry came from.

So, instead of setting up separate general ledger accounts for each department and project, you can use dimensions as a basis for analysis and avoid having to create a complicated chart of accounts.

There isn’t a single client I have worked with over the last 20 years who does not have a need for dimensions (or similar) as no-one reports only on the G/L account. Other values to be stored in dimensions would commonly be:

• Cost Centre
• Department
• Region

Dimensions can also be used to store non-financial analysis codes such as:

• Project
• Budget Holder

The above are just examples of some of the type of analysis codes I’ve seen in the past working with clients.

Dynamics BC allows financial postings to be filtered based on the GL account and on the dimension values selected against the posting. Over a few posts in this series, I am going to take a look at setting up and maintaining dimensions, setting defaults, combinations and priorities as well as viewing data posted with dimension values assigned to them.

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.

When you have created your G/L Accounts, you can view the created accounts in the Chart of Accounts list.

As you can see from the below, the list of accounts is indented based on the Begin/End-Total rows. This is not something which happens by default, but is the result of running a process to indent the accounts. This same process also calculates the accounts included in the End-Total row so that the end total includes all accounts from the preceding Begin-Total:

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Indent Chart of Accounts”

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 creating a new G/L account.

There is a few considerations when creating a new account:

1. The No is important as this will control where the account shows in the char of accounts and some of the reports.
2. Expansion space should be allowed in the chart of accounts numbering, to allow for new accounts to be created in the future and have them appear in the correct place.
3. The No does not have to be all numeric, it can be a mix of alpha and numeric characters.

New accounts, regardless of type, are created from the Chart of Account list page by clicking on the New button to open the G/l Account Card window:

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

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 (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”

I’ve been doing a lot of work with a client to, amongst other tasks, implement the Fixed Asset module in Microsoft Dynamics 365 Business Central. We ran through the configuration and then started testing that everything worked correctly.

It was all going well until we tried to calculate depreciation when we encountered an error message:

Continue reading “Error Calculating Depreciation in Microsoft Dynamics 365 Business Central”

As I announced in September, I am now working with Microsoft Dynamics 365 Business Central. I have been climbing a steep learning curve, but I think I’ve got a handle on most of the basics now.

It is sometimes the little things which are catching me out. I was doing some testing with fixed assets and ran into an issue trying to enter an asset acquisition:

Continue reading “FA Posting Type Must Not Be “” on a General Journal in Microsoft Dynamics 365 Business Central”