But it would be great to add additional filters to the existing CalcFormula.
Something like:
modify(Quantity)
{
AddToCalcFormula = "Parcel No." = FIELD("Parcel No. Filter");
}
Comments
That's a very good suggestion from Thomas. Infact, I had a similar situation with one of my clients who wanted to deactivate unposted job planning lines and that inactive filter should apply to the CalcFormula property on few job task fields. Not only did we create a copy of these new fields, but we also had to make a copy of several other objects such as the job statistics, job details, etc. so as to print the appropriate totals.
Requesting Business Central team to kindly work on this idea as it will really help AL developers to create dynamic metrics. Thank you!
Category: Development
This is a great suggestion. Please consider it as an addition to a future release.
Category: Development
Indeed adding the possibility to extended CalcFormula in Flowfields will solve many issues regarding extensibility and furthermore reduce scientifically the overall extension logic as already mentioned before (Reports,Factoboxes)
Category: Development
I agree that providing such an option as the one suggested AddToCalcFormula = "Parcel No." = FIELD("Parcel No. Filter"); it would be of great value
Category: Development
Very good suggestion.
We need to add FlowFilter Job No. to the G/L Account table and extend CalcFormula for related FlowFields which are shown on many pages and reports.
Standard solution to create our field is very awkward
Category: Development
Good suggestion. if such a modification is not possible, for some extensions you might have to copy several reports, factboxes, and 2 extensions with the requirement to modify quantity will multiply the fields even further - and if the customer wants to use both filters, a extension based on extension A and B must be made with a new copy of the fields, reports, factboxes...
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