Skip to main content

Next Generation - Set up Purchasing Prices for a stock record

A guide to setting up purchase prices on the Prices tab of a stock record, with a description of each available field on the Stock Prices - Purchase popup window.

You can set up to 10 purchasing prices on the Prices tab on your stock records. When creating a new stock record, the Prices tab is not visible. You must save the stock record first before you can set up prices.

You can access the Price tab on a stock record in view mode. To add or edit prices, you need to set the relevant stock record into edit mode. You will need to scroll down on the Prices tab to the Purchase Price section.

Set up a purchasing price for an existing stock record

  1. Click Stock then click Stock Records.
    Note: All stock records are displayed. You can narrow down your search using advanced filters. You can also search on the columns directly by pointing the mouse to the name of the column and click on the

    image.png

    icon and choose from the available filter list, then click OK.

  2. In the Stock Code column, click the hyperlink, the underlined text.
    Note: The Action Panel automatically opens from the right-hand-side of the screen. You can close the panel by clicking on the arrow

    image.png

    icon on the right-hand side middle of the screen.

  3. Click on the Edit button at the bottom of the screen to set the record into edit mode.

  4. Click on the Prices tab.
    Note: There are several default columns that are displayed for you. You can change these by clicking on the cog icon and selecting the Configure Columns option.

  5. Scroll to the Purchase Prices section, click on the relevant price key hyperlink (PRICE KEY 1, PRICE KEY 2, etc.) to open the Stock Price - Purchase popup window where you can add your price.

Note: Some fields are disabled by default, such as Stock Code on the Stock Prices - Purchase popup window.

You can customise the Price Key labels for both sales and purchase prices, and if this have been done on your database, the labels will be different. For more information on how to customise the Price Key labels, please refer to our Customise the Price Key labels for your stock items article.

Please refer to the table below for more information on the displayed fields on the Stock Prices - Purchase popup window

Field

Description

Price

  • Defaults to the currency of your database.

  • Is calculated automatically when your home price is zero and you enter or change the currency price, then the calculation will be currency price divided by the currency exchange rate.

Currency

  • Defaults to the same currency as your database.

  • Can be changed manually either by typing in the currency code or selecting from the drop-down or the Show More options.

Currency Price

  • Only displayed when you have selected a foreign currency.

  • Is calculated automatically when your currency price is zero and you enter or change the home price, then the calculation will be the home price x currency exchange rate.

Type

  • Defaults to Purchase as it is a purchase price type.

Purchase Analysis

  • Defaults to the default purchase analysis for the selected currency and you can change it to any purchase analysis for your selected currency.

Supplier Account

  • Defaults to blank and you can select your preferred supplier for the stock record.

  • Note: When you select a supplier whose currency is different to your database's currency, you will have to manually change the Purchase Analysis should you wish to match up the currencies.

Supplier Stock Code

  • Alphanumeric field which allows you to enter the stock code given by your supplier to your stock record as it could be different from your stock code.

    • Example:

      • Your stock code is 'WIDGET-001' but your supplier refers to it as 'WDG-A-001' in their system.

Method

Buy Unit

  • Defaults to 1.00 and can be changed.

  • The Buy Unit is a multiplier and helps in situations where you may want to purchase packaged stock records.

Unit Description

  • Defaults to "Each" and can be changed.

  • Allows up to 20 alphanumeric characters.

Quantity Range From

  • Defaults to zero and allows you to set quantity range from value.

  • Only displayed when the following price methods are selected:

    • Quantity

    • Quantity Uplift %

    • Quantity Deduct %

Quantity Range To

  • Defaults to zero and allows you to set a quantity range to value

  • Only displayed when the following price methods are selected:

    • Quantity

    • Quantity Uplift %

    • Quantity Deduct %

Percentage

  • Defaults to zero.

  • Only displayed when the following price methods are selected:

    • Quantity Uplift %

    • Quantity Deduct %

    • Uplift %

    • Deduct %

Did this answer your question?