Financial Management in Business Central

You can manage all common finance processes and information such as posting financial transactions, preparing financial statements, managing bank accounts, inventory costs, manufacturing costs, and fixed assets in Business Central.

Chart of Accounts

When you create a new company, you must first set up a chart of accounts and configure the posting processes. The chart of accounts in Business Central looks something like this:

Use these accounts to post transactions to the general ledger. You can setup balance sheet accounts and income statement accounts. Besides the basic setup, you can also set up advanced features related to GST.

Once G/L accounts are created, you can then use them in sales and purchase documents and in general journals to post transactions to the general ledger.

Dimensions

In Microsoft Dynamics 365 Business Central, you can make use of dimensions for advanced transaction analyses.

You can set up dimensions and then assign multiple dimension values to each dimension. Once dimensions are set up, you can assign default dimensions to customers, items, vendors, G/L accounts, jobs, resources and many more.

Examples: Before posting sales, you can assign a customer group dimension to a sales document. Or you can assign a department when posting expenses so that you can analyse and compare your expenses by department.

Processing Payments

From the payment registration page, you can process customer payments with only a few clicks and mark invoices as paid to automatically reconcile accounts.

To pay your vendors, you can use the payment journal, including advanced features such as vendor priorities and paying invoices on their due dates. To do so, you can run the suggest vendor payments batch, modify the payment journal lines if necessary, and then process the payments electronically or by check.

With the payment reconciliation journal, you process and reconcile bank statement transactions in one go. Use the import function to import bank statement files and let the system apply transactions automatically using advanced application rules.

Cash Flow Forecast

To get a better grip on their cash position, companies want to know how their cash flow will evolve in time. The cash flow forecast function uses a whole range of sources to calculate the future cash flow to receivables, payables, purchase orders and sales orders.

You can use manual revenues and expenses to analyse the impact of a future loan or an unforeseen future cost. By including Cortana Intelligence, machine learning is used to calculate the cash flow forecast based on historical income and disbursements.

Budgets

You can work with budgets for general ledger accounts, costs, sales and purchases.

Deferrals

You can set up deferral templates that automate the process of deferring revenues and expenses over a predefined schedule.

Fixed Assets

You can keep track of fixed assets and related transactions, such as acquisitions, depreciations, write-downs, appreciations, and disposals.

Audit Trails

Microsoft Dynamics 365 Business Central automatically assigns audit trails and posting descriptions to every transaction. In addition, you can define reason codes to create complementary audit trails.

Bank Account Management

You can create, operate, and manage multiple bank accounts to cater to your diverse business needs and across different currencies.

Reconcile your bank statement data automatically to open bank account ledger entries and keep track of all your bank statements.

Currencies

You can Manage multiple currencies throughout the system, including payables and receivables, general ledger reports, resource and inventory items, and bank accounts.

Show as Chart Feature in Microsoft Dynamics NAV 2017

In Microsoft Dynamics NAV there is a feature called Show as Chart, usually available on a list page. This feature has been available from quiet some versions now. The following article explains on how you can work with the feature.

We will consider Customer List as an example.

Open the Customer List page and on the Home tab, click Show as Chart.

And…. you see nothing! Well, read the instructions in the middle of the page and it says “Select measures and dimensions for the chart.

On the page, you have options to Select Measures and to Select Dimensions.

Scenario 1: Show me Balance Due per Customer Chart

In this case I select measure as Balance (LCY) and Dimension as No.:

Scenario 2: Show me Balance Due per Customer Chart – Exclude those customers who do not have any balance due.

In this first I click the Show as List action to go back to my customer list and provide an advanced filter to show only those customers which have balance due.

Now when you click on Show as Chart action to go to the charts again. You will notice that now the chart shows only those customers for which balance is due:

Similarly, you can choose many other combinations to view your data as a chart without any need to make customizations reports.

Actions Supported on Chart

When you right-click on the chart, you will have various options such as to Copy, save it as picture, print, etc. This is very useful, as you can now directly copy and paste it in your presentation or e-mail the report.

Zoom-In feature

If you held down the mouse, highlight a block and release the mouse, you can zoom-in to a block to have better view in selected area in the chart.

Does the Data Match?

When you hover your mouse over a bar chart, it gives you the exact figure for the record, so you can confirm if the chart shown matches the data.

Scenario 3: Advanced Chart

In the above example, we selected one measure and one dimension. But we also have an option to select one more dimension.

Let’s say, we would like to see, we would like to see Overdue Balance per Customer per Salesperson:

So, for example: here we can analyse that the sales person PS (Peter Shadow) has higher balances and JR (Julia Roberts) has comparatively lower balances.

Show the Chart in Role Centre

You can show the chart in your Role Centre as well.

Right-Click on the chart and click Customize. This will open the Generic Chart Customization page.

Here you can play around with various settings. Click Copy Chart action. Specify New Chart ID and New Chart Title fields and click Ok. You will get the following message.

But where has it copied to?

Click Departments/Administration/Application Setup/RoleTailored Client/Generic Charts to open Generic Charts and here you will find your chart saved.

So now you should be able to use that chart in any place you want to put it. Let’s say we would like to put the chart in a fact box beside the Customer List.

So, customize the Customer List page.

Choose FactBoxes, Add Chart Part, Customize Blank Chart and select the chart that you saved.

You can now see the chart besides your Customer List.

You can choose to have different chart types as well. Go ahead and give it a try.

Apply Date Filter on Chart of Accounts

 

  1. Open Chart of Accounts (Departments/Financial Management/General Ledger/Chart of Accounts)
  2. Drill down on the Chart of Accounts and select Limit totals to show the filters.
    SNAGHTML29cbbdba
  3. Under Limit total to, specify Where <Date Filter> is <Filter Value>
    image
  4. Amounts will be updated according to the filter applied.

You can also use Add Filter option to provide more filter combinations