• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: Nature of Expense Method

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.

 

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

10 Sunday Jul 2016

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

≈ Comments Off on Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (4)

Tags

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

C.5. Production of goods
Probably the most complex part when it comes to setting up the COS and NOE method in parallel is related to the production of goods. That is mainly because the production posting setup does not only require a setup of the inventory posting matrix but – depending on the parameter setup – also makes use of other accounts that are setup e.g. at the resource level, production category level and in the costing sheet.

Notes:

  • It is not feasible showing you all possible ways for setting up production related postings. Rather than trying to do that I will exemplify the setup based on a simple production item. You can use this basic setup then and apply it to more complex production scenarios.
  • To keep things as simple as possible, I do not create transactions that result in production related variances e.g. due to additional raw material consumption, changed execution times and so on.
  • All production postings illustrated in the following are based on the ledger principle “item and resource” that can be found in the production control parameters form.

Irrespective of the specific ledger setup for production related postings, the basic production process in Dynamics AX follows a three step procedure that begins with the start of a production order, continues with reporting the production order as finished and finally ends with the closing or “costing” of the production order. Those basic production steps and the related postings executed are illustrated in the next diagram, which will be used as a guideline for the subsequent illustration of the production related postings for a production item.
EN_91neu_0500
The structure of the production item I referred to above can be identified in the next screen-print.
EN_91neu_0505
The cost price calculation screen shown above illustrates that the production item (FG2000) consists of two raw materials (RM300 and RM400) that have a cost price of 10 EUR / pcs each. For the production of this good one piece of the first raw material (RM300) and two pieces of the second raw material (RM400) are required. In addition, for the assembly of the product a worker has to work one hour on a machine that has a total cost price of 270 EUR / hour. Based on those data a total production cost price for the production item of 300 EUR / pcs arises.

 

C.5.1. Production step 1: Start
For reasons of simplicity, the production parameters used in this example have been setup in a way that the material consumption (BOM) and route consumption are immediately posted when the production is started. The next screen-print shows the vouchers that have been created through the posting of the BOM and route journals.
EN_91neu_0510
The effect that these vouchers have on the financial statements of the company can be identified in the next illustration.
EN_91neu_0515
From a Balance Sheet perspective, the production start related postings are reflected in changes that can be observed on the WIP accounts no. 13430 and 13440. For the raw material consumption another Balance Sheet account (no. 13150) has been used as the offset account and the offset account for the route consumption has been posted on an Income Statement account (no. 60110).

 

Given that the NOE accounting method typically uses stock variation accounts for each and every change recorded in the company’s stock level, the question arises how the raw material related postings that were executed with the start of the production order can be explained / justified?
I will try answering this question based on the following illustration that shows the recorded accounting transactions in the upper part and the missing “in between” stock variation accounts in pink color in the lower part.
EN_91neu_0520
What becomes obvious from this illustration is that the approach followed here is not fully correct in the sense that the pink transactions highlighted above are missing.
An important question at this point is whether those missing transactions result in a critically wrong illustration of a company’s financial position or not.
From the author’s perspective the “missing” pink transactions are not critically important as they do not distort the financial position of a company that follows the NOE accounting method. That is because the NOE Income Statement does on the one hand side summarize all stock variation transactions into a single line. On the other hand side, one has to remember that the pink highlighted lines add up to zero and do thus have no impact on the company’s financial position.

 

The second transaction I would like to discuss in more detail here is the route related voucher that credits an Income Statement account (no. 60110 “production wages clearing”) and thus affects the profit of the company.
From a NOE accounting perspective this account / transaction can be explained by stating that the clearing account used represents a part of the stock variation of the company. In other words, the increase in semi-finished products for the route consumption part on account no. 13440 is offset by the “stock variation” recorded on account no. 60110. For that reason, the production wage clearing account has been assigned to the stock variation section in the Income Statement that follows the NOE accounting method.
If you take a look at the Income Statement that follows the COS method, you can identify that the very same account no. 60110 has been included in the section that incorporates the production wages recorded before. Irrespective of the whether the name and the section where those accounts have been assigned to is correct, the question that arises how one can justify the assignment of the production wages clearing account there?
From the authors perspective this assignment can be justified by interpreting the transaction recorded on the production wages clearing account as a kind of allocation that shifts a part of the total production wages from the company’s Income Statement into its Balance Sheet.
Stated differently, the production salary / wages posting recorded before immediately reduces a company’s profit. The start of the production on the other hand side creates a tangible value for the company in form of a (semi-) finished product and thus increases its overall wealth. This wealth increase is reflected on account no. 60110 in the company’s Income Statement.

 

C.5.2. Production step 2: Report as Finished (RAF)
The next production step consists of reporting the production as finished. Executing this production step results in the following voucher that debits and credits a Balance Sheet account with the total production cost amount of the item.
EN_91neu_0525
As only Balance Sheet Accounts are used for recording the RAF transaction, no difference between the COS and NOE method arises.
EN_91neu_0530

 

C.5.3. Production step 3: End the production order
The last production step ends the production order and ensures that the realized production costs get posted. Dynamics AX realizes this by reversing and replacing all prior production postings that have been recorded based on planned cost values with postings that are based on realized ones, that is, actual cost values. In the example used, the following costing voucher results.
EN_91neu_0535
Note: The lines that have been selected in the prior screen-print reverse the prior postings that have been created during the first two production steps.
The outcome of the production postings generated can be identified in the financial statements illustrated next.
EN_91neu_0540

Interpretation of the production costing posting created

Lines highlighted in light green color
* The amount of 300 EUR recorded on ledger account 13470 represents the stock increase resulting from the production of the finished good.
* The negative amount of 30 EUR that Dynamics AX credits on ledger account no. 13160 represents the reduction in raw materials that have been used for producing the finished good.

Lines highlighted in yellow color
* The three ledger accounts no. 53420, 53410 and 53170 are Income Statement accounts that – from an overall perspective – offset each other. That is, the total amount posted on those accounts adds up to 0 EUR.
* A first reason why these accounts were setup this way is to get the production costs – of 270 EUR for the production worker and 30 EUR for the raw materials consumed – transferred into the cost accounting module for subsequent cost analysis.
* A second reason for using this specific production posting setup is related to the NOE method as the accounts highlighted in yellow color represent stock variation accounts. The next illustration exemplifies this in detail by showing that those accounts are used “in between” each and every stock transaction.
EN_91neu_0550

Lines highlighted in white resp. orange color
* The lines highlighted in white color in the first screen-print of this section – resp. the orange line in the illustration above – shows the production costing voucher which posts 270 EUR on ledger account 60120 that arose for the assembly of the production item.
* As explained further above, from a NOE perspective, this account represents a stock variation and is consequently included in the cost variation section of the company’s Income Statement following the NOE accounting method.
* For the COS method reference can also be made to the interpretations from production step 1. That is, the amount recorded on ledger account 60120 represents an amount that allocates costs from the company’s Income Statement into its Balance Sheet and offsets the value increase caused by the production of the finished good.

 

To be continued in part (5)

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

01 Friday Jul 2016

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

≈ Comments Off on Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (3)

Tags

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

After analyzing purchase related transactions in the previous chapter we will now move on and take a look at the other business areas where differences between the COS and NOE accounting method can be identified.

C.2. Inventory adjustments
The next area where such differences can be recognized is related to adjustments of a company’s inventory. Whether or not the COS and NOE accounting method can also be applied in parallel for inventory related adjustment transactions will be investigated next based on the following sample transactions.
EN_91neu_0200
Note: Transfer orders within and between sites/warehouses and other item related transactions that do not generate ledger vouchers will not be analyzed in the following.

For reasons of brevity, no Dynamics AX screen-prints of the created inventory adjustment postings will be provided but rather a summarized overview of the ledger postings created when recording those transactions (please see the next illustration).
EN_91neu_0205

Note: The main accounts required to be setup for the inventory adjustment transactions recorded can be found in the inventory section of the inventory posting matrix shown in the next screenshot.
EN_91neu_0210

Once all four inventory adjustments are posted, the following result can be observed in the company’s financial statements:
EN_91neu_0215
In the prior illustration one can see that the Income Statement that follows the COS method incorporates the inventory profit and inventory loss accounts (no. 53150 & 53160) in the cost of sales section. Whether or not those accounts are better assigned to another Income Statement section – such as the other operating expense section – is not important for the general question whether or not the COS and NOE accounting method can be applied in parallel for inventory adjustment transactions.
What is important though is the question where to incorporate the inventory profit and inventory loss accounts according to the NOE method. Against the background of the explanations provided before, this question can be answered by stating that those accounts need to be incorporated into the stock variation section of the company’s Income Statement. That is because those inventory adjustments represent nothing else than “small” stock adjustment transactions that replace the “large” month-end stock variation transaction required for the NOE method.

 

C.3. Salary/wages & other operating expenses
Within this subchapter I will deal with the question how to record and disclose salary/wage & other operating expense related transactions in the financial statements that follow the COS and NOE accounting method.
The major difference to what has been shown previously is that the separation of the transactions according to their function of expense is now made through referencing the financial cost center dimension as exemplified in the next illustrations.
EN_91neu_0300 EN_91neu_0305
The financial statements resulting from the transactions recorded can be identified in the next screen-print.
EN_91neu_0310
An investigation of the Balance Sheet related transactions does not bring a specific notable outcome to light that deserves special attention. That is because the amounts shown on the other liabilities & accounts payable accounts (no. 22600 and 22500) increase due to the salary/wage & electricity expense transactions recorded.
What is notable though are the account balances shown in the Income Statements for the COS and NOE accounting method. In this respect it can be observed that the COS Income Statement shows the different amounts split up by functions (cost centers) whereas the NOE Income Statement shows those amounts on a summarized basis. Another disadvantage of the NOE method is thus that this method does not provide users with the same level of detailed information as the COS method.

 

C.4. Fixed asset acquisitions & depreciations
Recording and disclosing fixed asset related transactions does – in principle – not differ from the salary/wage & other operating expense transactions shown in the previous chapter. That is because also for fixed asset related transactions a separation of the different transactions through the use of a financial dimension is necessary in order to generate the Income Statement for the COS method.
EN_91neu_0400
Within the example used in this subchapter, several fixed assets have been setup and acquired first (please see the next screen-print) …
EN_91neu_0405
… before the related depreciation expense transactions were recorded.
EN_91neu_0410
The outcome of those transactions can be identified in the next Management Reporter report that shows the fixed asset acquisition and fixed asset accumulated depreciation accounts in the company’s Balance Sheet on the left-hand side.
In the middle part of the report one can identify the Income Statement that follows the COS method. From there it can be observed that the depreciation expense is split up by corporate functions by making use of the recorded financial (cost center) dimensions.
The Income Statement following the NOE method illustrated on the right-side does – on the other hand – summarize those transactions in a single line and does thus not allow an immediate analysis of the expenses recorded.
EN_91neu_0415

 

Intermediate result
In addition to the purchase related item transactions shown in the previous part, it can be summarized that also transactions related to inventory adjustments, salary/wages and other operating expeses as well as fixed asset related transactions can be posted in a way that allows the parallel generation of Income Statements that follow the COS and NOE method.
Please not that you can of course also use separate “function-related” ledger accounts – rather than financial dimensions – for separating the different corporate functions in the COS Income Statement report.
Yet, irrespective of what approach you chose for separating the different corporate functions (financial dimensions or separate ledger accounts), the most important thing that you have to take care of is that a consistent and integrated approach is followed in your company which ensures that the financial reports according to both accounting methods can be generated out of the box.

 

To be continued in part (4)

← Older posts

Microsoft BizApps Deutschland Podcast

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 Artificial Intelligence Bank reconciliation Budgeting Controlling Cost accounting Cost accounting module Cost center accounting customer D365 D365FO Dynamics 365 Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming intercompany Inventory Inventory reconciliation invoice invoice recording IOT Management Accounting Management Reporter Modern Finance MS Flow MT940 PowerApps PowerAutomate PowerPlatform Project Project module 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

  • March 2023
  • February 2023
  • 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 575 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...