Small and medium business | Business Central, N...

Recording Production BOM Changes in Active Version

(7) Share

Report

Posted on by AK-13051749-0

268

Is there a way we can record the date when the Active Version on a Production BOM gets updated, and also record the value of the previous active version and the current active version?

The Active Version field does not exist in the table but only exists on the page.

Any suggestions or guidance will be greatly appreciated. Thank you!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Dhiren Nagar 2,675 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

All the versions, current active version as well as all previous version gets saved in BOM version list. So in that table you have all the information you need. As to when the active version was updated you can check last modifidd date on active version for that.

Now if you want all these details to be on the BOM page, you can do customization to bring those values from BOM versions table to current page.

Regards,

Dhiren.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 10,974 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello ,

The Active Version isn’t stored anywhere — it’s calculated at runtime from Production BOM Version records based on Status = Certified and Starting/Ending Date vs Work Date, so you can’t log it directly; the correct approach is to calculate the active version yourself and log changes when it flips. Do this by subscribing to Production BOM Version table events (OnAfterModify/Insert/Delete), calculate the old active version before the change and the new active version after, and if they differ, write a row to a custom log table with BOM No., DateTime, UserId, Old Version, New Version. Just note that the active version can also change automatically when the Work Date moves, so if you want to capture that too, you’ll need a job queue check.

Regards,

Oussama

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,949 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

This can be achieved only through customization, the reason is that the Active Version field is not stored in the database; it is a calculated value shown on the Production BOM page, determined dynamically based on Certified BOM Versions and their Starting Dates. Since no actual update occurs on the Production BOM record when the active version changes, Business Central does not capture the previous or current active version, nor the change date. Therefore, tracking this information is not possible in standard functionality and requires custom logic to calculate and log version changes.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,014 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

As far as I know, only customization can achieve this. Alternatively, you could submit this idea to Microsoft.

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Thanks.

ZHU

Was this reply helpful? Yes No
Guy-JM 115 on at

Like (0)

Report
Copy link

Link copied!

You could achieve logging the changes using Power Automate but would need a new API.

To get a new API, you can get your partner to write this or it is move cost effective to use Hougaard Simple object designer if using power platform regularly.

Was this reply helpful? Yes No