FUJ00126042 - IMPACT R3 Branch Trading Issues Report, version 8.0.

Evidence on official site

IMPACT R3 Branch Trading Issues

FUJ00126042

FUJ00126042

Ref I ISSUE STATUS

1.1 I Taking into account the changes that are to be introduced at S80 to branch accounting
processes and reporting, confirmation is required concerning the evidence required to verify
branch conformance to POL accounting standards.

In summary, the following changes are proposed at S80:

Q_ The POL Ledgers will be fed on a daily basis from trading information automatically
generated by Horizon. The Cash Account will no longer be used in the construction of the
POL Ledgers

Q_ the existing weekly Cash Account process will be withdrawn. This process currently
produces a report that is signed with one copy sent to POL and a second copy retained at
the branch

Q Balance reports are also produced weekly at the branch for each Stock Unit, a copy of
which is signed by branch office staff and retained at the branch

Q = anew Branch Trading Statement is to be introduced that the branch will be required to
produce on a monthly basis. Requirements for signing and retention of reports to be
confirmed. The conditions governing the process for producing this report are broadly
similar to that for the existing Cash Account (see CD for full details)

Action: Tony Utting to confirm POL requirements. Response required by 18/2/04.

1.2 I Taking into account the requirements for a monthly Branch Trading Statement, confirmation is I Assessment provided to Clive Read and David
required concerning the impact on the Horizon infrastructure of increasing the retention of Parnell on 12/2/04. Following POL review of cost
transaction data at the branch from the current 35 days to 49 days. In particular, the impact implications, suggest that any revisions to
assessment should consider branch and central storage requirements and processing times for I requirement need to be confirmed by 18/2/04. In
branch reports. interim, working assumption remains that extended

data retention is required.
Action: Clive Read to confirm any revisions to
requirement by 18/2/04.
1.3 I Confirmation is needed concerning the POL requirement to use the rem out dockets/vouchers I Proposal circulated by Philip Godden on 10/2/04 to
functionality. It is understood that some sub-set of the following may be involved: be reviewed by Ben, Chris ,Gareth and discussed
. . with Philip with resulting requirement confirmed by
1. Losses (various categories) and gains 18/2/04.
2 Postage costs Action: Ben Gildersleve/Chris Allen to confirm POL
. etty cash expense / purchases requirements.

4, Robbery & Burglary clearance °

5. Write offs (various categories)

6. Intruder Alarms (Directly managed only)

7. Counterfeit Notes (DM only)

Vsn 8.0 Page I of 3 13/02/2004
IMPACT R3 Branch Trading Issues

FUJ00126042

FUJ00126042

Ref I ISSUE STATUS

8. MVLs to car hire companies (DM only)

9. Obsolete Stock (Agents only)

10. Customer Goodwill (Agents only)

11. Spoilt Postage Labels (Agents only)

12. Redeemed savings stamps (BBC, DVLA..)

This information is required to assess the impact on associated reporting, e.g.
opportunities to remove or implied change required to existing product specific reports.

1.4 I Confirmation is needed concerning how stock/ vouchers/ dockets items are required to be
mapped onto accounting and will they be represented on branch reports/accounts.

This information is required to help identify/confirm associated migration requirements.
Action: Ben Gildersleve/Chris Allen to confirm POL requirements. Response required by
18/2/04.

1.5 I Confirmation is needed regarding requirements concerned with the reconciliation of
transactions to be supported by Horizon automation.

This information is required to enable the assessment to progress with the identification of
scope for the reconciliation simplifications and associated cost savings anticipated by Schedule
12 of the Fujitsu contract.

Action: Anne Clarke/Nigel Stone/Clive Read to confirm POL requirements. Response
required by 18/2/04.

1.6 I Confirm impact on solution costs of removing stock values from existing Horizon reports. Assessment provided to Clive Read and David

Gareth Jenkins to provide impact assessment by 18/2/04. Parnell on 12/2/04. Following POL review of cost
implications, suggest that any revisions to
requirement need to be confirmed by 18/2/04. In
interim, working assumption remains that stock
handling requirements remain as stated in the
current CD working draft.
Action: Clive Read to confirm any revisions to
requirement by 18/2/04.

1.7 I Confirm requirement for handling variances and discrepancies arising from Stock Unit Ben's 9/2/04 email confirmed acceptance of
balancing following review of proposal distributed by Gareth on 5/2/04. Gareth's proposal (subject to certain clarifications).
Action: Ben Gildersleve/Tony Utting to confirm POL requirements. Response required by Action: Phil Boardman to incorporate in CD (with
12/2/04. clarifications) together with other revisions resulting

from current review activity. Issue closed

1.8 I Confirm re-engineering of DVLA product, to enable it to be controlled by Horizon, is out of
scope for IMPACT and will be addressed by a separate CR if required, i.e. DVLA product will

Vsn 8.0 Page 2 of 3 13/02/2004
IMPACT R3 Branch Trading Issues

FUJ00126042
FUJ00126042

Ref

ISSUE

STATUS

remain uncontrolled (non-value) at S80.

Investigations have shown that, compounded by S60 changes to DVLA product handling
incorporating use of ADC, it cannot be changed to controlled stock simply by changing the
associated reference data and would require non-trivial re-engineering to achieve the change.
Action: Graeme Seedall/Clive Read to confirm POL DVLA S80 requirements. Response
required by 18/2/04.

24

Review and confirm resolution of design authority issues (as notified on 11/2/04) arising from
team review of 2/2/04 CD working draft.

Action: Clive Read to notify Phil Boardman of design authority resolutions by 18/2/04 for
inclusion in CD.

2.2

Review results of updated assessment report on requirement scope issues provided to POL on
12/2/04 with the objective of confirming scope change or amending requirement.

Action: Clive Read to notify Phil Boardman of any revisions to associated requirements by
18/2/04 for inclusion in CD.

2.3

List of Horizon branch reports has been annotated by Ben/John/Sheena/Julie/Fujitsu with
anticipated changes resulting from IMPACT 3 requirements. Fujitsu clarifications forwarded to
Ben 12/2/04.

Action: Ben Gildersleve to confirm POL requirements to Phil Boardman by 18/2/04 for
inclusion in CD.

24

Following discussions between Tony Marsh and Clive Read, a review meeting has been
arranged for 18/2/04 to examine a proposal to remove the current method of posting
discrepancies into a branch Suspense account.

Action: Clive Read to notify Phil Boardman of any revisions to associated requirement by
18/2/04 for inclusion in CD.

25

Following discussions with IMPACT Stakeholders, a review meeting has been arranged for
18/2/04 to examine a proposal to continue to report daily cash declarations to SAP ADS so that
branch variance reports can be produced centrally.

Action: Clive Read to notify Phil Boardman of any revisions to associated requirement by
18/2/04 for inclusion in CD.

26

Review meeting in London on 11/2/04 confirmed that TMS/AIS requirements are not expected
to be completed on a timescale compatible with scheduled CD production. Decision taken to
include sufficient information in CD regarding TMS/AIS to enable solution design work to
proceed.

Action: Nigel Stone to coordinate production of TMS/AIS requirements, supported by Fujitsu/
Prism/ Parity, and forward material to Phil Boardman by 18/2/04 for inclusion in CD.

Vsn 8.0 Page 3 of 3

13/02/2004