How can I archive extension tables of Project?

(7) Share

Report

Posted on by CU08052056-0

1,185

Hi experts!

I would like to archive extension tables' data of Projects, so I set Archiving = "Always", below.
However, that doesn't work. How can I archive every extension table at any time when updated?

Look forward to herring from you.
Nobuhara

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Jinal P. 300 on at

Like (4)

Report

Hello,

The standard archive functionality in Business Central only archives a project when its status is set to 'Completed'. There is a standard 'Archived Project' table where you can view these archived records.

If you need to track all updated records (regardless of status), you might consider using change logs.

Alternatively, please clarify your exact requirement so I can suggest the best approach.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Sahib Dino 196 on at

Like (4)

Report
Business Central’s standard archiving behavior is usually tied to status changes or user actions, such as:

Completing a Job

Posting a document (e.g., Sales Order)

Running a specific archive action or codeunit

So, even if you've set Archiving = Always; in your extension table, nothing will happen until the base table triggers archiving — and that only happens when:

)You manually run the archive

)Or the system logic triggers it, like on status = "Completed"

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (3)

Report

It does not automatically archive data every time you update or change something in the table my friend. If you want archiving to happen in other cases, you need to add custom code or logic to handle it.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

CU08052056-0 1,185 on at

Like (2)

Report

Hi experts!

Thank you for your advice.

Once again, I will explain my issue, below.

I archived Project 113 with Table extension field is RED part,

However, I can't find that on the Project Archived Card, below and I can't search that Field from Page Inspection.

How can I archive this extension field?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (3)

Report

Have you added this custom field to the Job Archive table?

You should also review the standard logic. If the standard uses the TransferFields method, fields will be automatically transferred as long as the id, name, and type remain the same.
If the standard uses the assignment operator or the validate method, fields will not be automatically transferred.

Thansk.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (3)

Report
To archive extension fields from your custom table extensions (like Project/Job extensions), setting Archivable = Always in the field alone is not enough. You also need to:

Extend the Archive Table (e.g., Job Archive) and add the same custom field there.

Ensure that the archiving logic in the base app (usually Codeunit 1002 Job-Post or similar) copies the field values during the archive process. If TransferFields is used, your field will copy automatically if the field name, type, and ID match in both source and archive tables.

If the base code uses Validate() or direct assignment (JobArchive.MyField := Job.MyField), you'll need to customize or subscribe to that logic via an event subscriber and manually handle the data copy.

Tip: Use the OnBeforeArchiveJob or OnAfterArchiveJob events to add custom logic if needed.

If you're not a developer, you’ll need help from your Microsoft partner to implement this correctly.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (2)

Report
Hi there,

Setting Archive Projects = "Always" in the Projects Setup ensures that the main project data is archived, but it doesn't automatically include data from extension tables unless those tables are explicitly configured for archiving.

To archive extension table data when updated, consider the following steps:

Custom Archiving Logic: You may need to implement custom logic in your extension to handle archiving. This typically involves subscribing to events like OnAfterModifyEvent or OnBeforeModifyEvent and manually copying data to an archive table.

Use Archive Tables: Create corresponding archive tables for your extension tables and ensure they mirror the structure of the original tables.

Trigger Archiving: In your extension code, trigger the archiving process whenever relevant data is updated. This gives you full control over what gets archived and when.

Review Documentation: Microsoft’s documentation on archiving in Business Central may provide additional guidance, especially for handling custom extensions.

Let me know if you need help with the code or setup!

Please verify if this response was helpful.

Best regards!

Was this reply helpful? Yes No