Judul : [BE] - [70103] - [Enhancement - Report Coretax]

Backlog : Link Backlog

Planning Generated by AI : Link hasil generate AI

Phase 1: Discovery & Planning [10]

• [2] Understand the Backlog: Deeply review the business requirements, the end goal of Coretax compatibility, and the specific rules for BPMP and BPA1 reports.
• [4] Understand EmployeeReportPeriodic: Analyze the schema and data of this existing table to confirm it is the correct source of truth for all required data.
• [4] Understand the Current System: Investigate the existing backend services and Carbone templates to identify the exact queries and template files that need to be modified.

Phase 2: Development & Implementation [18]

• Data Sourcing Refactor (from EmployeeReportPeriodic)
  • BPMP Report Branch:
    • [4] Modify the existing BPMP service: Replace the old manual query with a new one that fetches all required data directly from the EmployeeReportPeriodic table.
  • BPA1 Report Branch:
    • [4] Modify the existing BPA1 service: Replace the old query with a new one that fetches and aggregates all required data directly from the EmployeeReportPeriodic table.
• Data Integrity Check
  • [2] Add a validation step to ensure that data retrieved from EmployeeReportPeriodic correctly handles database NULL values and does not convert them into the string "null".
• Carbone Template Modification
  • [4] Update the BPMP XML template with the necessary logic to render tags as <TagName isNil="True"/> when the corresponding data field is null.
  • [4] Update the BPA1 XML template with the same isNil="True" logic for its null data fields.

Phase 3: Final Testing [4]

• [4] Perform integration testing by generating both reports with test data, ensuring the final XML is correct and successfully uploads to the Coretax test environment.

Acceptance Criteria

• The queries in the existing backend services must be updated to source all data from the EmployeeReportPeriodic table.
• The system must correctly handle NULL values from the database without converting them to strings.
• For any null value in the source data, the final generated XML must render the tag as <TagName isNil="True"/>.
• Both the BPMP and BPA1 reports must be generated successfully using the new queries and updated templates.
• The final XML files must be accepted by the Coretax validation system.