Supplier Prices import
/erp/data-import/item-supplierserp-procurement-item-suppliers.view (görme, kontrol) · .import + .create + .edit (aktarma)Item × supplier: the supplier's item code, purchase price and unit, minimum order, lead time, main supplier and
block. Items and suppliers are loaded first. A record is matched by UrunKodu + TedarikciKodu; a record not in
the file is not deleted. The price proposal on a purchase order comes from this record; it can also be the basis of
the opening valuation after the opening stock.
Workbook sheets
| Sheet | Matching (record key) | What it writes |
|---|---|---|
| Tedarikçi Fiyatları (Supplier Prices) | UrunKodu + TedarikciKodu | Item–supplier records. Created if it does not exist, updated if it does; a record not in the file is not deleted. |
Columns
The tables are generated from the same source as the system's Alan Kılavuzu (Field Guide) tab. If a column with
Required: Yes is left empty, the row becomes Hatalı (Invalid). All cells are read as text; Evet/Hayır
(Yes/No) columns accept no other value, and in a column with a list of allowed values the spelling must match the
list.
Tedarikçi Fiyatları (Supplier Prices)
Item–supplier records. Created if it does not exist, updated if it does; a record not in the file is not deleted.
Matching: UrunKodu + TedarikciKodu.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
UrunKodu | Yes | An active, purchasable item. | HM-00277 |
UrunAdi | No | Information — not read. | |
TedarikciKodu | Yes | An active business partner with the supplier role. | T-00029 |
TedarikciUnvan | No | Information — not read. | |
TedarikciUrunKodu | No | The code the supplier gives this item. | |
TedarikciUrunAdi | No | The supplier's item description. | |
BirimFiyat | No | Purchase price — together with the currency and price unit. Empty = no price. | 100 |
ParaBirimi | No | Three-letter code (TRY, USD, EUR). | TRY |
FiyatBirimi | No | The price unit: the item's unit or a convertible unit. | M |
MinSiparisMiktari | No | Minimum order quantity, in the item's base unit. | |
TedarikSuresiGun | No | Lead time, whole days. | |
AnaTedarikci | No | Evet (Yes) = the item's main supplier (the previous one's flag is removed). Empty = Hayır (No). | Evet · Hayır |
GecerlilikBaslangici | No | The first day the price is valid (dd.mm.yyyy). | |
GecerlilikBitisi | No | The last day the price is valid. | |
Not | No | Free-text note. | |
Bloke | No | Evet (Yes) = blocked in the source list (no orders are placed with this supplier). Empty = Hayır (No). | Evet · Hayır |
BlokeGerekcesi | No | Required if blocked. |
In the demo package
09-tedarikci-fiyatlari.xlsx: main and alternative suppliers, lead time, minimum order; KUTU (box) price for
screws/rivets; one blocked record. Kontrol Et (Validate) in the demo installation: 159 rows · Hatalı (Invalid) 0
(1 Güncellenecek (To be updated) — the record was changed on the screen after the package was loaded).
Common errors
The messages are the same as the text in the system's Kontrol sonucu (Validation result) table (… is the
variable part).
| Message | Cause and solution |
|---|---|
| UrunKodu ve TedarikciKodu zorunlu. (UrunKodu and TedarikciKodu are required.) | Fill in both key columns. |
| '…' ürünü bulunamadı. (Item '…' was not found.) | Import the item first, or correct the code. |
| '…' iş ortağı bulunamadı. (Business partner '…' was not found.) | Import the supplier record first. |
| TedarikSuresiGun '…' tam gün olmalı. (TedarikSuresiGun '…' must be whole days.) | Enter a whole number (not a decimal). |