Purpose

Create Work Order documents. Documents are posted to GL on closure.

Procedure

Assembly (simple)


When an assembled (or disassembled) product is created, all the processes are done in one sweep.

  1. Enter number of units. If disassembling, then units are negative.
  2. The material cost for the assembled (disassembled) item is regulated.
  3. If overhead or labour cost has been added then these costs are adjust the average cost.
  4. The work order is inserted in the work orders table and the units_required and units_issued are updated.
  5. The BOM items are updated in table wo_requirements with units required and units issued.
    • The BOM items are added to stock moves with item quantities and a minus value.
  6. The stock movement for the assembled product is added as a positive quantity value
  7. The total cost for the BOM items are credited to GL Inventory account (debited if disassembled)
  8. If overhead cost and/or labour cost is <> 0:
    • A GL trans is credited the credit account for both values.
    • If this is a bank account, a bank trans is added to default (or first) bank account.
    • A GL trans is debited the GL Assembly Account for both values.
  9. A GL trans is debited the the assembly itself in GL Inventory account (from 7 above).
  10. Comments, reference and audit trail are created.
Assembly (Advanced)


Creation

  1. The material cost for the assembled item is regulated.
  2. The work order is inserted in the worders table and the units_reqd is updated.
  3. Comments, reference and audit trail are created for the work order.

Release

  1. The released flag and released_date in table work_orders are updated.
  2. The Requirements are entered into table wo_requirements with units required for each BOM item.
  3. Comments and audit trail are updated with 'Release'.

Additional Issues

  1. A record is created in the table wo_issues with the issue date and for each issued items a record is created in wo_issue_items with quantity issued.
  2. A stock move is created for each issued item of type Work Order Issue.
  3. Comments, reference and audit trail are created for the Issue.

Costs
Every time a Cost entry is done the following operations are done. The Type is work order and the id is the work order id.

  1. A credit GL transaction is done to the entered credit account. If this is a bank account a bank transaction is done to default account.
  2. A debit GL transaction is done to the entered debit account.

Production
For each production the following operations are done.

  1. A record is inserted in the table wo_manufacture and produced quantity is inserted.
    • For each BOM item the table wo_requirements are updated with produced quantity in quantity issued.
    • A stock move is created for the BOM item of type Work Order Production (minus). Was earlier of type Work Order.
    • The material cost for the item is credited the GL inventory account
  2. For each additional issued items the total issue cost is calculated.
  3. If the total cost <> 0 the Assembled items material cost is regulated.
  4. The overhead and labour cost is fetched and if <> 0 the overhead and/or labour cost is regulated for the assembled item.
  5. The material cost for the assembled Item is debited GL inventory account.
  6. The stock move for the produced assembly is created of type Work Order Production.
  7. The work order is updated with the produced quantity (issued).
  8. Comments, reference and audit trail are updated with 'Production'.
Voiding a Work Order


Assembly (or dis-assembly)

  1. Returning material cost for assembled item and regulated.
  2. if overhead cost and/or labour cost, these costs are regulated.
  3. Set units_reqd and units_issued to 0 in work order table.
  4. Void all the stock moves belonging to the work order.
  5. Void all the corresponding GL transactions
  6. Void all we requirements.

Assembly (Advanced)

  1. Returning material cost for assembled item and regulated.
  2. Check the productions..
    • Set quantity in table wo_manufacture to 0.
    • Void the stock move from the production with type Work Order Production.
  3. Set the issued items from table wo_issue_items, quantity to 0
  4. If issued items.
    • Return the issued items cost from the assembled avg material cost
    • Void stock moves from the issued items from type Work Order Issue.
  5. If Overhead cost and/or labour cost then.
    • Return this cost to the assembled items avg cost
  6. Set the work order to be closed and the units_reqd and units_issued to 0.
  7. Voiding all stock moves belonging to the Work Order type.
  8. Voiding all GL transactions for this Work Order..
  9. Voiding all wo_requirements for this Work Order.

GL Transactions
All GL transactions from a Work Order are of type Work Order and the trans_no is the work order id. despite it might be an issue, cost or production. Some of the transactions will have different dates but no transactions are one-legged (the total for every date is 0).

Tips and Tricks

  • Set a Bills of Material for a manufactured Items before creating a Work Order.
  • Make sure appropriate Item Assembly Costs Account is set in System and General GL Setup.
  • Work Order Required by setting defines number of days to allow for manufacturing of items.