This is a known issue that we are still working to understand.
We do have a fix for it in the meantime that we can run for you or provide you if self-hosted.
This will fix any issues in the database up to that point in time, although you might need to run it again as newer occurrences of this issue are introduced by workers.
We are still investigating the potential causes but below are two we know of.
Purchase Step Configuration Containing FA Forms
We have noticed a customer who had as part of the step configuration for a care package workstep the Financial Assessment form as part of the step configuration. When our Finance Consultants replicated this locally, we found that we got the same result with duplicate contributions being produced.
This is something that you would like to check, and the aforementioned customer has since taken this advice back to their business and taken the FA form out of the care package step configuration onto a step type of its own.
Financial Assessment Results and Week 13/Deferred contributions
Another scenario where duplicate contributions may occur is due to the financial assessment's functionality for auto-contributions when a financial assessment or the purchase element changes. It can occur with Deferred Payment contribution elements and possibly Week 13 elements.
Every time there is an Auto Contributions change, a stored procedure is run that goes through the provision and financial assessments and looks for gaps in the Deferred Contribution and if it finds any, tries to plug them with a new auto contrib.
The bug here is where the Deferred Payment assessment result is for a period before the Deferred Payment is valid, i.e. it is within the first 12 weeks of a service.
The code then tries to create a contribution for that period – and in doing so ends up using the correct start date for when that week 13 would legally kick in (i.e. start of the 13th week) - but an end date of the financial assessment result, which is BEFORE that date. See if you can spot that is the case on your service user.
This might lead to the dates looking backwards, and duplicate contributions as the system keeps trying.
If you require the duplicate contributions to be removed via script, then please raise a new case online and reference the title of this article and we will be able to assist you to resolve this.
Could you also let us know any of your care package steps that have been used for this service users finance include the FA form (even as an optional form to select within the step).