BOM Material List Summary - Total Length Zero Supression

[Lewk_SGS]

The total length of the pieces for the P1000 Unistrut (which is a custom section that is classified as a Beam) is correct. However, the format is not what I desire. I do not want 41' 1/2" as it is currently shown, I would like it to show 41'-0 1/2".

I searched around in the BOM Editor for a bit, and I found that the DataField is "../SLength" but I can't find it in anywhere in the database, let alone anything in the Defaults in MT to edit the format. All of the lengths of the pieces show X'-0" instead of X' so maybe it's something with just that "_ Summary Length _" cell? I dunno, I'm stumped.

[DMorton_Graitec_Mtl]

You may want to check your Management Tools - Defaults. There is an option there to remove the 0 on inches. If it is enabled then this will affect the BOM output. 

WITH OPTION CHECKED:

WITHOUT OPTION CHECKED:

[Lewk_SGS]

Thank you for your reply.

I have the option unchecked. I should've specified that this is for the list called "Material List Summary". As I can see in your screenshots this was not the BOM list that you used, as it does not contain the total length. The length shows with the added zero as expected, but the total length does not.

[DMorton_Graitec_Mtl · Accepted solution]

I looked through the following areas:

• Report fields and settings.
• Management Tools --> Defaults
• Management Tools --> Various databases for the program, including the .mdf files in the kernal folder.
  • The summary Length token can be found in the BomExternTokens table of the AstorKernelEnvironment mdf. There are no settings here however to control the visualization of the '0' in the length output. 

I also tested the field itself, in this group, by changing the token from Slength to Ilength. The standard Ilength token (used in the details area) works here and places the '0'. Therefore I can only conclude that it is not the list group or field that is the problem but the token itself.

After searching, I could not find anywhere that controls the output of the Slength token and other tokens do display the '0'. My guess is that for this token it is hardcoded not to display the '0'. 

[Lewk_SGS]

Thank you for looking into this. It pretty much confirms what I thought.