Skip to content
logo Knowledgebase

The product record Details tab

Created on  | Last modified on 

Summary

Information about the Details tab in product records, found in Sage 50 Accounts.

Description

The Details tab in a product record can store details about your products, including details, defaults and more.

Resolution

To get to the Details tab:

  1. Click Products and services.
  2. Double-click on an existing product, or click New if you’re creating a new record.
  3. The product record opens automatically on the Details tab.

In this window, you can amend the following:

Skip to:

Product Details

Product Code*

You can enter up to 30 characters for the product code. Each product must have its own unique code.

NOTE: Once you create a stock code, you can't change it. If you want to change the code, you'll need to create a new product record.
Item Type From the drop-down list, choose the type of product required.

The product can either be a:
  • Stock Item
  • Non-Stock Item
  • Service Item - Sage 50 Accounts Professional and above

Choose Stock Item for items you keep in stock where you want to record the stock activity. Choose Non Stock Item for items you don't keep in stock, no activity details exist for Non Stock Items.
A Service Item is similar to a Non Stock item. You'd use this for services, such as labour.

TIP: You can change the default Item Type in a new record in Product defaults.
Description

Enter the product name or description. This appears on reports and it automatically appears when you use the product code on invoices, credit notes, sales and purchase orders. You can enter up to 120 characters in v29 and above, or 60 in v28.1 and below.
Category From the drop-down list, you can choose one of the 999 category codes available for reporting purposes.
Intrastat Com. Code

NOTE: Use this field to produce Intrastat Supplementary Declaration information in Sage 50 Accounts Professional only.

Enter the item's commodity code here. This must be eight numeric characters for HMRC to accept your Intrastat returns. There's an additional field at the end of Intrastat Com. Code for a two-digit duty code. A duty code explains the duty you apply to the stock item when you import it. The duty code doesn't appear on any reports, however you can add this variable onto your reports.
Supp Unit Qty Enter any supplementary units here. For each commodity code, you must report either the net mass, or both the net mass and the supplementary unit quantities.
Com. Code Description

Enter the item’s commodity code description here.

NOTE: You can only enter a description in Sage 50 Accounts Professional.
Weight (kg) Enter the weight, in kilograms, of the item. This is essential if you're using Sage 50 Accounts Professional or above to produce Intrastat Supplementary Declaration information.
Bar Code Bar code entries are alphanumeric and can be up to 60 characters in length. You can add bar codes to a range of layouts in Sage Accounts including invoices, orders and delivery notes.
Inactive Select this box to prevent any further activity on the record, and exclude it from the products and services window and selection lists.
Location

Enter the location of your stock item. You can enter up to 16 characters.

NOTE: This is a free text field, you can't set up pre-defined locations and move the stock between location.
Country of Origin To ensure it appears in your Intrastat Declaration, enter the item's country of origin code here. Failure to do so may result in a rejected declaration.

This field refers to the country of manufacture. This may differ from the supply country, known as the country of consignment on the supplier's record. 
* indicates a compulsory field.

Defaults

Sales Nominal Code Use this box to identify the sales nominal code to which the value of these items post to when you use this item.
You can override this if you select the Use Default Nominal Code for Sales check box from within the Customer record, Defaults tab.
Tax Code Use this drop-down list to choose the VAT rate applied by default when you create a document for this item.
If required, you can change this tax code when you enter invoices or orders. You can overwrite this if you select the Use Default Tax Code for Sales check box, from the Customer Record, Defaults tab.
Purchase Nominal Code Sage 50 Accounts Professional only
Use this box to identify the purchase nominal code to which the value of the items post when you update any purchase orders that include this item.
You can override this if you select the Use Default Nominal Code for Purchases check box from the Supplier record, Defaults tab.
Part No.

You can enter a product reference number here, up to 60 characters for v29 and 16 for v28.1 and below.

For example, a supplier's reference or part number.
Supplier A/C From the drop-down list, choose the supplier account reference for the supplier of this product.
Department If you use the departmental analysis option, you can assign the product to a department for reporting purposes. Use the drop-down list to choose one of the 999 department codes available.
EC VAT Description UK only
This box is blank by default. From the drop-down list, choose an EC Sales description.
We include three default descriptions, and you can create a further four extra messages. If required, amend within Settings, Company Preferences, VAT tab, EC VAT Descriptions.

Status

These options are available in Sage 50 Accounts Professional only.

In Stock The current quantity in stock appears in this box. You can use the OB option to enter the opening balance for the product.
Free Stock The Free Stock is the In Stock total minus the Allocated stock total.
Re-order Level

Specify the stock quantity that triggers a new order. If the stock falls below this figure, the product appears in red in the Products window and appears on the Re-Order Levels and Shortfall reports.
Allocated The quantity of stock allocated to Sales Orders and Project records appears in this box.
On Order The quantity of stock on order on Purchase Orders appears in this box.
Re-order Qty Enter the quantity of stock that you'd normally re-order. When you raise a purchase order for this product, the quantity you enter here appears automatically, but can be overwritten if required.

Ordering

Last Cost Price (Standard) This is the latest cost price for the product, taken from the last entry made when purchasing or recording adjustments. 

This calculation does not include discounts.
Last Cost Price (Discounted) Sage 50 Accounts Professional only
This is the discounted cost price for the product item, taken from the last entry made.
Last Ord Qty Sage 50 Accounts Professional only
This is the quantity of the last purchase order raised for this product, after it's placed on order.
Last Ord Date Sage 50 Accounts Professional only
This is the date of the last purchase order raised for this product, after it's placed on order.

Sales Price

Price This is the net sales price of the product, used for sales orders, product invoices and credit notes.
Unit of Sale You can use up to eight characters to describe the unit of sale, for example, Each, Boxes, Kilograms, Hours. Used for reference only but you can add it to reports if necessary.
Pricing Structure Sage 50 Accounts Plus and above only

If you need to create a special price for this product, click Pricing Structure then complete, as required.

Stock Take

Date The date of your last stock take. This date updates when you post a stock take using the Stock Take option.
Quantity The stock quantity of this product at your last stock take. This quantity is for information only and doesn't affect your In Stock quantity. This quantity updates when you post a stock take using the Stock Take option.

Upgrading your licence

Need a little more room? To add extra companies, users, employees or more to your software licence, leave your details and we'll be in touch.

Leave your details

Image