Skip to content

価格表(Price List)|iDempiere 13 画面リファレンス

This content is not available in your language yet.

iDempiere 13 標準ウィンドウ(AD_Window_ID: 146)

メニュー: 在庫管理 ▸ 品目マスタ管理 ▸ 価格表

Maintain Product Price Lists

The Price List Window allows you to generate product price lists for your Business Partners. Price lists determine currency and tax treatment. Price list versions allow to maintain parallel lists for different date ranges. The most current pricelist version is used based on the document date.
All pricelists have three prices: List, Standard and Limit
First step is to create a base price list. You can manually add products and enter the prices or create them automatically. The base price list is often the purchase price list with list price (‘official’ retail price), the standard price (your purchase price). The limit price can be used to check your final purchase costs after discounts, rebates, etc.
Pricelists can be calculated and copied. To speed up the calculation, the parameters are stored an used when creating a new price list version.

#タブテーブル階層説明
10価格表M_PriceList0Define Price Lists
20バージョンM_PriceList_Version1Maintain price list versions
30品目価格M_ProductPrice2Maintain Product Prices
40取引先別分岐価格設定M_ProductPriceVendorBreak2
50翻訳M_PriceList_Version_Trl2
60翻訳M_PriceList_Trl1

Price lists determine currency of the document as well as tax treatment.

フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
名称NameStringAlphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record
ベース価格表BasePriceList_IDTablePricelist to be used, if product not found on this pricelist
デフォルトIsDefaultYes-NoDefault value
通貨C_Currency_IDTable DirectThe Currency for this record
価格精度PricePrecisionIntegerPrecision (number of decimals) for the Price
販売用価格表IsSOPriceListYes-NoThis is a Sales Price List
税込IsTaxIncludedYes-NoTax is included in the price
限度価格チェックEnforcePriceLimitYes-NoDo not allow prices below the limit price
有効IsActiveYes-NoThe record is active in the system

Price lists are automatically created based on Product Purchasing Information and the Vendor Category Discount. The other alternative is to copy them from existing pricelists and the re-calculate them. You can also re-calculate the pricelist by referencing no pricelist or referencing the same pricelist. If no base price list is selected, the Procuct Purchase records are used as reference.

フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
価格表M_PriceList_IDTable DirectUnique identifier of a Price List
名称NameStringAlphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record
有効IsActiveYes-NoThe record is active in the system
プライスリストスキーマM_DiscountSchema_IDTableプライスリスト計算のためのスキーマ
ベース価格表M_Pricelist_Version_Base_IDTableSource for Price list calculations
有効開始日ValidFromDateValid from including this date (first day)
品目価格自動作成ProcCreateButton品目価格を自動作成します。

The Price List Tab displays the prices for a product based on the selected price list.

フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
価格表バージョンM_PriceList_Version_IDTable DirectIdentifies a unique instance of a Price List
品目M_Product_IDSearchProduct, Service, Item
有効IsActiveYes-NoThe record is active in the system
営業定価PriceListCosts+PricesList Price
実績価格PriceStdCosts+PricesStandard Price
限度価格PriceLimitCosts+PricesLowest price for a product

取引先別分岐価格設定 タブのフィールド

Section titled “取引先別分岐価格設定 タブのフィールド”
フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
価格表バージョンM_PriceList_Version_IDTable DirectIdentifies a unique instance of a Price List
品目M_Product_IDSearchProduct, Service, Item
取引先C_BPartner_IDSearchIdentifies a Business Partner
分岐値BreakValueNumberLow Value of trade discount break level
有効IsActiveYes-NoThe record is active in the system
営業定価PriceListCosts+PricesList Price
実績価格PriceStdCosts+PricesStandard Price
限度価格PriceLimitCosts+PricesLowest price for a product
フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
価格表バージョンM_PriceList_Version_IDSearchIdentifies a unique instance of a Price List
言語AD_LanguageTableLanguage for this entity
有効IsActiveYes-NoThe record is active in the system
翻訳するIsTranslatedYes-NoThis column is translated
名称NameStringAlphanumeric identifier of the entity
フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
価格表M_PriceList_IDSearchUnique identifier of a Price List
言語AD_LanguageTableLanguage for this entity
有効IsActiveYes-NoThe record is active in the system
翻訳するIsTranslatedYes-NoThis column is translated
名称NameStringAlphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record