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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Tie Breaking Logic For...
Small and medium business | Business Central, N...
Suggested answer

Tie Breaking Logic For Production BOM Versions [NAV 2013 R2]

(1) ShareShare
ReportReport
Posted on by Community member 2
Hi,
 
Trust you are well.
We are trying to implement a codeunit that queries the active BOM version for a given Production BOM Header..
We have applied following filters on the bom versions table..

Production BOM No. = BOM Header PK
Status = Certified
Starting Date <= TODAY()

There is a possibility that we may end up with more than 1 records in this case.. so we were interested in knowing NAV's tie-breaking rule so that we can mimic the same in our code.
 
Thanks.
Categories:
Dynamics 365 Business Central
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 6,181 Super User 2025 Season 2 on at
    Tie Breaking Logic For Production BOM Versions [NAV 2013 R2]
    Not a programmer, so I can't tell you the code.  You should change your Starting Date logic to pick the most current date out of the matching BOM Versions it finds.  Then it will select the most current BOM Version out of the list of Certified BOMs.  Hope this helps.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 461 on at
    Tie Breaking Logic For Production BOM Versions [NAV 2013 R2]
    Namaste 
     
    Version No is unique with Production BOMs . One Production BOm can have multiple Versions . You will get multiple records against one BOM No if there are multiple Versions . 
    If you want version wise specific then please add in your script 
     
    IF this has helped , please verify the answer 
     
    Regards
    Pallavi Phade

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,856

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,681 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,342 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans