Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Error creating invoice

Monkgogi Samson   ( User )

Commented 4 years ago

I get the below error trying to create an invoice:
SQLSTATEP3000J: Integrity constraint violation: 1048
Column 'account_id' cannot be null (SQL: insert into
( 'company_id
account_id', 'ledgerable_id', 'ledgerable_type',
'issued_at', 'entry_type', 'debit', 'updated_at',
' created_at4) values (71095, ?, 328135, App\Models\sale\lnvoice, 2020-05-11 22:12:28, total, 0,2020-05-11
22:12:32, 2020-05-11 22:12:31))

Michael Morales   ( User )

Commented 4 years ago

Were you able to resolve this? I have been running into the same issue when trying to create an invoice or enter a payment. I put in a ticket about 5 hours ago but haven't heard back yet.

Monkgogi Samson   ( User )

Commented 4 years ago

I abandoned the whole thing after waiting for a response and struggling with other issues in the software , but this was their response later:
'Hello,
We're not able to reproduce such an issue so please, provide us an admin account of your Akaunting installation so we could see what's going wrong there.'

Michael Morales   ( User )

Commented 4 years ago

I was debating the same thing... I just purchased the double entry, spent a few hours setting up the chart of accounts and then had no way to enter anything. Not a good feeling trying to weigh the decision on which platform to use...

I did find that when running the site in another window in incognito mode, I didn’t get the error. I’m assuming it’s an issue if you have multiple tabs open to the site. There’s probably multiple versions of the cache and the browser doesn’t know what to do as it still doesn’t see something like a vendor you set up in another tab. Closing all tabs and doing a hard refresh (control + F5) on the site may work too, but I’ll try it next time.

Thanks for the reply.

Goodluck.

Famakinwa Babatunde   ( User )

Commented 4 years ago

Hi all,

I just ran into this issue too. I cannot post invoices and I get same error above. What is the best resolution to this ?

Regards

Wayne   ( User )

Commented 4 years ago

Hey folks. you are exactly correct. When i went into private window I could work with the invoices and not get this SQL error. This is weird and unfortunately but I must say that after it started working I was quite impressed. But this bug needs fast attention indeed ! I've filed a ticket with them. Hopefully their speed will be faster than the reports online ....

Please login or register to leave a response.

Showing 1 to 6 of 6 discussions