Row Modifier for Beginning Balance /BB is NOT working

(1) Share

Report

Posted on by Community Member Microsoft Employee

When I try to use the beginning balance row modifier "/BB" in my cash flow statement it always = $0. I created a new row definition and it didn't work there either. I tried other row modifiers to see if any of them worked and they did. Below is my row with modifier.

*This post is locked for comments

All responses (9)

Answers (2)

Matloob 781 on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Hi Bat,

I had a similar situation also and when i changed my report setting to "Perform column calculation first and then row" it worked and perfectly displaying opening and closing balances in respective columns.

I am using MR with AX 2012 R3.

Regards

Muhammad Matloob
CG-Fisk on at

Like (1)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Thanks Ven, I used your suggestions and it worked. The problem I had a piece of info in the row definition that was not related to the column definition. I saw in an example that was saying "do the same thing" in these 2 cases as you did in the column definition. The problem was, there was only "1" case on the column definition and not 2. When I removed the one from the row definition that had no reference in the column definition, the report generated perfect. Thanks.
26P2ER 1,773 on at

Like (1)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Hello -

I can't see your attachment. Maybe it is a good idea not show the actual report that is in use.

Regarding your problem -

Have you tried the below

Clone your row definition, column definition and report definitions.

Open the report definition cloned from your original report.

Make sure you select the row def and column def you cloned in the 1st step and save your changes.

Next, open up the clone row def and add one line to the top, include a high volume balance sheet account from that category by choosing

[main account segment] in the FD and not Account category and punch in the value, for example, if the account is 000-1100-00, you would add this for segment 2 in FD for the from and to.

Generate the report and check if this line yields any results. It should match what you have for 000-1100-00 in Account Summary Inquiry from within GP.

If your cloned report passes this pencil test, then you will have to check what the account category the balance sheet accounts belong to. The account category should be typed exactly as they appear in GP if you have an account category called Misc & Other Expenses but in MR your row definition has Misc Other Expenses for account category, that line will not yield accurate results.

Best regards

Ven
CG-Fisk on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

I really need help with this CF statement. The study material that I have gives standard guidance only; nothing with a unique situation. My CF statement is still not matching the official stmt. When I set up the row definition I used the correct accounts for each category. When the report generates, all information comes in correctly on the report except for the 'cash and cash equivalent beginning balance category'. So I use the account modifier to bring this information in.

I realize some modification has to be given to the column definition. The default for YTD period was "YTD." When setting generates the correct information for all categories but leaves the beginning balance category blank. When I change the period information in the column definition to bb\YTD, the report generates the beginning balance for the cash and cash equivalent category but all other information is off. I went back to the row definition and chose for the account modifier to bring in the beginning balance on the cash and cash equivalent category only but that did not work. The report still has the wrong information.

Official CF Statement Format
26P2ER 1,773 on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Hell CG-Fisk -

I tried this just now on MR 2012 CU14 for Dynamics GP 2010 SP1 - we use the MR Data mart.

Here are snippets from my row definition , column definition, row modifier and output listing:-

Row def

Row Modifier def

column Def

Output Listing

Calculation Priority used:

Best Regards
CG-Fisk on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Mine is on column calculation and I'm still getting zero. Are there any other suggestions as to why my report can't pull beginning balances?
CG-Fisk on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Ven, you instructed them to go to the setting tab to check the calculation priority.

I'm having the same problem, trying to get the beginning balances to generate but the results are zero. What should the calculation priority be set at in order for the beginning balances to pull in (perform column or Perform row)?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Thank you so much Ven! My calculation priority was "Perform row calculation first and then column" so I switched it to "Perform COLUMN calculation first and then row" and it works!! Thanks for your help!
Verified answer

26P2ER 1,773 on at

Like (0)

Report

RE: Row Modifier for Beginning Balance /BB is NOT working

Hello BaT,

Could you review Settings tab at the report level and check to see if what you have for calculation priority.

I am on MR2012CU14 and I am able to add a row modifier of /BB to a row line.

Could you perhaps try this on a different natural and see if you get a similar result?

Best Regards

Ven