[Solved] Adding labor and overhead to manufactured items??
I am able to set up a BOM and run a Work Order successfully. The BOM only includes Purchased materials. I am using Weighted Average Costing.
After running the WO, the Cost and Quantity On Hand are properly reported for the Inventory Item. If I click on Maintain Standard Cost, I see fields to input Standard Labor and Standard Overhead on a per-Unit basis. If I put anything in either of those fields and hit Update, ERP gives two error messages:
Database Error : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The GL credit for the stock cost adjustment posting could not be inserted because
Cannot add or update a child row: a foreign key constraint fails (`sierracoffee`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY (`account`) REFERENCES `chartmaster` (`accountcode`))
Database SQL Failure : The following SQL to insert the GLTrans record was used
INSERT INTO gltrans (type, typeno, trandate, periodno, account, narrative, amount) VALUES ('35', '26', '2013-07-23', '1', '0', 'FRC16 cost was 49.847 changed to 79.847 x Quantity on hand of 100', '-3000')
Please tell me how to add labor and overhead to the WO. I have set up a Work Center and set the Overhead Per Hour but I have no idea how to tell ERP how many hrs. to charge towards the WO.
Other than this lack of understanding on my part, I am finding WebERP to be a great tool.
Thanks,
Ray
|