Contents

    Variables, commands, and formatting for reports

    Stand: JTL-POS Version 0.9.7.2

    On this page you will find an overview of all variables, commands and formatting options for reports You can use all of them in the print templates for reports in the printer settings. Some commands do not work on certain printers.

    Variables for reports

    Here is a list of all the variables that you can use in reports.

    $header$

    The header defined under Settings > Printing objects > Header

    $report_name$

    Name of the report, for example “Intermediate report” or “Day-end closing”.

    $report_no$

    Report ID

    $last_report_id$

    Number of the last report

    $last_report_date$

    Creation time of the last report

    $from_id$

    Number of the first receipt in the report

    $to_id$

    Number of the last receipt in the report

    $from_date$

    Start time of the report, date of the first receipt

    $from_date$

    End time of report, date of the last receipt

    $count_sales$

    Total number of sales in the reporting period

    $total_net_all$

    Total sales revenue in the reporting period

    $count_return$

    Total number of returns in the reporting period

    $total_net_return$

    Total number of returns in the reporting period

    $total_net_diff$

    Difference between total sales and returns

    $total_tax$

    Total tax

    $total_gross_diff$

    Gross total

    $currency$

    Currency

    $receipt_id$

    Receipt number

    $cancellation$

    Cancellation reason

    $net$

    Net amount (cancelled receipt)

    $total$

    Gross amount

    $cash_balance_old$

    Cash register balance (former)

    $cash_on_hand$

    Gross turnover CASH

    $count_deposit$

    Number of cash deposits

    $sum_deposit$

    Total cash deposits

    $count_removal$

    Number of cash withdrawals

    $sum_removal$

    Total cash withdrawals

    $sum_amount_back$

    Total change (for non-cash payments)

    $sum_gratuity$

    Total tips received

    $cash_balance_calc$

    Target cash register balance

    $cash_balance_manually$

    Actual cash register balance

    $cash_difference$

    Difference between target cash balance and actual cash balance

    $cash_balance_new$

    Cash register balance (new)

    $t1$

    Normal tax rate in percent

    $t2$

    Reduced tax rate in percent

    $t1net$

    Total net amount to which the normal tax rate applies

    $t2net$

    Total net amount to which the reduced tax rate applies

    $t1tax$

    The total amount of tax resulting from the normal tax rate

    $t2tax$

    Total amount of tax resulting from the reduced tax rate

    $t1total$

    Total gross amount for receipts to which the normal tax rate applies

    $t2total$

    Total gross amount for receipts to which the reduced tax rate applies

    $total_net$

    Total net sales revenue

    $payment_name$

    Name of payment method

    $amount$

    Total amount per payment method

    $total_payment$

    Total amount of payments

    $comment$

    Comment

    $tse_sn$

    Serial number of the TSE. Can only be used after the TSE has been activated.

    Commands

    You can insert these commands on reports to control the printer. Not all commands are supported by all printers.

    <CUT>

    Cuts the paper at the tag position.

    <OPENCD>

    Opens the cash drawer connected to the printer.

    Formatting options

    You can use these options to format your text. xxx can be replaced by plain text or one of the above variables. Not all formatting options are supported by all printer models.

    <BR>

    Inserts a line break.

    <B>xxx</B>

    Formats the text within the tags in bold.

    <U>xxx</U>

    Underlines the text within the tags.

    <U2>xxx</U2>

    Underlines the text within the tags and formats it in bold.

    <F1>xxx</F1>

    Selects Font 1 for the text within the tags.

    <F2>xxx</F2>

    Selects Font 2 for the text within the tags.

    <H2>xxx</H2>

    Doubles the hight of text within the tags.

    <W2>xxx</W2>

    Doubles the width of the text within the tags.

    <T2>xxx</T2>

    Makes the text within the tags twice as large (height and width).

    <L>xxx</L>

    Aligns the text within the tags to the left.

    <R>xxx</R>

    Aligns the text within the tags to the right.

    <C>xxx</C>

    Centres the text within the tags.

    <FS>

    Resets the font size to default.

    <WIDTH>

    Window width

    Contents

    Use these variables to mark certain elements of your reports, for example, as cancelled receipts. These are only printed if the corresponding content is required.

    <cancellation>xxx</cancellation>

    Cancelled receipts

    Bar codes

    You can print bar codes on your reports. You can use the following variables to do this.

    <QRCODE>xxx</QRCODE>

    Issues a QR code for the variable specified in xxx. The size is approx. 3.5 cm x 3.5 cm.

    <QRCODE2>xxx</QRCODE2>

    Issues a smaller QR code for the variable specified in xxx. The size is approx. 1.5 cm x 1.5 cm.

    <CODE128>xxx</CODE128>

    Issues a Code128 bar code (GS1-128) for the variable specified in xxx.

     <EAN8>xxx</EAN8>

    Issues a GTIN-8 bar code for the variable specified in xxx.

     <EAN13>xxx</EAN13>

    Issues a GTIN-13 bar code for the variable specified in xxx.

    <UPC_A>xxx</UPC_A>

    Issues a UPC-A bar code (GTIN-12) for the variable specified in xxx.

     <UPC_E>xxx</UPC_E>

    Issues a UPC-E bar code for the variable specified in xxx.