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
