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;

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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.
SammySevens 130 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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
Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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..
Robert Jolliffe 859 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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.
KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

RE: Indent string field based on indentation (BOM)

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