A full list of the variables available in print templates. How to use them, how the item tables, functions and conditions work is described in Print templates.
Material
| Variable |
Description |
| {{name}} |
material name |
| {{sku}} |
SKU |
| {{unit}} |
unit of measure |
| {{price}} |
purchase price per unit |
| {{supplier}} |
suppliers, comma separated |
| {{categories}} |
categories, comma separated |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{single_storage}} |
1 when one location is selected, 0 when all of them are |
| {{storage}} |
location name. Filled in only if one location is selected |
| {{stock}} |
stock. If all locations are selected, this is their sum |
| {{minimum}} |
minimum stock. If all locations are selected, this is their sum |
| {{planned}} |
stock change from planned operations. Negative if an outflow is planned |
| {{total}} |
stock including planned operations |
| {{stocks}} |
stock by location |
| {{stock.name}} |
location: name |
| {{stock.stock}} |
location: stock |
| {{stock.planned}} |
location: stock change from planned operations |
| {{stock.total}} |
location: stock including planned operations |
| {{stock.minimum}} |
location: minimum stock |
| {{history}} |
material movement history |
| {{history.date}} |
history: operation date |
| {{history.status}} |
history: plan or fact |
| {{history.amount}} |
history: quantity. Negative if it is an outflow |
| {{history.unit}} |
history: unit of measure |
| {{history.storage}} |
history: location |
| {{history.comment}} |
history: description of the operation, for example Purchase from Thread Ltd |
| {{used_in_products}} |
products that use this material |
| {{used_in_product.number}} |
used in: row number |
| {{used_in_product.name}} |
used in: product name |
| {{used_in_product.sku}} |
used in: product SKU |
| {{used_in_product.amount}} |
used in: how much goes into one unit of that product |
| {{used_in_product.unit}} |
used in: unit of measure |
Product
| Variable |
Description |
| {{name}} |
product name |
| {{sku}} |
SKU |
| {{unit}} |
unit of measure |
| {{batch_size}} |
batch size. Empty if batches are not used, that is the size equals 1 |
| {{price}} |
sales price |
| {{cost}} |
total cost per unit |
| {{percent}} |
share of the cost in the sales price, a number of percent |
| {{supplier}} |
suppliers, comma separated |
| {{categories}} |
categories, comma separated |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{has_subproducts}} |
1 if the components include other products and not only materials, 0 otherwise |
| {{single_storage}} |
1 when one location is selected, 0 when all of them are |
| {{storage}} |
location name. Filled in only if one location is selected |
| {{stock}} |
stock. If all locations are selected, this is their sum |
| {{minimum}} |
minimum stock. If all locations are selected, this is their sum |
| {{planned}} |
stock change from planned operations. Negative if an outflow is planned |
| {{total}} |
stock including planned operations |
| {{components_cost}} |
total cost of the materials and products in the components |
| {{resources_cost}} |
total cost of the resources |
| {{components}} |
product components |
| {{component.number}} |
components: row number |
| {{component.name}} |
components: name of the material or product |
| {{component.sku}} |
components: SKU |
| {{component.unit}} |
components: unit of measure |
| {{component.quantity}} |
components: how much goes into one unit of the product |
| {{component.cost}} |
components: row cost |
| {{resources}} |
resources used to make the product |
| {{resource.number}} |
resource: row number |
| {{resource.name}} |
resource: name |
| {{resource.unit}} |
resource: unit of measure, a percent sign for percentage resources |
| {{resource.quantity}} |
resource: quantity per unit of the product |
| {{resource.cost}} |
resource: row cost |
| {{stocks}} |
stock by location |
| {{stock.name}} |
location: name |
| {{stock.stock}} |
location: stock |
| {{stock.planned}} |
location: stock change from planned operations |
| {{stock.total}} |
location: stock including planned operations |
| {{stock.minimum}} |
location: minimum stock |
| {{history}} |
product movement history |
| {{history.date}} |
history: operation date |
| {{history.status}} |
history: plan or fact |
| {{history.amount}} |
history: quantity. Negative if it is an outflow |
| {{history.unit}} |
history: unit of measure |
| {{history.storage}} |
history: location |
| {{history.comment}} |
history: description of the operation, for example Production 12 |
| {{used_in_products}} |
products that use this product |
| {{used_in_product.number}} |
used in: row number |
| {{used_in_product.name}} |
used in: product name |
| {{used_in_product.sku}} |
used in: product SKU |
| {{used_in_product.amount}} |
used in: how much goes into one unit of that product |
| {{used_in_product.unit}} |
used in: unit of measure |
Purchase
| Variable |
Description |
| {{status}} |
purchase status |
| {{payment}} |
payment status: unpaid, partial or paid |
| {{date_placed}} |
purchase date |
| {{date_received}} |
date received |
| {{shipment_date}} |
date of the selected receipt. Filled in only when you print one receipt rather than the whole purchase |
| {{products_storage}} |
products location |
| {{materials_storage}} |
materials location |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{amount}} |
total quantity across all items. Units of measure are ignored: pieces and metres are added up together |
| {{subtotal}} |
sum of the items, without delivery and discount |
| {{delivery_price}} |
delivery price |
| {{discount}} |
discount |
| {{total}} |
total due: subtotal plus delivery minus discount |
| {{items}} |
purchase items |
| {{item.number}} |
item: row number |
| {{item.name}} |
item: name of the product or material |
| {{item.sku}} |
item: SKU |
| {{item.unit}} |
item: unit of measure |
| {{item.quantity}} |
item: quantity |
| {{item.price}} |
item: price per unit, without delivery and discount |
| {{item.total}} |
item: row total, quantity * price |
| {{supplier.name}} |
supplier: name |
| {{supplier.phone}} |
supplier: phone |
| {{supplier.email}} |
supplier: email |
| {{supplier.address}} |
supplier: physical address |
| {{supplier.address_legal}} |
supplier: registered address |
| {{supplier.agreement}} |
supplier: agreement |
| {{supplier.notes}} |
supplier: notes |
| {{supplier.manager_name}} |
supplier: contact person |
| {{supplier.manager_position}} |
supplier: job title of the contact person |
| {{company.name}} |
your company: name |
Production
| Variable |
Description |
| {{number}} |
production number |
| {{name}} |
production name |
| {{date}} |
production date |
| {{status}} |
status, for example Planned or Done |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{price}} |
total value of what was produced, at sales prices |
| {{cost}} |
total production cost |
| {{materials_storage}} |
materials location |
| {{products_storage}} |
products location |
| {{components_cost}} |
total cost of the materials and products used |
| {{resources_cost}} |
total cost of the resources used |
| {{products}} |
produced products |
| {{product.number}} |
product: row number |
| {{product.name}} |
product: name |
| {{product.sku}} |
product: SKU |
| {{product.unit}} |
product: unit of measure |
| {{product.quantity}} |
product: quantity |
| {{product.cost}} |
product: row cost |
| {{product.price}} |
product: row value at the sales price |
| {{components}} |
materials and products used |
| {{component.number}} |
used: row number |
| {{component.name}} |
used: name of the material or product |
| {{component.sku}} |
used: SKU |
| {{component.unit}} |
used: unit of measure |
| {{component.quantity}} |
used: quantity |
| {{component.cost}} |
used: row cost |
| {{resources}} |
resources used |
| {{resource.number}} |
resource: row number |
| {{resource.name}} |
resource: name |
| {{resource.unit}} |
resource: unit of measure, a percent sign for percentage resources |
| {{resource.quantity}} |
resource: quantity |
| {{resource.cost}} |
resource: row cost |
Sale
| Variable |
Description |
| {{number}} |
sale number |
| {{status}} |
sale status, for example New or Shipped |
| {{payment}} |
payment status: unpaid, partial or paid. Empty if payment tracking is turned off in the company settings |
| {{date_placed}} |
sale date |
| {{date_shipped}} |
shipping date. Empty if the date is turned off in the company settings |
| {{shipment_date}} |
date of the selected shipment. Filled in only when you print one shipment rather than the whole sale |
| {{fulfillment}} |
how the sale is fulfilled: production if the goods are made to order, from_stock if they ship from stock |
| {{production_number}} |
number of the production, if the sale is made to order. Empty otherwise |
| {{products_storage}} |
products location |
| {{materials_storage}} |
materials location |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{amount}} |
total quantity across all items. Units of measure are ignored: pieces and metres are added up together |
| {{subtotal}} |
sum of the items, without delivery and discount |
| {{delivery_price}} |
delivery price |
| {{discount}} |
discount |
| {{total}} |
total due: subtotal plus delivery minus discount |
| {{items}} |
sale items |
| {{item.number}} |
item: row number |
| {{item.name}} |
item: name of the product or material |
| {{item.sku}} |
item: SKU |
| {{item.unit}} |
item: unit of measure |
| {{item.quantity}} |
item: quantity |
| {{item.price}} |
item: price per unit |
| {{item.total}} |
item: row total, quantity * price |
| {{item.cost}} |
item: row cost |
| {{customer.name}} |
customer: name |
| {{customer.phone}} |
customer: phone |
| {{customer.email}} |
customer: email |
| {{customer.address}} |
customer: delivery address |
| {{customer.address_legal}} |
customer: registered address |
| {{customer.agreement}} |
customer: agreement |
| {{customer.notes}} |
customer: notes |
| {{customer.manager_name}} |
customer: contact person |
| {{customer.manager_position}} |
customer: job title of the contact person |
| {{company.name}} |
your company: name |
Write-off
| Variable |
Description |
| {{number}} |
write-off number |
| {{date}} |
write-off date |
| {{status}} |
status |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{total}} |
total cost written off |
| {{materials_storage}} |
materials location |
| {{products_storage}} |
products location |
| {{items}} |
written-off items |
| {{item.number}} |
item: row number |
| {{item.name}} |
item: name of the material or product |
| {{item.sku}} |
item: SKU |
| {{item.unit}} |
item: unit of measure |
| {{item.quantity}} |
item: quantity |
| {{item.price}} |
item: cost per unit |
| {{item.total}} |
item: row cost |
Resource
| Variable |
Description |
| {{name}} |
resource name |
| {{type}} |
how it is calculated: rate, percent or amortized |
| {{dynamic}} |
1 if the rate or the percent is set in the product components rather than in the resource itself. The numbers in price and percent are then meaningless |
| {{base}} |
what a percentage resource is calculated from: cost or price |
| {{unit}} |
unit of measure. For a rate resource it is the unit of the rate, for an amortized one the unit of the useful life |
| {{price}} |
cost per unit |
| {{percent}} |
the percent of a percentage resource, a number without the percent sign |
| {{initial_cost}} |
initial cost of an amortized resource |
| {{left_cost}} |
remaining cost |
| {{useful_life}} |
useful life, a number in the units of the resource |
| {{left_life}} |
how much of the life is left |
| {{amortized_life}} |
how much of the life is used up |
| {{categories}} |
categories, comma separated |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{history}} |
resource usage history |
| {{history.date}} |
history: operation date |
| {{history.status}} |
history: plan or fact |
| {{history.amount}} |
history: quantity. Negative if it is an outflow |
| {{history.unit}} |
history: unit of measure |
| {{history.storage}} |
history: location. Resources have no locations, so this is empty |
| {{history.comment}} |
history: description of the operation |
| {{used_in_products}} |
products that use this resource |
| {{used_in_product.number}} |
used in: row number |
| {{used_in_product.name}} |
used in: product name |
| {{used_in_product.sku}} |
used in: product SKU |
| {{used_in_product.amount}} |
used in: how much goes into one unit of that product |
| {{used_in_product.unit}} |
used in: unit of measure |
Transfer
| Variable |
Description |
| {{number}} |
transfer number |
| {{date}} |
transfer date |
| {{status}} |
status |
| {{type}} |
what is being moved: materials or products |
| {{source}} |
location the goods leave |
| {{target}} |
location the goods arrive at |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{total_cost}} |
total cost across all items |
| {{total_price}} |
total value at sales prices. Empty for materials: they have no sales price |
| {{items}} |
transferred items |
| {{item.number}} |
item: row number |
| {{item.name}} |
item: name of the material or product |
| {{item.sku}} |
item: SKU |
| {{item.unit}} |
item: unit of measure |
| {{item.quantity}} |
item: quantity |
| {{item.cost_per_unit}} |
item: cost per unit |
| {{item.cost}} |
item: row cost |
| {{item.price}} |
item: row value at the sales price. Filled in for products only |
Audit
| Variable |
Description |
| {{number}} |
audit number |
| {{date}} |
audit date |
| {{status}} |
status |
| {{type}} |
what is being counted: materials or products |
| {{storage}} |
location being counted |
| {{currency}} |
currency symbol |
| {{is_saved}} |
1 for a saved audit, 0 for a blank count sheet |
| {{shortage_cost}} |
shortages at cost |
| {{shortage_price}} |
shortages at sales prices. Empty for materials: they have no sales price |
| {{surplus_cost}} |
surpluses at cost |
| {{surplus_price}} |
surpluses at sales prices. Empty for materials |
| {{total_cost}} |
result at cost: surpluses minus shortages |
| {{total_price}} |
the same at sales prices. Empty for materials: they have no sales price |
| {{items}} |
audit items |
| {{item.number}} |
item: row number |
| {{item.name}} |
item: name of the material or product |
| {{item.sku}} |
item: SKU |
| {{item.unit}} |
item: unit of measure |
| {{item.expected}} |
item: quantity on record |
| {{item.actual}} |
item: quantity counted |
| {{item.difference}} |
item: difference, counted minus on record |
| {{item.notes}} |
item: note on the row |
Supplier
| Variable |
Description |
| {{name}} |
supplier name |
| {{address}} |
registered address |
| {{manager}} |
contact person |
| {{position}} |
job title of the contact person |
| {{phone}} |
phone |
| {{email}} |
email |
| {{agreement}} |
agreement |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{purchases_count}} |
how many purchases there are from this supplier in total |
| {{purchases_total}} |
sum of all of them |
| {{delivery_days_avg}} |
average delivery time in days, a number |
| {{purchases}} |
purchases from this supplier |
| {{purchase.number}} |
purchase: row number |
| {{purchase.date_placed}} |
purchase: purchase date |
| {{purchase.date_received}} |
purchase: date received |
| {{purchase.delivery_days}} |
purchase: days from the order to the receipt |
| {{purchase.total}} |
purchase: amount |
Customer
| Variable |
Description |
| {{name}} |
customer name |
| {{address_legal}} |
registered address |
| {{address_real}} |
delivery address |
| {{manager}} |
contact person |
| {{position}} |
job title of the contact person |
| {{phone}} |
phone |
| {{email}} |
email |
| {{agreement}} |
agreement |
| {{notes}} |
notes |
| {{currency}} |
currency symbol |
| {{orders_count}} |
how many sales this customer has in total |
| {{orders_total}} |
sum of all their sales |
| {{delivery_days_avg}} |
average time to process a sale in days, a number |
| {{orders}} |
sales of this customer |
| {{order.number}} |
sale: number |
| {{order.date_placed}} |
sale: sale date |
| {{order.date_shipped}} |
sale: shipping date |
| {{order.delivery_days}} |
sale: days from the sale to the shipment |
| {{order.total}} |
sale: amount |