transaction.number_next

[InteliClic]

Akaunting version

3.0.6

PHP version

8.1

Operating system

Ubuntu 14.04

Steps to reproduce

Import data which changes the auto-increment of the transactions table creates an annoying error on the add payments popup and in add income/expense transaction.

In the following images you can see the issue:


tings table.

Expected result

Add a payment without issue.

Actual result

Add a payment prompts an error.

Additional comments

I managed to fix this issue very easily by going into the database and changing the settings.transaction.number_next but it seems to me that Akaunting should check the auto-increment on the database and update the row in the set.

This ended up happening because I had to manually import the old Akaunting system. Quite frustrating that the export / import didn't work either. On the old system kept getting an error but since that's not supported seems pointless to explore that.

Relevant log output

No response

[barthmania]

I have the exact same issue since the V3 update, I have to manually input a transaction number for every single invoice or expense I add... Which is very annoying.

[cuneytsenturk]

You can update on database this number, settings table key = transaction.number_next

[WillyReyno]

@cuneytsenturk This issue also happens on the hosted version https://akaunting.com/, where we don't have access to the database. How can we fix that ?