RELATED IDEAS
Bring in Flow Fields
Allow flow fields to be used inside reports. I used these all the time in Jet Reports and it was super convenient.
Allow flow fields to be used inside reports. I used these all the time in Jet Reports and it was super convenient.
Hi Kyle, thank you for your suggestion regarding FlowFIelds. Those are a construct that live within BC itself and are essentially calculated fields. When the user wants to leverage one they can plug in some filters (e.g. Date Filter) and BC will go off to another table, calculate the relevant records, and return the total.
Since we are exporting the raw data from BC into a data warehouse, that concept of FlowFields isn't something that we can leverage directly in the way that you may be accustomed to working with them. WIth that being said, since they are just calculations, you can create a sum function in Cosmos to do the same thing. For example, the "Balance" FlowField in the Customer table is just going to the associated customer ledger entries, so in Cosmos you can achieve the same thing by adding a sum function on the Accounts Receivable Transactions table.
Because of this, at this time we don't have plans to work directly with FlowFields in BC. We do appreciate your suggestion and reach out to us with any questions!