Open topic with navigation

Details (stock record)

Enter the main details of the stock item. Some of the information added here is inherited from the stock item's product group and cannot be changed.

To enter stock record details

Open: Stock Control > Stock Records > Enter New Stock Item | Details.

1. Enter a unique Code (up to 30 characters) and Name (up to 60 characters) for the item.

   Stock Codes and Names can contain letters and numbers.

2. Enter the Item classification:

   Product group	Select the product group the stock item belongs to. The stock item inherits the settings of the product group.
   Product type	The product type is inherited from the product group and cannot be changed on the stock item.

3. Enter the Item status:

   Current status

   Select the item's status from the drop-down list. Active When a stock item is Active stock movements can be recorded against it. Inactive When a stock item is Inactive, you cannot select it. The item will not appear in any lists in Sage 200 (for example, when recording a stock movement, sales order or purchase order). Inactive stock items are still included in the stock Valuation report and are available for stocktake.

   Inactivation date

   This is used for reporting purposes only. The item will not be made Inactive on this date.

4. Enter the Trading settings:

   Stock unit	Select the unit of measure used to store the stock item, from the drop-down list. This is inherited from the Product group.
   Tax rate	Select the Tax rate used when the stock item is sold. This is the tax rate used when transactions such as invoices, credit notes, sales orders and purchase orders are entered into Sage 200. You can change this for individual transactions if required. The system automatically assigns the first non-zero rated code defined in the Accounting System Manager to the stock item.

5. If required, enter the Manufacturer details:

   Use this to store the Manufacturer's name and Part no for the item.

   Different suppliers may have their own name or product code for the item.

6. Enter the Label Printing Option:

   Select how you want to print order labels order labels for this stock item: per item, per batch, or not at all.

   This is set to Label not required, by default.

7. Select Allow sales orders if you want the stock item to be used in sales orders.

8. Costing Method:

   Cost method

   This is inherited from the product group and cannot be changed. It controls how the cost of sales for an item is calculated. Note: In order to avoid restricting business operations, Sage 200 supports the sale of goods before their cost is known. There can be significantly different cost of sale values for the same sequence of purchases and issues depending on the costing method used. In the case of Standard costed items, the cost of sales is calculated using the standard cost at the time of the sale. This is not adjusted when the actual cost becomes known. In the case of Average costed items, the cost of sales is calculated using the average cost at the time of the sale. This is not adjusted when the actual cost becomes known. In the case of Actual costed and FIFO items, the cost of sales is calculated using the average cost at the time of the sale. This is adjusted when the actual cost becomes known. It also influences how the stock item value is represented in the stock Valuation report. Manufacturing users If you are using Manufacturing it also controls how the works order costs items that have been issued to it with unconfirmed value. Note: In order to avoid restricting business operations, Sage 200 supports the issue of components to works orders before their cost is known. There can be significantly different values for the cost of finished goods for the same sequence of purchases and issues, depending on the costing method used for the components. In the case of Standard costed items, the issue cost is calculated using the standard cost at the time of the issue. This is not adjusted when the actual cost becomes known. In the case of Average costed items, the issue cost is calculated using the average cost at the time of the issue. This is not adjusted when the actual cost becomes known. In the case of Actual costed and FIFO items, the issue cost is calculated using the average cost at the time of the issue. This is adjusted when the actual cost becomes known and the works order is closed. Works orders can only be closed when all costs are known.

   Cost price.

   If the Cost method is Standard enter the Standard cost price of the item. For other costing methods the calculated Average buying price is displayed.

9. Enter an Item description (optional).

   Use this to enter a detailed description of the item.

   Use item description on orders and invoices

   Select this to use this description order or invoice documents.

10. BOM Details:

    If you are using the Bill of Materials module, select how this stock item will be used in a bill of materials.

    About the BOM details

    • Component: This is a single stock item. These are used as part of a finished stock item. This option is selected by default.
    • Built item: This is a stock item that is assembled from one or many components/sub assemblies to create a finished stock item.
    • Phantom item: This is used in a finished item; if it is an item that you would not sell to your customers or keep in stock. Phantom stock items are typically used to segment large BOMs and to assist in planning how to build the finished item.

    • Built/Bought (Sage 200 Manufacturing users only): This is a stock item that can be built from other stock items or be bought in from another supplier.

      Select from the Built/Bought drop-down list, to determine whether the item is a Default Built or Default Bought item. The default is Default Bought.

      MRP will raise a works order recommendation for a Default Built item and a purchase order recommendation for a Default Bought item.

      Note: If the stock item is a component and not a BOM, then MRP will always raise a recommendation for a purchase order for the item.

      Trial Kitting, Costing, Allocation and Build in the Bill of Materials module also use this setting.

      The From Stock option is used as the fulfilment method by default.

Go to top