Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

Mass Approve Activate BOMs

(5) ShareShare
ReportReport
Posted on by 45
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
    DO-08051210-0 45 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
    lvdtang Profile Picture
    lvdtang 2,156 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
    DO-08051210-0 45 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
  • lvdtang Profile Picture
    lvdtang 2,156 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
    DO-08051210-0 45 on at
    Mass Approve Activate BOMs
    Also is there an alternative?
  • 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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans