web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

BOM Report - When Printing Multi-Level BOM Report.. Sort Order Question

(0) ShareShare
ReportReport
Posted on by 245

Does anyone know how to alter the Multi-Level BOM Report, using the Report Modifier, to sort the order of the BOM items so they will display on the report tree-style fashion? For further clarification on my question: If you look at an item's BOM structure on the Bill of Materials screen and expand all the nodes, this is what I'm trying to make the Multi-Level Report to print out like. The report definition's original sort order has no sort order specified.

I tried using PositionNumber, Level0, and PositionNumber2 in different orders but I can't seem to achieve the desired results using this combination of sort fields. As of right now, it's looking slim that this is going to be possible due to the limitations on sorting in the Report Modifier.

Thanks in Advance

 

**Update** I changed the key to the following and it worked well enough for what we needed. Any level after the 1st level in the BOM sorts by item number, so I'll leave this post open in case someone figures out how to sort all levels by their position number in the Report Modifier.

*This post is locked for comments

I have the same question (0)
  • Jeff Titus Profile Picture
    245 on at

    I took out the sort by fields and used the key that sorts by position number. That seemed to work but it has a few hiccups.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans