FlowFields, the superpower inside Business Central.

Ғылым және технология

Find more information at my blog www.hougaard.com or follow me on / ehougaard
Source code can be found here: github.com/hougaard/KZread-V...

Пікірлер: 36

  • @pleasecheckmyid
    @pleasecheckmyid3 жыл бұрын

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

  • @saouchiilyes9630
    @saouchiilyes96303 жыл бұрын

    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

  • @hugo_alves
    @hugo_alves2 жыл бұрын

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

  • @Hougaard

    @Hougaard

    2 жыл бұрын

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

  • @k.lindner6836
    @k.lindner68363 жыл бұрын

    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

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

  • @jackpeterson480
    @jackpeterson4803 жыл бұрын

    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

    @Hougaard

    3 жыл бұрын

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

  • @m-cos
    @m-cos Жыл бұрын

    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

    @Hougaard

    Жыл бұрын

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

  • @m-cos

    @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

    @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

    @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

    @Hougaard

    Жыл бұрын

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

  • @user-ku9er7ph2i
    @user-ku9er7ph2i6 ай бұрын

    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

  • @heimdaldk
    @heimdaldk3 жыл бұрын

    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

    @Hougaard

    3 жыл бұрын

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

  • @erikseifert6059

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

  • @jennyabao8132
    @jennyabao81322 жыл бұрын

    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

    @Hougaard

    2 жыл бұрын

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

  • @shahidullah07
    @shahidullah073 жыл бұрын

    need flowfilter example video

  • @kish100100
    @kish100100 Жыл бұрын

    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

    @Hougaard

    Жыл бұрын

    No

  • @tristancliffe
    @tristancliffe Жыл бұрын

    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

    @Hougaard

    Жыл бұрын

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

  • @umarnaeem6128
    @umarnaeem61283 жыл бұрын

    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

    @Hougaard

    3 жыл бұрын

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

  • @umarnaeem6128

    @umarnaeem6128

    3 жыл бұрын

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

  • @Hougaard

    @Hougaard

    3 жыл бұрын

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

  • @umarnaeem6128

    @umarnaeem6128

    3 жыл бұрын

    @@Hougaard Thanks ^^

  • @ScrollwithSpyder
    @ScrollwithSpyder Жыл бұрын

    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

    @Hougaard

    Жыл бұрын

    Those would be BOMs also. (Bottle+content)

  • @user-um6jk3wc9f
    @user-um6jk3wc9f10 ай бұрын

    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

    @Hougaard

    10 ай бұрын

    You cannot get the last record in a flowfield.

Келесі