Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

Mass Approve Activate BOMs

(7) ShareShare
ReportReport
Posted on by 49
Hello everyone,
I need to mass approve/active disapprove/disactivate Bom headers and versions using the Bill of materials headers and versions V3 entity and I get this error Is there a way to fix it?
or an alternative to do the job 
Thank you

Error text:
Results. Field 'BOM' does not allow editing.
Results. Invalid specification of BOM
Results. Number sequence Bill_25 does not allow change to a lower number.
Results. Field 'BOM' does not allow editing.
Results. Invalid specification of BOM
Results. Number sequence Bill_25 does not allow change to a lower number.
Results. Validation of field 'From date' failed
Results. Validations failed

  • DO-08051210-0 Profile Picture
    49 on at
    Mass Approve Activate BOMs
    Hello Laurens,

    Thank you for your response.

    I tried using the entity 'Bill of Materials Version V4' and the result is as follows.
    If I set ISAPPROVED and ISACTIVE to No, It will create another Bom version Line not updating the current one because the ISACTIVE flag is part of the Entity Key thus modifying it will result in creating a new record.
    If I only set only the ISAPPROVED to No. It will generate the following error:
    Results. Version is not approved and thus cannot be activated
    Results. validateWrite failed on data source 'BOMVersion (BOMVersion)'



    PS: Disapproving Bills of material headers is successful with this entity: Bill of materials headers
    I only still have to disapprove the Versions
    PSS: I can also change the To Date of the bom version using 'Bill of Materials Version V4'

     
  • Suggested answer
    Laurens vd Tang Profile Picture
    2,293 Super User 2025 Season 1 on at
    Mass Approve Activate BOMs
    Good day,
     
    Thanks for sharing the Excel file.
     
    I've done a few tests... Could you try again using the entity 'Bill of Materials Version V4'?
     
     
     
    The import was succesful without any errors:
     
     
    Best regards,
    Laurens van der Tang
  • DO-08051210-0 Profile Picture
    49 on at
    Mass Approve Activate BOMs
    Hello,
    I filtered on the BOMID : 000035 (demo usmf environement),
    exported the file,
    set ISACTIVE, ISAPPROVED to No then imported again.

    here's the file
  • Laurens vd Tang Profile Picture
    2,293 Super User 2025 Season 1 on at
    Mass Approve Activate BOMs
    Good day,
     
    Could you share the Excel file you’re using for the import? Or perhaps a screenshot of the data in Excel?
     
    Best regards,
    Laurens van der Tang
  • DO-08051210-0 Profile Picture
    49 on at
    Mass Approve Activate BOMs
    Also is there an alternative?
  • Peter Kulikov (N.progression) Profile Picture
    340 on at
    Mass Approve Activate BOMs
    Hi!
    What is this "Bill of materials headers and versions V3 "?
    I have never heard of this entity and have not found any mention of it in the standard SCM documentation.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,680 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,639 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans