Filter Responsibility Center on COA

Business Central/NAV Developers Forum
1

Hi Everybody

On NAV 2013 I use Responsibility Center. I want filter by Responsibility on Chart Of Account.

Please give me one solution.

Thanks very much.
2

Hi Dinhson,
You don’t have responsibility center on GL Entries, so you cannot filter on responsibility center on the COA.

I have before had the same requirement. And what you could do is to create a “responsibility center” dimension. Typically that dimension already exists, if the customer is using dimensions. So you “fix” a dimension to each responsibility center and then you can filter on that dimension in COA.

3

Thanks you for reply.

on table GL Entries i link filed Responsibility Center with table Dimension Set Entry on relation field Dimension Set ID
and When I filter on Table G/L Account
TableRaletion = “Dimension Value”.Code WHERE (Global Dimension No.=CONST(9))

But still fails. (Filter Limited Total on Page 16 Chart of Accounts)

4

What do you mean by fails?

5

it does not filter results respon Code. I similar manner of Dimension (Brand, Cost Center) but not success.

6

I recently tried for another issue to use syntax WHERE (Global Dimension No.=CONST(x)) - it seems to be working only with x=1|2…

(should add that my NAV programmer’s skills are rather poor, maybe the above is not correct)

7

Thanks Modris Ivans. I tried unsuccessfully