Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to write-off (bug in Dutch add-on?)?

By
ton123
on 2/10/13, 10:01 AM 2,265 views

In some cases the customer pays a littlebit less or more than invoiced. Sometimes it is 0.1 or 0.05 euro. I know there is a function in the financial module for write-off. If I use this function and give the accountnumber for the write-off the write-off doesn't take place. I am working with Dutch scheme. Is this a bug? Or am I doing something wrong?

Update 11 March '13 based on comment of Mohammed Ali and further testing: In my situation the result was "The Write-Off could be found on the Profit and Loss Report. So far so good. But one problem remained: the write-off amount (In our case 0.01) was still to be found in the Aged Partner Balance report. That's should be zero right?"

First we set the write-off to "Write-off" 498000. At first we have set our internal type to 'regular' and account to expense. A second test we made a new account 498001 with part of the parent account "Other Income and Expenses", same parameters. A thirth test we have set 498001 type to receivable and we set account to 'receivable'.

Additional testing with differences in type and account give the result (or look alikes): "ValidateError Error occurred while validating the field(s) user_type,type: Configuration Error! You can not select an account type with a deferral method different of "Unreconciled" for accounts with internal type "Payable/Receivable"!

write-off account settings

The result of the three tests is the same. Write off account 0.01 but the account payable has still 0.01 open.

Also, I'm really wondering if I should set the 'allow reconciliation' option for this account to active. Could somebody explain to me what this option does?

The result of a search on the account gives: search on involved account

4

The most common mistake would be: forgot to check the 'Full Reconcile' checkbox. Forgotting this would make the payment balance value still available for payment and the invoice status still 'Open'

This is an example: A customer paid 301 for 301.88 invoice and the 0.88 difference will be written-off, you will need to make sure the following things:

  • enter the actual paid amount: 301
  • check 'Full Reconcile' so allocation would become 301.88 (the full amount)
  • select 'Reconcile Payment Balance'
  • select the counterpart account e.g: 'Debt write off', for this example I just use 'Reserve...'

image description

I tested this and works even for difference as small as 0.01

If in some case you forgot to check the Full Reconcile:

  • just pay the invoice again with '0' as paid amount.
  • select Full Reconcile in Invoice(s) you want to be written-off
  • Reconcile Payment Balance
  • enter the Counterpart account. This would finish the workflow/invoice state to 'Paid'

Thanks. However I did this with the web client. The result was The Write-Off could be found on the Profit and Loss Report. So far so good. But one problem remained: the write-off amount (In our case 0.01) was still to be found in the Aged Partner Balance report. That's should be zero right?

ton123
on 2/19/13, 9:48 AM

Hi, is this applicable in version 7? I have the same concern., so this may help. :) thanks

jheszica
on 2/24/13, 5:43 AM

@ Mohammad Ali. Based on your comment additionals to the question. @Jhezica Question answers and test based on 6.1

ton123
on 3/11/13, 1:17 PM

Dear Yohanes what is the counterpart account?

Hamza Allouh
on 5/16/13, 1:27 PM
2

Mohammad Alhashash

--Mohammad Alhashash--
2075
| 5 5 8
Giza, Egypt
--Mohammad Alhashash--

Developer

Mohammad Alhashash
On 2/23/13, 10:06 AM

Is the internal type of the write-off account 'Payable' or 'Receivable'. It should not appear on the partner balance unless it is defined as such.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/10/13, 10:01 AM
Seen: 2265 times
Last updated: 3/16/15, 8:10 AM