• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Monthly Archives: March 2015

AP Payment Distribution Functionality

14 Saturday Mar 2015

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on AP Payment Distribution Functionality

Tags

Dynamics AX 2012, Payment distribution, Vendor payments

The following screenshots will provide you with a brief overview of the Accounts Payable (AP) payment distribution functionality that is available in vendor payment journals. For the purpose of this illustration the following three bank accounts are setup.EN_3-1After setting up the three bank accounts a General Ledger (GL) journal is used to post the following initial balances:
EN_3-2

Thereafter, three different AP methods of payments are setup – one for each bank account. EN_3-3Based on the assumption that payments will primarily be made from the Deutsche Bank bank account, all vendor records are setup with the default “SEPA (DB)” method of payment.EN_3-4After finalizing all the setup, a number of invoices is posted for the vendors DE-002, DE-003 and DE-004.EN_3-5After posting the different invoices a payment proposal is created in a vendor payment journal.EN_3-6The result of this payment proposal can be identified in the vendor payment proposal form. As one might expect, Dynamics AX suggests paying all invoices from the Deutsche Bank bank account because previously the SEPA (DB) method of payment was setup as the default method of payment for each vendor. This can be identified from the lower part of the following screenshot. EN_3-7If you open the balance control window you can identify that all invoices cannot be paid from the Deutsche Bank bank account because paying all invoices from this bank account would result in a negative balance of 117000 EUR on this account.EN_3-8To avoid this negative balance, the following payment priority is specified in the last column of the payment distribution window. EN_3-9The priority specified defines that vendor payments should primarily be made from the Citibank bank account. If funds on the Citibank account are insufficient, money from the Deutsche Bank bank account shall be used and so on. Leaving the payment distribution window with “OK” results in the following changed vendor payment proposal.EN_3-10As one can identify from this window, 15000 EUR will be paid from the Citibank account to pay an invoice of vendor DE-003. From Deutsche Bank another 17000 EUR (12000 EUR + 5000 EUR) will be paid and the remainder will be paid from the ING DIBA bank account. The following illustrations summarize how Dynamics AX distributes the payment amounts to the different bank accounts.
EN_3-11b
If you confirm the payment proposal by clicking the transfer button, the payment lines will be transferred to the vendor payment journal where you can create your payments and post the journal as usual.EN_3-12

Book review ’50 tips & tricks’

08 Sunday Mar 2015

Posted by Ludwig Reinhard in Book reviews

≈ Comments Off on Book review ’50 tips & tricks’

Within this review I will cover the following thee books from Murray Fife:

  • 50 tips & tricks for Dynamics AX 2012 (volume 1),
  • Another 50 tips & tricks for Dynamics AX 2012 (volume 2), and
  • 50 more tips and tricks for Dynamics AX 2012 (volume 3).

Even though the books are not explicitly differentiated by volumes, I will use this differentiation in the following for simplicity. On first sight, it might seem odd trying to review three different books at once. Yet, because all three books follow the same structure, this approach is made. The aforementioned structure is made of the following common chapters:

  1. Desktop client tips,
  2. Functional tricks,
  3. Office tricks,
  4. Reporting tips (only volume 1 and volume 2),
  5. Workflow tricks (only volume 2 and volume 3),
  6. System administration tips.

As one can identify, the only difference between the books is in chapter 4 and chapter 5. In the following, I will give a brief summary of each chapter before concluding with a brief summary.

Chapter 1: Desktop client tips
The first chapter in each volume focuses on tricks that are mainly for users that are new to Dynamics AX. A major focus in this chapter is made on searching and filtering data and on how to organize and work with the desktop client in a ‘smart’ way. Examples: Adding fields to summary tabs, configuring the status bar, identifying records with attachments, setting forms to automatically open in edit mode, converting records into templates, processing multiple records at once, using shortcuts, etc. While long-time Dynamics AX users might already be familiar with most of the tricks described in this chapter, I am convinced that even they can find the one or the other trick they have not seen or used before.

Chapter 2: Functional tricks
Within this chapter, Murray describes many tricks from various Dynamics AX modules. From a finance & controlling perspective, the following tricks seem to be the most useful:

  • How to add approval workflows to general ledger journals,
  • How to use print management to automatically email documents to customers and vendors,
  • How to do price updates
  • How to mark deleted sales orders as voided,
    (This section can be found in the last volume and is one of my favorites as it shows you the setup required to analyze your ‘lost sales’)
  • How to block users from using particular journal names,
  • How to enable change management for purchase orders,
    (Here I need to make a qualification. That is, while Murray nicely describes how this feature works, no hint can be found on the fact that change management for purchase orders currently does not support inter-company trading relationships)
  • How to control price adjustments on sales orders,
  • How to create filtered alters,
  • How to configure notes to print on standard forms.

Chapter 3: Office tricks
Whether or not you will find this chapter on office tricks helpful or not depends on the extent to which you use the MS office products in your daily work. If you use the MS Office products extensively – especially MS Word and MS Excel – you will find the office tricks in the first volume very helpful. The other volumes do not contain that many office tricks. Yet, in volume 2 you can find some interesting hints on the MS Outlook integration that I find worth reading.

Chapter 4: Reporting tips
The first and second volume include a chapter on reporting tricks. Within this chapter you will be able to find many tips on using Power-View/-Pivot/-BI to analyze your Dynamics AX data. Especially those of you that have to prepare (financial) reports will find these tips very useful. Yet, be aware that some setups required for using those features might not be available in your company’s Dynamics AX system. Another remark that I would like to make is that the reporting tips chapter is probably not the best starting point for those of you who just started or plan to start working with Dynamics AX.

Chapter 5: Workflow tricks
The second and last volume include a chapter on workflow tricks. If you are involved in setting up Dynamics AX you might find the tricks that you can find here helpful. Yet, despite the fact that everyday work of many Dynamics AX users is heavily influenced by workflows, the tricks described in this chapter are probably not the ones I would start with.

Chapter 6: System administration tips
The system administration tips chapter is primarily focusing on Dynamics AX users with a technical background that have enhanced user rights. Many tricks, such as e.g. copying data from one partition to another one, restricting user access rights through roles, copying data between companies via the import export framework, etc., do only have an indirect influence on the daily work of most finance & controlling users. However, the sections on how to use alerts and the new Dynamics AX task recorder can be useful for every Dynamics AX user. 

In summary, all three books include numerous valuable tips and tricks that might help you in your daily work with Dynamics AX. Especially people who are new to Dynamics AX will find the first chapter on desktop client tricks helpful. A major advantage of all books is that you can just pick and read through the sections that are of interest to you. This fact makes the books very valuable for those of you that are busy and need to grasp things quickly. The only minor disadvantage that I could find is that the explanations in the one or other section could be a bit more detailed. This remark does, however, not influence my overall positive impression of the books.

Switching Accounts

01 Sunday Mar 2015

Posted by Ludwig Reinhard in Management Reporter

≈ Comments Off on Switching Accounts

If you are involved in setting up financial reports you might face the requirement that one single account needs – depending on its balance – either be included on the asset or liability side of a company’s balance sheet. How this can be realized in Management Reporter is illustrated in the following.

Initial Situation
In 2012 the “Bank Account – USD” shows a positive balance of approximately
+93 mio. USD and in 2013 the same account has a negative balance of approximately -2 mio. USD. Using the default balance sheet report that is shipped with Management Reporter results in the following balance sheet reports:DEEN_8-1DEEN_8-2As you can identify from the screenshots above, the bank account is included on the asset side of the balance sheet irrespective of ist balance. To change this illustration, follow these steps:

Step 1: Copy the original report
I copy the original report and save it under a different name (Balance Sheet B) to make sure that the original report does not get destroyed by the following changes.

Step 2: Copy the original line structure
I also create a copy of the original line structure and save it under a different name (Balance Sheet B) to make sure that I can always go back to the original line structure in case that something goes wrong.
DEEN_8-3

Step 3: Define non-printing line in the newly created line structure
After copying the report and the line structure, I define the original reporting line for my bank account as a non-printing line. This can be identified by the NP code in the print control column. See the following screenshot.DEEN_8-4
DEEN_8-5
(Hint: double check your total and calculation lines that include the line you defined as non-printing and adjust them as required)

Step 4: Include calculation lines in the newly created line structure
After the original reporting line has been hidden through its definition as a non-printing line, two calculation (CAL) lines are included in the new line structure – one on the asset side of the balance sheet and one on the liability side of the balance sheet. For those calculation lines I use the following IF-THEN-ELSE formulas:
Asset side: IF @160>0 THEN @160 ELSE 0
Liability side: IF @160<0 THEN @160 ELSE 0
Those formulas check whether the balance of the account included in line 160 is positive or negative and depending on the outcome the account is either illustrated on the asset or liability side of my balance sheet.

Outcome
The following two screenshots illustrate the balance sheets in 2012 and 2013.DEEN_8-8_neuDEEN_8-7
As one might expect, in 2013 the bank account is included on the liability side of my balance sheet.

Communities4Future

Dynamics UserGroup Deutschland

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
  • Podcast
  • Project
  • Sustainability
  • Uncategorized

Tags

Advanced bank reconciliation Allocations Bank reconciliation Budgeting Controlling Cost accounting Cost accounting module Cost center accounting customer D365 D365FO Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming indirect costs intercompany Inventory Inventory reconciliation invoice invoice recording IOT Management Accounting Management Reporter Modern Finance MS Flow MT940 PowerApps PowerAutomate PowerPlatform Project Project module Purchase Order Resource scheduling Sensor settlement SharePoint Sustainability Sustainability Accounting Tax time recording timesheet 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 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • 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.

  • Follow Following
    • Dynamics 365FO/AX Finance & Controlling
    • Join 569 other followers
    • Already have a WordPress.com account? Log in now.
    • Dynamics 365FO/AX Finance & Controlling
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...