Small and medium business | Business Central, N...

Fill up data from temporary table to normal table

(5) Share

Report

Posted on by CU22100733-0

281

Hello,

I want to fill up data from Temporary table to normal table, by editing the qty, and getting that qty into normal table , on Action-I am not able to do it properly , kindly suggest me the code here. When it comes to findset it goes directly to end.

 ItemAvailbleTable.Reset();
        ItemAvailbleTable.SetRange("Item No.", MOItem."Item No.");
        IF ItemAvailbleTable.FindFirst() THEN;
        ItemAvailblePage.LookupMode(true);
        ItemAvailblePage.SetTableView(ItemAvailbleTable);
        if ItemAvailblePage.RunModal() = Action::LookupOK then begin
            ItemAvailbleTableTemp.Reset();
            ItemAvailbleTableTemp.SetRange("Item No.", ItemAvailbleTable."Item No.");
            IF ItemAvailbleTableTemp.FindFirst() THEN;
            MOItem.Reset();
            MOItem.SetRange("MOCode", Rec."MOCode");
            if MOItem.FindFirst() then
                ItemAvailbleTableTemp.Reset();
            ItemAvailblePage.SetSelectionFilter(ItemAvailbleTableTemp);
            ItemAvailbleTableTemp.SetCurrentKey("Item No.", "Location Code");
            if ItemAvailbleTableTemp.FindSet() then begin
                repeat
                    MOItem.Quantity := ItemAvailbleTable."Qty to Allocate";
                    MOItem."Location Code" := ItemAvailbleTable."Location Code";
                    MOItem."Unit Price excl. VAT" := ItemAvailbleTable."Last Unit Price";
                    MOItem."Line Amount excl. VAT" := MOItem.Quantity * MOItem."Unit Price excl. VAT";
                    MOItem.Modify(true);
                    LineNo += 1000;
                until ItemAvailbleTable.Next() = 0;
            end;
        end;

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

Report

ItemAvailbleTableTemp.FindSet() is used on the temp table after selection filter is applied. Inside the loop, you're using ItemAvailbleTableTemp, not ItemAvailbleTable anymore. MOItem.SetRange("Item No.", ...) is used to make sure the correct item line is found before modifying.

I have below suggestion which might help find the error message

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

The copy method on temporary records – The BC Docs Librarian

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (2)

Report

If the code only contains this paragraph, no value is inserted into ItemAvailbleTableTemp, which is empty, so there is no way to find data.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (2)

Report

How did you fill in the ItemAvailbleTemp record?

It looks like the variable ItemAvailbleTemp is empty.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (2)

Report

ItemAvailbleTableTemp is empty because you never inserted or copied any data into it, so when you try to FindFirst or FindSet, it finds nothing and ends immediately. You must first fill the temporary table before you can loop through it.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (2)

Report

Check this: https://www.fornav.com/knowledge-base/how-to-fill-temporary-tables-in-al-code-and-use-them-in-custom-layouts/

Was this reply helpful? Yes No