Lista Preços (Janela ID-146)
Janela: Lista Preços
Descrição: Maintain Product Price Lists
Ajudar: 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: Lista Preço
Descrição: Define Price Lists
Ajudar Price lists determine currency of the document as well as tax treatment.
Ficheiro:Lista Preços - Lista Preço - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Client | Empresa | A Empresa instalada neste sistema. | A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organismo | Unidade organizacional componente da Empresa | A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Name | Nome | 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 | Descrição | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Activo | The record is active in the system | 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 | Padrão | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
Currency | Divisa | The Currency for this record | 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 | Tabela Preços Venda | This is a 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 | Preço inclui IVA | Tax is included in the price | 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 | Aplicar limite de preço | 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: Versão
Descrição: Maintain price list versions
Ajudar 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.
Ficheiro:Lista Preços - Versão - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Price List Version | Versão Tabela Preços | 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 | Empresa | A Empresa instalada neste sistema. | A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organismo | Unidade organizacional componente da Empresa | A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Price List | Tabela Preços | 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 | Nome | 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 | Descrição | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Activo | The record is active in the system | 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 | Esquema de Descontos | Esquema para calcular os descontos (em percentagem) sobre o preço | Após determinar/calcular o preço (base), este Esquema é aplicado para calcular o desconto sobre o preço e determinar o preço final. | M_DiscountSchema_ID numeric(10) NOT NULL Table |
Base Price List | Tabela Preços Base | 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 | Válido de | 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 | Criar Lista Preço | Create Prices based on parameters of this version | 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: Artigo, Preço
Descrição: Maintain Product Prices
Ajudar The Price List Tab displays the prices for a product based on the selected price list.
Ficheiro:Lista Preços - Artigo, Preço - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Client | Empresa | A Empresa instalada neste sistema. | A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organismo | Unidade organizacional componente da Empresa | A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Price List Version | Versão Tabela Preços | 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 | Artigo | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Active | Activo | The record is active in the system | 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 | Preço de Tabela | List Price | The List Price is the official List Price in the document currency. | PriceList numeric NOT NULL Costs+Prices |
Standard Price | Preço Padrão | 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 | Preço Limite | Lowest price for a product | 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
Descrição: null
Ajudar null
Ficheiro:Lista Preços - Product Price Break - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Client | Empresa | A Empresa instalada neste sistema. | A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organismo | Unidade organizacional componente da Empresa | A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Price List Version | Versão Tabela Preços | 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 | Artigo | 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 | Terceiros | Identifica uma entidade externa à empresa (cliente, fornecedor, vendedor, etc. ) | Terceiros são todas as instituições, sociedades ou individuos com quem a empresa tem um relacionamento comercial ou de trabalho. Exemplos: clientes, fornecedores, funcionários, vendedores ou representantes comerciais, etc. | C_BPartner_ID numeric(10) NOT NULL Search |
Break Value | Escalão, Valor | Low Value of trade discount break level | Starting Quantity or Amount Value for break level | BreakValue numeric NOT NULL Number |
Active | Activo | The record is active in the system | 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 | Preço de Tabela | List Price | The List Price is the official List Price in the document currency. | PriceList numeric NOT NULL Costs+Prices |
Standard Price | Preço Padrão | 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 | Preço Limite | Lowest price for a product | The Price Limit indicates the lowest price for a product stated in the Price List Currency. | PriceLimit numeric NOT NULL Costs+Prices |