I have designed the P&L report using AX Financial Statment, Now the issue is I tried to design Balance Sheet & I want to pick the Net P&L Value from P&L, I choose structure & select NET Profit node from P&L Statment but system give error,
“System error in calculation expression on the row structure:IS dimension name:Net profit”
If there is any problem in the calculation expression this error also come in the IS but its working fine. Another thing, if I select the another node from IS the value came.
Please find the attached for Financial Statment Steps
That’s fine. Just try once. I was configuring in AX 4.0 and there i faced some issue using structures. So i created duplicate of the row definition with calculation removed and called the updated row structure in the PL structure.
If you get this error message, don’t make your life difficult.
I suppose that you need to have total assets and total liabilities & shareholders equity balanced, right?
Rather than using the structure, create a separate position under shareholders equity where you include the current net profit/income by selecting all profit and loss accounts.
Hello Ludwig and Pranav, I need a P&L statement with two dimensions - BU and Department. My primary dimension set contains these two. Seconday dimension set is main-account set. (do I need seconday?).
Here is my set up - Primary dimension set is “BU+Dept”; Seconday - Main-account Set; In the set up - I use the row definition for secondary dimension set.
I have 4 columns - Business Unit, Department, Account name and Current Year
Account name - secondary dimension set name;
current year - current
what do I put for Business Unit and Department? Its bit confusing to generate per dimension.