Dynamically change table box columns


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?



Hi Gabor,

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

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.


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.