Import Buy-from BP Files (tppdm7260m000)

Use this session to read and/or print the contents of supplier files. Buy-from business partners can send files to give you information on prices and discounts. This session is used to read the data that is stored in the file.

Recording codesBecause the buy-from business partner's item codes and unit codes can differ from your own codes, you must define the relationship between both codes through the sessions:

Items by Buy-from BP (tppdm7150s000)
Units by Buy-from BP (tppdm7156m000)

Reading filesTo read a file, LN must know the following:

The structure of the data in the file
The method used for recording discounts

You can enter this data by buy-from business partner through the File Layouts by Buy-from BP (tppdm7151s000) session. However, you can also enter them directly in the relevant fields by using this session. First, you copy the file with prices to a directory on the system where LN is running. When you select the Import option, LN displays a dialogue box to allow the user to indicate where the file can be found. For each buy-from business partner you can define default values for this session through the File Layouts by Buy-from BP (tppdm7151s000) session.

Field Information

Buy-from Business Partner: The code that identifies the buy-from business partner.
Buy-from Business Partner: The description or name of the code.
Path File Name: The directory into which the supplier file has been copied.
File Name: The name of the file that contains a supplier's price details.

Start Time

The date on which the prices in the file become effective.

Expiry Time

The date on which the prices in the file cease to be effective. The value 0 [zero] indicates that the prices remain valid indefinitely.

Import/Print

Select the appropriate option.

Print: Print the data from the file.
Import: Read in the data from the file and save the price lists by supplier and item in the price books.
Import and Print: Print and read in the data from the file, and save the price lists by supplier and item in the price books.

Price Division Factor

The factor by which the price must be divided to convert the supplier's price unit to your price unit. When reading in files in this session, LN divides all prices in a file by this factor.

This factor is used in addition to:

The factor that you can record by supplier unit in the Units by Buy-from BP (tppdm7156m000) session
The factor that you can enter for net prices in this session.

Field Positioning

The positioning of fields determines how data is stored in a file.

Fixed Positions: Data is stored in fixed positions in the file. LN identifies the positions by means of a start position and the length of the data.
Separator: The start and end positions of the data in the file are indicated by a separator sign, a delimiter (that is a character or sequence of characters marking the beginning or end of a unit of data). The positions of data are stored using sequence numbers.

Separator Sign

The separator sign that marks the separation of data in a file. This is usually an alphanumeric character.

This field is available only if Field Positioning is set to Separator.

Discount Method

The method used to determine the net price.

Net Price

The net price is stored in the file.

To avoid unauthorized users from viewing the information, the buy-from business partner can send a letter that contains the factor by which the net price must be multiplied, in order to determine the actual net price.

Discount Groups

The net price is determined based on the gross price and on the following discounts recorded for the discount group:

Company discount
Group discount
Quantity discount

To avoid unauthorized users from viewing the information, the buy-from business partner can send a letter that contains the discounts.

Price Book: The price book that must be used to store pricing information.
Discount Schedule Series: The discount schedule series that must be used to store pricing information.

Item: This check box is always selected, meaning that the item is always included in the file data.
Item: The sequence number that indicates the position of the item code in relation to the other data in the file.
Item: The start position of the item in the file.
Item: The number of characters of the item code in the file.
Item Description: If this check box is selected, an item description is included in the file.
Item Description: The sequence number that indicates the position of the item description in relation to the other data in the file.
Item Description: The start position of the item description in the file.
Item Description: The number of characters of the item description.
Buy-from's Unit Code: If this check box is selected, the buy-from's unit code is included in the file.
Buy-from's Unit Code: The sequence number that indicates the position of the supplier's unit code in relation to the other data in the file.
Buy-from's Unit Code: The start position of the buy-from supplier's unit code.
Buy-from's Unit Code: The number of characters of the buy-from supplier's unit code.
Gross Price: If this check box is selected, the gross price in the file must be read. This check box is always selected, meaning that the item is always included in the file data.
Gross Price: The sequence number that indicates the position of the gross amount in relation to the other data in the file.
Gross Price: The start position of the Gross Price field.
Gross Price: The number of characters of the Gross Price field.
Net Price: If this check box is selected, the net amount is included in the file.
Net Price: The sequence number that indicates the position of the net amount in relation to the other data in the file.
Net Price: The start position of the Net Price field in the file.
Net Price: The number of characters of the Net Price field.
Net Price: The factor by which the net price in the file must be divided to calculate the actual net price. This factor is determined by the buy-from business partner.
Discount Group: If this check box is selected, the discount group is included in the file.
Discount Group: The sequence number that indicates the position of the discount group in relation to the other data in the file.
Discount Group: The start position of the Discount Group field in the file.
Discount Group: The number of characters of the Discount Group field.
Text: If this check box is selected, a text is included in the file.
Text: The sequence number that indicates the position of the text in relation to the other data in the file.
Text: The start position of the text in the file.
Text: The number of characters of the Text field.

Automatic Item Generation: If this check box is selected, LN generates items based on the information in the business partner file and the selected item group defaults.
Item Group: The item group for which the item group defaults are used while generating the item.
Overwrite: If this check box is selected, LN overwrites the existing data.