Multi-company invoices and revenues create errors

[iahmadaj]

Please, submit only real issues. Use the forum for support, feature requests, proposals, new versions, help etc. https://akaunting.com/forum

Steps to reproduce the issue

1- Create a new company and switch to that company
2- Go to incomes->invoices or incomes->revenues
3- Click on add new and it will show "Whoops, looks like something went wrong."
4- Also an error when you try to go to general settings for this 2nd company

Expected result

1- It should show a form to add invoices or Revenues
2- For settings it should show general settings form

Actual result

Displays an error page with "Whoops, looks like something went wrong." error

System information (Akaunting, PHP versions)

Akaunting_1.3.14-Stable version, and

PHP Version 7.1.27

Additional comments

After debugging I noticed that for 2nd company the settings table is not being populated with some required variable for invoices and revenues. After I changed the code and added those settings variables it started working as expected.

I just want to know if I am doing anything wrong while adding new company or during company management do I need to do anything extra which I am missing.

[vplaya]

This is a serious problem with me too and it will be appreciated if we can be assisted here.

[cuneytsenturk]

thank for reporting @iahmadaj

[mgschwan]

I found a partial solution for this problem.

This only happens if there are no offline payment methods configured, which is the case when a new company is created.

However, creating a new offline payment method via Settings -> Offline Payments does not work either if the list of offline payments is empty.

A workaround is to add the offline payments directly in the database via:

insert into hdu_settings ( company_id, key, value ) VALUES ( 2 , 'offlinepayment.methods', '[{"code":"offlinepayment.cash.1","name":"Cash","order":"1","description":null},{"code":"offlinepayment.bank_transfer.2","name":"Bank Transfer","order":"2","description":null}]' );

Where hdu_settings is the name of the settings table in your database (the first three letters seem to be randomly generated at the time of the installation)

This has to be done for every company, and the company_id (in this example the id is 2 ) has to be changed accordingly

[vplaya]

Editing the database to solves this seem to be challenging for some of us, is there anyone who could assist in a layman terms please. I access my data base via phpmyadmin. thanks in advance.

[mgschwan]

This should not be the official "solution" but for those that are using phpmyadmin go to the settings table of your akaunting database. It's called xxx_settings where xxx is a random 3 letter prefix that was set at the time of installation.

Click on Insert.

In the company_id field enter the id of the company you are trying to edit. If it is the second company you created then the company id should be 2.

In the key field enter offlinepayment.methods

In the value field paste the following json string
[{"code":"offlinepayment.cash.1","name":"Cash","order":"1","description":null},{"code":"offlinepayment.bank_transfer.2","name":"Bank Transfer","order":"2","description":null}]

Click Go and it should be done.

But please note that this is not an official solution, just a hack to get it working until the issue is fixed.

[vplaya]

Thanks Michael, Your assistance is highly appreciated. Best Regards, Thebe

…

On Sat, 30 Mar 2019, 09:13 Michael Gschwandtner ***@***.***> wrote: This should not be the official "solution" but for those that are using phpmyadmin go to the settings table of your akaunting database. It's called xxx_settings where xxx is a random 3 letter prefix string that was set at the time of installation. Click on Insert. In the company_id field enter the id of the company you are trying to edit. If it is the second company you created then the company id should be 2. In the key field enter offlinepayment.methods In the value field paste the following json string [{"code":"offlinepayment.cash.1","name":"Cash","order":"1","description":null},{"code":"offlinepayment.bank_transfer.2","name":"Bank Transfer","order":"2","description":null}] Click Go and it should be done. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#804 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Ao7LUtwbFm0j-qr-35r4ExHZB4XjV6pkks5vbw6rgaJpZM4cHE-c> .

[vplaya]

Hi Michael,

The error seems to be still popping up when I click on setting-general. Any ideas?

Are the function fields have to be left blank? please see the attachment

[mgschwan]

Yes that's fine the id is automatically filled and the rest is ok.
But your value seems to be missing the bracket ] at the end.

The string should end with }] but in your case it's only }

[vplaya]

Thank you. Let me try again.

…

On Sat, 30 Mar 2019, 16:40 Michael Gschwandtner ***@***.***> wrote: Yes that's fine the id is automatically filled and the rest is ok. But your value seems to be missing the bracket ] at the end. The string should end with }] but in your case it's only } — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#804 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Ao7LUhb-vzwb6HZmQNfphs0O_A7j-jaxks5vb3d1gaJpZM4cHE-c> .