Create / Edit Stock Items - BOM

Parent Previous Next

You need to select the BOM (Bills of Materials) option if you are selling Stock Items or products consisting of various other Stock Items (components) and some services, etc. This option allows you to link existing Stock Items and non-physical Stock Items to the finished product.

For example, if you wish to sell a complete spraying kit (consisting of a compressor, 2 high pressure pipes and a spray gun), you may select and add these components (existing Stock Items) to your finished product.

You will also not be allowed to specify the re-order level and select the Cost of Sales, Stock Control and Input Tax accounts.


To Create a Stock Item for Bills of Materials (BOM):

1.Click on the Stock Items button (Sidebar) or click on the Edit → Stock Items menu.

F12

The Stock Item - List View default screen will be displayed.

2.Click on the New button. A blank Stock screen will be displayed.

3.Select the BOM Stock Type. The Stock Entry screen is displayed as follows:

4.Enter the Stock Code, Description, Units, Reorder Level, Reorder at, Minimum, Extra Description as required.

5.Apply Invoice Discount - This is applicable to Debtor (Customer) accounts, as the percentage customer discount is specified on the Edit → Debtor (Accounting Information tab) menu.

6.Reports - Stock Group 1 / 2 - The reporting group to which you wish this service Stock Item to be allocated.

The description of Stock Group 1 or 2 you have entered on the Reporting Group Name field on the Stock Groups tab on the Setup → System parameters → Groups menu may be reflected in this list.

7.Click on the Ledger tab, if not already displayed.

8.Enter or select the following options:

a)Tax Select the Output Tax account. The Input Tax account field is disabled.

b)Weight - Optional - Enter Gross Weight and / or Net Weight if applicable.

c)Ledger - Select the Sales account. The Cost of Sales and Stock Control accounts are disabled.

d)Selling Prices - Enter the Selling Price 1/2/3 exclusive or inclusive of Tax. The inclusive of VAT/GST/Sales Tax will be calculated based on the percentage entered in your Output Tax account. (if you selected that account in advance).

This description should reflect your selling price descriptions as you have entered in the Setup → System parameters → Stock Information menu.

If you have for example entered: "Retail", "Wholesale" and "Cash" for these Selling Prices, the Selling Price 1 / 2 / 3 will be respectively displayed as such.

The amounts as entered in these fields will be displayed on Invoices, Credit Notes and Quotes. When the cursor is displayed on the Amount fields, you may select any of the available selling prices you wish to charge your debtors (customers).

e)Values -

i)Average Cost - The average cost price of your Stock Item cannot be entered at this stage. When you process purchases, the Average Cost Price will be automatically updated.

ii)Total Cost - The total cost price of your Stock Item cannot be entered at this stage. When you process purchases, the Total Cost Price will be automatically updated.

iii)Quantity on Hand - The quantity, or number of Stock Items on hand, cannot be entered at this stage. When you process purchases, the quantities will be automatically updated.

iv)Last Invoice - The date of the last purchase or other document generated on which the service Stock Item was selected. This field will not display any date if it is a new item, or if no Stock Items have been selected on any documents.

v)Latest Cost - The latest cost price of your Stock Item can now be entered. When you process purchases, the Latest Cost Price will be automatically updated.

Once you have created your new Stock Items, you may enter the cost prices and quantities in the Stock Take-on option of the Edit → Adjust Stock menu, if you have any Stock Item records on a previous accounting system.

f)Preferred Supplier 1 - Optional - Select a creditor (supplier) account and enter a supplier stock code if applicable.

g)Preferred Supplier 2 - Optional - Select a creditor (supplier) account and enter a supplier stock code if applicable.

9.Click on the BOM tab, if not already displayed.

10.Click on the Add button to select an item on the Stock Item lookup facility. Repeat this process until all the items (components) have been added to the list.

If more than 1 Stock Item is included in the finished product, you need to enter the the quantities to be included in the finished product.

To delete (remove) an item from the BOM List, select the item on the list and click on the Delete button.

11.Once you have added the BOM items to the list, enter the quantities of the components for each item. The values in the Average Cost, Latest Cost and Quantities on Hand fields will automatically be displayed for each stock item. The total Cost Price value will also be automatically calculated (sum of the number of items x cost price for each item).

12.Select Cost Price or Selling Price option in the Calculate Base field. Click on the Recalculate Sales % button. This will calculate the Percentage of Sales for each item on the BOM List.

13.Click on the Save button to save this stock item. The Stock Item - List View - Default screen will be displayed.

Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle