Accounting/Module G - Using Manufacturing
INTRODUCTION TO MANUFACTUTING WITH SOLACE ACCOUNTING
A manufacturing business is any type that uses components, parts or raw materials to produce finished good. Manufacture in accounting deals with inventory valuation and cost of goods sold.
Inventory valuation
The inventory can be valuated with many ways. Solace accounting only provides 2 methods, Last-in-First-out called latest price and the averaging technique called average cost.
Cost of goods sold
The cost of goods sold also called cost of sales is the accumulated total used to manufacture a product or to produce a service which are being sold. In a service business setup, the cost of goods sold is generally the labor to render the service. In retails business, the cost of goods sold is likely to be the purchase price including other costs of acquiring the product.
These settings are found in the inventory settings section of the control panel and explained in “Module F trading in Stock”
B.O.M SETTINGS
Bill of Martials also called B.O.M and referenced in solace accounting as BOM is the structure or the list of raw materials, parts or components need to produce an end-product. Before defining these lists, all parameters bust be setup in solace account.
-Create BOM Entry Type Journal
Solace accounting uses a dedicated journal to record all BOM transactions, if not created yet proceed to create one.
From main screen, navigate to control panel
Double click on Entry Type setup,
Click add button
Type in the Journal Description
Click ok to save
Click Close.
-To Setup Manufacturing General Parameters
From main screen, navigate to control panel
Double click on inventory setup,
Click on Bill of Materials(BOM) menu button.
Select “Enable Manufacturing”. This will make all parameters changeable by the user and define the system to used manufacturing module.
Type in the Next BOM number
Select the Journal used for BOM transactions
Type in any additional cost
Select Account Number that will record the extract Cost.
Click Apply.
CREATE BOM ITEM
For illustration, we will manufacture simple bookshelf with 3 parts and maintenance labor as extra cost. First, we need to create the 3 parts inventory items.
| Code | Description | Last unit Cost |
|---|---|---|
| 1BS_PART_A | Bookshelf Part A | 140.00 |
| 1BS_PART_B | Bookshelf Part B | 150.00 |
| 1BS_PART_C | Bookshelf Part C | 160.00 |
We will now create the end-product and define the list a raw materials BOM
-To create list of raw materials (BOM)
While the inventory item is still selected in the list on the left
Click on BOM tab
Tick enabled
Type in the BOM code
Type in the description
Type in “1” in produce … with these components
Tick print details on invoice. This will list all components in the invoice
Enter all 3 parts and type in quantity needed
Click on Extra Cost and enter Amount for all listed costs
Click Save
| Note: Solace Accounting uses the same BOM module for combo items and kit items. The option use as kit will set the BOM to be generated on the fly in the invoice. A BOM item defined as Kit do not need to be manufactured as there as end-product is a simple assembly of components items. |
|---|
-To Manufacture and produce end-product
SETP 1: Record BOM Request
After defining the BOM and extra cost new the system is ready to create end-product by using the BOM and general parameters.
From main screen navigate to inventory
Double click on Manufacturing
Click on New Request
Fill in all details on the screen
Click Save
| Internal | Tick this option is the request in an internal request that did not originate from a customer order. If unticked, the request will be linked to a customer account. |
|---|---|
| Manufacture Number | This is filled automatically by the system using the next BOM number as defined in setup |
| Sub Account | Customer sub account Number |
| BOM Code | Select the BOM Item code from the list |
| Description | Type in the request description |
| Stock Code | This is filled in automatically with end-product code |
| Store | Define the store in which the end-product will be generated |
| Quantity Done | Solace accounting allows manufacture on-demand. The requested quantity can be produced in stages. This box will display total quantity already produced |
-Material Requirement Report
You can at this point check your stock level by printing the request Material Requirement Report. Click on MR Report
SETP 2: Process BOM Requests
Select or highlight the request
Click on process
Enter processing quantity
Tick completed. If full requested quantity was reduced by the customer and the process need to complete with, tick this option for the system to complete the request regardless on of the total quantity produced
Click Ok
After clicking OK, the system will create end-product in the store, reduce the components quantities and post to the ledger all transactions generated by the process. The request will be off the list if the full request quantity has been produced
The end-product for finished good will be available in the inventry and can be sold as standard retail item.
Few reports are affected with the manufacture process and here are a samples
The BOM Journal report
The inventory Quantities Report
CREATE COMBO/KIT ITEM
Solace Accounting has the option to combine items into one process it as a whole item. This is particularly usefully also in case of break down when the item bought is sold component by component or into parts. To setup combo or kit, when creating BOM, tick the option "Use as Kit". For our tutorial, let create a Dinner suite item which is a combo of a table and six chairs. First let create the chair inventory item that will be a component to the Kit. Combo is synonymous with kit and can be substituted.
| Code | Description | Last unit Cost |
|---|---|---|
| 1CH001 | Dinner Chair | 75 |
Then let create the Kit
| Code | Description | Last unit Cost |
|---|---|---|
| 1DS001 | Dinner Suite | Will be calculated |
Add the 2 components and change the cost to accommodate the a discount if applicable to the combo/kit. Below, we adjusted the dinner table to 1 500. When selling this kit, Solace accounting will use the total of components as inclusif price of the kit sold.
SELLING A COMBO/KIT
The main difference between a BOM item and a kit item is that BOM item need to be manufactured before it can be sold and the kit item can be sold directly with no extra process. There are two ways of selecting a kit item in a document: by using the kit code with line type set to line type “1 stock item” or by setting the line type to “3 kit item” which will filter the inventory lookup list to show only kit items. Create an invoice, refer to “Module F Trading In Stock”, and select the kit item. The system will automatically add components in comments line as “Print Details on Invoice” was selected.
The system added 1 Dinner Table at 1 500 and 6 Dinner Tables at 75 each
1x1500 + 6x75 = 1 950 (inclusive total)
Posting this invoice will result in all accounts changes, as per standard invoice but with the kit item, Solace accounting will also reduce each component quantity.
All sales analysis reports are affected here is a sample
On the report, the Dinner chair and Dinner table quantities are reduced proportionally to the sale.
WERE FROM HERE
Manufacturing is presented in this tutorial as a complement to the inventory module, to gain full understanding of bills of materials, combo and kits we recommend studying all the modules related to inventory.