Bill of Material

Top  Previous  Next

 

This module is used to maintain finished goods and raw materials in bill of material, perform item assembly, provide reports on transaction and stock balance.  

Go to Tools > Program Control > Module Setting

Check the checkbox of Bill of Material to enable it.

 

 

Stock Item Maintenance

 

First of all, maintain stock items for BOM finished goods and materials, then key in their opening balances OR create purchase documents (if any).

In the following example, 'BOM FINISHED ITEM' is a finished goods, and its materials are: BOM-A, BOM-B, and BOM-C.

 

 

module95b

 

 

 

Item BOM Maintenance

 

We need to maintain Bill Of Material for such finished goods and its material items.

Go to Stock > More Stock Maintenance > Item BOM Maintenance

Click on New,

 

 

module95

 

Item Code: assign finished goods' item code.

Total Bal. Qty.: balance quantity of this finished goods (auto displayed)

Description: description of this finished goods (auto displayed upon selection of Item Code)

Assembly Cost: key in (if any) amount of cost involved in assembling one unit of this finished goods, which will be included in Finish Goods Cost.

Automatic Serial No. Format: (if this is an item with serial number) select a serial numbering format so that the system will auto generate serial number upon creation of finished goods. To maintain the serial number format, go to General Maintenance > Document Numbering Format Maintenance,  click on New, select Document Type: S#. After saved, it will appear under Category: Others.

Sub Item Code: click on '+' sign to add B.O.M. material items one by one.

Qty: the quantity of this material needed to assemble one unit of finished goods

Overhead Cost: overhead cost that will occur when using this material item to assemble finished goods (regardless of quantity)

Total Bal.Qty: current balance quantity of this material item (auto displayed)

Sequence: indicating the sequence order of material items.

Finish Good Cost: total assembly cost of one unit of B.O.M. finished goods.

Manually Update BOM Cost: to manually update (when needed) the Standard Cost of this finished goods either from sub-items Standard Cost or Up-To-Date Cost. 

Auto Update BOM Cost: to automatically update the Standard Cost of this finished goods either from sub-items Standard Cost or Up-To-Date Cost whenever there is a change in that cost. 

Recalculate: to recalculate the cost of this BOM finished goods based on latest updates. 

 

 

Click on Save.

 

 

module95a

 

Click on '+' sign before Item Code to list the Sub-Items and details.

 

Related topics: 15035 BOM Finished Goods Cost column

 

 

 

 

BOM Optional

 

This is to maintain optional/alternative material items for BOM finished goods. It will be used in Stock Assembly and Stock Assembly Order.

Go to Stock > BOM Optional

Click on New,

 

 

module95c

 

BOM Optional Code: key in an optional code

Description: key in description of this BOM optional

Details tab: click on '+' button to assign sub-items... For example: to replace one unit of BOM-C (key in negative quantity value -1) with 2 units of BOM-D (key in positive quantity value 2).

Apply to BOM Item tab: click on '+' sign to assign which is (are) the BOM finishes goods that this BOM Optional can apply to.

 

Click on Apply to BOM Item...

 

 

module95d

 

 

Click on '+' sign to assign BOM finishes goods that this BOM Optional can apply to.

Click on Save..

 

 

 

 

Stock Assembly Order

 

Just like the function of Sales Order or Purchase Order, Stock Assembly Order will not affect stock movement, it can be transferred to Stock Assembly and there will be an outstanding report on Stock Assembly Orders that have not been transferred.

 

Go to Stock > Stock Assembly Order

Click on Create a New Stock Assembly Order,

 

 

module95e

 

Transfer Document: you may transfer from Sales Order.

Description: description of this document

Stock Assembly Order No: auto running document number, next possible number is shown on the top of window. You may click on <<New>> to key in any document number.

Date: document date

Ref. Doc. No: key in reference document number (if any)

Expected Completion: key in expected date (or days) of completion. (For reference only)

Main tab: the related materials will be listed with the rate (the quantity of material item needed for one unit of finished goods), material item unit cost, overhead cost (lump sum) and sub total.

Raw Material Status tab: to show the total quantity of raw materials needed and stock availability.

 

module95f

 

 

Apply BOM Optional: to apply BOM Optional that was maintained earlier, e.g. to substitute one or more of the material items.

 

module95g

 

Check the checkbox to select, fill in quantity, and click on OK...

 

 

module95h

 

Alternatively you may click on '-' and/or '+' signs to remove/add a material item or just edit item code, Qty, item cost, overhead cost and/or assembly cost.

 

 

 

View Stock Card Report...

 

 

module95i

 

 

 

 

 

Stock Assembly

 

Stock Assembly is to assemble finished goods according to BOM setting. This transaction will increase stock quantity of finished goods and at the same time decrease stock quantity of material items.

 

Go to Stock > Stock Assembly

Click on Create a New Stock Assembly,

 

Select Item Code (finished goods to be assembled),

Key in quantity to be assembled,

 

 

module95j

 

Transfer Document: you may transfer from Stock Assembly Order.

Description: description of this document

Stock Assembly No: auto running document number, next possible number is shown on the top of window. You may click on <<New>> to key in any document number.

Date: document date

Ref. Doc. No: key in reference document number (if any)

Show Up-To-Date Cost Details: to display (at footer area) the up-to-date cost for the highlighted item.

Main tab: the related materials will be listed with UOM Rate (quantity of material item needed for one unit of finished goods), Qty (total quantity of material item needed for this transaction), material item unit cost, overhead cost (lump sum) and sub total.

Raw Material Status tab: to show total quantity of raw materials needed and stock availability.

Apply BOM Optional: to apply BOM Optional earlier maintained, e.g. to substitute one or more of the material items.

Child Item: this is to be used together with BOM Optional when Multi Level Assembly module is enabled.

Update Item Cost With Standard/Up-To-Date Cost: to update item cost with Standard Cost or Up-To-Date Cost.

Dismantled Qty: quantity of this item that has been dismantled or taken out from this assembly.

Total Cost: total cost of material items including overhead cost.

Assembly Cost: total assembly cost, derived from:  Assembly Cost per set  X  assembly quantity

Net Total Cost: will be used to calculate unit cost of this finished goods.

 

 

View the Stock Card Report again...

 

 

module95k

 

 

 

 

 

Dismantled Quantity

 

Dismantled quantity must be recorded when one or more material items were taken out from assembled item. The dismantled items will be returned back to store room  (stock increase) and the quantity of assembled finished goods will be reduced accordingly.

 

Go to Stock > Stock Assembly

Highlight the item assembly that involved dismantled quantity, click on Edit,

 

 

module95l

 

 

Key in quantity value into the column of Dismantled Qty.

Click on Save..

 

 

module95m

 

 

 

View the Stock Card Report again...

 

 

module95n

 

Note: you may see that the balance quantity of material (BOM-C) and finished goods (BOM) were affected accordingly.

 

 

 

 

BOM Listing Report

 

To list all BOM items and show the maximum quantity (finished goods) that could be assembled based on currently available material items stock level.

 

Go to Stock > BOM Listing Report

Define filter options,

Click on Inquiry,

Click on '+' sign before Item Code to expand the details of sub-items. (or right click on column header and click on Expand All)

 

 

module95o

 

Max. Manufactured Qty.: the maximum quantity (finished goods) that can be assembled based on current level of stock (material items).

Ratio: the maximum rounded quantity that can be assembled based on this material item stock level. (take Available Qty and divide by Required Qty)

 

 

 

 

BOM Material Usage Inquiry

 

To check the usage of a material item, such as in which finished item and the quantity needed to produce one unit of that finished item.

 

Go to Inquiry > BOM Material Usage Inquiry

Select a material item code (Sub Item Code),

 

 

module95p

 

 

 

 

 

Check BOM Material Inquiry

 

To check the availability of material items if a certain quantity of finished goods is to be assembled.

 

Go to Inquiry> Check BOM Material Inquiry

Click '+' to assign a BOM Item Code (finished goods item code) and key in Qty To Be Manufactured,  (you may add more than one BOM items)

Click on Inquiry,  

 

 

module95q

 

Note: the negative value in Balance Qty means insufficient quantity of that material item.

Click on Raw Material Summary tab,

 

 

module95r

 

 

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.