Hougaard , this is just pure gold , laid down in the open , free to consume really , I would like to thank you for taking the time to stream all these videos :) On a side note (or is it lol) , do you think , you could demonstrate how to implement automatic posting of GL entries with a posting group , say for a sales invoice when posted for instance ? , I would be eternally grateful
Thanks so much Erik... your videos have been tremendously useful. Sorry for dumping code in the comments here, but I figured that would probably be more readable than my explanation and you'd no doubt see the issue right away! We wanted to have the G/L Register No. as a field within the G/L Entries table. I first looked at generating that as a standard field and saving it on post, but Flow Fields seems like a great alternative and would work retroactively too. The main issue is that the WHERE clause appears to only accept (=) equals and not greater than (
@@Hougaard Our Accounting Team requested it... I'm in IT, but I believe they're using it as a reference when they export reports for auditing purposes in batches. We're still pretty new to BC and this may be just be a legacy process that they've kept.
Okay, back to the drawing board then. I did start out looking at doing it that way, but figured it was worth a shot this way since it seemed so easy. I'm sure that I'll find other situations to use flowfields as they seem really useful! Thanks again for your videos and taking the time to reply!
how can use flowified to find difference in two dates, today and a another day. how many days have passed. I need an integer result in flow field for every record
Amazing videos you are making :) But you should have made the video 5 min. longer to show the flow filter field, and how you actually set the the value of a flow filter in code. ie OnOpenPage
Yes, the trademarks FlowField, FlowFilter, and SIFT were created together as a family. SIFT was originally "Sum-Indexed Flow Technology" - it seems that Microsoft later has changed the meaning of the "F" from "Flow" to "Field." I'm not sure why.
Hi Erik, I'm an avid fan of yours, I'm still a beginner though. I just want to ask how to make a flowfield for unapplied vendor payments...when you can only see whether the remaining quantity is open or not in the vendor ledger entry and not in the detailed vendor ledger entries. Hope I can get some light from you. Thanks in advance! 🙏😊
Can you count when a value appears in column A OR column B (or both, let's not think about XOR)? ChatGPT is no help at all, and is suggesting using "|" or "||" or if statements or the + operator in the calcformula, all of which just causes VS Code to give up hope.
Great Videos. As a starter, they really help me progressing with AL. One question: I have a list page with a date field and a Dezimal field. Also a setup Page, where I can define a duration, for Exempel 30D. In another list page, I have a date field as well and also want to add a flowfield, which shows the sum of the decimals from the first page, however only where the date is
A flowfield cannot use a "setup field". So you need to do this manually, you must calculate the field and then create the drilldown by adding your own trigger OnDrilldown() for that.
hi sir Suppose We produce Facewash of 1000 Liter using Production BOM. Now we want to fill this facewash in different bottles of 100ml, 200ml, 500ml , 1000ml (Packaging) and then sale these bottles How we can achieve this in Business Central
How will I use Calformula to auto-populate the BOOLEAN field based on a condition? e.x something like this: if I'm in PO table extension and I want a field to be true when PO is released otherwise should be false. Is there a way to do that?
What about, let say, a flowfield on Lot No. Information that take the last location code from a item ledger entry, for example, i want that this flowfield take the last entry no of type receipt for the lot I have selected. So imagine a transfer order from Location A to B with Transit location in the middile, my goal is that the flowfield that I have on the Lot No. Information shows to me the last location code = B