Your videos are extremely helpful - I understand BC so much better because of them. Thanks a lot!

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

A deep class in less then half an hour! Thank you Erik!

@Hougaard

2 жыл бұрын

You're welcome, enjoy many more classes on the channel :)

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

@Hougaard

3 жыл бұрын

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.

Erik - how would you get the new list to mimic the entire list of the customer list so that you didnt have to manually type in the customers?

@Hougaard

3 жыл бұрын

By making the page run on the integer table and the simulate table operations on triggers...

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

Жыл бұрын

Why do you want the register on the G/L entries?

@m-cos

Жыл бұрын

​@@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.

@Hougaard

Жыл бұрын

I don't think is solvable with flowfields. You could create a real field, and the populate it from an event subscriber in the posting routine.

@m-cos

Жыл бұрын

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!

@Hougaard

Жыл бұрын

Get inspiration from this video kzread.info/dash/bejne/qmppt7unZrHKp7Q.html

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

@Hougaard

3 жыл бұрын

Thanks Flemming, yeah, thinking about a quick followup video :)

@erikseifert6059

3 жыл бұрын

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! 🙏😊

@Hougaard

2 жыл бұрын

Thanks... But "unapplied" would just be all the open ones?

need flowfilter example video

Is it possible to show two flowfields data in one field? For Ex. Can we show orders and Sales in one field by using Flow fields?

@Hougaard

Жыл бұрын

No

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.

@Hougaard

Жыл бұрын

You can not... Flowfields are implemented in pure (limited) SQL

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?

@Hougaard

3 жыл бұрын

You dont, but you might be able to use the EXIST() flowfield to accomplish something like that.

@umarnaeem6128

3 жыл бұрын

@@Hougaard please can you give me a small example ?

@Hougaard

3 жыл бұрын

EXIST(where(Status=const(Release)) ?

@umarnaeem6128

3 жыл бұрын

@@Hougaard Thanks ^^

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

@Hougaard

Жыл бұрын

Those would be BOMs also. (Bottle+content)

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

@Hougaard

10 ай бұрын

You cannot get the last record in a flowfield.