[Akauntig] - transaction numbering doesn't update after manual input #410

Closed
opened 2023-01-17 10:20:01 +01:00 by antilopa · 3 comments
Owner

All transactions get a number code beginning with the prefix TRA-. After entering some manaul payments and batch imports the numbers don't update properly. Trying to enter a payment on an invoice result in an error because the auto-generated transaction number is already taken so a subsequent number has to be entered manualy instead. The auto-generated number is already about 400 numbers behind the latest transaction number. See images below.

All transactions get a number code beginning with the prefix TRA-. After entering some manaul payments and batch imports the numbers don't update properly. Trying to enter a payment on an invoice result in an error because the auto-generated transaction number is already taken so a subsequent number has to be entered manualy instead. The auto-generated number is already about 400 numbers behind the latest transaction number. See images below.
muppeth was assigned by antilopa 2023-01-17 10:20:01 +01:00
meaz was assigned by antilopa 2023-01-17 10:20:01 +01:00
Author
Owner

The issue has been addressed on Akaunting git:
https://github.com/akaunting/akaunting/issues/2610

Only solution given is to update the numbering in the database

The issue has been addressed on Akaunting git: https://github.com/akaunting/akaunting/issues/2610 Only solution given is to update the numbering in the database
Owner

Oh nice @antilopa ! that would be great to fix this @muppeth because I admit it is very annoying!

Oh nice @antilopa ! that would be great to fix this @muppeth because I admit it is very annoying!
Owner

Done. @antilopa do I understand correctly that this wee keep occurring because of the imports from spreadsheets? If so, let me know I can prepare a one-liner to update the next transation number.

Done. @antilopa do I understand correctly that this wee keep occurring because of the imports from spreadsheets? If so, let me know I can prepare a one-liner to update the next transation number.
muppeth added this to the 23.01 - January milestone 2023-01-22 23:53:11 +01:00
muppeth added this to the 23.01 - January project 2023-01-22 23:53:14 +01:00
Sign in to join this conversation.
No Milestone
No Assignees
3 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Disroot/Disroot-Project#410
No description provided.