Dynamically change table box columns

Business Central/NAV Developers Forum
1

Hi,

I want to have columns in a tablebox for each bank account (with the caption of the bank account code, and the field values (balances) would be calculated from a code). As bank accounts can be modified dynamically, how is this possible?

Thanks,

Gabor

2

Hi Gabor,

Sound like you want a Matrix box - have a look at the items by location form for an example.

3

OK, thank you, this is what I need. But I still a question:

How is the relation given in the matrix between the items and locations? In Item table I can not find location field.

Gabor

4

Hi Gabor,

You will not find Location code in the Item Card, but you will find Location Filter (FlowFilter) [:)] And the quantity shown is actually Inventory field in Item card, which is a FlowField to Item Ledger Entry with Location Filter as one of the filter.

Regards,

-TR-