Hi, I am running the latest ledger123 (git pull says up to date). When I view an assembly make no changes and simply click on save I get the following error: DBD::Pg::db do failed: ERROR: syntax error at or near "," at character 140 Error!
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? A little background for what I am trying to accomplish. All of my parts are entered as services except for this one assembly for which I do not track qty on hand since I do not stock it. I only order its parts when I have an order from a customer. 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. Can someone suggest how to accomplish the above? Regards, -- Tom [email protected] Spamtrap address [email protected] _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
