HELP! error...failed to update company:duplicate key value violates unique constraint "company_payer_abn_wpn_branch+key"

  • 3
  • Question
  • Updated 1 month ago
Help, I have many employees waiting to do their tax returns, but can't submit the final 18/19 file, also have 2 other files form this financial year sitting ready to go through, have had no problem throughout the year submitting file & employees can see their payroll details through their MYGOV accounts just needs finalizing my end. Keep getting error message above, can't reach Reckon tech via phone as not taking anymore calls :(   
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb

Posted 1 month ago

  • 3
Photo of Rav

Rav, Community Manager

  • 84,250 Points 50k badge 2x thumb
Hi Anita,
Can you let me know where specifically in the process you're encountering this error message?

Have you been going through your usual submission process which has been successful before?
(Edited)
Photo of James Nally

James Nally

  • 136 Points 100 badge 2x thumb
Hi Rav,

Is there any ideas on this? I have the same error. And a lot of staff waiting to do their tax returns.

James 
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
I encounter this message when I go to submit the file in gov connect page, every week for last 12 months it has been submitted the same way, have all the files that have been submitted sitting there saying pending? And employees are saying that they can see their pay details on their MyGov account just isn't finalized for tax?
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
Been waiting on phone for 1 hr 17 mins :( tried everything went into single user mode, took out ABN popped it back in again) Rang ATO twice all good their side of things, all files previously submitted when clicked on details changed from pending to success, up to 26/6/2019 now can't submit 18/19 file, or file for 1 pay run this financial year.  Very frustrating :( 
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
Morning James, a technician from Reckon tried for about 40 minutes
 to fix the error, then no luck so they have taken a copy of my company file to try work it out, waiting to hear if successful as I also have 45 people waiting to do tax returns.
Photo of James Nally

James Nally

  • 124 Points 100 badge 2x thumb
I'm still on hold with reckon. Which number did you end up calling for tech support?

James
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
It was the number with the option of STP in the menu & ever since they have rang me or emailed. Mine are submitting now, so hopefully everyone else is the same.
Photo of James Nally

James Nally

  • 124 Points 100 badge 2x thumb
ahhh ok. Whatever the tech guy did seemed to work for you. We are still waiting to hear back from Reckon. Do you know what magic was worked at their end to get it working?

James
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
They took a copy of our company file, so I don’t know what they did unfortunately, but i got files to submit to ATO this afternoon.
Photo of KristianWenckowski

KristianWenckowski

  • 202 Points 100 badge 2x thumb
I have the same problem!! Just noticed that i haven't submitted STP for 26/6/19 prior to updating Hosted File to 2019R2?? Any help please?

 This is the message I receive.

Failed to update company.: duplicate key value violates unique constraint "company_payer_abn_wpn_branch_key"
(Edited)
Photo of James Nally

James Nally

  • 136 Points 100 badge 2x thumb
Hi Kristian,

Did you get a response on this? I have the same problem.

James
Photo of KristianWenckowski

KristianWenckowski

  • 202 Points 100 badge 2x thumb
Hi James,

Sadly no response to this thread. Waiting patiently to read a solution. Have also been conversing with Joydeep from support via email (Friday) with no solution forthcoming.

Kristian
Photo of Anita Seabourne

Anita Seabourne

  • 180 Points 100 badge 2x thumb
Morning Kristian, it took 4, 5 days for them to fix mine, they took a copy of my company file & did something, but they kept sending me emails letting me know they were still working on it.
Photo of James Nally

James Nally

  • 136 Points 100 badge 2x thumb
I'm having the same issues. Encounter it when doing the final sign off regarding the ATO having the Reckon software ID.

Any swift answers on this would be appreciated.
Photo of Gary

Gary

  • 120 Points 100 badge 2x thumb
Surely someone at Reckon must have an answer for this? Its now been over 1 week since this question was asked. I can't lodge any pays because of this error.  This should be moved to the high importance list!!!!!
Photo of James Nally

James Nally

  • 136 Points 100 badge 2x thumb
I have been told that this error comes up when multiple payroll staff set up multiple profiles for the same ABN and as a result the system looks for a branch ID. They are currently looking into my issue and trying to delete the second profile.