• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Monthly Archives: April 2016

Budget control for fixed assets – Part 2: AX7

20 Wednesday Apr 2016

Posted by Ludwig Reinhard in Budgeting

≈ 10 Comments

Tags

budget control, Budgeting, Fixed Assets

After analyzing how to check available budget funds for fixed assets in AX2012, let’s now have a look at the very same functionality in the new Dynamics AX7.

 

Setup
For this comparison I setup the same fixed asset posting profile and account structure as in AX2012. The budget control configuration was also setup as before. That is, budget control is executed at the main account level only and …
EN_2_124_0005
… a budget control rule for my fixed asset accounts that start with “180” is setup.
EN_2_124_0010

 

Record budget amounts for the fixed assets
With this setup in place I created a fixed asset, recorded and transferred the fixed asset budget amount to the budgeting module. The result of this transfer can be identified in the next screen-print.
EN_2_124_0015
What can be identified from the previous screen-print is the green check mark in the budgeting line. Different from the “old” Dynamics AX2012 this feature seems to come out of the box in AX7.

 

Post vendor invoice
With the budgeted amount registered and activated, let’s now have a look at what happens if a vendor invoice for more than the budgeted amount of 100000 EUR is recorded. The result of this posting test can be identified in the next screen-print.
EN_2_124_0020
As one would expect, Dynamics AX does prevent users from recording an invoice that exceeds the budgeted amount. If the invoice amount is reduced below the budgeted one, Dynamics AX posts the vendor invoice as usual.
EN_2_124_0025

 

Summary
Different from the “old” Dynamics AX2012, the “new” Dynamics AX7 does not require a code modification to check available budget amounts for balance sheet (fixed asset) accounts. Irrespective of this improved functionality, users still need to ensure that all balance sheet accounts that shall be checked against available budget funds are included in the single account structure that is setup in the budget control configuration form.

Budget control for fixed assets – Part 1: AX2012

16 Saturday Apr 2016

Posted by Ludwig Reinhard in Fixed Assets

≈ 9 Comments

Tags

budget control, Budgeting, Fixed Assets

Within this and the following post I would like to show how one can setup budget control for fixed assets in AX2012 and AX7. Let’s start with the setup and configuration in AX2012 first by referring to the following example.

Setup
The first step in my setup process is specifying the main account that is used for posting fixed asset acquisitions in the fixed asset posting profile form. Please note that the main account setup here (account no. 180100) is a balance sheet account.
EN_1_124_0005
Because I am aware that the budget control configuration form does only allow setting up a single account structure, I setup my ledger with only one account structure that includes all of my balance sheet and income statement accounts.
EN_1_124_0010
My next step was selecting this account structure in the budget control configuration form and specifying that budget control shall be executed at the main account level only.
EN_1_124_0015
To let Dynamics AX check and ensure that I do not spent more money than the amount budgeted, I setup the following budget control rule, which defines that my main (balance sheet) accounts that start with “180” shall be subject to budget control.
EN_1_124_0020

 

Record budget amounts for the fixed assets
After setting up and activating budget control, I recorded fixed asset budgets for the different fixed assets that I setup for the years 2020 to 2024. For details, please see the next screen-print.
EN_1_124_0025
After transferring those budget values to the budgeting module, I double-checked the amounts transferred and updated the budget balances.
EN_1_124_0030
A first thing that I noticed in the budget register entry form was that the first column denominated “budget check results” did not include a green check mark for my transferred budget values.

As I wanted to compare this behavior with the one that can be identified for ordinary expense related budgets, I modified my budget control configuration and setup a second budget control rule for my travel expense accounts. Once that was done, I recorded a budget for one of those travel expense accounts and noticed that Dynamics AX automatically shows me a green check mark when entering the budget amount. Please see the next screen-print.
EN_1_124_0031

 

Post vendor invoice
Irrespective of the issue with the green check mark and after having done all the necessary setup, I finally tried recording and posting a vendor invoice. Please note that the invoice amount that I entered exceeds the budgeted amount. Details of my test are included in the next screen-print.
EN_1_124_0040
What you can identify from the screen-print above is that Dynamics AX allowed me posting the invoice for my fixed asset even though the invoice exceeds the budgeted amount by 25000 EUR.

This was not quite what I expected. For that reason, I changed the budget control configuration several times in order to execute the budget control at different levels and with different main account-financial dimension combinations. Yet, irrespective of the budget control configuration that I used, I was always able to post the vendor invoice even though the posted amount exceeded the budgeted one.

 

Solution: Code adjustment
After this disappointing result, I started having a look at the program code that is responsible for executing the budget control check and noticed that standard Dynamics AX runs the budget control check only for expense, profit&loss and total accounts. As balance sheet accounts – such as the one that I setup for my fixed asset acquisitions – are by default excluded from budget control, I slightly modified the code in the following two methods:
EN_1_124_0045 EN_1_124_0050

 

Second test run
Once the code adjustments were implemented, I setup a new fixed asset and entered a budget for it. The next screen-print shows you the process of entering the budget amount for the newly created fixed asset. The main difference that you can identify in the screen-print below compared to the earlier budget registration is the green check mark in the budget check column.
EN_1_124_0055
Please note that the previously recorded budgets for my „old“ fixed assets are not influenced by the code change, which induced me setting up a new fixed asset and fixed asset budget for the following tests.

With the new setup in place I tried once again recording a vendor invoice for the acquisition of my fixed asset. Interestingly and different from before, Dynamics AX did now prevent me from posting the invoice as the total invoice amount exceeded the budget amount. Please see the next screen-print.
EN_1_124_0060
After reducing my total invoice amount to one below the total budgeted amount I was finally able to get the invoice posted.
EN_1_124_0065

 

Summary
By doing some little code modifications you can let Dynamics AX check available budgets for balance sheet accounts. An important prerequisite for this budget control check is that the balance sheet accounts – for which you want to have the budget control enabled – are included in the account structure that is setup in the budget configuration form. In other words, if you want to have also balance sheet accounts checked for available budget funds, you might have to reconsider the setup of your account structures e.g. by including all accounts into a single account structure and by making use of advanced account structure rules.

Please do also note that additional code modifications are necessary in the budget control inquiry forms to get the balance sheet accounts included for subsequent comparisons.

Within the next post I will take a look at the same process and differences in the new Dynamics AX7. Till then.

A note on budgeting on total accounts

08 Friday Apr 2016

Posted by Ludwig Reinhard in Budgeting

≈ Comments Off on A note on budgeting on total accounts

Tags

budget control, Budgeting, summary account, total account

Over the last months I noticed many people asking how to budget on total accounts and how budget control needs to be setup for those accounts. Within this post I aim to answer this question by recording budget amounts on a total ledger account (e.g. for travel expense). Budget control should then verify whether the amounts recorded for all the individual ledger accounts that make up the total ledger account (e.g. the amounts posted for hotels, taxi, flights, etc.) exceed the total amount budgeted.

Let’s have a look at some business scenarios that illustrate how such budgeting scenarios can be implemented in Dynamics AX.

 

Scenario 1: Budgeting on total ledger accounts
For the implementation of the first scenario a total account No. 601510 for travel expense is setup that comprises all other travel expense accounts No. 601500 to 601509. For details, please see the following screen-print.
EN_95_0005
Thereafter, an amount of 50000 EUR is budgeted on the total account No. 601510 for the year 2018.
EN_95_0010
(Please note that I recorded the budget amount for this illustration at the main account level only. Further below, I will extend this scenario by budgeting on more than one single financial dimension)

In order to let Dynamics AX check whether or not sufficient budget funds are available when recording travel expense related transactions, I setup the following budget control rule which specifies that all ledger accounts that start with 6015 are subject to budget control. (Please note that these are the travel expense accounts that I showed at the beginning of this post).
EN_95_0015
After setting up this budget control rule, I activated the budget control configuration and tried posting a transaction for 5 EUR on ledger account 601504, which belongs to the group of my travel expense accounts. Interestingly, Dynamics AX prevents me from recording this single transaction – see the next screen-print – even though the total amount recorded is far below the total amount budgeted.
EN_95_0020
The underlying reason for this system behavior is that no budget has been recorded for ledger account No. 601504 and that the only thing that has been specified in the budget control configuration is that all accounts that start with 6015 are subject to budget control.

After this initial test I changed my budget control configuration as follows:

Change 1: I setup a user group (“IN”) that includes my Dynamics AX user and did not allow this user to process transactions that exceed the total amount budgeted. At the same time, I specified that Dynamics AX should execute a second budget control check at the budget group level if the first budget check (at the budget control rule level) fails.
EN_95_0025

Change 2: The second change that I made in the budget control configuration was setting up a budget group (“TR”) that includes all my travel expense accounts including the total account (No. 601510) for which I recorded my budget.
EN_95_0030
This second setup change determines that Dynamics AX executes the secondary budget group check on the total amount that has been budgeted for all ledger accounts starting with 6015.

With this setup in place I tried posting the very same transaction for 5 EUR as illustrated before. The outcome of this second test is illustrated in the next screen-print.
EN_95_0035
As you can identify from the previous screen-print, Dynamics AX gives me a warning message which says that the amount recorded (5 EUR) exceeds the amount budgeted for the ledger account used (No. 601504). That is completely right, as no budget has been recorded for this account.
Yet, at the same time, Dynamics AX allows me posting the journal and says that the journal is ok. Now, this system behavior is caused by the setup of the budget group rule that checks the amount recorded (5 EUR) against the total amount budgeted for all travel expense accounts (50000 EUR) including the total account.

 

Scenario 2: Budgeting on total ledger accounts & financial dimensions (1)
The example used above for illustrating the first business scenario records budget amounts only at the ledger account level. Personally I felt that this example lacks a bit practical relevance as most companies typically budget on combinations of ledger accounts and financial dimensions such as cost centers, departments and alike.

For that reason I extended my budget control scenario by budgeting at the main accounts and cost center level. The next screen-print shows you my second budgeting example that still records the budget on the total ledger account (No. 601510) but does now split up this total amount by cost centers.
EN_95_0040
Please note that the total amount budgeted is now 60000 EUR (20000 EUR + 25000 EUR + 15000 EUR).

As I do not only want to have my main accounts but also my financial dimensions checked for available budget funds, I included all cost centers in the budget control rule. (Please see the next screen-print).
EN_95_0045
This setup specifies that Dynamics AX shall check all my travel expense accounts and cost centers whether sufficient budget funds are available when recording transaction.
Please note that I have not changed the budget group setup. In other words, my budget control configuration is still setup in a way that a second budget control check is executed once the amounts recorded exceed the ones budgeted on the individual ledger account-cost center combinations.

After making this modification in the budget control configuration I recorded a total amount of 30000 EUR for one of the travel expense accounts at cost center “007”. (Please note that only 25000 EUR have been budgeted for this cost center).
EN_95_0050
As the total amount recorded exceeds the amount budgeted for the cost center, Dynamics AX gives me a warning message but still allows me posting this journal. The underlying reason for this behavior is the budget group control setup, which compares the amount recorded (30000 EUR) to the total amount budgeted for all travel expense accounts that start with 6015 (60000 EUR).

Now let’s have a look what happens if the amount recorded (90000 EUR) exceeds the total amount budgeted for all my travel expense accounts (60000 EUR).
EN_95_0055
As you can identify from the previous screen-print, Dynamics AX does now prevent me from posting this transaction as insufficient budget funds are available.

 

Scenario 3: Budgeting on total ledger accounts & financial dimensions (2)
In this third scenario I changed my budget control setup once again to illustrate how budget control can be executed at the financial dimension level. For this illustration I recorded the following six budget register entries for my cost centers 007 and 008. Please see the next screen-print.
EN_95_0060
As before, I setup my budget control configuration in a way that all combinations of ledger accounts and financial dimensions are checked against the amounts budgeted (highlighted in yellow in the next screen-print).
In addition, a budget group rule was setup that allows recording transaction as long as the total amount recorded is less than the total amount budgeted for the financial dimension (highlighted in blue in the next screen-print).
EN_95_0065
Against the background of this setup, Dynamics AX allows recording transactions that exceed the amount budgeted for a specific ledger account-financial dimension combination.

The next screen-print illustrates this behavior by showing that Dynamics AX allows recording a total amount of 75000 EUR even though this amount exceeds the one that has been budgeted for this ledger account-financial dimension combination (20000 EUR). That is because the budget group rule allows recording transactions up to the total amount budgeted for the financial dimension; in my example up to 100000 EUR.
EN_95_0070
Once the transaction recorded exceeds the total amount budgeted for the financial dimension, Dynamics AX prevents me from processing this transaction. This behavior is illustrated in the next screen-print which shows that a transaction for a total amount of 101000 EUR cannot be recorded as the total amount budgeted for the cost center is less than the amount recorded.
EN_95_0075

 

Summary
Within this post I showed you some examples that illustrate how the budget control configuration can be setup to check transactions for sufficient budget funds available even though the budget funds have been recorded for different ledger account-financial dimension combinations.

The last hint that I would like to provide here is the fact that Dynamics AX does currently support budgeting for total ledger accounts but not for total financial dimensions. If you try registering a budget for a total financial dimension – such as department 100 in my example illustrated in the next screen-print – Dynamics AX will prevent you from updating and completing this budget register entry.
EN_95_0099

Invoice search AX2012 vs. AX7 (Part 2)

01 Friday Apr 2016

Posted by Ludwig Reinhard in Accounts Receivable

≈ Comments Off on Invoice search AX2012 vs. AX7 (Part 2)

Tags

customer, customer invoice search, invoice, search

Part 2: Invoice search AX7
Now let’s have a look at the invoice search capabilities in the new Dynamics AX 7.

Option 1: Invoice journal inquiry form
The first option available to search for customer invoices is the invoice journal inquiry form. In this form, a new search field has been introduced that does – on first sight – not seem to be able to search for invoices by using wildcards. Example:
EN_120_0100
An alternative to searching for the invoice number through the new search field is using the new filter options illustrated in the next two screen-prints.
EN_120_0105
EN_120_0110
Compared to the AX2012 filter options, those two filters seem inferior, as the use of wildcards is (currently) not possible.

Because of the numerous search results that I received from my prior searches I tried using the advanced filter options in addition …
EN_120_0115
… and noticed that the use of wildcards in the advanced filter form is possible and helps identifying the invoice I am searching for quickly. For details, please have a look at the following two screen-prints. EN_120_0120 EN_120_0125
Note: A major difference and advantage compared to AX2012 is the ability to search for the customer name … EN_120_0130
… and several other criteria in the standard search field available.
EN_120_0131

 

Option 2: Customer list page
An alternative to searching for invoices in the invoice register inquiry form is an invoice search via the “all customers” list page. Searching for invoices via the customer list page follows the same principles as in AX2012. That is, you need to apply an advanced filter first by adding joined table relations…
EN_120_0135
EN_120_0140
…before you can apply the search filter and identify the customer with the respective invoice record.
EN_120_0145
Once you have identified the respective customer account you need to apply a second filter in order to extract the invoice information you are looking for.
EN_120_0150

 

Option 3: Open customer invoice list page
Invoice searches in the open customer invoice list page work the same as in AX2012 except for the way how you enter filters. Please note that this form will show you only open invoices and if the invoice you are searching for is already paid, no invoice is filtered.
EN_120_0155

 

Option 4: Collections window
Searching for a specific customer invoice via the collection windows – note the new AX7 term “aged balances” – is identical to the search in AX2012.
EN_120_0160
That is, you have to use an advanced filter first to get your customer selected …
EN_120_0165
…and then apply a second filter in the collections form for the very customer you have selected.
EN_120_0170

 

Option 5: Customer service form
Searching for customer invoices in the customer service form works exactly as in AX2012.
EN_120_0175
Interestingly, AX7 supports the use of wildcards in the customer service form to identify the customer record … EN_120_0180… and the invoice one is looking for.
EN_120_0185

 

Option 6: Enterprise Portal search functionality
As the Enterprise Portal is not an element of the new AX7 system, searching for invoices through the Enterprise Portal is not possible anymore.

 

Option 7: Enterprise search functionality
What has been said for the Enterprise Portal search also applies for the global enterprise search. That is, as the global enterprise search functionality is not part of the new AX7 version it cannot be used for invoice searches anymore.

 

If you have some additional hints on how to search for customer invoices in AX2012 and/or AX7, feel free to leave a comment on this site to help also other users that might have similar problems. Thank you very much and till next time.

Invoice search AX2012 vs. AX7 (Part 1)

01 Friday Apr 2016

Posted by Ludwig Reinhard in Accounts Receivable

≈ Comments Off on Invoice search AX2012 vs. AX7 (Part 1)

Tags

customer, customer invoice search, invoice, search

Especially employees working in the Sales and/or Accounts Receivable department regularly need to search for customer invoices and related customer payments. Within this post I want to show you different ways how one can search for customer invoices in order to give customers a quick feedback about their invoices and their account status.
This post is separated into two parts. Within the first part I will show you different ways how to search for customer invoices in AX2012. The second part does the same but for the new Dynamics AX7.
Note: The AX7 version used for this post is the so-called RTW (Ready to Web) version that was released on 24. February 2016.

 

Part 1: Invoice search AX2012
For the following illustrations and examples, I will search for customer invoice no. “CIV-000015”.

Option 1: Invoice journal inquiry form
A first option to search for customer invoices is the invoice journal inquiry form available in the Accounts Receivable module.
EN_120_0005
Searching for invoices through this form allows an easy and fast drill down into the customer transactions and the related customer settlements form as exemplified in the next screen-print.
EN_120_0010
Please be aware of the following limitations (disadvantages) of this form:

  • The invoice journal form does not show you customer invoices that have been created through the project module,
  • It is not possible to search for the customer name in this form.

 

Option 2: Customer list page
An alternative option to search for customer invoices is the “all customers” list page.
EN_120_0015
In this form you can make use of the advanced filter options to search for invoice numbers. Please see the next screen-prints for an example.
EN_120_0020
EN_120_0025 EN_120_0030
If you are using the all customers form to search for customer invoices you have to be aware of the following:

  • The invoices you are looking for are not shown in the customer list page directly. You rather need to open the customer transactions window and apply a second filter.
  • An invoice search in the customer list page may not always result in a single outcome. The next screenshot shows you an example where two customer records have been found that include an invoice ending with “*015”.

EN_120_0035
Note: The underlying reason for this search result is a project invoice ending with “015” that has been recorded for another customer. A small modification of the filter applied can help you overcoming this issue. Please see the next screen-print.
EN_120_0036

 

Option 3: Open customer invoice list page
The third option available that allows searching for customer invoices is the open customer invoices form.
EN_120_0040
This form will, however, only show you open invoices. If the invoice is already paid, no invoice is filtered in this form.
EN_120_0045

 

Option 4: Collections window
The fourth option to search for customer invoice is the collections list page. Users can apply advanced filters in this list page similar to the one shown previously for the “all customers” list page (option 2).
EN_120_0050
What has been mentioned for the customer list page above also applies here. That is, your search might result in more than a single customer record and …
EN_120_0055
…you might need making use of a second filter in the collections details form to find the invoice you are looking for.
EN_120_0060
Note: In my example I even had to change the transaction filter via the “show” button to identify the invoice I was looking for as this invoice had already been settled.

 

Option 5: Customer service form
If you are using the Dynamics AX retail features you can alternatively make use of the invoice filter functionalities available in the customer service form of the Call Center module. Please see the next screen-prints for an example.
EN_120_0065 EN_120_0070
Please note that you can easily open the customer invoices through clicking on the hyperlinks provided in this form. Example:
EN_120_0075
Note: The customer service form does not include project invoices as the invoice journal inquiry form shown above (option 1).

 

Option 6: Enterprise Portal search functionality
Another way to search for customer invoices is the invoice journal site available in the Dynamics AX Enterprise Portal.
EN_120_0076
A major advantage of this site are the manifold search options available (please see the next screen-print for details).
EN_120_0077
Please note that the limitations mentioned for the customer service form and invoice journal inquiry form do also apply if you are searching for invoices through this Enterprise Portal site.

 

Option 7: Enterprise search functionality
A final option to search for customer invoices is the so-called global search functionality. Example:
EN_120_0080
The major advantage of this search feature is that you are able to define what you want to search for through an individualized search configuration.
EN_120_0085
Before you are able to make use of this feature you have to make sure that your search queries do have the searchable property activated and that they do not infringe any best practice rule.
EN_120_0090
In addition, a periodic search process interval needs to be setup.
EN_120_0095
Additional information can be for the global search functionality can be found on the following sites: site1, site2.

Project Accounting Book – Part 2

Project accounting book

Categories

  • Accounts Payable
  • Accounts Receivable
  • Bank Management
  • Book reviews
  • Budgeting
  • Cost accounting
  • Fixed Assets
  • General Ledger
  • Inventory
  • Management Reporter
  • Miscellaneous
  • Project
  • Uncategorized

Tags

Accruals Advanced bank reconciliation Allocations Approval Bank reconciliation Controlling Cost accounting module Cost center accounting Cost of Sales Method customer Dynamics AX Dynamics AX 2012 Earned Value Analysis Electronic reporting Email Fixed asset statement General Ledger journal indirect costs intercompany Inventory Inventory reconciliation Inventory valuation Inventory value report invoice invoice recording Management Accounting Management Reporter MS Flow MT940 Nature of Expense Method parallel Posting setup PowerPlatform Prepayments Profit & Loss Statement Project Project controlling Project module Purchase Order search settlement SharePoint standard costs Tax upload valuation Vendor invoice recording Vendor payments WBS workflow

Important Websites

  • Dynamics AX/365FO Links

Legal

  • Disclaimer

Subcribe

  • RSS - Posts
  • RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Archives

  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015

Blog at WordPress.com.

Cancel