Adding a Flow Field from another table to a Form.

Business Central/NAV User Forum
1

I have been asked to add Quantity On Hand a flow Field from the Item table 27 to a form for Production BOM - 99000788.

If it’s not on the list of field menu to add how do you go about adding a field to a form - let alone a flow field.

Thanks in advance.

Greg

2

Hi Greg,

First of all declare a record variable for the Item table

Add a textbox from the toolbox. Add into the source property Item.Inventory (I assume this is the field you want). Then add the C/AL code in the onaftergetrecord

if not item.get(“no.”) then

item.init

else

item.calcfields( Inventory );

You might have to add to the onaftergetcurrrecord as well.

3

That’s the field I want Dave.

I’ll give it a try and see what happens.

Thanks,

Greg

4

I think I would try adding the inventory field to the other table first. Flowfields will perform much better than running that code from the form.