Task #19414: Capture and record advance payment into client account - FFA - Redmine

Actions

Copy link

Task #19414

open

Capture and record advance payment into client account

Added by Redmine Admin 21 days ago. Updated about 5 hours ago.

Status:

Priority:

High

Assignee:

Start date:

02/10/2026

Due date:

02/25/2026 (6 days late)

% Done:

100%

Estimated time:

32:00 h

Spent time:

32:00 h

GitLab ID:

3825

GitLab Milestone:

GitLab Ticket Number:

1207

GitLab Time Logged:

115200

Lock Timeline Date:

gitlab project trace:

Description

I want to record advance payments received from clients, including payments made in foreign currencies, so that the client’s advance account balance in MUR is accurately updated and can be used to settle future invoices.

Pre-Conditions

Client account exists in the system
User has permission to record advance payments

Functional Flow

User selects a client.
System displays client information and existing advance balance.
User enters payment details (date, mode, reference).
User selects payment currency and enters amount received.
User has foreign currency and want it to be converted in MUR or other Currencies
User enters amount to be converted and confirms the exchange rate (Initially bring the rate available from maintenance (But shall be modifiable)
System converts the amount into MUR.
System re-calculate and displays the updated advance balance.
User saves the transaction.
Let say there is an invoice amount of MUR 1500 and client pays MUR 2000. The remaining amount (MUR 500) should update the account of the client.

Acceptance Criteria

1 – Display Client Information

The system shall display:
- Client Name
- Client Code
- Account Currency (MUR)
These fields shall be read-only.

2 – Display Existing Advance Balance

The system shall display the opening advance balance in MUR when the screen loads.

3 – Capture Payment Details

The user shall be able to enter:
- Payment Date
- Payment Mode
- Payment Reference Number

4 – Support Foreign Currency Payments

The user shall be able to:
- Select a payment currency (e.g. USD)
- Enter the amount received
The system shall:
- Allow entry of an exchange rate
- Automatically calculate the converted amount in MUR
- Display the converted amount as read-only

5 – Optional Narration and Evidence

The user may enter narration or notes.
The user may upload payment evidence (PDF/JPG/PNG).
Evidence upload shall not be mandatory.

6 – Update Advance Balance

The system shall:
- Add the converted amount to the opening balance
- Display the new advance balance before saving

Advance Payment layout.xlsx

7 – Save Advance Payment

When the user saves the transaction:
- The advance payment shall be recorded
- The exchange rate shall be locked
- The client’s advance balance shall be updated
- The balance shall be available for invoice offset
- Generate a Receipt for the Advance payment received

GitLab Sync Log

[{"id": "38870", "author": "Avisham", "hours": 6.0, "created": "2026-02-18T09:52:00.113Z", "log_date": "2026-02-12", "comment": "Imported from GitLab by @Avisham on 2026-02-18T09:52:00.113Z: 6h-(6.0)h spend at: 2026-02-12", "status": "active", "deleted_by": "", "redmine_entry_id": 12324}, {"id": "38869", "author": "Avisham", "hours": 4.0, "created": "2026-02-18T09:51:40.300Z", "log_date": "2026-02-17", "comment": "Imported from GitLab by @Avisham on 2026-02-18T09:51:40.300Z: 4h-(4.0)h spend at: 2026-02-17", "status": "active", "deleted_by": "", "redmine_entry_id": 12325}, {"id": "38959", "author": "Avisham", "hours": 2.0, "created": "2026-02-19T10:45:09.886Z", "log_date": "2026-02-18", "comment": "Imported from GitLab by @Avisham on 2026-02-19T10:45:09.886Z: 2h-(2.0)h spend at: 2026-02-18", "status": "active", "deleted_by": "", "redmine_entry_id": 12350}, {"id": "39181", "author": "Avisham", "hours": 4.0, "created": "2026-02-24T05:43:18.465Z", "log_date": "2026-02-23", "comment": "Imported from GitLab by @Avisham on 2026-02-24T05:43:18.465Z: 4h-(4.0)h spend at: 2026-02-23", "status": "active", "deleted_by": "", "redmine_entry_id": 12389}, {"id": "39178", "author": "Avisham", "hours": 7.0, "created": "2026-02-24T05:42:32.246Z", "log_date": "2026-02-22", "comment": "Imported from GitLab by @Avisham on 2026-02-24T05:42:32.246Z: 7h-(7.0)h spend at: 2026-02-22", "status": "active", "deleted_by": "", "redmine_entry_id": 12390}, {"id": "39177", "author": "Avisham", "hours": 4.0, "created": "2026-02-24T05:42:10.571Z", "log_date": "2026-02-19", "comment": "Imported from GitLab by @Avisham on 2026-02-24T05:42:10.571Z: 4h-(4.0)h spend at: 2026-02-19", "status": "active", "deleted_by": "", "redmine_entry_id": 12391}, {"id": "39176", "author": "Avisham", "hours": 2.0, "created": "2026-02-24T05:41:50.269Z", "log_date": "2026-02-18", "comment": "Imported from GitLab by @Avisham on 2026-02-24T05:41:50.269Z: 2h-(2.0)h spend at: 2026-02-18", "status": "active", "deleted_by": "", "redmine_entry_id": 12392}, {"id": "39231", "author": "Avisham", "hours": 1.0, "created": "2026-02-25T05:06:07.779Z", "log_date": "2026-02-24", "comment": "Imported from GitLab by @Avisham on 2026-02-25T05:06:07.779Z: 1h-(1.0)h spend at: 2026-02-24", "status": "active", "deleted_by": "", "redmine_entry_id": 12400}, {"id": "39230", "author": "Avisham", "hours": 1.0, "created": "2026-02-25T05:05:59.943Z", "log_date": "2026-02-23", "comment": "Imported from GitLab by @Avisham on 2026-02-25T05:05:59.943Z: 1h-(1.0)h spend at: 2026-02-23", "status": "active", "deleted_by": "", "redmine_entry_id": 12401}, {"id": "39256", "author": "Avisham", "hours": 1.0, "created": "2026-02-25T06:12:49.826Z", "log_date": "2026-02-24", "comment": "Imported from GitLab by @Avisham on 2026-02-25T06:12:49.826Z: 1h-(1.0)h spend at: 2026-02-24", "status": "active", "deleted_by": "", "redmine_entry_id": 12408}]