Or be very blunt and after finding out the part_id X of the assembly do a manual update of the onhand quantity:
update parts set onhand=o where part_id=x I think you can even skip the normal restrictive part (where part_id= x y z ) when you have no inventory. However, this might very welll screw up COGS, same as selling it for zero as someone else suggested. So I suggest to make a backup, restore all data into a test-firm and try both solutions in this testfim first. Good SOP (standard operating practice) anyhow.. Hope this helps, Paul 2012/2/12 Rolf Stöckli <[email protected]>: > Am 12.02.2012 18:22, schrieb [email protected]: > >> INSERT INTO inventory ( >> warehouse_id, parts_id, >> trans_id, qty, >> shippingdate, >> employee_id, department_id, linetype) >> VALUES (, 15007, >> 15007, -2, >> NULL, >> , , '5' >> ) >> ERROR: syntax error at or near "," at character 140 >> >> Anyone have any ideas what is wrong? > > > Strange error. employee_id and department_id are empty, but some rows above > they are multiplied by 1, so their value should be at least 0. > > >> Somehow I have a qty of 2 on hand. I need to understand how to zero out >> the >> qty on hand since there are none on hand and I wish to obsolete the >> assembly. > > > Sell these 2 assemblies with sellprice 0 to a customer "Inventory > Difference". > > Regards > Rolf > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
