Project

General

Profile

Actions

Task #19917

open

United Cargo: Add Foreign Currency Payment Column in Cashier Report

Added by Redmine Admin 3 months ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
05/22/2026
Due date:
05/22/2026 (about 3 months late)
% Done:

0%

Estimated time:
0:00 h
GitLab ID:
4450
GitLab Milestone:
GitLab Ticket Number:
1546
GitLab Time Logged:
0
Lock Timeline Date:
No
gitlab project trace:

Description

Issue:

The existing Cashier Report currently displays payment amounts under payment mode columns such as Cheque, Cash, and Other. The current report shows current columns including Date, Receipt, Invoice, Customer, Mode, Cheque/Ref, Cheque, Cash, and Other, with totals grouped by payment mode.

However, when a client pays in a foreign currency, the report currently mainly displays the converted MUR amount under the relevant payment mode column. The user now needs visibility of the actual foreign currency amount received, for example:

  • USD 20 received
  • Equivalent MUR amount displayed under Cash / Cheque / Other as per existing logic

Requirement

Add a new column to the existing Cashier Report to display the actual payment amount in foreign currency when the payment is made in a currency other than MUR.

Functional Requirements

1. Add New Column

Add a new column in the Cashier Report:

FCY Amount

2. Display Logic

The new column should display data only when the receipt/payment was made in a foreign currency.

3. Existing Payment Mode Columns Remain Unchanged

The converted MUR equivalent should continue to appear in the existing corresponding payment mode column, such as:

  • Cheque
  • Cash
  • Other

Example:

If client pays USD 20 in cash:

Mode FCY amount Cash
CASH USD 20.00 950.00

4. Blank for MUR Payments

If the payment currency is MUR, the new column should remain blank.

This avoids duplication because MUR payments are already shown in the existing Cheque / Cash / Other columns.

5. Report Totals

The existing report totals for:

  • Cheque
  • Cash
  • Other
  • Total Payment

must remain based on the converted MUR amount.

The new foreign currency column does not need to be totalled, because it may contain mixed currencies.

Acceptance Criteria

AC1 – New Column Displayed

Given the user generates the Cashier Report
Then the report displays a new column named FCY Amount.

AC2 – Foreign Currency Payment Displayed

Given a client paid in a foreign currency
When the Cashier Report is generated
Then the new column displays the original payment currency and amount, for example USD 20.00.

AC3 – Converted Amount Still Displayed

Given a client paid in foreign currency
When the amount is converted to MUR
Then the converted MUR amount continues to appear in the existing payment mode column, such as Cash, Cheque, or Other.

AC4 – MUR Payment Shows Blank Foreign Currency Column

Given the payment was made in MUR
When the Cashier Report is generated
Then the Foreign Currency Amount column remains blank.

AC5 – Existing Totals Unchanged

Given the report contains both MUR and foreign currency payments
When totals are calculated
Then existing totals should remain based on MUR-converted values.

AC6 – Export / PDF Consistency

Given the Cashier Report is exported or printed
Then the new column should appear consistently in the report output format.


GitLab Sync Log

[]

Actions

Also available in: Atom PDF