Balance in specific date for allocation basis

Summary:

Is it any way we can derive balance in specific accounting date for allocation basis?

Content (please ensure you mask any confidential information):

We have requirement to derive balance in specific accounting date for allocation basis

For example

Create Journal for Account A accounting date 1-Mar-25 amount 0.5 Debet

Create Journal for Account A accounting date 3-Mar-25 amount 0.7 Debet

We want to derive balance of account A on specific accounting date 3-Mar-25 (0.7)

Is there anyway we could achieve it?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):