Category: Business Central (Nav/Navision)

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 Sales 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 (Sales), how do I… Series Index”

This post is part of the In Microsoft Dynamics 365 Business Central (Purchasing), 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.

The setup of specific posting groups tends to be simpler than the general posting groups, in that there is only one page in which you need to enter data.

Do create one, search for vendor posting groups:

Continue reading “In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Create a Vendor Posting Group”

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 Purchasing 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 (Purchasing), how do I… Series Index”

For a recent training session on the general ledger in Microsoft Dynamics 365 Business Central, I covered recurring journals with the client. One of the requirements, for accruals, is that the journal be posted on the last day of the month.

If every month was of an equal length this would be quite easy to do using a date formula of 1M, but they aren;t so a more complex date formula is required.

To post the journal on the last day of a month, every month, the date formula required is 1D+1M-1D, which means add 1 day, add 1 month and subtract 1 day from the posting date. With this formula Business Central calculates the date correctly regardless of how many days are in the month.

I was doing some training for a client last month where I was showing them how to process on the general ledger in Microsoft Dynamics 365 Business Central and encountered an error when we were looking at recurring journals for accruals:

Continue reading ““There is nothing to post because the journal does not contain a quantity or amount” Error in Microsoft Dynamics 365 Business Central”

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 have created the general business posting groups and general product posting groups we have the key pair combinations needed to configure all of the general posting setup.

You can access the general product posting groups on a filtered basis by opening the page from either the General Business Posting Groups or General Product Posting Groups windows or, as I am in this post, seeing an unfiltered list of all of them by searching for and opening General Posting Setup:

After entering the key pair of Gen. Bus. Posting Group and Gen. Prod. Posting Group you can enter a Description and then enter all of the accounts which should default.

At the simplest level, only the Sales, Purchase and COGS accounts are required, but you would be better served entering the G/L accounts for the other transaction types you process or for discounts if you use them. As you go across the page you will have accounts to set for sales, purchasing and then inventory.

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.

After creating the general business posting groups, the next element to create is the general product posting group, which is the “what” part of the key combination to the general posting setup. There “what” is often something like retail/trade/services.

To configure, search for general product posting groups and enter the Code and Description for each of the required general product posting groups:

Enter a Code and Description for each of the codes; you can also enter a Default VAT Business Posting Group and whether this should Auto Inert the Default.

As Business Central saves as you work, you can just close the page when all of the required codes have been entered.

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.

To configure the setup for general posting roups requires three steps, which I’ll start covering in the first post of this series and complete in the next two.

The first element to configure is the general business posting group, which is the “who” part of the key to the general posting setup. This is often setup for regional groups such as domestic, European or ROW (Rest of World).

To configure, do a search for and select the General Business Posting Group page:

Enter a Code and Description for each of the codes; you can also enter a Default VAT Business Posting Group and whether this should Auto Inert the Default.

As Business Central saves as you work, you can just close the page when all of the required codes have been entered.

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.

On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.

In the UK, Tax Posting Groups are known as VAT Posting Groups and like the general posting groups, the VAT posting groups use a combination of business and product posting groups in combination which determine the VAT code and rate which should be applied.

For example, you might have a VAT Business Posting Group of UK and a VAT Product Posting Group of S which combine to give the rate of 20%, which is setup in the Tax Posting Setup.

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.

On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.

At the simplest level, a specific posting group, such as the Vendor Posting Group, is used to determine the accounts which would always be the same for the record type. In the case of vendors, this would be the accounts payable control account, discount, rounding accounts and so on.

The Inventory Posting Groups are slightly different as they can be combined with the location to allow different G/L accounts per site to be used.