• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Category Archives: Fixed Assets

Dynamics AX Fixed Asset Module

Fixed Asset Counting with RPA

01 Saturday Feb 2020

Posted by Ludwig Reinhard in Fixed Assets

≈ Leave a comment

Tags

Barcode, Flow, MS PowerApps, Power Automate, QR Code, Robotic Process Automation, RPA, Scan

 

 

 

 

Fixed Asset Counting

25 Saturday Jan 2020

Posted by Ludwig Reinhard in Fixed Assets

≈ Leave a comment

Tags

Barcode, Counting, Flow, Power Apps, Power Automate, QR Code, Scan

 

 

 

 

Investment management process… by the way

11 Friday Oct 2019

Posted by Ludwig Reinhard in Fixed Assets, Project

≈ Leave a comment

Tags

Create fixed asset, PowerApps, PowerPlatform

A small note on how one can improve the investment management process shown in the previous post.

Investment management process

09 Wednesday Oct 2019

Posted by Ludwig Reinhard in Fixed Assets, Miscellaneous, Project

≈ 1 Comment

Tags

Approval, investment, investment management process, Project, workflow

Parallel accounting & Financial statements (Part 2/2)

01 Monday Oct 2018

Posted by Ludwig Reinhard in Fixed Assets

≈ 4 Comments

Tags

delta postings, financial statements, Parallel accounting, Posting layer

In this second part, I will show you an alternative approach how different accounting standards can be incorporated in MSDyn365FO.

With the help of corrective fixed asset books the disadvantages identified in the previous webcast can be overcome and allow you an easy and straightforward reporting on different accounting standards, such as IFRS, local GAAP and tax GAAP.

Sample data: SampleDataFA2

 

 

Parallel accounting & Financial statements (Part 1/2)

25 Tuesday Sep 2018

Posted by Ludwig Reinhard in Fixed Assets

≈ 2 Comments

Tags

delta postings, financial statements, Management Reporter, Posting layer

This webcast illustrates how one can create financial statements in situations where fixed asset postings are made on different posting layers to incorporate different GAAP, such as IFRS, local GAAP, tax GAAP and alike.

What can make things difficult in this context are situations where non-fixed asset related postings are made in the form of so-called delta postings that account only for the difference in the amounts required by the different GAAPs.

Join me in this webcast and see how one combine full fixed asset related postings and delta postings made outside of the fixed asset module when creating financial statements for the different GAAPs.

Attachment: SampleDataFA_Final

 

 

Allocate depreciation postings to projects with the help of MS-Flow

11 Wednesday Apr 2018

Posted by Ludwig Reinhard in Cost accounting, Fixed Assets, Project

≈ 4 Comments

Tags

Allocations, MS Flow

In this webcast, I show you how you can use MS-Flow for allocating depreciation costs from the fixed asset module to the projects that you operate in the project management and accounting module. Everything works out of the box without a system modification – something that was not possible in the past.

 

Intercompany transfer of Fixed Assets with the help of MS-Flow

01 Thursday Mar 2018

Posted by Ludwig Reinhard in Accounts Payable, Accounts Receivable, Fixed Assets

≈ 6 Comments

Tags

intercompany, MS Flow

In this post I will show you how you can sell fixed assets in one company and automatically create and acquire a fixed asset in another company. With the help of MS-Flow I could solve a long-term mystery with out of the box functionalities.

Automatic posting of journals

17 Wednesday Aug 2016

Posted by Ludwig Reinhard in Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger

≈ 2 Comments

Tags

periodic/mass posting of journals, post journals

The previous post dealt primarily with the question how the selection and posting of journals can be restricted. Within this post I would like to change the perspective and take a look at a function that allows a periodic posting of a number of journals that have been created.

The “post journals” functionality I refer to here can be found in the General Ledger module in the journal entries section. (In prior Dynamics AX versions it can be found in the periodic General Ledger module section).

As the information that has been provided e.g. on TechNet for the “post journals” functionality is a bit sparse and as several questions in regards to this function have been brought forward recently, I decided summarizing the different setup and processing options in this post.

Note: Please note that the following illustrations and explanations will only refer to posting General Ledger journals. The post journals function is, however, not limited to those kind of journals but can be applied to other journals as well. Please see the following summary.

 

In order to explain the different setup options of the post journals feature, I started setting up some daily General Ledger journals that included either no error (“OK”), some journal lines with errors (“Partly ok”) or only erroneous lines (“Error”). The next screenshot exemplifies the setup of some of those journals used.
EN_127_0005

 

Option 1: Select the journals, and post them
Once all demo journals have been prepared, I opened the post journals window and selected them through the identic button.
EN_127_0010 EN_127_0015
After all journals have been selected, the posting process was initiated by hitting OK button in the post journal form.
EN_127_0020
Result:
The result of this first posting test was that all journals except the ones that contained errors were posted.
EN_127_0025
Newly created journals that did not contain any error remained, however, unposted.

 

Option 2: Select the journals and post them by using a batch job
To get also those journals automatically posted that have been created later on, I deleted all unposted previously generated journals, setup some new ones and selected them as before in the post journals form.
EN_127_0030
This time I changed the posting process by making use of a batch process that runs every some minutes and that does the posting for me.
EN_127_0035
Result:
As before, all journals have been posted except the ones that contained errors.
EN_127_0040
My next step was setting up a new journal (No. 188) that did not contain any error.
EN_127_0045
Because of my posting setup I expected that the batch process will pick up the newly generated journal and post it. Yet, as nothing happened, I finally checked the batch job history window and noticed that the batch job stopped because it could not process the first two journals that contained erroneous lines. Please see the next screen-print.
EN_127_0050

 

Option 3: As option 2 & select the transfer errors checkbox
As processing newly created journals did not work with the previous approach, I repeated the earlier setup steps and created a number of new journals. This time I tried processing them by selecting the ‘transfer errors’ checkboxes (please see below).
EN_127_0055
Result:
As expected, all journals except the ones that contained errors were posted. After setting up a new journal that contained no error I expected that this time the newly created journal will be posted.
EN_127_0060
Yet, unfortunately nothing happened to the newly created journal as the batch job stopped as before after detecting errors.
EN_127_0065
Note: The difference between the 2nd and 3rd setup option is related to the journal that was partly ok. That is, this time all journal lines that did not include an error in the original (partly correct) journal No. 189 were posted and the journal lines that contained errors were transferred to a new journal No. 191 that contains only the erroneous lines.

 

Option 4: As option 3 but with the late selection and transfer errors checkbox activated
Since none of the prior setup options successfully posted the journals that I created subsequently, I changed the setup in the post journals form once again. This time – after selecting the journals that I want to post – the “late selection” and “transfer error” parameters were activated as shown in the next screen-print.
EN_127_0075
Result:
This time all erroneous journals/journal lines remained unposted as before but the journal that I created later on – in my case journal No. 196 – was finally picked up by the batch process and posted automatically as the following screen-prints prove.
EN_127_0080 EN_127_0085
Note: Despite the fact that the newly generated journal was successfully posted, the batch job still continued running (and ending) with errors because of the two journals that contained lines with errors.
EN_127_0090
Even though this issue in not directly related to the journal posting process itself, it can become quite cumbersome, as it might flood your mailbox with error messages / Emails if alerts and/or Email notifications have been setup that control the processing of batch jobs.

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (5)

16 Saturday Jul 2016

Posted by Ludwig Reinhard in Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger, Inventory

≈ 2 Comments

Tags

Cost of Sales Method, Nature of Expense Method, Posting setup, Profit & Loss Statement

C.6. Sale of goods
Within the last part of this series on the COS & NOE accounting method, the item that has been produced before will be sold for 1000 EUR / pcs through a standard customer sales order shown in the next screen-print.
EN_91neu_0600

The first sales order related voucher is created when the sales order packing slip is posted. In the example used, Dynamics AX created the following voucher:
EN_91neu_0605
As only Balance Sheet accounts are addressed, no influence on the company’s Income Statements can be identified and as a result, no difference between the COS and NOE method arises.

The next and final posting step in my example is related to the sales order invoice. The voucher created when posting the invoice is shown in the next screen-print.
EN_91neu_0610

For reasons of clarity and traceability, the vouchers created when posting the sales order packing slip and sales order invoice, have been summarized in the next illustration.
EN_91neu_0615

  • Similar to the previous chapters, all transactions that offset each other have been highlighted in grey color. In the example used, the packing slip voucher is reversed with the posting of the sales order invoice.
  • All accounts highlighted in green color represent Balance Sheet accounts that debit a receivable account and credit the inventory account that traces the stock reduction due to the sale of the finished item.
  • The first yellow highlighted Income Statement account no. 40500 records the sales revenue of 1000 EUR. This transaction is self-explanatory. The posting on the second Income Statement account no. 50500 on the other hand requires some explanation, as it is used and interpreted differently from a COS and NOE accounting perspective. That is, from a COS perspective the amount recorded on ledger account no. 50500 is included in the cost of sales section and directly influences (reduces) a company’s profit. The reduction in a company’s profit does also occur when the NOE method is applied. Yet, for the NOE method this account represents a stock variation account and consequently needs to be included in the stock variation section of the company’s income statement.

The following financial statements summarize the sales order related transactions resulting from the sales order invoice posting.
EN_91neu_0620

 

D. Summary
Within this series on the COS and NOE accounting method I demonstrated that Dynamics AX can be setup in a way to generate financial statements that follow both accounting methods in parallel. This also holds for situations where other inventory valuation principles, such as standard costs, moving average costs, etc. are used.

Irrespective of those valuation principles and differences thereof, the key to a successful parallel implementation of both principles is a “correct” setup of your chart of accounts and related account structures.

 

← Older posts

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

  • 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.

Cancel

 
Loading Comments...
Comment
    ×