This report prints all client price lists and services with price details, discounts and other properties.
When a price list is assigned to specific clients then the client names are printed.
Report content
Each line shows one specific service of a price list and client (in the case a price list is assigned to that client).
Please note:
- Disabled price lists or draft price lists are not included.
- Disabled services are not included.
- Services with custom discounts (which are filled in as unit prices in the service) are printed as percentages in this report.
Template
Screenshot of default template:
Global placeholders
These can be placed in any location in the Excel and are general properties applicable to all the report.
| Placeholder name | Description |
|---|---|
| <#GeneratedDate> | The date when the report was generated. |
| <#MasterCurrency> | Your default currency as 3 letter ISO code (such as EUR or USD). This is taken from the default price list you configured in the My Company page of your platform. Read more. |
Data rows and placeholders
Each row in the report corresponds to a supplier service. In other words, all information of a specific supplier service will be contained in one single row.
The placeholders of the row must be placed within the Excel table range named "___Lines___" (3 leading and trailing underscore characters). Click here for more details on table ranges.
A report prints the raw data in rows. Each row, you can use any of the following placeholders:
| Placeholder name | Description |
|---|---|
| Client | Shows the client details to which the price list and service was assigned. |
| <#Lines.Company> | The client name. Set if the price list was assigned to this client. Note: A price list which is not assigned to any client is automatically "available" for use for all clients. This column and all other client columns are then empty in the report. |
| <#Lines.CompanyId> | Numeric unique client company identifier. |
| <#Lines.Profile> | The client profile: Agency, Freelancer etc. |
| <#Lines.Active> | Indicates if the client has any enabled logins. |
<#Lines.CCF1>... <#Lines.CCF10> | The client company custom fields. As the platform administrator you can create up to 10 custom fields for companies. |
| Price list | Shows price list details |
| <#Lines.PLId> | An internal numeric identifier of the price list. |
| <#Lines.PLName> | Name of price list |
| <#Lines.PLEnabled> | Indicates if the price list is enabled. Always true as this report shows active price lists only. |
| Service | Shows all fields relative to the supplier service for this line. |
| <#Lines.LocaleSource> | The source language |
| <#Lines.LocaleTarget> | The target language |
| <#Lines.Task> | The task name. |
| <#Lines.LocaleSourceCode> | The source language ISO code. |
| <#Lines.LocaleTargetCode> | The target language ISO code. |
| <#Lines.TaskCode> | The task code such as TR for translation or PROOF for proofreading. These codes can be viewed in Wordbee under Settings > Task categories. |
| <#Lines.ServiceID> | The ID of the service. |
| <#Lines.Enabled> | Indicates if service is enabled. |
| <#Lines.BackupServiceID> | The service ID of the backup service. |
| <#Lines.BackupCompanyName> | The company name of the backup company. |
| <#Lines.BackupPriceListId> | The pricelist ID of the backup service. |
| <#Lines.BackupPriceList> | The pricelist name of the backup service. |
| Price | Shows all fields relative to the supplier service prices for this line. |
| <#Lines.PriceListId> | The pricelist ID for the service. |
| <#Lines.ParentPriceListId> | The parent pricelist ID for the service. |
| <#Lines.PriceListCode> | The pricelist code for the service. |
| <#Lines.UnitCode> | The price unit code for the service. |
| <#Lines.Units> | The price units for the service. |
| <#Lines.ProductCode> | The product code for the service. |
| <#Lines.Amount> | The price amount for the service. |
| <#Lines.Currency> | The price currency. |
| Discounts | Shows all fields relative to the supplier service pre-translation discounts for this line. |
| <#Lines.DCMode> | The discount mode in string format. |
| <#Lines.DiscountMT> | The Machine Translation (MT) discount in negative percent form. |
<#Lines.DiscountPT100> | The discount for total words that are pre-translated at 100% or above in percentage form. |
| <#Lines.DiscountPT100Prev> | The discount for total words that are pre-translated at 100%(identical pre-translations) from memories or termbases, in percentage form. |
| <#Lines.DiscountPT110> | The discount for total words of perfect pre-translations (110%) in percentage form. |
| <#Lines.DiscountPT110Prev> | The discount for total words that were pre-translated at 110% (perfect pre-translations) from a previous document version in percentage form. |
| <#Lines.DiscountPTFuzzy> | The discount for total words of fuzzy (< 100%) pre-translations in percentage form. |
<#Lines.Interval1>... <#Lines.Interval5> | The discount intervals in string form. The report prints intervals from 1 to 5. |
<#Lines.Discount1>... <#Lines.Discount5> | The discount in each interval in negative percent form. |
| Service Details | Shows all fields relative to the supplier service details for this line. |
| <#Lines.Rating> | The rating for the service. |
| <#Lines.LeadTime> | The lead time for the service in numeric format. |
| <#Lines.LeadTimeLabel> | The lead time for the service in string format. |
| <#Lines.Capacity> | The capacity of the service.It describes delay in units per day. |
| <#Lines.CapacityLabel> | The capacity label in string format. It also contains lead time information as it is displayed in the UI. (e.g: 2d1h+2 ) |
| <#Lines.Comments> | The comments for the service. |