Task #19457: MCL/CPW - Import of Opening Balances via Unlinked Invoice - FFA - Redmine

Actions

Copy link

Task #19457

open

MCL/CPW - Import of Opening Balances via Unlinked Invoice

Added by Redmine Admin 6 days ago. Updated about 1 hour ago.

Status:

Priority:

Normal

Assignee:

Start date:

02/25/2026

Due date:

02/27/2026 (4 days late)

% Done:

57%

Estimated time:

7:00 h

Spent time:

4:00 h

GitLab ID:

3888

GitLab Milestone:

GitLab Ticket Number:

1225

GitLab Time Logged:

14400

Lock Timeline Date:

gitlab project trace:

Description

MACCS will import the opening balance records into FFS using the completed Excel template provided by MCL—refer to ticket #1224.

This activity will be executed on 30th June 2026 as per our meeting with MCL/COPW on 23 Feb 2026. They will start using the Sicorax interfacing files effective 1st July 2026

Requirements

System shall support bulk import of Unlinked Invoices.
Imported records shall reflect the information from the file correctly including:
- Customer outstanding balances
- Correct invoice dates
Records shall be available in Debtors reports, Statement of Account, and other relevant receivable reports after the import.

Acceptance Criteria

Completed Excel file is received from MCL.
Data is successfully imported into FFS.
No validation errors remain post-import.
Opening balances are reflected correctly in Debtors Summary Report, Statement of Account, and other relevant receivable reports.
Import is completed prior to or on Go-Live date 1st July 2026.

GitLab Sync Log

[{"id": "39421", "author": "Avisham", "hours": 4.0, "created": "2026-02-27T06:53:53.389Z", "log_date": "2026-02-26", "comment": "Imported from GitLab by @Avisham on 2026-02-27T06:53:53.389Z: 4h-(4.0)h spend at: 2026-02-26", "status": "active", "deleted_by": "", "redmine_entry_id": 12439}]