Hi,
I am also getting an error with adjustment for version 3.4. If keeps giving me this error trace:
Code:
Trace information for debug purposes. Phreedom release 3.4, generated 2012-04-11 01:38:21.
GET Vars = Array ( [module] => inventory [page] => adjustments )
POST Vars = Array ( [todo] => save [id] => [adj_reason] => [post_date] => 04/11/2012 [gl_acct] => 5000 [purchase_invoice_id] => [sku_1] => AIP100 [serial_1] => [acct_1] => 1200 [def_cost_1] => 412 [stock_1] => 0 [qty_1] => 2 [price_1] => 412.00 [bal_1] => 2 [desc_1] => AIP100 [sku_2] => Search [serial_2] => [acct_2] => [def_cost_2] => [stock_2] => [qty_2] => [price_2] => [bal_2] => 0 [desc_2] => [store_id] => 0 )
Time: 188 ms, 3 SQLs 1 ms =>
Posting Journal main ... id = and action = insert and journal_id = 16
Time: 188 ms, 3 SQLs 1 ms => main_array = Array ( [period] => 4 [journal_id] => 16 [post_date] => 2012-04-11 [store_id] => 0 [description] => Adjustments Entry [closed] => 1 [closed_date] => 2012-04-11 [currencies_code] => USD [currencies_value] => 1 [purchase_invoice_id] => [admin_id] => 3 [total_amount] => 824 )
Time: 189 ms, 4 SQLs 2 ms =>
Posting Journal rows ...
Time: 189 ms, 4 SQLs 2 ms => journal_rows = Array ( [sku] => AIP100 [qty] => 2 [gl_type] => adj [serialize_number] => [gl_account] => 1200 [description] => AIP100 [credit_amount] => 0 [debit_amount] => 824 [post_date] => 2012-04-11 )
Time: 190 ms, 5 SQLs 3 ms => journal_rows = Array ( [sku] => [qty] => [gl_type] => ttl [gl_account] => 5000 [description] => [debit_amount] => 0 [credit_amount] => 824 [post_date] => 2012-04-11 )
Time: 191 ms, 5 SQLs 3 ms =>
The failing sql was: insert into journal_item (sku, qty, gl_type, gl_account, description, debit_amount, credit_amount, post_date, ref_id) values ('', '', 'ttl', '5000', '', '0', '824', '2012-04-11', '6')
Time: 191 ms, 5 SQLs 3 ms =>
mySQL returned: 1265 Data truncated for column 'qty' at row 1
Page trace stats: Execution Time: 191 ms, 5 queries taking 3 ms
Any help is appreciated.
