Should there be any change in the 0_refs table as well?
Also the wo_requirements costs are listed as 0 for WO # 1.
The type field in the gl_trans table too needs to be set to 29:
UPDATE 0_gl_trans SET `type`='29' WHERE `counter`='13';
UPDATE 0_gl_trans SET `type`='29' WHERE `counter`='14';
UPDATE 0_gl_trans SET `type`='29' WHERE `counter`='15';
and lines 908-910 in en_US-demo.sql should be:
('13', '29', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
('14', '29', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
('15', '29', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
At the moment, any zero amount item (like Support in the WO #0) will be treated as Work in Progress and have it's amount set to total value of all inputs and later contra-ed on finished product receival. See Anatomy SQL in previous post. Wonder what happens when there are more than one zero cost input items!