<![CDATA[FrontAccounting forum — Error/Bug on Standard Material Cost Per Unit of an item]]> 2013-02-01T16:08:03Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=3809 <![CDATA[Re: Error/Bug on Standard Material Cost Per Unit of an item]]> Hi,

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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2013-02-01T16:08:03Z https://frontaccounting.com/punbb/viewtopic.php?pid=15401#p15401 <![CDATA[Error/Bug on Standard Material Cost Per Unit of an item]]> Hi

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)

]]> https://frontaccounting.com/punbb/profile.php?id=16332 2013-02-01T15:22:08Z https://frontaccounting.com/punbb/viewtopic.php?pid=15398#p15398