• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: Statistical member based allocation

Cost accounting (8)

01 Friday Sep 2017

Posted by Ludwig Reinhard in Cost accounting

≈ 1 Comment

Tags

Controlling, Cost accounting module, Cost center accounting, Management Accounting, Statistical member based allocation

This post builds upon the previous one and illustrates a third cost allocation approach that can be used in the standard D365 application. The third approach illustrated below makes once again use of direct costs that were recorded in the financial modules.

This time, the allocations are made based on different statistical dimensions (no. of employees, no. of company cars and production data) that are setup as statistical members in a first step.

Because the statistical data that are used for the cost allocations are not tracked in D365, they need to be imported via the data management framework. In the example used, the statistical dimension member data were prepared in an Excel file that was uploaded through the data management import framework.

The target fields of the respective data entity and the uploaded Excel data are illustrated in the next screenprints.

Once the statistical members are defined and the statistical member data uploaded, the allocation policy can be set up. This time in a way that the costs of the first supporting cost center no. 110 are allocated based on the number of employees working in the other cost centers. The costs of the car pool cost center are allocated to the other cost centers based on the number of company cars used there and the costs of the product management costs are allocated to the other operative cost centers based on the number of bikes produced.

Next, a cost accounting ledger is setup and the statistical measure data provider configured.

This configuration is done in a way that a link to the import source identifier from the uploaded Excel file is made. In addition, a link to the Excel column that includes the cost object data must be established.

As an example, in the screenprint above it is specified that statistical data for the employee statistical measure are imported. Through the dimension mappings field, one can determine the column of the Excel document that holds the cost object data. In the example used that information is tracked in the ‘dimension2’ column. For details, please see the Excel screenprint further above.

Once this setup is made, the statistical measure data need to be processed, that is imported into the cost accounting ledger.

All other processing steps are identical to what has been shown in the prior post and for reasons of brevity skipped.

As in the previous posts, the next illustrations summarize the different cost center costs and allocations.

The next screenprint summarizes – as before – the executed allocations for the different cost centers together with the allocation basis measures that have been uploaded.

In the next post, we will focus on another (hierarchy based) allocation technique. Till then.

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