Stock Control Settings

Use these settings to control how you manage you stock items in Sage 200cloud.

Stock Fulfilment methods

Open: Settings > Stock Control > Stock Control Settings | Options

The sales order fulfilment methods determine how stock is allocated to your sales orders. You can choose here whether which methods you want to use. You can choose either or both.

  • From stock

    This is the most commonly used and therefore the default method. Your stock items are allocated and despatched from the available stock in your warehouse.

  • From supplier via stock

    This allows you to generate a purchase order for a supplier when the item is added to a sales order - back to back ordering. This is useful if you don't keep items in stock but order them when required.

    When you use this fulfilment method, you create a purchase order for item from the sales order. When the items are received, they are automatically allocated to the sales order, ready for despatch.

    To use this fulfilment methods, the stock item must

    • Have a supplier account set on the stock item record.
    • Have the From supplier vis Stock fulfilment method set for the item.

Profit calculation method

Open: Settings > Stock Control > Stock Control Settings | Options

Sage 200cloud automatically calculates the profit you make on the sale of your invoice and order lines. You can see this on orders and invoices, and via various reports and enquiries such as the Monthly Trading Figures. This is the difference between the cost of the line and the revenue received. It is also referred to as the Gross Margin.

The profit percentage is calculated using:

  • The Sale value for each line. This is the selling price multiplied by the line quantity.
  • The Cost value for each line. This is the cost price multiplied by line quantity.

You decide how you want this percentage profit to be calculated on the Stock Control Settings | Options tab:

  • A percentage of revenue.

    100 * (sale value - cost value) / (sale value)

  • A percentage of cost.

    100 * (sale value - cost value) / (cost value)

Landed costs

Open: Settings > Stock Control > Stock Control Settings | Options

Landed costs refer to any costs associated with the shipping, handling and importing of your stock items that you want to include on your purchase orders.

These additional costs are often invoiced separately, by a courier for example and they may span multiple purchase orders.

In Sage 200cloud you can:

  • Choose whether stock items use landed costs by default.
  • Charge landed costs as a set amount, or as a percentage of the order line.
  • Apply landed costs whenever you use a particular supplier.

If you want to use landed costs in Sage 200cloud, you need to turn this on here in the Stock Control Settings. You set defaults for your landed costs on the relevant product groups and these are inherited by the stock items in that group. Landed costs can also be applied when using a specific supplier.

Write off categories

Open: Settings > Stock Control > Stock Control Settings | Write Off Categories

These allow you to monitor reasons why stock has been written off, such as damaged or faulty.

When you use the Write off stock screen, you can choose the reason for the write off from a drop-down list. You create the options for the list here.

A default category Stock Write Offs has been created for you by default. If you don't want to use any other categories, then you don't need to do anything here.

Configurable names

Open: Settings > Stock Control > Stock Control Settings | Configurable Names

You can use configurable names to make the names used in Stock Control more meaningful for your organisation.

You can enter your own labels for:

  • Locations. These labels are used when you enter stock item locations. The default labels are Warehouse and Bin.

  • References. These labels are used when you add a reference to a stock movement transaction. The default labels are Reference and Second ref.

Note: If you make changes to configurable names, but the new names are not displayed in Sage 200cloud workspaces, we recommend restarting your server (IIS).

Internal areas

Open: Settings > Stock Control > Stock Control Settings | Internal Areas

These allow you to allocate stock that's being used for your internal use. For example, you may use some of the stock items you produce for yourself, or your sales department might want to reserve stock items for demonstration purposes.

An internal area represents the department you are allocating the stock to. You can record the stock as issued to that department or internal area and then you can report on this. If you intend to create several internal areas you must select a default. This should be the most commonly used area.

If you don't need to use internal areas then just leave this blank.