Modified Multilevel BOM Report
Hello, I have modified the existing multilevel BOM report to get all the levels of the BOM. The OOTB feature only lets you fecth till the 5th level. I have modified the existing report to fetch till 18th level which was my initial requirement, this part is hardcoded and I want to make it dynamic. Please advice me on this topic. Just to gave a background, I have increased the indenture level in the Report stylesheet to 18 and made other changes accordingly, please let me know if this can be done dynamically. Please let me know. Thanks in advance, Mithun8.8KViews0likes6CommentsAras REST API - How do you navigate / create a BOM Structure using the REST API?
Hello Aras Community Members Does the ARAS REST API allow you to navigate the BOM structure, starting with a Part? For example, if I have a BOM structure as shown below, I would like to start with any Part in the structure and navigate down the BOM tree. Can anyone share the REST API endpoint for making this work, or point to a specific section in the API guide? Part A - Part A1 - Part A2 --- Part A21 --- Part A22 ------Part A221 Second question: Does the REST API allow users to create a BOM structure, e.g. a BOM tree as above? Third question: Does the REST API allow users to update the BOM structure?Solved5.4KViews0likes2CommentsBOM feature
Hi, Is it possible to modify BOM that we can see all parts levels, not just top-level, something like in the 'BOM Structure'? I think it would be helpful to see this information when building a BOM. You could even have a feature that lets you add a part directly to another level. This could speed up work by creating the BOM. Many thanks Best Regards, Erlandas4.5KViews0likes1CommentExport Relationships to Import to Another ItemType
Good day all. I would like to export all of the Relationship info from one ItemType so I can import it to another ItemType. Currently our database is configured so the Parts List (BOM) is a document and not part of the Part, both are custom ItemTypes. I would like to be able to export the BOM information from the Parts List so I can add it to the Part (trying to bring our database closer to OOTB). Thank you for any recommendations that you can provide.2.2KViews0likes1CommentPrinting a Multi-Level BOM Report for an Effectivity Resolved BOM
Experts - How do I print a multilevel BOM report for an effectivity resolved BOM? More details: We built a 150% BOM with model effectivity. We resolve the BOM to 100% by applying the model effectivity. Now we want to print this as a Multi-level BOM Report so that procurement can do their stuff? Exporting to excel is not an option, since the report is formatted and does not need all of the properties. Kamran1.9KViews0likes5CommentsCustom BOM Quantity Rollout Report
Hi, I am trying to develop a custom BOM Quantity Rollout report, we have been able to pull in all the information we need from the Parts and Part BOM however, we need help pulling in the Manufacturer Part from the Part AML, I need help in determining what I must add to the query in order to pull in the Part AML correctly, below is the current query: <Item type="Part" action="get" id="{@id}" select="item_number,name,cavi_manufacturer"> <Relationships> <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)"> <related_id> <Item type="Part" select="item_number,name,cavi_manufacturer"> <Relationships> <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)"> <related_id> <Item type="Part" select="item_number,name,cavi_manufacturer"> <Relationships> <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)"> <related_id> <Item type="Part" select="item_number,name,cavi_manufacturer"> <Relationships> <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)"> <related_id> <Item type="Part" select="item_number,name,cavi_manufacturer"> <Relationships> <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)"> <related_id> <Item type="Part" select="item_number,name,cavi_manufacturer"></Item> </related_id> </Item> </Relationships> </Item> </related_id> </Item> </Relationships> </Item> </related_id> </Item> </Relationships> </Item> </related_id> </Item> </Relationships> </Item> </related_id> </Item> </Relationships> </Item> Any help on how to modify this to include the Part AML would be greatly appreciated, Thanks in advance,1.4KViews0likes0CommentsHow we can add search mode (Simple Search, AML Search, Advanced Search) dropdown in Multi-level BOM
Hi, I am trying to add search mode in the Multi-level BOM relationship toolbar, but I am not very sure that how can I achieve this. Also, I have one custom relationship where I am displaying data in TGV, in that custom toolbar also I want the same functionality i.e Search mode dropdown. Can anyone please let me know that is there any way to achieve the same? Regards, Maddy.1.4KViews0likes0CommentsCustomize Bills of Materials (BOM)
Hello, I need to make a new BOM form where the BOM level is only 1 and I need to remove some of the columns that appear in the default BOM form. Also, need to add a logo to the form. Super new to Aras, therefore, if someone can point me in the right direction that would be great. I need to know which topic in the Aras documentation to look for. If someone can provide birds-eye-view of the whole process that would be great.199Views0likes3CommentsTree Grid View slow: reads whole branch on expand — improvement ideas?
Hi Aras Community Folks, I’m facing a performance issue with the Aras TGV, expanding a node is extremely slow at large data volumes (~10 minutes at 1M items), and it looks like the server reads all descendant rows even though only the first 100 are shown. Details below — would really appreciate any guidance. Environment: Aras Innovator 14.36(14 SP36). Standard TreeGridView over a recursive Query Definition. Short version of the problem: When a user expands a node, the grid shows only the first 100 children (page size 100, with a “Show More” row). But under the hood, the server reads every descendant item beneath that branch — hundreds of thousands of rows — even though only 100 are displayed and none of the descendants are returned in the response. At 1Million items this makes a single expand take ~10 minutes. Root item (starting point) │ └─ Level B item ← via root's reference property │ ├─ [B → B] Count(child B) > 0 │ └─ Level B item ⟲ "Reuse Query Element Definition" → back to B (recursion) │ └─ [B → C] Count(C) > 0 └─ Level C item (is_current = 1) │ └─ [C → C] Count(C) > 0 └─ Level C item ⟲ "Reuse Query Element Definition" → back to C (recursion) Page size (max_child_items) = 100 | Default grow depth = 2 Two recursive legs: B→B and C→C, each gated by Count(...) > 0 Two recursive legs: B→B and C→C, each via Reuse Query Element Definition. Each relationship is gated by a Count(...) > 0 child-existence filter. TGV settings: page size max_child_items = 100, default grow depth = 2. What we measured: Expand one mid-level B node at 1M items: ~8 min. Shows 100 B rows + “Show More”, 0 C rows — but SQL reads the full descendant set (hundreds of thousands of rows) twice (paging query + property read). Count(...) > 0 already compiles to a permission-aware EXISTS; the cost is the broad descendant read, tied to the expand-icon (hasChild) check. Relationship source_id/related_id indexes already exist. Questions: On expand of an item, only the first 100 children are shown — but the server reads all descendants beneath the branch (full data) first, then returns 100 items. The descendants are read in full just to show 100 rows and to decide each row’s “+” expand icon. Is there a supported way to fetch only the 100 displayed rows from the start, and to make the expand-icon check stop at the first match instead of reading everything? Regarding the global tgv_MaxFetchItemsCount variable (default 1,000,000): we’re considering temporarily lowering it (e.g. to 100) before an expand and restoring the default afterwards, to limit how much is fetched. Does it actually limit the result to that many rows (return just the first N), or does it only reject an over-limit request with an error? And is it checked before the heavy SQL runs (so it saves the work), or after (so the rows are already read)? Would really appreciate any guidance or suggestions on the queries above100Views0likes3Comments