Just like the function of the Sales Order or Purchase Order, Stock Assembly Order will not affect stock movement. Furthermore, it can be transferred to Stock Assembly and there will be an outstanding report on Stock Assembly Orders that have not been transferred.
First, go to Stock >Next, click on Stock Assembly Order
Then, click on Create a New Stock Assembly Order,
Description: description of this document
Ref. Doc. No: key in reference document number (if any)
Stock Assembly Order No: auto-running document number, the next possible number is shown on the top of the window. Next, you may click on <<New>> to key in any document number.
Date: document date
Expected Completion: key in expected date (or days) of completion. (For reference only)
Functional Buttons:
to be saved in the K.I.V folder to be used later.
to add/insert a detail row. (Insert)
to insert a detail row before the highlighted row. (Ctrl + Insert)
to delete the highlighted row. (Ctrl + Delete)
to move the detail row up/down. (Alt + Shift + Up/Down)
to select all detail rows (Ctrl + Alt + A), so that it can be deleted or modified in one shot (using Range Set)
range set (F12)… a range setting windows will be prompted. This is usually used to apply changes to several/all selected detail rows.
to prompt the item search screen (F9). Type a keyword, select search criteria, click on Search. From the search result, check the check-boxes to select items to be included in the document, then click on OK</span
to apply BOM Optional that was maintained earlier, e.g. to substitute one or more of the material items.
this is to be used together with BOM Optional when the Multi-Level Assembly module is enabled.
Click on this button will display (at bottom section) instant information related to the highlighted item, such as Price History, Stock Balance …
to copy a stock assembly order which previously already save.
to copy the existing stock assembly order to a new stock assembly order.
to transfer sales order to invoice.
to check the invoice which has already been transferred.
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.
First, go to Stock > After that, go to BOM Optional
Then, click on New,
BOM Optional Code: key in an optional code
Description: key in the description of this BOM optional
Details tab: click on the ‘+’ 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 the ‘+’ sign to assign which is (are) the BOM finishes goods that this BOM Optional can apply to.
Next, click on Apply to BOM Item…
Then, click on the ‘+’ sign to assign BOM finishes goods that this BOM Optional can apply to.
And lastly, click on Save.
Apply BOM Optional
In Order to make 5 quantity of BOM finished goods, you need 10 quantity BOM C and 15 quantity BOM D. Now, click to Apply BOM Optional.
Next, check the checkbox to select, fill in quantity, and after that click on OK…
The item BOM C has been replaced with item BOM D which you have to maintain earlier. 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.
Edit tab:
Copy Whole Document: Copy the whole document to the clipboard.
Copy Selected Details: To copy some item details to the clipboard. (press ctrl+ highlight the item to copy)
Copy as a spreadsheet: To copy the item details and paste them into a spreadsheet.
Paste Whole Document: To paste the whole document from the clipboard.
Paste Item Detail Only: To paste some item details from the clipboard.
Undo Master: To undo (reverse one step) the header section.
Convert To Multi-Level: To show at a single level or multi-level BOM.
Edit MRU Items: to edit /delete historical descriptions (which was keyed in previously). MRU = Most Recently Used
Convert to Multi-Level
Let say I created another item BOM A with sub-item code SUB-A and SUB B.
When I click Converter To Multi-Level, the following message will prompt:
Now, click Yes to proceed.
It will show all the sub-level of your item BOM.
Then, click View Stock Card Report…
Stock Assembly
Stock Assembly is to assemble finished goods according to the BOM setting. This transaction will increase the stock quantity of finished goods and at the same time decrease the stock quantity of material items.
Now, go to Stock > Next, go to Stock Assembly
Then, click on Create a New Stock Assembly,
After that, select Item Code (finished goods to be assembled),
Then, key in quantity to be assembled,
Now, you may key in the details of this new document OR copy/transfer from other documents.
However, when Stock Assembly Order was issued on the case, you MUST create an invoice using ‘Transfer from Assembly Order’.
(Here I am going to transfer document from Stock Assembly Order)
Description: description of this document
Ref. Doc. No: key in reference document number (if any)
Stock Assembly No: auto-running document number, the next possible number is shown on the top of the window. You may click on <<New>> to key in any document number.
Date: document date
Functional Buttons:
to be saved in the K.I.V folder to be used later.
to add/insert a detail row. (Insert)
to insert a detail row before the highlighted row. (Ctrl + Insert)
to delete the highlighted row. (Ctrl + Delete)
to move the detail row up/down. (Alt + Shift + Up/Down)
to select all detail rows (Ctrl + Alt + A), so that it can be deleted or modified in one shot (using Range Set)
range set (F12)… a range setting windows will be prompted. This is usually used to apply changes to several/all selected detail rows.
to update item cost with Standard Cost.
to update item cost with Up-To-Date Cost.
to prompt the item search screen (F9). Type a keyword, select search criteria, click on Search. From the search result, check the check-boxes to select items to be included in the document, then click on OK.
to apply BOM Optional that was maintained earlier, e.g. to substitute one or more of the material items.
this is to be used together with BOM Optional when the Multi-Level Assembly module is enabled.
Click on this button will display (at bottom section) instant information related to the highlighted item, such as Price History, Stock Balance …
to copy a stock assembly which previously already save to copy existing stock assembly to a new stock assembly.
to transfer stock assembly from stock assembly order
Variance Qty: the difference between order quantity and quantity
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 the unit cost of these finished goods.
After these, view the Stock Card Report again…
Dismantled Quantity
Dismantled quantity must be recorded when one or more material items were taken out from the assembled items. Moreover, the dismantled items will be returned back to the storeroom (stock increase) and the quantity of assembled finished goods will be reduced accordingly.
First, go to Stock > Next, go to Stock Assembly
Then, highlight the item assembly that involved dismantled quantity
And then, click on Edit,
Now, key in quantity value into the column of Dismantled Qty.
Lastly, click on Save.
now, view the Stock Card Report again…
Note: you may see that the balance quantity of material (BOMA) and finished goods (BOM) were affected accordingly.
New Features
Stock Disassembly
Stock Disassembly is to disassemble finished goods and get back to its raw materials. Additionally, this transaction will decrease the stock quantity of finished goods and at the same time increase the stock quantity of material items.
First, go to Stock > Then, go to Stock Disassembly
Now, click on Create a New Stock Assembly,
Then, select Item Code (finished goods to be assembled),
Next, key in quantity to be assembled,
Functional Buttons:
to update item cost with Standard Cost.
to update item cost with Up-To-Date Cost.
to distribute the cost according to the cost fraction, standard cost, or most recently cost.
to prompt the item search screen (F9). Type a keyword, select search criteria, click on Search. From the search result, check the check-boxes to select items to be included in the document, then click on OK.
click on this button will display (at bottom section) instant information related to the highlighted item, such as Price History, Stock Balance …
to copy a stock disassembly which previously already save.
to copy existing stock disassembly to a new stock disassembly.
View the Stock Card Report
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.
First, go to Stock > Next, click on BOM Listing Report
Now, define filter options,
Then, click on Inquiry,
After that, click on the ‘+’ sign before Item Code to expand the details of sub-items. (or right-click on column header and click on Expand All)
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.
First, go to Inquiry > Next, go to BOM Material Usage Inquiry
Then, select a material item code (Sub Item Code),
Check BOM Material Inquiry
To check the availability of material items if a certain quantity of finished goods is to be assembled.
Now, go to Inquiry> Then, 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)
Then, click on Inquiry,
Note: the negative value in Balance Qty means insufficient quantity of that material item.
Click on Raw Material Summary tab,
Include Outstanding P/O & Outstanding S/O & Outstanding A/O: to include all outstanding purchase order, sales order and assembly order quantity
Calculate All UOMs: to include all UOMs
Multi-Level: if the options are ticked, all sub-item codes will be shown in detail.
Pingback: AutoCount Module - AutoCount Software