You’re offline. This is a read only version of the page.
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)
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
Share
Report
All responses (
Answers (
4
