Need Validation to Restrict Backdated Entries

[khaanw]

Is your feature request related to a problem? Please describe.
Yes. Currently, the ERP system allows users to submit transactions with any past date. This can lead to data integrity issues, as it opens up possibilities for users to manipulate historical data without control.

Describe the solution you'd like
We would like to implement a backdate transaction tolerance limit in the ERP system. Specifically, users should only be allowed to submit transactions with a posting date no more than 3 days (H-3) before the current date. If a user attempts to enter a transaction older than 3 days, the system should block the submission and display an error message like:
"You are not allowed to post transactions more than 3 days in the past."

Describe alternatives you've considered
An alternative could be to implement a role-based override or approval mechanism for backdated entries beyond the 3-day limit. However, the primary goal is to set a strict restriction unless otherwise authorized.

Additional context
Steps to Replicate the Issue:

Go to a transaction form (e.g., Stock Entry, Sales Invoice, Journal Entry, etc.).

Set the posting date to more than 3 days in the past.

Try to submit the transaction.

Observe if the system restricts the submission.

Current Behavior:
The ERP system currently allows users to post backdated transactions without any limit.

Expected Behavior:
The system should enforce a validation rule preventing submission of any transaction dated more than 3 days in the past. The user should receive an appropriate error message if they try to do so.

[ankush]

Already exists.. partly:

[ankush]

accounts don't have "days" config, but if you want that can be handled with few lines of customization to update the frozen date daily.

Perhaps it should just be added to core.