New user of Accounting here. After connecting a bank feed I see it downloads EVERY transaction. That results in duplication of items already accounted for in the opening balances.
How can I do a mass deletion of the banking payments and receipts?
It appears that every item has been posted as if it's completed, and deletion of posted entries isn't possible. Mass 'resetting to draft' seems to be a missing function too.
I've now got thousands of duplicated items.
Version: Online
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Financeiro
- Inventário
- PoS
- Project
- MRP
Esta pergunta foi sinalizada
6
Respostas
14044
Visualizações
Via the Accounting Dashboard:
Note: This is a screenshot of Odoo 17 - in Odoo 16 and 15 you want the Operations Menu.
From here, filter by date, select multiple, and from the Actions Menu select Delete (provided they are not reconciled with transactions in Odoo).
This way you can delete a specific bank statement line, or as many as your filter returns.
Fantastic, Ray! Thank you.
After deleting the bank transactions, all of the bank journal entries are no longer in posted status either and can now be deleted too!
The solution above worked for me. Took a lot of manual labor, but at least there is a workaround. It seems there is a Find Duplicates tool in Odoo 18, but it would not work for me.I have sent a ticket to support to ask for the root cause.
Hopefully this is resolved soon! A very important functionality! I don't want to do this manually again.
After using odoo, one thing clear I want to replace it due to very complicated, no clear documentation.
Thank you for sharing! Such great help.
I know this is an older thread, but I wanted to share my experience. I did a similar thing to Mark and started with a free/single-user database, then I did a couple weeks with the trial. Suddenly, upon signing up, I had a database full of duplicate and unwanted accounting entries. I ended up uninstalling the Accounting app, then Sales, then Invoicing. This cleared the entries and I was able to re-add the apps. I only installed Invoicing for the moment.
In Odoo Accounting, you cannot delete posted entries like bank statements or journal entries. However, you can correct or reverse them by creating a new entry with opposite values or by editing the existing entry.
Here are the steps to correct or reverse the duplicated bank transactions:
Go to the Accounting module and open the bank statement that contains the duplicated transactions.
Locate the duplicated transaction and click on the "Edit" button.
Edit the transaction by reversing the values or changing the account.
Click on the "Save" button to save the changes.
Repeat the process for all duplicated transactions in the bank statement.
If you have multiple bank statements with duplicated transactions, you can follow the same process for each statement.
If you have already created journal entries for the duplicated transactions, you can reverse them by creating a new entry with opposite values or by editing the existing entry.
Note that correcting or reversing transactions will update your accounting records and financial statements accordingly. Make sure to review your records carefully before making any changes.
Also, it is recommended to reconcile the bank statement after correcting or reversing the transactions to ensure that your records match the bank statement.
Está gostando da discussão? Não fique apenas lendo, participe!
Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!
Inscreva-se| Publicações relacionadas | Respostas | Visualizações | Atividade | |
|---|---|---|---|---|
|
2
dez. 24
|
1692 | ||
|
1
mai. 24
|
1448 | ||
|
0
abr. 24
|
790 | ||
|
1
mai. 25
|
83 | ||
|
0
mai. 25
|
120 |
One of the support team at Odoo has thankfully just sent me a video on my own data how to delete these entries.
** For anyone else trying to do the same thing, the trick is to delete the 'Bank Reconciliation' items, not the journals.
Full steps if you need them:
1. To get to the right area you choose : >>Dashboard Menu, then choose the problem >>Bank account
2. Heading 1 will show "Accounting Dashboard / Bank Reconciliation " if you're on the right page
3. Now choose the List view, for convenience
4. Change the range from the default "1-80" if you wish to something like "1-9999", again for convenience
5. Then, click the "Select All" button
6. Lastly choose the "Action" button and then the "Delete" function
And they're gone!
7. Optional Step (to delete unwanted bank accounts) - Choose "Configuration menu" from top menu, Select any unwanted bank accounts, then choose "Delete".
Thank you for sharing!
Ouch. Seriously, is that the only way to delete unwanted, automatically downloaded transactions?
No one will go through thousands of unwanted transactions one by one.
This seems a serious deficiency. I'll have to look around for another accounting system if this is the case.