Supply chain | Supply Chain Management, Commerce

Mass Approve Activate BOMs

(7) Share

Report

Posted on by DO-08051210-0

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

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (6)

Answers (0)

Peter Kulikov (N.pr... 579 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
DO-08051210-0 49 on at

Like (0)

Report

Mass Approve Activate BOMs

Please refer to this
Bill of materials headers and versions V3 | Dynamics.FO - F&O Documentation and References

Also is there an alternative?

Was this reply helpful? Yes No
Laurens vd Tang 3,627 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
DO-08051210-0 49 on at

Like (0)

Report

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

BOM and versions ...

Was this reply helpful? Yes No
Suggested answer

Laurens vd Tang 3,627 Super User 2025 Season 2 on at

Like (3)

Report

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

Was this reply helpful? Yes No
DO-08051210-0 49 on at

Like (2)

Report

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'

Was this reply helpful? Yes No