Project

General

Profile

Actions
Copy link

Task #19457

open

MCL/CPW - Import of Opening Balances via Unlinked Invoice

Added by Redmine Admin 6 days ago. Updated about 3 hours ago.

Status:
QA
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:
No
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

  1. Completed Excel file is received from MCL.
  2. Data is successfully imported into FFS.
  3. No validation errors remain post-import.
  4. Opening balances are reflected correctly in Debtors Summary Report, Statement of Account, and other relevant receivable reports.
  5. 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}]

Actions
Copy link

Also available in: Atom PDF