Add New Item to Stock
When I try to add an item, I capture the data in the form and submit it throws me this error:
Database Error : The item could not be added because
Field 'lastcostupdate' doesn't have a default value
Database SQL Failure : The SQL that was used to add the item failed was
INSERT INTO stockmaster (stockid, description, longdescription, categoryid, units, mbflag, eoq, discontinued, controlled, serialised, perishable, volume, kgs, barcode, discountcategory, taxcatid, decimalplaces, shrinkfactor, pansize) VALUES ('1000', 'Test Part', 'Purchase Part Test', 'PLANT', 'each', 'B', '1', '0', '0', '0', '0', '1', '1', '1000', '', '1', '0', '0', '0')
Someone could say that is what is wrong ?
This is my form:
Item Code: 1000
Part Description: TEST
Part Description: PART TEST
Imagen File:
Category: Plant and Equipment
Economi Order Quantity: 0
Packaged Volume: 0
Packaged Weight: 0
Units of Measure: 0
Assembly, kit, manufactured or service: Purchased
Current or Obsolet: Current
Batch, Serial or Lot Control: No Control
Serialised: No
Perishable: No
Decimal Place for display Quantity: 0
Bar Code: 1000
Discount Category:
Tax Category: Taxable Sypply
Pan Size: 0
Shrinkage Factor: 0
Depresiation Type: Straight Line
Annual Depresiation Percentege:
Thanks for your help...
|