Forum

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

New Discussion

Akaunting 2.1.33 quantity limit for 5 digits

Samer   ( User )

Commented 2 years ago

When adding more than 5 numbers in the invoice item quantities field like (Quantity = 160320) I get the following error
The quantity must be between 1 and 5 digits
Any Help!!

Samer   ( User )

Commented 2 years ago

when i change from Document.php
foreach ($items as $key => $item) {
$size = 5;
to 6
i get the following error

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'quantity' at row 1 (SQL: insert into `lqx_document_items` (`item_id`, `name`, `description`, `quantity`, `price`, `discount_type`, `total`, `created_from`, `created_by`, `company_id`, `type`, `document_id`, `tax`, `discount_rate`, `updated_at`, `created_at`) values (11,B/W-0.05, Black&White Pages, 118633, 0.05, percentage, 5931.65, core::ui, 1, 1, invoice, 26, 1008.38, 0, 2022-03-16 22:12:55, 2022-03-16 22:12:55))

Samer   ( User )

Commented 2 years ago

any ideas ????

Please login or register to leave a response.

Showing 1 to 3 of 3 discussions