コンテンツにスキップ

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

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 Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
名称NameString✔Alphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record
ベース価格表BasePriceList_IDTablePricelist to be used, if product not found on this pricelist
デフォルトIsDefaultYes-No✔Default value
通貨C_Currency_IDTable Direct✔The Currency for this record
価格精度PricePrecisionInteger✔Precision (number of decimals) for the Price
販売用価格表IsSOPriceListYes-No✔This is a Sales Price List
税込IsTaxIncludedYes-No✔Tax is included in the price
限度価格チェックEnforcePriceLimitYes-No✔Do not allow prices below the limit price
有効IsActiveYes-No✔The 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 Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
価格表M_PriceList_IDTable Direct✔Unique identifier of a Price List
名称NameString✔Alphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record
有効IsActiveYes-No✔The record is active in the system
プライスリストスキーマM_DiscountSchema_IDTable✔プライスリスト計算のためのスキーマ
ベース価格表M_Pricelist_Version_Base_IDTableSource for Price list calculations
有効開始日ValidFromDate✔Valid 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 Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
価格表バージョンM_PriceList_Version_IDTable Direct✔Identifies a unique instance of a Price List
品目M_Product_IDSearch✔Product, Service, Item
有効IsActiveYes-No✔The record is active in the system
営業定価PriceListCosts+Prices✔List Price
実績価格PriceStdCosts+Prices✔Standard Price
限度価格PriceLimitCosts+Prices✔Lowest price for a product

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

Section titled “取引先別分岐価格設定 タブのフィールド”
フィールドカラム型必須説明
クライアントAD_Client_IDTable Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
価格表バージョンM_PriceList_Version_IDTable Direct✔Identifies a unique instance of a Price List
品目M_Product_IDSearch✔Product, Service, Item
取引先C_BPartner_IDSearchIdentifies a Business Partner
分岐値BreakValueNumber✔Low Value of trade discount break level
有効IsActiveYes-No✔The record is active in the system
営業定価PriceListCosts+Prices✔List Price
実績価格PriceStdCosts+Prices✔Standard Price
限度価格PriceLimitCosts+Prices✔Lowest price for a product
フィールドカラム型必須説明
クライアントAD_Client_IDTable Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
価格表バージョンM_PriceList_Version_IDSearch✔Identifies a unique instance of a Price List
言語AD_LanguageTable✔Language for this entity
有効IsActiveYes-No✔The record is active in the system
翻訳するIsTranslatedYes-No✔This column is translated
名称NameString✔Alphanumeric identifier of the entity
フィールドカラム型必須説明
クライアントAD_Client_IDTable Direct✔Tenant for this installation.
組織AD_Org_IDTable Direct✔Organizational entity within tenant
価格表M_PriceList_IDSearch✔Unique identifier of a Price List
言語AD_LanguageTable✔Language for this entity
有効IsActiveYes-No✔The record is active in the system
翻訳するIsTranslatedYes-No✔This column is translated
名称NameString✔Alphanumeric identifier of the entity
説明DescriptionStringOptional short description of the record