Task #19917
openUnited Cargo: Add Foreign Currency Payment Column in Cashier Report
0%
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
[]