Quantum VS Help: File Maintenance

Previous  Next  

Creating A Supplier Pricing Record

Supplier Pricing records are used for recording and applying the buying costs/terms a Supplier charges for a product or group of products. If the Supplier offers discounts based on ordering a certain quantity, weight or value of the product you may define a breaks table to record the discounts available.

 

Note: For further details - including Enabling Supplier Pricing - see Supplier Pricing Maintenance.

 

To create a Supplier Pricing record:

 

1.      Do one of the following:

 

A new Supplier Pricing record will open in a new tab:

 

FileM_SupplierPricingNew.gif

 

2.      Enter/select details for the Supplier Pricing record, using the following as a guide:

 

Note: You may use your [Tab] key to move from one field to the next.

Field

Definition (* = mandatory field)

 

Supplier *

 

Select the Supplier for which this Supplier Pricing record will apply, then click [Tab].

 

If you know the Supplier's Account Number (e.g. AB/0000125) or Short Name (e.g. Absolute), type it into the Supplier field.

 

If you don't know the Supplier's Account Number or Short Name, use the Finder to locate and select it. To do this:

 

For further details on using the Finder to locate and select a Supplier record see Finding Suppliers.

 

Address / Town / County / Post Code / Country

 

These read-only fields will display the Supplier's details after entering the Supplier's Account code (see above).

 

Price Type *

 

For the selected Supplier you may set up price breaks for a single Product, or for a group of Products (defined by Product Group, Price Group or Analysis Code etc.).

 

Select the required Supplier price break type from the following options:

  • Product (1): Create price breaks for a defined Supplier and Product

  • Product Group (2): Create price breaks for a defined Supplier and Product Group

  • Product Major Group (3): Create price breaks for a defined Supplier and Product Major Group

  • Price Group (4): Create price breaks for a defined Supplier and Price Group

  • Analysis Code 1 (5): Create price breaks for a defined Supplier and Analysis Code 1

  • Analysis Code 2 (6): Create price breaks for a defined Supplier and Analysis Code 2

  • Analysis Code 3 (7): Create price breaks for a defined Supplier and Analysis Code 3

Product /  Product Group / Product Major Group / Price Group / Analysis Code  *

 

Depending on the selected Price Type (see above), enter/select the Product, Product Group, Product Major Group, Price Group or Analysis Code to which the Supplier price breaks will apply.

 

For example, if you selected the Price Type 'Product', enter/select the Product Code in the Product field.

 

If you don't know the Product Code you may enter it automatically using the Finder. To do this:

  • place your cursor in the From/To field;

  • click [F3] to make Products active in the Finder;

  • in the Finder, locate the product you wish to add (see Finding Products); then

  • double-click on the product line in the Finder to add the Product Code.

 

Alternatively, if you selected the Price Type 'Product Group', 'Product Major Group', 'Price Group' or 'Analysis Code 1, 2 or 3', select the required option from the available drop-down menu in the Product Group, Product Major Group, Price Group or Analysis Code field.

 

Note: Values are maintained in the following Table Files: Product Group = P; Product Major Group = PMAJ; Price Group = PRI; Analysis Code 1 = PA1; Analysis Code 2 = PA2; Analysis Code 3 = PA3. See Table File Maintenance.

Branch *

 

Select the Branch to which the Supplier Pricing record applies. This may be All Branches (0) or a specific Branch.

 

Start Date / End Date

 

Use these fields to set a date range for the Supplier Pricing record, if applicable.

 

For example, if the Supplier Pricing record applies only from or to a certain date, or between two dates, click the Start Date and/or End Date field and enter/select the required date.

 

Currency

 

Use the drop-down menu to select the currency for the Supplier Pricing record.

 

Note: Currency menu values are maintained in the Table File CURR. See Table File Maintenance.

Use Cost

 

This section defines how buying costs/prices will be applied when the product is purchased.

 

Note: Options are subject to the selected Price Type (see above). Use Cost options 1, 2 and 3 apply only when Price Type 'Product' is selected.

 

The following options are available:

  • This Supplier Pricing Record (1): Product costs will be the Supplier's Base Cost (including additional discounts offered by the Supplier) according to the quantity, weight or value of the product being purchased. You must enter these values in a multi-line break table below.

  • This Supplier Pricing Record Band 1 (2): Product costs will be the Supplier's Base Cost, as entered in the Base Cost field on line 1 of the break table below.

  • Standard Cost Of Product (3): Product costs will be the Standard Cost of the Product, as defined in the Product record.

  • Product Code Band 1 (4): Product costs will be the Buying Cost of the Product, as defined in the Product record.

Note: If you select Use Cost options 3 or 4, the Base Cost in the break table below is entered automatically. When amending the Use Cost to type 3 or 4 on a Supplier Pricing record with a multi-line break table, the Base Cost on each line will be replaced with the product's Standard or Buying Cost.

Order Type *

Select the Purchase Order Type this Supplier Pricing record will apply to, from the following options:

  • Stock POs (1)

  • Direct POs (2)

  • Stock and Direct POs (3)

For example, when Purchase Ordering a Product from a Supplier to which this Supplier Pricing record applies, its prices will be applied to Stock Purchase Orders only, Direct Purchase Orders only, or both types.

 

Settlement Discount

 

If the supplier offers a settlement discount, enter it here. This is a discount offered by some Suppliers for settling payment within a certain time period, for example, and/or fulfilling certain settlement criteria.

 

Break Type

 

Select:

  • Break Quantity: to apply prices/buying costs based on the quantity ordered; or

  • Break Value: to apply prices/buying costs based on the value ordered;

  • Break Weight: to apply prices/buying costs based on the weight ordered;

as defined by the break table.

 

Lead Time

 

Enter the time in days that it takes for the Supplier to deliver goods ordered.

 

Absolute

 

Check this field if you wish to force the system to use the price for this product and supplier combination as defined by this record, regardless of whether it is the 'best' price that Quantum VS can calculate.

 

 

Note: * = mandatory field

 

3.      In the lower section, enter/select buying costs and other details for the Product/Supplier combination.

 

If you selected Use Cost type 3 or 4:

Enter details on Index line 1 only (i.e. you will not be setting up quantity/value/weight breaks). Enter the High Value and select the UOM (Unit of Measure). The Base Cost and Buying Cost are entered automatically.

 

If you selected Use Cost type 2:

Enter details on Index line 1 only (i.e. you will not be setting up quantity/value/weight breaks). Enter the High Value and select the UOM (Unit of Measure). Then enter the Supplier's Base Cost, plus any additional discounts, as described below.

 

If you selected Use Cost type 1:

You will not be entering quantity/value/weight break values on Index line 1, 2, 3 etc. Use as many Index lines as required, up to a maximum of 12. For each line of the breaks table, enter a High Value and select the UOM (Unit of Measure). Then enter the Supplier's Base Cost, plus any additional discounts, as described below.

 

Entering The High Value

 

FileM_SupplierPricingHVUOM.gif

 

Selecting The Unit Of Measure (UOM)

On Index line 1, select the applicable Unit of Measure (e.g. Each, Box, Hundred, Metre, Square Metre) using the drop-down menu in the UOM field.

 

The UOM on subsequent lines - if you are creating a multi-line breaks table - defaults to the UOM for Index line 1, but you may select an alternative as required.

 

Entering The Base Cost - And Supplier Discounts

 

To enter the Base Cost (for the current Index line):

 

FileM_SupplierPricingBaseCost.gif

 

The derived Buying Cost is displayed (read-only) when you add these details.

 

For examples see Entering Supplier Buying Terms.

 

Setting Up Break Discounts (Use Cost Type 1 Only)

If the Supplier offers discounts based on the quantity, weight or value of the product being purchased, define a breaks table by entering cost details on Index line 1, 2, and so on, using as many lines as required. To do this:

 

 

FileM_SupplierPricingBreakTable.gif

 

In the example above we have chosen to apply prices/buying costs for this Supplier/Product combination based on the quantity ordered. So if we order:

 

4.      When you have finished entering details for the chosen Supplier/Product combination, click Save on the Toolbar - Sub Menu to save the Supplier Pricing record.

 

You may set up further Supplier Pricing records as necessary.

 

Note: Saved Supplier Pricing records will display in the Finder. See Finding Supplier Pricing Records.

 

NEXT: Editing A Supplier Pricing Record