This question has been flagged
9 Replies
7582 Views

Hi 

We are trying to input our initial balances in V12 Enterprise . We seem to have to do this in Journal Entries and manually input the Debit and Credit amounts. But we only get so far 274 entries and then we get the following error when we save.


Wrong credit or debit value in accounting entry! Credit or debit should be zero.


We have checked all entries, they look correct and all have a corresponding entry.

In V11, there was an Initial Balances setup in the dashboard of the Accounting App. But this seems to have been removed in V12.

Does anyone know how to set up Initial Balance in V12??


Thanks

Darren


Avatar
Discard
Best Answer

If you click on chart of account from accounting dashboard on top it will redirect accounts list where you can set opening credit and debit for each accounts. If you allready close it or open it, then it will not show you. In that case you can show that tree view with little cutomization and then fill your values.

Avatar
Discard
Author

Thanks Ajeet, I cannot see chart of accounting in the dashboard. Configuration steps is missing in V12.

See screenshot of V12

https://www.dropbox.com/s/1xjpy1gc6b0u4tu/Accounting Dah V12.png?dl=0

See a screenshot of V11 which has got it.

https://www.dropbox.com/s/mbsn98atap9n9xb/Screenshot 2019-09-28 06.59.10.png?dl=0

Can you explain : "In that case you can show that tree view with little cutomization and then fill your values."

Best Answer

Its possible to access initial Balances from the dashboard until it is disabled by the user: Initial setup


Avatar
Discard
Author

Thanks Ricardo

How can I reinable the Initial Setup on the dashboard. I think it was disabled accidentally

Author

Thanks Ricardo, I’ll give that a try

Best Answer

You can get the configuration steps back by editing view 'account.setup.company.form' and remove the 'invisible =true' part of the field. 

\https://drive.google.com/open?id=1mvN2x0HlaT8KGBJ6rMygECaPtcCvRBdW

Then you can uncheck  the 'hide setup-bar' in the account configuration. the configuration steps are shown again on the dashboard and you can open and edit the chart of accounts with the initial balances, or open the initial balance move lines. 

Have you checked if you have an account more than once in your inital balance, maybe once with a debit value and once with a credit value? Or perhaps you have a debtor with a credit value? 

Avatar
Discard
Best Answer

This particular error is caused by having a single line that has both a debit and a credit. This can happen at any time, not just during opening balances. 

If you are trying to import a line with say a credit of 10 and a debit of 6, you can either balance them off and keep the credit of 4, or have two lines, one with a credit of 10 and one with a debit of 6.

Avatar
Discard
Author

Thanks Jake, I have checked all lines and there is no line that has both a debit and credit on the same line

For each customer we add a line :

Account Partner Label Debit Credit

110000 Debtors Control Account (1100) Customer Name Bal B/Fwd 0.00 €1,162.97 €0.00

Then we add the balancing line:

304000 Change Over Suspense Account 0.00 €0.00 €1,162.97

We do that for each customer.

https://www.dropbox.com/s/yld7h7ts587k4un/Screenshot 2019-09-27 09.31.10.png?dl=0