Value for field "Account" (...) is not valid

Support User
1

Good afternoon everybody,

when trying to validate or post a supplier invoice, I get this error message.

Bildschirmfoto von 2020-08-09 14-29-43

Can somebody with magic long-distance diagnosis abilities tell me what I’m doing wrong? With customers’ invoices, the problem does not occur…

Cheers,
Wolf

2

Good afternoon herrdeh,
The account of the movement is closed:

account_move
account_move1680×1050 52.8 KB

2 Likes
3

Hello Alnus, thank you for your attention - and welcome to the club.
Your idea sounds very much plausible, unluckily none of the two relevant accounts are closed. Where else could the problem be?

Cheers,
Wolf

4

The error message is clear that the problem is one account used is closed.
Maybe you did not check the right accounts or you forgot that other accounts are involved like the tax account.

5

Sorry, back again with this problem.

Bildschirmfoto von 2020-10-16 19-54-37

This happens in sales and purchases when trying to “process” an order.

Background: I took the wrong decision not to choose the standard German SKR04 account scheme, but trying to enhance the “minimal account table”. Bad idea, but now such it is. Due to advice of an accountant, I had to rearrange some of the accounts. Now this problem occurs again. I checked all the accounts, not of them is closed. Definitively not.

Is there any possibility for solving this problem - or will I really have to start over from close to scratch with SKR04?

Cheers,
Wolf

6

The error message is clear. You have a closed account on the invoice. But closed may be also because it has no type.

7

Indeed, there where two accounts without type. I added accounts there. Still it does not work. None of the account has a “debit type” - whatever this is. Can that be the problem?

8

No, if the error is still the same. Then it is still an account that is closed.

9

Let’s check whether I understood the idea of “closed account”. @Alnus pointed in #2 to the “closed” box. So I opened:

Bildschirmfoto von 2020-10-17 08-01-59
Bildschirmfoto von 2020-10-17 08-01-591127×503 87.4 KB

then opened this view:

Bildschirmfoto von 2020-10-17 08-02-10
Bildschirmfoto von 2020-10-17 08-02-101057×480 48.4 KB

and cycled thorough all the accounts and checked whether the “closed” box is ticked… It is nowhere. Is that review correct?

Anyway: Anybody is cordially invited to have a look on my little messy install with AnyDesk or whatever. Drop me a PM in case… (-;

Cheers,
Wolf

10

I hit the same problem with the « French » chart of account whilst creating a Sales Order. What I did :

  • Run the query « Select * from account_account where closed = true; » in « Postgres / pgadmin4 »
  • This query confirmed that 252 accounts were « closed »
  • I did not bother to find out which one
  • Run the query « UPDATE account_account SET closed = false WHERE closed = true; »
  • That solved the problem : I could advance the Sales Order to « Process »
    Suggestion : whilst processing the sales order, to have the error message display one such account encountered in this state up until there are no more in that state.