{"id":2143,"date":"2021-11-20T09:47:28","date_gmt":"2021-11-20T09:47:28","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=2143"},"modified":"2021-11-21T08:13:29","modified_gmt":"2021-11-21T08:13:29","slug":"use-of-repeat-until-in-dynamics-365","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-repeat-until-in-dynamics-365\/","title":{"rendered":"Use of REPEAT-UNTIL in Dynamics 365"},"content":{"rendered":"\n

Use of REPEAT-UNTIL in Dynamics 365:<\/h2>\n\n\n\n

(1) For finding sets of records in tables according to the filters and current key on tables in Business Central, use REPEAT-UNTIL with FINDSET function<\/strong>.<\/p>\n\n\n\n

(2) REPEAT-UNTIL<\/strong> is defined as finding sets of records in the table according to the filter and current key. REPEAT UNTIL<\/strong> statement is executed from left to right, it is always executed at least one time, regardless of what the Condition<\/em> is written.<\/p>\n\n\n\n

(3) Note- <\/strong>REPEAT-UNTIL: only <\/strong>use this function only when you explicitly want to loop through a record set. You should only use this function in combination with\u00a0the FINDSET function<\/strong>.<\/p>\n\n\n\n

(4) Syntax of REPEAT-UNTIL is-<\/p>\n\n\n\n

REPEAT 
<Statements> UNTIL <Condition><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(5) Let’s take an example, find sets of values and calculate its total number of documents in the Sales Header table by using REPEAT-UNTIL as shown.<\/p>\n\n\n\n

Example-01: <\/strong>Total number of Sales Orders in Table.<\/p>\n\n\n\n

\"Total<\/figure><\/div>\n\n\n\n

Source Code:<\/strong><\/p>\n\n\n\n

codeunit 50001 “Custom Functions-01”
{
    trigger OnRun()
    begin
 
    end;
 
    local procedure HowToCountNoOfRecordsInTableinBCD365()
    Var
        ApplyFilteronSalesHeader: Record “Sales Header”;
        Counter: Integer;
    begin
        \/\/Case-01 Use of REPEAT_UNTIL<\/em>
        ApplyFilteronSalesHeader.reset; \/\/Removing intial filters on table<\/em>
        if ApplyFilteronSalesHeader.FindSET then begin \/\/Find Set of record in table<\/em>
            repeat
                Counter += 1
            until ApplyFilteronSalesHeader.next = 0;
            message(‘Total Number of Sales Order No.: %1’, Counter);\/\/Show all SO No. one by one<\/em>
        end;
    end;
}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Example-02:<\/strong> Count only the first 10 sales order number.<\/p>\n\n\n\n

\"Count<\/figure><\/div>\n\n\n\n

Source Code:<\/strong><\/p>\n\n\n\n

codeunit 50001 “Custom Functions-01”
{
    trigger OnRun()
    begin
 
    end;
 
    local procedure HowToCountNoOfRecordsInTableinBCD365()
    Var
        ApplyFilteronSalesHeader: Record “Sales Header”;
        Counter: Integer;
    begin
        \/\/Case-01 Use of REPEAT_UNTIL<\/em>
        ApplyFilteronSalesHeader.reset; \/\/Removing intial filters on table<\/em>
        if ApplyFilteronSalesHeader.FindSET then begin \/\/Find Set of record in table<\/em>
            repeat
                Counter += 1
            until (ApplyFilteronSalesHeader.next = 0) or (Counter = 10); \/\/It will exit when counter is 10<\/em>
            message(‘Total Number of Sales Order No.: %1’, Counter);\/\/Show all SO No. one by one<\/em>
        end;
    end;
}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
Use of FINDFIRST FINDLAST and FINDSET in BC D365<\/span><\/a>
Use of SETRANGE and SETFILTER in Dynamics 365<\/span><\/a>
How to Show Image or Picture in Report in D365 BC from Table Field<\/span><\/a>
How to Create Sales and Receivables Setup in D365 BC<\/span><\/a>
Understanding the General Ledger and the COA<\/span><\/a>\u2013 Microsoft<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of REPEAT-UNTIL in Dynamics 365: (1) For finding sets of records in tables according to the filters and current key on tables in Business Central, use REPEAT-UNTIL with FINDSET function. (2) REPEAT-UNTIL is defined as finding sets of records in the table according to the filter and current key. REPEAT UNTIL statement is executed from left to right, it is always executed at least one time, regardless of what the Condition is written. (3) Note- REPEAT-UNTIL: only use this function only when you explicitly want to loop through a record set. You should only use this function in combination <\/p>\n","protected":false},"author":1,"featured_media":2177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[236,232,234,233,235],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/11\/Use-of-REPEAT-UNTIL-in-Dynamics-365.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/2143"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=2143"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/2177"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}