This is a bug. This would normally happen when there are no stock on hand for the item.

Fixed and HG repository updated.

You can download items_trans_db.inc, and replace existing /inventory/includes/db/items_trans_db.inc

/Joe

I'm getting this error when I insert Standard Material Cost Per Unit of an item.

DATABASE ERROR : Cannot add audit info
error code : 1264
error message : Out of range value for column 'trans_no' at row 1
sql that failed was : INSERT INTO audit_trail (type, trans_no, user, fiscal_year, gl_date, description, gl_seq) VALUES('35', '-1',1,3,'2013-02-01','', 0)