How to fill Last archived date of a Sales Order Archive (field 3999)

(1) Share

Report

Posted on by LE-20010955-0

Hi Community members,

I have implemented automatic archiving of orders (via Sales & Receivables Setup, TAB Archiving).

I would like to implement a retention policy on table 5107 (Sales Header Archive). I noticed that this retention policy is based on field 3999 (Last Archived Date):

Unfortunately this field is not automatically filled when archiving sales orders. This fields remains empty in all situations which I have seen so far:

The result is that the retention policy does not work.

It is by deafult not allowed to change the Date Field No. of this specific retention policy. This field is set by Microsoft.

Does anyone know what I need to do to correctly fill the field 'Last Archived Date' of the Sales Header Archive records? Preferably without any customizations. I assume this should work somehow out-of-the-box.

Thank you for your input on this topic!

Best regards,

Lianne Elzenga

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

Khushbu Rajvi. 6,300 Moderator on at

Like (1)

Report

How to fill Last archived date of a Sales Order Archive (field 3999)

Hope this helps: https://www.dynamicsuser.net/t/retention-policies-on-sales-header-archives/79114
Suggested answer

YUN ZHU 75,883 Super User 2024 Season 2 on at

Like (0)

Report

How to fill Last archived date of a Sales Order Archive (field 3999)

Hi, This is a flowfield, not an actual field, so it cannot be entered.

Its setting formula are as follows

Thanks

ZHU