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

Indent string field based on indentation (BOM)

(0) Share

Report

Posted on by SammySevens

130

Hi All,

I am trying to create an indented BOM in BC. The closest I get is when I show BOM from assembly item, giving an image like the below. Ideally - I want the "No." field name to be indented based on indentation level value

My AL code is below as well, as a page extension for BOM STRUCTURE....however it doesn't seem to do anything on the page...what am i missing?

    trigger OnOpenPage()
    var
        levelOneIndent: Text[20];
        levelTwoIndent: Text[20];
    begin
        levelOneIndent := '     ';
        levelTwoIndent := '          ';
        repeat
            if rec.Indentation = 1 then
                rec."No." := levelOneIndent   rec."No.";
            if rec.Indentation = 2 then
                rec."No." := levelTwoIndent   rec."No.";
            rec.Modify()
        until rec.Next() = 0;
    end;

I have the same question (0)

All responses (7)

Answers (0)

KasparsSemjonovs 4,780 Super User 2025 Season 2 on at

Like (0)

Report

As the Replenishment System is already field where indendation works, I would advice just to Copy/compare that part with Your field No.

Was this reply helpful? Yes No
Robert Jolliffe 885 on at

Like (0)

Report

If you look at the Cost Shares page (under an Item | Navigate | BOM | Cost Shares) that is a good example of an indented BOM structure.

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

Do you mean you want to use your "No." field as an indentation field like Replenishment field in your picture? if not then simply adding the field should get indented with all the other fields.. you don't have to add extra empty space.. also why don't you try the OnAfterGetCurrRecord trigger? and instead of using Indentation, you can look at the "Low-Level Code" field..

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, there is a very good example in the post below, hopefully it will give you some hints.

https://businesscentralgeek.com/tree-view-property-business-central

Thanks

ZHU

Was this reply helpful? Yes No
SammySevens 130 on at

Like (0)

Report

Thank you all, and Zhu thank you for the example, now I understand it.

My only question is how do I persist this indentation when exporting to excel? It seems like when I export to an excel spreadsheet, the indentation is gone. Please see below (based on existing replenishment system)

Thank you

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

I believe when you export the data to Excel, you won't be able to keep the same indentation as in BC. You'll need to manually select the columns that contain the indentation level and format them to be indented in Excel.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, I tested copying and pasting directly to Excel, same problem. So unfortunately, as Govinda mentioned, this can only be done manually.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No