价目表 (窗口 ID-146)

来自iDempiere zh
跳转至:导航搜索



窗口: 价目表

描述: 维护产品价目表

幫助: 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.



TAB: 价目表

描述: 定义价目表


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


File:价目表 - 价目表 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Name 名称 Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description 描述 该记录的可选描述 描述最多为 255 个字符。 Description
character varying(255)
String
Active 有效 本记录有效 There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Default 缺省值 缺省值 The Default Checkbox indicates if this record will be used as a default value. IsDefault
character(1) NOT NULL
Yes-No
Currency 货币 币种为该笔记录 Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10) NOT NULL
Table Direct
Price Precision Price Precision Precision (number of decimals) for the Price The prices of the price list are rounded to the precision entered. This allows to have prices with below currency precision, e.g. $0.005. Enter the number of decimals or -1 for no rounding. PricePrecision
numeric(10) NOT NULL
Integer
Sales Price list 销售价目表 这是销售价目表 The Sales Price List check box indicates if this price list is used for sales transactions. IsSOPriceList
character(1) NOT NULL
Yes-No
Price includes Tax 价格包括税 价格已包含税 The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price. IsTaxIncluded
character(1) NOT NULL
Yes-No
Enforce price limit 强制价格限制 Do not allow prices below the limit price The Enforce Price Limit check box indicates that prices cannot be below the limit price in Orders. Invoices are not checked. EnforcePriceLimit
character(1) NOT NULL
Yes-No




TAB: 版本

描述: 维护价目表版本


幫助 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.


File:价目表 - 版本 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Price List Version 价目表版本 Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID
numeric(10) NOT NULL
ID
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Price List 价目表 Unique identifier of a Price List Price Lists are used to determine the pricing, margin and cost of items purchased or sold. M_PriceList_ID
numeric(10) NOT NULL
Table Direct
Name 名称 Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description 描述 该记录的可选描述 描述最多为 255 个字符。 Description
character varying(255)
String
Active 有效 本记录有效 There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Price List Schema 打折模式 Schema to calculate the trade discount percentage After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. M_DiscountSchema_ID
numeric(10) NOT NULL
Table
Base Price List 基本价格列表 Source for Price list calculations The Base Price List identifies the Base Pricelist used for calculating prices (the source) M_Pricelist_Version_Base_ID
numeric(10)
Table
Valid from 开始有效 Valid from including this date (first day) The Valid From date indicates the first day of a date range ValidFrom
timestamp without time zone NOT NULL
Date
Create Price List 产生价格目录 基于这个版本的叁数价格创建价格 Create Prices for this pricelist version in the sequence of the Discount Schema Price List.

Lines with a higher sequence overwrite existing prices. The sequence should be from generic to specific.

ProcCreate
character(1)
Button




TAB: 产品价格

描述: 维护产品价格


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


File:价目表 - 产品价格 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Price List Version 价目表版本 Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID
numeric(10) NOT NULL
Table Direct
Product 产品 Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10) NOT NULL
Search
Active 有效 本记录有效 There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
List Price 公开报价 公开报价 The List Price is the official List Price in the document currency. PriceList
numeric NOT NULL
Costs+Prices
Standard Price 标准价格 标准价格 The Standard Price indicates the standard or normal price for a product on this price list PriceStd
numeric NOT NULL
Costs+Prices
Limit Price 限制价格 产品的最低价格 The Price Limit indicates the lowest price for a product stated in the Price List Currency. PriceLimit
numeric NOT NULL
Costs+Prices




TAB: Product Price Break

描述: null


幫助 null


File:价目表 - Product Price Break - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization 机构 客户内的机构实体。 An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Price List Version 价目表版本 Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID
numeric(10) NOT NULL
Table Direct
Product 产品 Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10) NOT NULL
Search
Business Partner 业务伙伴 标识业务伙伴 A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID
numeric(10) NOT NULL
Search
Break Value 休息价值 Low Value of trade discount break level Starting Quantity or Amount Value for break level BreakValue
numeric NOT NULL
Number
Active 有效 本记录有效 There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
List Price 公开报价 公开报价 The List Price is the official List Price in the document currency. PriceList
numeric NOT NULL
Costs+Prices
Standard Price 标准价格 标准价格 The Standard Price indicates the standard or normal price for a product on this price list PriceStd
numeric NOT NULL
Costs+Prices
Limit Price 限制价格 产品的最低价格 The Price Limit indicates the lowest price for a product stated in the Price List Currency. PriceLimit
numeric NOT NULL
Costs+Prices


Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。