I got a requirement to flow 'Vendor Item No' on Warehouse Shipment and Receipt Line and Posted Warehouse tables also. So I have two options either FlowField or through the posting routine. I tried both and working fine in both the cases. But now I want to know which is best way to do and why? Working in Business Central cloud.
Thanks in Advance.
I would use a real field and have it flow through the posting functions.
If you were using a flowfield, and the vendor changed their item number, then instead of showing the correct (at time of posting) item no. shipped, it would show you the new vendor item number. As a field it would stay correct.
But it really depends on the purpose of this requirement and the nature of the items.
Thanks Erik for the reply .
Above is one reason, I use real field.
But my confusion was, suppose the field which I need to flow will not going to change any time(just a scenario). In that case,
1 - if I flow through posting routine then as entries will increase it will help to increase database size.
2 - if I use flow field it will give me run time values, no saving data anywhere. But as a flow field it will take little(fraction of seconds) more time. in that case
Just trying to understand how to take decision.
Though Flow-fields are the easiest way to achieve such requirements but these are very expensive as they are actually executed during Run-time. Keeping performance in mind I will say be extremely decisive if you go for Flow-Fields.