11 · What Needs Attention
Four open items.
Listed openly, so they can be planned for.
One database index
The permanent fix for the settlement lookups behind the paid and settles indicators. Without it those queries scan and will eventually exceed their time limit without any visible error. It is a schema change and waits on approval.
The SQL testing blind spot
The build environment runs no database, so query changes are proved by inspection and static assertion until they run against the live catalogs. The method accounts for it; it remains the weakest link in the chain.
Reproducing a filed return
A filed VAT return cannot currently be reproduced after an amendment, because boxes are recomputed live and the submitted XML is not stored. Storing the filed figures would close it.
Source control
The project is not under version control. The hash and baseline discipline compensates, and has caught every incident so far, but this is the area where a mistake is hardest to undo.
Next. Work resumes on the reporting shelf, completing the match between each native report and the original it replaces.