Akaunting free accounting software

Forum

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

Back
New Discussion

All Discussions

Dedicated Support Collaboration Hub

Templates clarification / Can't delete a disabled company

Redor KURAC   ( User )

Commented 5 years ago

Hi,


1. Templates that are available to download aren't clear enough. 


 - When I select the date format for my company, that should automatically apply to sample templates



  •   Some parts of templates xls samples should be clarified, for example, I don't understand:













category_id payment_method
3 offlinepayment.cash.1

What does category ID represent and where can I find it? What can I find a string for my payment method? For exmaple I added 'PayPal' as a payment method, does it have a string like offlinepayment.cash.1?


2. The company can't be deleted. I disabled it tried to delete "Error: Can not delete active company, please, change it first "



  •  What is considered an active company? I assume once I disable it, it should be easy to delete it, possibly a bug.

Redor KURAC   ( User )

Commented 5 years ago

Here's debug


16 statements were executed, 14 of which were duplicated, 2 unique12.33ms


  • select * from `ak9l_users` where `id` = '1' and `ak9l_users`.`deleted_at` is null limit 12.76mspavle_akau728

  • select * from `ak9l_settings` where `company_id` = '3'180μspavle_akau728

  • select * from `ak9l_currencies` where `ak9l_currencies`.`deleted_at` is null and `ak9l_currencies`.`company_id` = '3'180μspavle_akau728

  • select * from `ak9l_modules` where `ak9l_modules`.`deleted_at` is null and `ak9l_modules`.`company_id` = '3'1.6mspavle_akau728

  • select count(*) as aggregate from `ak9l_companies` inner join `ak9l_user_companies` on `ak9l_companies`.`id` = `ak9l_user_companies`.`company_id` inner join `ak9l_settings` on `ak9l_companies`.`id` = `ak9l_settings`.`company_id` where `ak9l_user_companies`.`user_id` = '1' and `ak9l_user_companies`.`user_type` = 'users' and `key` = 'general.company_name' and `ak9l_companies`.`deleted_at` is null340μspavle_akau728

  • select `ak9l_companies`.*, `ak9l_companies`.*, `ak9l_user_companies`.`user_id` as `pivot_user_id`, `ak9l_user_companies`.`company_id` as `pivot_company_id` from `ak9l_companies` inner join `ak9l_user_companies` on `ak9l_companies`.`id` = `ak9l_user_companies`.`company_id` inner join `ak9l_settings` on `ak9l_companies`.`id` = `ak9l_settings`.`company_id` where `ak9l_user_companies`.`user_id` = '1' and `ak9l_user_companies`.`user_type` = 'users' and `key` = 'general.company_name' and `ak9l_companies`.`deleted_at` is null order by `value` asc limit 25 offset 0230μspavle_akau728

  • select * from `ak9l_settings` where `ak9l_settings`.`company_id` = '1' and `ak9l_settings`.`company_id` is not null190μspavle_akau728

  • select `ak9l_media`.*, `ak9l_mediables`.`mediable_id` as `pivot_mediable_id`, `ak9l_mediables`.`media_id` as `pivot_media_id`, `ak9l_mediables`.`tag` as `pivot_tag`, `ak9l_mediables`.`order` as `pivot_order` from `ak9l_media` inner join `ak9l_mediables` on `ak9l_media`.`id` = `ak9l_mediables`.`media_id` where `ak9l_mediables`.`mediable_id` = '1' and `ak9l_mediables`.`mediable_type` = 'App\Models\Common\Company' and `deleted_at` is null order by `order` asc210μspavle_akau728

  • select * from `ak9l_settings` where `ak9l_settings`.`company_id` = '3' and `ak9l_settings`.`company_id` is not null410μspavle_akau728

  • select `ak9l_media`.*, `ak9l_mediables`.`mediable_id` as `pivot_mediable_id`, `ak9l_mediables`.`media_id` as `pivot_media_id`, `ak9l_mediables`.`tag` as `pivot_tag`, `ak9l_mediables`.`order` as `pivot_order` from `ak9l_media` inner join `ak9l_mediables` on `ak9l_media`.`id` = `ak9l_mediables`.`media_id` where `ak9l_mediables`.`mediable_id` = '3' and `ak9l_mediables`.`mediable_type` = 'App\Models\Common\Company' and `deleted_at` is null order by `order` asc200μspavle_akau728

  • select * from `ak9l_notifications` where `ak9l_notifications`.`notifiable_id` = '1' and `ak9l_notifications`.`notifiable_id` is not null and `ak9l_notifications`.`notifiable_type` = 'users' and `read_at` is null order by `created_at` desc230μspavle_akau728

  • select `ak9l_media`.*, `ak9l_mediables`.`mediable_id` as `pivot_mediable_id`, `ak9l_mediables`.`media_id` as `pivot_media_id`, `ak9l_mediables`.`tag` as `pivot_tag`, `ak9l_mediables`.`order` as `pivot_order` from `ak9l_media` inner join `ak9l_mediables` on `ak9l_media`.`id` = `ak9l_mediables`.`media_id` where `ak9l_mediables`.`mediable_id` = '1' and `ak9l_mediables`.`mediable_type` = 'users' and `deleted_at` is null order by `order` asc

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions