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

Missing custom fields restoring Quote Archive

(5) Share

Report

Posted on by OscarFernandez

Hi,

I´ve noticed in the latest 25 release that my custom fields in the Sales Line table are archived correctly but when I try to restore the Quote they are lost.

Checking the base code of BC after transfering the fields from the Sales Line Archive to the Sales Line it runs a Validate of the No. field, this triggers the code bellow that clears the custom fields

I took for granted that in any element of the system the archive and restore process of a custom fields was made by default.

thanks in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Kamal Khakhkhar 3,347 on at

Like (1)

Report
Copy link

Link copied!

Hii there,

You can update event to OnValidateNoOnAfterUpdateUnitPrice as per this you can get your data without any lost due to init or use onaftervalidate() for no.

If you found answer please mark it answered.

Thank You,

Kamal Khakhkhar

Was this reply helpful? Yes No
OscarFernandez 45 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the answer,

Yes, I subscribed to an event as a workaround but I found extrange this behaviour of the system as now I cannot trust the archive/restore process for the rest of the emelents in the system regarding my custom fields.

Was this reply helpful? Yes No
CU28031029-0 6 on at

Like (1)

Report
Copy link

Link copied!

It looks like the issue happens because when the No. field is validated during the restore process, it triggers code that clears the custom fields.

By default, Business Central archives custom fields correctly, but restoring them isn't always automatic, especially if the standard validation logic resets them.

To fix this, you may need to manually transfer the custom fields from Sales Line Archive to Sales Line after the standard restore process. You can do this by extending the restore functionality with an event subscriber or modifying the process to include your custom fields.

Let me know if you need more details on how to implement this!

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 3,347 on at

Like (1)

Report
Copy link

Link copied!

Hii there,

As per requirement you need to add all the fields in use event of

CU -ArchiveManagement

event -OnAfterRestoreSalesLines in this event you need to assign the custom field value of sales line archive to sales line. So it will flow . You can do validate () also if you require..

As per i check it's same code is written in base action of restore documents in archive sales quotas

Mark it answered if you found answer.

Thank you.

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Your custom fields are lost because the Init() function clears them during the restore process when Validate("No.") is triggered. To fix this, ensure the fields are explicitly restored after validation or modify Init() to preserve them.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,258 on at

Like (1)

Report
Copy link

Link copied!

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No