Wrong unit cost for AP Surf Set in demo data

I will have a look at it later.

Joe

@Joe
No, the mentioned table is 0_stock_moves not the workorders table.

In the same vein, shouldn't the other entries be type=29 (ST_MANURECEIVE) instead of the current type=26?

Even after the last commit, there is however no change in the WO_Production Costs for WO #1 shown in the attachment in the Post #2 in this thread. Everything still remains in the finished product receival part of the view instead of the input items being part of issues.

The complete anatomy of an Assembly Work Order is listed here and attached as well.

The time of entry is available only in the audit_trail table.
The amounts are not rounded off in the stock_moves and wo_requirements tables.
The amounts are rounded off in the gl_trans and stock_master tables.
The stock_master.material_cost field is computed as the weighted average of existing stock quantity and value and those of the currently produced item (or any other chosen programmed means).

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!