Supplier Item

The following program description deals with:

Remarks on the Program Function

By use of this program the items defined in the system can be assigned to a supplier. They can be added, changed or deleted in the system. The assignment is carried out using a supplier item number.

During the assignment of the item, other information can be specified, e.g. any minimum order quantity, fixed and variable costs, delivery time, etc..


Remarks on the Input Fields

This paragraph will provide a short overview over the options available for updating these Basic Data.

Just like in almost any other program:


Company

Permitted input range: numeric, 1 - 9999

Enter the number of the company under which the supplier items are stored in the system.

If you do not know the number, you can also select the data record via the Search Function.


Supplier no.

Permitted input range: numeric, 1 - 999999

Enter the number of the supplier who delivers the items.

If you do not know the number, you can also select the data record via the Search Function.

The maintenance of this supplier and his supplier number is carried out using the program Supplier.


SAN

Permitted input range: alphanumeric, max. 14 pos.

To create a new record, enter the number for the item which is used for ordering the item from the supplier. This number has to be unique.

For changes or deletions, the item is to be retrieved by entering its item number or supplier item number. If you do not know the number, you can also select the data record via the Search Function.


Item

Permitted input range: decimal, max. 14 digits with no decimal places

Enter the number of the item with which the item is created in the system. If you do not know the number, you can also select the data record via the Search Function.

The maintenance of the items and their numbers is carried out in the program Item.


Descriptor

Permitted input range: alphanumeric, max. 20 characters

The description of the item is arbitrary.


Price unit *

Permitted input range: numeric, 1 - 999

Enter the price ID for the order unit which is shown after field Minimum order quantity.

The price unit is updated with program Quantity unit.


Package unit *

Permitted input range: numeric, 1 - 99

Enter the number of the package unit. If you do not know the number, you can also select the data record via the Search Function.

The maintenance of the package units is carried out using the program Quantity Units.


Minimum per order

Permitted input range: decimal, max. 13 digits including max. 3 decimal places

This is the minimum quantity to be ordered from the supplier. The value entered under minimum order quantity is multiplied by the Price in window Price; the result is the order costs for the item.

This parameter is influenced directly by program Stock item, by the values in fields Minimum and Maximum, and by the program Item where the order type is defined in the lower window Stock.

Example "Order suggestion by maximum":
In program Stock item the value 50 is entered in field Minimum and 100 is entered in field Maximum. This item has a current stock of 80 in program Stock item status. In program Item -> Stock the order type "Order by max." is defined, i.e. with an order suggestion the stock should be filled up to the maximum. As a value of 30 has been defined in field Min.order quantity this item will not be included in an order suggestion.

Example "Order suggestion by minimum":
In program Stock item the value 50 is entered in field Minimum and 100 is entered in field Maximum. This item has a current stock of 80 in program Stock item status. In program Item -> Stock the order type "Order by max." is defined, i.e. with an order suggestion the stock should be filled up to the maximum. As a value of 30 has been defined in field Min.order quantity this item will not be included in an order suggestion.
The item will only be ordered when a quantity of 70 or lower is reached, i.e. the order type has priority in view of the defined minimum order quantity.


Fixed costs

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

Enter the fixed amount the supplier charges for delivering this item (e.g. postage, minimum freight).


Variable costs

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

Enter any variable costs related to the delivery of this item.


% Shrinkage

Permitted input range: decimal, max. 5 digits including max. 2 decimal places

This is the shrinkage factor in percent.


Deliv. Day

Permitted input range: numeric, 0 - 999

This is the average delivery time in number of days for the item.


Durability in days

Permitted input range: numeric, 0 - 999

This is the average shelf life of the item in number of days.


Preferred item group

Button activated : The item belongs to a preferred group of items

Button deactivated : The item does not belong to any groups of preferred item..


Discontinued item

Button activated: Item is no longer available from supplier


Price

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

Enter the actual cost price for the order unit of the item.


New price

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

If the cost price of the item is to be changed, the new cost price is to be entered here. In the next Field, the date from which this price is valid is to be entered.


Promotion price

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

If a promotion price is offered by the supplier for the item, enter the amount into this field. The period of time for which the price is valid is entered into the next 2 fields.


% rate calc.CP

Entry range permitted: decimal, max. 3 digits incl. max. 2 decimal places

A percentage should be entered in the field to allow for calculation of "Calc.CPs". When goods received is confirmed the system checks how the cost price is to be calculated.

Note:
For normal sales items the calc.CO is calculated on the basis of the various cost prices and their quantities. This method cannot be used for media articles (newspapers, etc.) or articles without a cost price (press or film) because the CP is not known in the branches and delivery, return delivery and sale of press articles are recorded under one item no.. The branch enters the RPmanually in the delivery note for delivery and return delivery.

 

Check:

Example:


Foreign Currency Price

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

Enter the price in foreign currency if this item is to be ordered from a supplier who uses foreign currency as payment type.


Recommended price

Permitted input range: decimal, max. 11 digits including max. 3 decimal places

This field is not used at the moment.


Date for new price

Permitted input range: DDMMYYYY (day, month, year)

Enter the date from which the new purchase price entered in the Previous Field is valid.


From date

Permitted input range: DDMMYYYY (day, month, year)

Enter the date from which the promotion price entered in the Previous Field is valid.


To date

Permitted input range: DDMMYYYY (day, month, year)

Enter the date up to which the promotion price entered in the Previous Field is valid.


First order date

Permitted input range: DDMMYYYY (day, month, year)

The date of the first order for this item is stored in this field.


Last order date

Permitted input range: DDMMYYYY (day, month, year)

The date of the last order for this item is stored in this field.


Perc. disc/quantity

Permitted input range: numeric, 1 - 99

If the supplier offers a percent discount based on quantity, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Disc. percent/palue

Permitted input range: numeric, 1 - 99

If the supplier offers a percent discount based on value, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Disc. /quantity

Permitted input range: numeric, 1 - 99

If the supplier offers a value discount based on quantity, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Disc. value/value

Permitted input range: numeric, 1 - 99

If the supplier offers a value discount based on value, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Disc. kind/quantity

Permitted input range: numeric, 1 - 99

If the supplier offers a discount in kind based on quantity, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Disc. kind/value

Permitted input range: numeric, 1 - 99

If the supplier offers a discount in kind based on value, enter the number of the appropriate discount table. If you do not know the number, you can also select the data record via the Search Function.

This discount table is maintained using the corresponding Update Program where the discount which is applied commonly to all the items from this supplier is defined . Note that a discount defined specifically for an item has always priority over a common discount for all items of the supplier.


Button: Suppl. Order create List

With this button, a report program is initiated where a list of items used to prepare an order from a supplier can be produced. When the program is called, a dialog window is opened where different selection fields are displayed and prompted to produce the report. This type of order is only produced for standing orders.

The data for this type of orders originates from the program Stock Item (minimum/maximum).

The following fields are listed on the screen:

The report is initiated by pressing button Screen or Printer.


Index


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin