It would be helpful if you could combine multiple tables to calculate a sum.
Frist example (simplified):
I want to calculate the availability for and item directly in the item overview. To do this, I need to sum the quantity in the item ledger entries minus the sum of the sales line (document type: order).
Second example (simplified):
To calculate the "open credit limit", it would be better to create a flow field as well.
With the flow field, it would also be possible to export the information to Excel and sort and filter the value.
Comments
For your information, in the "old" world, I created a query in SQL and created a LinkedObject in NAV/Navision. With the LinkedObject I was able to create FlowFields like this. With this SaaS I can't do that anymore.
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team