Cost accounting report structure

(0) Share

Report

Posted on by Hristo Filipov

Hi,

I am setting up Cost accounting module but I need help.

I am trying to set up a P&L report using Expense distribution sheet. The structure of the lines of the report is:

Revenue

COGS

Gross profit

Sales expenses

Administrative expenses

Total OPEX

Financial expenses

Net profit/loss

The problem is that I cannot split the expenses between Sales and Administrative. For example the labor cost. It is booked in one GL account(cost category) by cost centers. So, in line Sales expenses I should include only the amounts for cost center Sales and in line Administrative expenses I should include the amounts for cost center Administration. When I set up the line structure or Expense distribution sheet I cannot set up the line to be for a specific dimension value or values.

How can I do it? Is there nay functionality for this?

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Hristo Filipov,

In the cost lines form you can only assign an expense once, as you describe above.

A possible workaround of creating your report is the Management Reporter.

As you know, the Management Reporter can't retrieve secondary cost elements from the cost accounting module. However, you could alternatively make use of the GL ledger allocation rules and statistical ledger accounts to get your allocations incorporated into such a MR report.

Another alternative is using the new cost accounting module. With the spring release, users have the possibility to retrieve their data from AX2012 systems and to use them in the new cost accounting module. Yet, this needs more effort and a larger investment.

Best regards,

Ludwig

Was this reply helpful? Yes No