Attachment #120077 for bug #26734

View | Details | Raw Unified | Return to bug 26734
Collapse All | Expand All




('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');




('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');

INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
[% IF ( LibraryName ) %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
    </th>
 </tr>
[% END %]
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2><u>Fee receipt</u></h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\" class=\"centerednames\">
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
    </th>
 </tr>
 <tr>
    <th colspan=\"4\">
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
        Card number: [% credit.patron.cardnumber | html %]<br />
    </th>
 </tr>
  <tr>

    <th>Amount</th>
 </tr>

 <tr class=\"highlight\">
    <td>[% credit.date | $KohaDates %]</td>
    <td>
      [% PROCESS account_type_description account=credit %]
      [%- IF credit.description %], [% credit.description | html %][% END %]
    </td>
    <td>[% credit.note | html %]</td>
    <td class=\"credit\">[% credit.amount | $Price %]</td>
 </tr>

[% IF ( tendered ) %]
  <tr>
    <td colspan=\"3\">Amount tendered: </td>
    <td>[% tendered | $Price %]</td>
  </tr>
  <tr>
    <td colspan=\"3\">Change given: </td>
    <td>[% change | $Price %]</td>
  </tr>
[% END %]

  [% END %]
<tfoot>
  <tr>
    <td colspan=\"3\">Total outstanding dues as on date: </td>
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
  </tr>
</tfoot>
</table>', 'print', 'default');

INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
[% PROCESS \"accounts.inc\" %]
<table>
  [% IF ( LibraryName ) %]
    <tr>
      <th colspan=\"5\" class=\"centerednames\">
        <h3>[% LibraryName | html %]</h3>
      </th>
    </tr>
  [% END %]

  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2><u>INVOICE</u></h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" class=\"centerednames\">
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
    </th>
  </tr>
  <tr>
    <th colspan=\"5\" >
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
      Card number: [% debit.patron.cardnumber | html %]<br />
    </th>
  </tr>
  <tr>
    <th>Date</th>
    <th>Description of charges</th>
    <th>Note</th>
    <th style=\"text-align:right;\">Amount</th>
    <th style=\"text-align:right;\">Amount outstanding</th>
  </tr>

  <tr class=\"highlight\">
    <td>[% debit.date | $KohaDates%]</td>
    <td>
      [% PROCESS account_type_description account=debit %]
      [%- IF debit.description %], [% debit.description | html %][% END %]
    </td>
    <td>[% debit.note | html %]</td>
    <td class=\"debit\">[% debit.amount | $Price %]</td>
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
  </tr>
    </tr>
  [% END %]

  <tfoot>
    <tr>
      <td colspan=\"4\">Total outstanding dues as on date: </td>
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
    </tr>
  </tfoot>
</table>', 'print', 'default');
- 

Return to bug 26734

Lines 110-217 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (-50 / +61 lines)
110	('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 \| $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 \| $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	110	('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 \| $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 \| $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
111		111
112	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	112	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
113	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '<table>	113	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		114	[% PROCESS \"accounts.inc\" %]
		115	<table>
114	[% IF ( LibraryName ) %]	116	[% IF ( LibraryName ) %]
115	<tr>	117	<tr>
116	<th colspan="4" class="centerednames">	118	<th colspan=\"4\" class=\"centerednames\">
117	<h3>[% LibraryName \| html %]</h3>	119	<h3>[% LibraryName \| html %]</h3>
118	</th>	120	</th>
119	</tr>	121	</tr>
120	[% END %]	122	[% END %]
121	<tr>	123	<tr>
122	<th colspan="4" class="centerednames">	124	<th colspan=\"4\" class=\"centerednames\">
123	<h2><u>REÇU</u></h2>	125	<h2><u>Fee receipt</u></h2>
124	</th>	126	</th>
125	</tr>	127	</tr>
126	<tr>	128	<tr>
127	<th colspan="4" class="centerednames">	129	<th colspan=\"4\" class=\"centerednames\">
128	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	130	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
129	</th>	131	</th>
130	</tr>	132	</tr>
131	<tr>	133	<tr>
132	<th colspan="4">	134	<th colspan=\"4\">
133	Reçu de [% patron.firstname \| html %] [% patron.surname \| html %] <br />	135	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
134	Numéro de carte : [% patron.cardnumber \| html %]<br />	136	Card number: [% credit.patron.cardnumber \| html %]<br />
135	</th>	137	</th>
136	</tr>	138	</tr>
137	<tr>	139	<tr>
138	<th>Date</th>	140	<th>Date</th>
139	<th>Description des frais</th>	141	<th>Description of charges</th>
140	<th>Note</th>	142	<th>Note</th>
141	<th>Montant</th>	143	<th>Amount</th>
142	</tr>	144	</tr>
143		145
144	[% FOREACH account IN accounts %]	146	<tr class=\"highlight\">
145	<tr class="highlight">	147	<td>[% credit.date \| $KohaDates %]</td>
146	<td>[% account.date \| $KohaDates %]</td>	148	<td>
147	<td>	149	[% PROCESS account_type_description account=credit %]
148	[% PROCESS account_type_description account=account %]	150	[%- IF credit.description %], [% credit.description \| html %][% END %]
149	[%- IF account.description %], [% account.description \| html %][% END %]	151	</td>
150	</td>	152	<td>[% credit.note \| html %]</td>
151	<td>[% account.note \| html %]</td>	153	<td class=\"credit\">[% credit.amount \| $Price %]</td>
152	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	154	</tr>
153	</tr>	155
		156	[% IF ( tendered ) %]
		157	<tr>
		158	<td colspan=\"3\">Amount tendered: </td>
		159	<td>[% tendered \| $Price %]</td>
		160	</tr>
		161	<tr>
		162	<td colspan=\"3\">Change given: </td>
		163	<td>[% change \| $Price %]</td>
		164	</tr>
		165	[% END %]
154		166
155	[% END %]
156	<tfoot>	167	<tfoot>
157	<tr>	168	<tr>
158	<td colspan="3">Solde non-réglé : </td>	169	<td colspan=\"3\">Total outstanding dues as on date: </td>
159	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	170	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
160	</tr>	171	</tr>
161	</tfoot>	172	</tfoot>
162	</table>', 'print', 'default');	173	</table>', 'print', 'default');
163		174
164	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	175	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
165	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	176	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		177	[% PROCESS \"accounts.inc\" %]
		178	<table>
166	[% IF ( LibraryName ) %]	179	[% IF ( LibraryName ) %]
167	<tr>	180	<tr>
168	<th colspan="5" class="centerednames">	181	<th colspan=\"5\" class=\"centerednames\">
169	<h3>[% LibraryName \| html %]</h3>	182	<h3>[% LibraryName \| html %]</h3>
170	</th>	183	</th>
171	</tr>	184	</tr>
172	[% END %]	185	[% END %]
173		186
174	<tr>	187	<tr>
175	<th colspan="5" class="centerednames">	188	<th colspan=\"5\" class=\"centerednames\">
176	<h2><u>FACTURE</u></h2>	189	<h2><u>INVOICE</u></h2>
177	</th>	190	</th>
178	</tr>	191	</tr>
179	<tr>	192	<tr>
180	<th colspan="5" class="centerednames">	193	<th colspan=\"5\" class=\"centerednames\">
181	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	194	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
182	</th>	195	</th>
183	</tr>	196	</tr>
184	<tr>	197	<tr>
185	<th colspan="5" >	198	<th colspan=\"5\" >
186	Facturé à : [% patron.firstname \| html %] [% patron.surname \| html %] <br />	199	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
187	Numéro de carte : [% patron.cardnumber \| html %]<br />	200	Card number: [% debit.patron.cardnumber \| html %]<br />
188	</th>	201	</th>
189	</tr>	202	</tr>
190	<tr>	203	<tr>
191	<th>Date</th>	204	<th>Date</th>
192	<th>Description des frais</th>	205	<th>Description of charges</th>
193	<th>Note</th>	206	<th>Note</th>
194	<th style="text-align:right;">Montant</th>	207	<th style=\"text-align:right;\">Amount</th>
195	<th style="text-align:right;">Solde</th>	208	<th style=\"text-align:right;\">Amount outstanding</th>
196	</tr>	209	</tr>
197		210
198	[% FOREACH account IN accounts %]	211	<tr class=\"highlight\">
199	<tr class="highlight">	212	<td>[% debit.date \| $KohaDates%]</td>
200	<td>[% account.date \| $KohaDates%]</td>	213	<td>
201	<td>	214	[% PROCESS account_type_description account=debit %]
202	[% PROCESS account_type_description account=account %]	215	[%- IF debit.description %], [% debit.description \| html %][% END %]
203	[%- IF account.description %], [% account.description \| html %][% END %]	216	</td>
204	</td>	217	<td>[% debit.note \| html %]</td>
205	<td>[% account.note \| html %]</td>	218	<td class=\"debit\">[% debit.amount \| $Price %]</td>
206	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	219	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
207	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	220	</tr>
208	</tr>
209	[% END %]
210		221
211	<tfoot>	222	<tfoot>
212	<tr>	223	<tr>
213	<td colspan="4">Solde non-réglé : </td>	224	<td colspan=\"4\">Total outstanding dues as on date: </td>
214	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	225	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
215	</tr>	226	</tr>
216	</tfoot>	227	</tfoot>
217	</table>', 'print', 'default');	228	</table>', 'print', 'default');

Lines 223-250 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-46 / +56 lines)
223	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	223	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
224		224
225	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	225	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
226	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	226	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		227	[% PROCESS \"accounts.inc\" %]
		228	<table>
227	[% IF ( LibraryName ) %]	229	[% IF ( LibraryName ) %]
228	<tr>	230	<tr>
229	<th colspan="4" class="centerednames">	231	<th colspan=\"4\" class=\"centerednames\">
230	<h3>[% LibraryName \| html %]</h3>	232	<h3>[% LibraryName \| html %]</h3>
231	</th>	233	</th>
232	</tr>	234	</tr>
233	[% END %]	235	[% END %]
234	<tr>	236	<tr>
235	<th colspan="4" class="centerednames">	237	<th colspan=\"4\" class=\"centerednames\">
236	<h2><u>Fee receipt</u></h2>	238	<h2><u>Fee receipt</u></h2>
237	</th>	239	</th>
238	</tr>	240	</tr>
239	<tr>	241	<tr>
240	<th colspan="4" class="centerednames">	242	<th colspan=\"4\" class=\"centerednames\">
241	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	243	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
242	</th>	244	</th>
243	</tr>	245	</tr>
244	<tr>	246	<tr>
245	<th colspan="4">	247	<th colspan=\"4\">
246	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	248	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
247	Card number: [% patron.cardnumber \| html %]<br />	249	Card number: [% credit.patron.cardnumber \| html %]<br />
248	</th>	250	</th>
249	</tr>	251	</tr>
250	<tr>	252	<tr>
Lines 254-334 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
254	<th>Amount</th>	256	<th>Amount</th>
255	</tr>	257	</tr>
256		258
257	[% FOREACH account IN accounts %]	259	<tr class=\"highlight\">
258	<tr class="highlight">	260	<td>[% credit.date \| $KohaDates %]</td>
259	<td>[% account.date \| $KohaDates %]</td>	261	<td>
260	<td>	262	[% PROCESS account_type_description account=credit %]
261	[% PROCESS account_type_description account=account %]	263	[%- IF credit.description %], [% credit.description \| html %][% END %]
262	[%- IF account.description %], [% account.description \| html %][% END %]	264	</td>
263	</td>	265	<td>[% credit.note \| html %]</td>
264	<td>[% account.note \| html %]</td>	266	<td class=\"credit\">[% credit.amount \| $Price %]</td>
265	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	267	</tr>
266	</tr>	268
		269	[% IF ( tendered ) %]
		270	<tr>
		271	<td colspan=\"3\">Amount tendered: </td>
		272	<td>[% tendered \| $Price %]</td>
		273	</tr>
		274	<tr>
		275	<td colspan=\"3\">Change given: </td>
		276	<td>[% change \| $Price %]</td>
		277	</tr>
		278	[% END %]
267		279
268	[% END %]
269	<tfoot>	280	<tfoot>
270	<tr>	281	<tr>
271	<td colspan="3">Total outstanding dues as on date: </td>	282	<td colspan=\"3\">Total outstanding dues as on date: </td>
272	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	283	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
273	</tr>	284	</tr>
274	</tfoot>	285	</tfoot>
275	</table>', 'print', 'default');	286	</table>', 'print', 'default');
276		287
277	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	288	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
278	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	289	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		290	[% PROCESS \"accounts.inc\" %]
		291	<table>
279	[% IF ( LibraryName ) %]	292	[% IF ( LibraryName ) %]
280	<tr>	293	<tr>
281	<th colspan="5" class="centerednames">	294	<th colspan=\"5\" class=\"centerednames\">
282	<h3>[% LibraryName \| html %]</h3>	295	<h3>[% LibraryName \| html %]</h3>
283	</th>	296	</th>
284	</tr>	297	</tr>
285	[% END %]	298	[% END %]
286		299
287	<tr>	300	<tr>
288	<th colspan="5" class="centerednames">	301	<th colspan=\"5\" class=\"centerednames\">
289	<h2><u>INVOICE</u></h2>	302	<h2><u>INVOICE</u></h2>
290	</th>	303	</th>
291	</tr>	304	</tr>
292	<tr>	305	<tr>
293	<th colspan="5" class="centerednames">	306	<th colspan=\"5\" class=\"centerednames\">
294	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	307	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
295	</th>	308	</th>
296	</tr>	309	</tr>
297	<tr>	310	<tr>
298	<th colspan="5" >	311	<th colspan=\"5\" >
299	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	312	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
300	Card number: [% patron.cardnumber \| html %]<br />	313	Card number: [% debit.patron.cardnumber \| html %]<br />
301	</th>	314	</th>
302	</tr>	315	</tr>
303	<tr>	316	<tr>
304	<th>Date</th>	317	<th>Date</th>
305	<th>Description of charges</th>	318	<th>Description of charges</th>
306	<th>Note</th>	319	<th>Note</th>
307	<th style="text-align:right;">Amount</th>	320	<th style=\"text-align:right;\">Amount</th>
308	<th style="text-align:right;">Amount outstanding</th>	321	<th style=\"text-align:right;\">Amount outstanding</th>
309	</tr>	322	</tr>
310		323
311	[% FOREACH account IN accounts %]	324	<tr class=\"highlight\">
312	<tr class="highlight">	325	<td>[% debit.date \| $KohaDates%]</td>
313	<td>[% account.date \| $KohaDates%]</td>	326	<td>
314	<td>	327	[% PROCESS account_type_description account=debit %]
315	[% PROCESS account_type_description account=account %]	328	[%- IF debit.description %], [% debit.description \| html %][% END %]
316	[%- IF account.description %], [% account.description \| html %][% END %]	329	</td>
317	</td>	330	<td>[% debit.note \| html %]</td>
318	<td>[% account.note \| html %]</td>	331	<td class=\"debit\">[% debit.amount \| $Price %]</td>
319	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	332	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
320	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	333	</tr>
321	</tr>
322	[% END %]
323		334
324	<tfoot>	335	<tfoot>
325	<tr>	336	<tr>
326	<td colspan="4">Total outstanding dues as on date: </td>	337	<td colspan=\"4\">Total outstanding dues as on date: </td>
327	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	338	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
328	</tr>	339	</tr>
329	</tfoot>	340	</tfoot>
330	</table>', 'print', 'default');	341	</table>', 'print', 'default');
331
332	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES	342	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
333	('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');	343	('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
334	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	344	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES

Lines 225-252 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-45 / +56 lines)
225	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	225	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
226		226
227	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	227	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
228	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	228	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		229	[% PROCESS \"accounts.inc\" %]
		230	<table>
229	[% IF ( LibraryName ) %]	231	[% IF ( LibraryName ) %]
230	<tr>	232	<tr>
231	<th colspan="4" class="centerednames">	233	<th colspan=\"4\" class=\"centerednames\">
232	<h3>[% LibraryName \| html %]</h3>	234	<h3>[% LibraryName \| html %]</h3>
233	</th>	235	</th>
234	</tr>	236	</tr>
235	[% END %]	237	[% END %]
236	<tr>	238	<tr>
237	<th colspan="4" class="centerednames">	239	<th colspan=\"4\" class=\"centerednames\">
238	<h2><u>Fee receipt</u></h2>	240	<h2><u>Fee receipt</u></h2>
239	</th>	241	</th>
240	</tr>	242	</tr>
241	<tr>	243	<tr>
242	<th colspan="4" class="centerednames">	244	<th colspan=\"4\" class=\"centerednames\">
243	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	245	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
244	</th>	246	</th>
245	</tr>	247	</tr>
246	<tr>	248	<tr>
247	<th colspan="4">	249	<th colspan=\"4\">
248	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	250	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
249	Card number: [% patron.cardnumber \| html %]<br />	251	Card number: [% credit.patron.cardnumber \| html %]<br />
250	</th>	252	</th>
251	</tr>	253	</tr>
252	<tr>	254	<tr>
Lines 256-332 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
256	<th>Amount</th>	258	<th>Amount</th>
257	</tr>	259	</tr>
258		260
259	[% FOREACH account IN accounts %]	261	<tr class=\"highlight\">
260	<tr class="highlight">	262	<td>[% credit.date \| $KohaDates %]</td>
261	<td>[% account.date \| $KohaDates %]</td>	263	<td>
262	<td>	264	[% PROCESS account_type_description account=credit %]
263	[% PROCESS account_type_description account=account %]	265	[%- IF credit.description %], [% credit.description \| html %][% END %]
264	[%- IF account.description %], [% account.description \| html %][% END %]	266	</td>
265	</td>	267	<td>[% credit.note \| html %]</td>
266	<td>[% account.note \| html %]</td>	268	<td class=\"credit\">[% credit.amount \| $Price %]</td>
267	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	269	</tr>
268	</tr>	270
		271	[% IF ( tendered ) %]
		272	<tr>
		273	<td colspan=\"3\">Amount tendered: </td>
		274	<td>[% tendered \| $Price %]</td>
		275	</tr>
		276	<tr>
		277	<td colspan=\"3\">Change given: </td>
		278	<td>[% change \| $Price %]</td>
		279	</tr>
		280	[% END %]
269		281
270	[% END %]
271	<tfoot>	282	<tfoot>
272	<tr>	283	<tr>
273	<td colspan="3">Total outstanding dues as on date: </td>	284	<td colspan=\"3\">Total outstanding dues as on date: </td>
274	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	285	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
275	</tr>	286	</tr>
276	</tfoot>	287	</tfoot>
277	</table>', 'print', 'default');	288	</table>', 'print', 'default');
278		289
279	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	290	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
280	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	291	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		292	[% PROCESS \"accounts.inc\" %]
		293	<table>
281	[% IF ( LibraryName ) %]	294	[% IF ( LibraryName ) %]
282	<tr>	295	<tr>
283	<th colspan="5" class="centerednames">	296	<th colspan=\"5\" class=\"centerednames\">
284	<h3>[% LibraryName \| html %]</h3>	297	<h3>[% LibraryName \| html %]</h3>
285	</th>	298	</th>
286	</tr>	299	</tr>
287	[% END %]	300	[% END %]
288		301
289	<tr>	302	<tr>
290	<th colspan="5" class="centerednames">	303	<th colspan=\"5\" class=\"centerednames\">
291	<h2><u>INVOICE</u></h2>	304	<h2><u>INVOICE</u></h2>
292	</th>	305	</th>
293	</tr>	306	</tr>
294	<tr>	307	<tr>
295	<th colspan="5" class="centerednames">	308	<th colspan=\"5\" class=\"centerednames\">
296	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	309	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
297	</th>	310	</th>
298	</tr>	311	</tr>
299	<tr>	312	<tr>
300	<th colspan="5" >	313	<th colspan=\"5\" >
301	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	314	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
302	Card number: [% patron.cardnumber \| html %]<br />	315	Card number: [% debit.patron.cardnumber \| html %]<br />
303	</th>	316	</th>
304	</tr>	317	</tr>
305	<tr>	318	<tr>
306	<th>Date</th>	319	<th>Date</th>
307	<th>Description of charges</th>	320	<th>Description of charges</th>
308	<th>Note</th>	321	<th>Note</th>
309	<th style="text-align:right;">Amount</th>	322	<th style=\"text-align:right;\">Amount</th>
310	<th style="text-align:right;">Amount outstanding</th>	323	<th style=\"text-align:right;\">Amount outstanding</th>
311	</tr>	324	</tr>
312		325
313	[% FOREACH account IN accounts %]	326	<tr class=\"highlight\">
314	<tr class="highlight">	327	<td>[% debit.date \| $KohaDates%]</td>
315	<td>[% account.date \| $KohaDates%]</td>	328	<td>
316	<td>	329	[% PROCESS account_type_description account=debit %]
317	[% PROCESS account_type_description account=account %]	330	[%- IF debit.description %], [% debit.description \| html %][% END %]
318	[%- IF account.description %], [% account.description \| html %][% END %]	331	</td>
319	</td>	332	<td>[% debit.note \| html %]</td>
320	<td>[% account.note \| html %]</td>	333	<td class=\"debit\">[% debit.amount \| $Price %]</td>
321	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	334	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
322	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	335	</tr>
323	</tr>
324	[% END %]
325		336
326	<tfoot>	337	<tfoot>
327	<tr>	338	<tr>
328	<td colspan="4">Total outstanding dues as on date: </td>	339	<td colspan=\"4\">Total outstanding dues as on date: </td>
329	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	340	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
330	</tr>	341	</tr>
331	</tfoot>	342	</tfoot>
332	</table>', 'print', 'default');	343	</table>', 'print', 'default');

Lines 241-268 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (-45 / +56 lines)
241	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	241	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
242		242
243	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	243	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
244	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	244	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		245	[% PROCESS \"accounts.inc\" %]
		246	<table>
245	[% IF ( LibraryName ) %]	247	[% IF ( LibraryName ) %]
246	<tr>	248	<tr>
247	<th colspan="4" class="centerednames">	249	<th colspan=\"4\" class=\"centerednames\">
248	<h3>[% LibraryName \| html %]</h3>	250	<h3>[% LibraryName \| html %]</h3>
249	</th>	251	</th>
250	</tr>	252	</tr>
251	[% END %]	253	[% END %]
252	<tr>	254	<tr>
253	<th colspan="4" class="centerednames">	255	<th colspan=\"4\" class=\"centerednames\">
254	<h2><u>Fee receipt</u></h2>	256	<h2><u>Fee receipt</u></h2>
255	</th>	257	</th>
256	</tr>	258	</tr>
257	<tr>	259	<tr>
258	<th colspan="4" class="centerednames">	260	<th colspan=\"4\" class=\"centerednames\">
259	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	261	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
260	</th>	262	</th>
261	</tr>	263	</tr>
262	<tr>	264	<tr>
263	<th colspan="4">	265	<th colspan=\"4\">
264	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	266	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
265	Card number: [% patron.cardnumber \| html %]<br />	267	Card number: [% credit.patron.cardnumber \| html %]<br />
266	</th>	268	</th>
267	</tr>	269	</tr>
268	<tr>	270	<tr>
Lines 272-348 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
272	<th>Amount</th>	274	<th>Amount</th>
273	</tr>	275	</tr>
274		276
275	[% FOREACH account IN accounts %]	277	<tr class=\"highlight\">
276	<tr class="highlight">	278	<td>[% credit.date \| $KohaDates %]</td>
277	<td>[% account.date \| $KohaDates %]</td>	279	<td>
278	<td>	280	[% PROCESS account_type_description account=credit %]
279	[% PROCESS account_type_description account=account %]	281	[%- IF credit.description %], [% credit.description \| html %][% END %]
280	[%- IF account.description %], [% account.description \| html %][% END %]	282	</td>
281	</td>	283	<td>[% credit.note \| html %]</td>
282	<td>[% account.note \| html %]</td>	284	<td class=\"credit\">[% credit.amount \| $Price %]</td>
283	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	285	</tr>
284	</tr>	286
		287	[% IF ( tendered ) %]
		288	<tr>
		289	<td colspan=\"3\">Amount tendered: </td>
		290	<td>[% tendered \| $Price %]</td>
		291	</tr>
		292	<tr>
		293	<td colspan=\"3\">Change given: </td>
		294	<td>[% change \| $Price %]</td>
		295	</tr>
		296	[% END %]
285		297
286	[% END %]
287	<tfoot>	298	<tfoot>
288	<tr>	299	<tr>
289	<td colspan="3">Total outstanding dues as on date: </td>	300	<td colspan=\"3\">Total outstanding dues as on date: </td>
290	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	301	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
291	</tr>	302	</tr>
292	</tfoot>	303	</tfoot>
293	</table>', 'print', 'default');	304	</table>', 'print', 'default');
294		305
295	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	306	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
296	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	307	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		308	[% PROCESS \"accounts.inc\" %]
		309	<table>
297	[% IF ( LibraryName ) %]	310	[% IF ( LibraryName ) %]
298	<tr>	311	<tr>
299	<th colspan="5" class="centerednames">	312	<th colspan=\"5\" class=\"centerednames\">
300	<h3>[% LibraryName \| html %]</h3>	313	<h3>[% LibraryName \| html %]</h3>
301	</th>	314	</th>
302	</tr>	315	</tr>
303	[% END %]	316	[% END %]
304		317
305	<tr>	318	<tr>
306	<th colspan="5" class="centerednames">	319	<th colspan=\"5\" class=\"centerednames\">
307	<h2><u>INVOICE</u></h2>	320	<h2><u>INVOICE</u></h2>
308	</th>	321	</th>
309	</tr>	322	</tr>
310	<tr>	323	<tr>
311	<th colspan="5" class="centerednames">	324	<th colspan=\"5\" class=\"centerednames\">
312	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	325	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
313	</th>	326	</th>
314	</tr>	327	</tr>
315	<tr>	328	<tr>
316	<th colspan="5" >	329	<th colspan=\"5\" >
317	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	330	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
318	Card number: [% patron.cardnumber \| html %]<br />	331	Card number: [% debit.patron.cardnumber \| html %]<br />
319	</th>	332	</th>
320	</tr>	333	</tr>
321	<tr>	334	<tr>
322	<th>Date</th>	335	<th>Date</th>
323	<th>Description of charges</th>	336	<th>Description of charges</th>
324	<th>Note</th>	337	<th>Note</th>
325	<th style="text-align:right;">Amount</th>	338	<th style=\"text-align:right;\">Amount</th>
326	<th style="text-align:right;">Amount outstanding</th>	339	<th style=\"text-align:right;\">Amount outstanding</th>
327	</tr>	340	</tr>
328		341
329	[% FOREACH account IN accounts %]	342	<tr class=\"highlight\">
330	<tr class="highlight">	343	<td>[% debit.date \| $KohaDates%]</td>
331	<td>[% account.date \| $KohaDates%]</td>	344	<td>
332	<td>	345	[% PROCESS account_type_description account=debit %]
333	[% PROCESS account_type_description account=account %]	346	[%- IF debit.description %], [% debit.description \| html %][% END %]
334	[%- IF account.description %], [% account.description \| html %][% END %]	347	</td>
335	</td>	348	<td>[% debit.note \| html %]</td>
336	<td>[% account.note \| html %]</td>	349	<td class=\"debit\">[% debit.amount \| $Price %]</td>
337	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	350	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
338	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	351	</tr>
339	</tr>
340	[% END %]
341		352
342	<tfoot>	353	<tfoot>
343	<tr>	354	<tr>
344	<td colspan="4">Total outstanding dues as on date: </td>	355	<td colspan=\"4\">Total outstanding dues as on date: </td>
345	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	356	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
346	</tr>	357	</tr>
347	</tfoot>	358	</tfoot>
348	</table>', 'print', 'default');	359	</table>', 'print', 'default');

Lines 220-247 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-45 / +56 lines)
220	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	220	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
221		221
222	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	222	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
223	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	223	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		224	[% PROCESS \"accounts.inc\" %]
		225	<table>
224	[% IF ( LibraryName ) %]	226	[% IF ( LibraryName ) %]
225	<tr>	227	<tr>
226	<th colspan="4" class="centerednames">	228	<th colspan=\"4\" class=\"centerednames\">
227	<h3>[% LibraryName \| html %]</h3>	229	<h3>[% LibraryName \| html %]</h3>
228	</th>	230	</th>
229	</tr>	231	</tr>
230	[% END %]	232	[% END %]
231	<tr>	233	<tr>
232	<th colspan="4" class="centerednames">	234	<th colspan=\"4\" class=\"centerednames\">
233	<h2><u>Fee receipt</u></h2>	235	<h2><u>Fee receipt</u></h2>
234	</th>	236	</th>
235	</tr>	237	</tr>
236	<tr>	238	<tr>
237	<th colspan="4" class="centerednames">	239	<th colspan=\"4\" class=\"centerednames\">
238	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	240	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
239	</th>	241	</th>
240	</tr>	242	</tr>
241	<tr>	243	<tr>
242	<th colspan="4">	244	<th colspan=\"4\">
243	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	245	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
244	Card number: [% patron.cardnumber \| html %]<br />	246	Card number: [% credit.patron.cardnumber \| html %]<br />
245	</th>	247	</th>
246	</tr>	248	</tr>
247	<tr>	249	<tr>
Lines 251-327 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
251	<th>Amount</th>	253	<th>Amount</th>
252	</tr>	254	</tr>
253		255
254	[% FOREACH account IN accounts %]	256	<tr class=\"highlight\">
255	<tr class="highlight">	257	<td>[% credit.date \| $KohaDates %]</td>
256	<td>[% account.date \| $KohaDates %]</td>	258	<td>
257	<td>	259	[% PROCESS account_type_description account=credit %]
258	[% PROCESS account_type_description account=account %]	260	[%- IF credit.description %], [% credit.description \| html %][% END %]
259	[%- IF account.description %], [% account.description \| html %][% END %]	261	</td>
260	</td>	262	<td>[% credit.note \| html %]</td>
261	<td>[% account.note \| html %]</td>	263	<td class=\"credit\">[% credit.amount \| $Price %]</td>
262	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	264	</tr>
263	</tr>	265
		266	[% IF ( tendered ) %]
		267	<tr>
		268	<td colspan=\"3\">Amount tendered: </td>
		269	<td>[% tendered \| $Price %]</td>
		270	</tr>
		271	<tr>
		272	<td colspan=\"3\">Change given: </td>
		273	<td>[% change \| $Price %]</td>
		274	</tr>
		275	[% END %]
264		276
265	[% END %]
266	<tfoot>	277	<tfoot>
267	<tr>	278	<tr>
268	<td colspan="3">Total outstanding dues as on date: </td>	279	<td colspan=\"3\">Total outstanding dues as on date: </td>
269	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	280	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
270	</tr>	281	</tr>
271	</tfoot>	282	</tfoot>
272	</table>', 'print', 'default');	283	</table>', 'print', 'default');
273		284
274	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	285	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
275	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	286	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		287	[% PROCESS \"accounts.inc\" %]
		288	<table>
276	[% IF ( LibraryName ) %]	289	[% IF ( LibraryName ) %]
277	<tr>	290	<tr>
278	<th colspan="5" class="centerednames">	291	<th colspan=\"5\" class=\"centerednames\">
279	<h3>[% LibraryName \| html %]</h3>	292	<h3>[% LibraryName \| html %]</h3>
280	</th>	293	</th>
281	</tr>	294	</tr>
282	[% END %]	295	[% END %]
283		296
284	<tr>	297	<tr>
285	<th colspan="5" class="centerednames">	298	<th colspan=\"5\" class=\"centerednames\">
286	<h2><u>INVOICE</u></h2>	299	<h2><u>INVOICE</u></h2>
287	</th>	300	</th>
288	</tr>	301	</tr>
289	<tr>	302	<tr>
290	<th colspan="5" class="centerednames">	303	<th colspan=\"5\" class=\"centerednames\">
291	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	304	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
292	</th>	305	</th>
293	</tr>	306	</tr>
294	<tr>	307	<tr>
295	<th colspan="5" >	308	<th colspan=\"5\" >
296	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	309	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
297	Card number: [% patron.cardnumber \| html %]<br />	310	Card number: [% debit.patron.cardnumber \| html %]<br />
298	</th>	311	</th>
299	</tr>	312	</tr>
300	<tr>	313	<tr>
301	<th>Date</th>	314	<th>Date</th>
302	<th>Description of charges</th>	315	<th>Description of charges</th>
303	<th>Note</th>	316	<th>Note</th>
304	<th style="text-align:right;">Amount</th>	317	<th style=\"text-align:right;\">Amount</th>
305	<th style="text-align:right;">Amount outstanding</th>	318	<th style=\"text-align:right;\">Amount outstanding</th>
306	</tr>	319	</tr>
307		320
308	[% FOREACH account IN accounts %]	321	<tr class=\"highlight\">
309	<tr class="highlight">	322	<td>[% debit.date \| $KohaDates%]</td>
310	<td>[% account.date \| $KohaDates%]</td>	323	<td>
311	<td>	324	[% PROCESS account_type_description account=debit %]
312	[% PROCESS account_type_description account=account %]	325	[%- IF debit.description %], [% debit.description \| html %][% END %]
313	[%- IF account.description %], [% account.description \| html %][% END %]	326	</td>
314	</td>	327	<td>[% debit.note \| html %]</td>
315	<td>[% account.note \| html %]</td>	328	<td class=\"debit\">[% debit.amount \| $Price %]</td>
316	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	329	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
317	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	330	</tr>
318	</tr>
319	[% END %]
320		331
321	<tfoot>	332	<tfoot>
322	<tr>	333	<tr>
323	<td colspan="4">Total outstanding dues as on date: </td>	334	<td colspan=\"4\">Total outstanding dues as on date: </td>
324	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	335	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
325	</tr>	336	</tr>
326	</tfoot>	337	</tfoot>
327	</table>', 'print', 'default');	338	</table>', 'print', 'default');

Lines 222-249 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (-45 / +56 lines)
222	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	222	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
223		223
224	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	224	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
225	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	225	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		226	[% PROCESS \"accounts.inc\" %]
		227	<table>
226	[% IF ( LibraryName ) %]	228	[% IF ( LibraryName ) %]
227	<tr>	229	<tr>
228	<th colspan="4" class="centerednames">	230	<th colspan=\"4\" class=\"centerednames\">
229	<h3>[% LibraryName \| html %]</h3>	231	<h3>[% LibraryName \| html %]</h3>
230	</th>	232	</th>
231	</tr>	233	</tr>
232	[% END %]	234	[% END %]
233	<tr>	235	<tr>
234	<th colspan="4" class="centerednames">	236	<th colspan=\"4\" class=\"centerednames\">
235	<h2><u>Fee receipt</u></h2>	237	<h2><u>Fee receipt</u></h2>
236	</th>	238	</th>
237	</tr>	239	</tr>
238	<tr>	240	<tr>
239	<th colspan="4" class="centerednames">	241	<th colspan=\"4\" class=\"centerednames\">
240	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	242	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
241	</th>	243	</th>
242	</tr>	244	</tr>
243	<tr>	245	<tr>
244	<th colspan="4">	246	<th colspan=\"4\">
245	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	247	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
246	Card number: [% patron.cardnumber \| html %]<br />	248	Card number: [% credit.patron.cardnumber \| html %]<br />
247	</th>	249	</th>
248	</tr>	250	</tr>
249	<tr>	251	<tr>
Lines 253-329 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
253	<th>Amount</th>	255	<th>Amount</th>
254	</tr>	256	</tr>
255		257
256	[% FOREACH account IN accounts %]	258	<tr class=\"highlight\">
257	<tr class="highlight">	259	<td>[% credit.date \| $KohaDates %]</td>
258	<td>[% account.date \| $KohaDates %]</td>	260	<td>
259	<td>	261	[% PROCESS account_type_description account=credit %]
260	[% PROCESS account_type_description account=account %]	262	[%- IF credit.description %], [% credit.description \| html %][% END %]
261	[%- IF account.description %], [% account.description \| html %][% END %]	263	</td>
262	</td>	264	<td>[% credit.note \| html %]</td>
263	<td>[% account.note \| html %]</td>	265	<td class=\"credit\">[% credit.amount \| $Price %]</td>
264	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	266	</tr>
265	</tr>	267
		268	[% IF ( tendered ) %]
		269	<tr>
		270	<td colspan=\"3\">Amount tendered: </td>
		271	<td>[% tendered \| $Price %]</td>
		272	</tr>
		273	<tr>
		274	<td colspan=\"3\">Change given: </td>
		275	<td>[% change \| $Price %]</td>
		276	</tr>
		277	[% END %]
266		278
267	[% END %]
268	<tfoot>	279	<tfoot>
269	<tr>	280	<tr>
270	<td colspan="3">Total outstanding dues as on date: </td>	281	<td colspan=\"3\">Total outstanding dues as on date: </td>
271	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	282	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
272	</tr>	283	</tr>
273	</tfoot>	284	</tfoot>
274	</table>', 'print', 'default');	285	</table>', 'print', 'default');
275		286
276	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	287	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
277	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	288	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		289	[% PROCESS \"accounts.inc\" %]
		290	<table>
278	[% IF ( LibraryName ) %]	291	[% IF ( LibraryName ) %]
279	<tr>	292	<tr>
280	<th colspan="5" class="centerednames">	293	<th colspan=\"5\" class=\"centerednames\">
281	<h3>[% LibraryName \| html %]</h3>	294	<h3>[% LibraryName \| html %]</h3>
282	</th>	295	</th>
283	</tr>	296	</tr>
284	[% END %]	297	[% END %]
285		298
286	<tr>	299	<tr>
287	<th colspan="5" class="centerednames">	300	<th colspan=\"5\" class=\"centerednames\">
288	<h2><u>INVOICE</u></h2>	301	<h2><u>INVOICE</u></h2>
289	</th>	302	</th>
290	</tr>	303	</tr>
291	<tr>	304	<tr>
292	<th colspan="5" class="centerednames">	305	<th colspan=\"5\" class=\"centerednames\">
293	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	306	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
294	</th>	307	</th>
295	</tr>	308	</tr>
296	<tr>	309	<tr>
297	<th colspan="5" >	310	<th colspan=\"5\" >
298	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	311	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
299	Card number: [% patron.cardnumber \| html %]<br />	312	Card number: [% debit.patron.cardnumber \| html %]<br />
300	</th>	313	</th>
301	</tr>	314	</tr>
302	<tr>	315	<tr>
303	<th>Date</th>	316	<th>Date</th>
304	<th>Description of charges</th>	317	<th>Description of charges</th>
305	<th>Note</th>	318	<th>Note</th>
306	<th style="text-align:right;">Amount</th>	319	<th style=\"text-align:right;\">Amount</th>
307	<th style="text-align:right;">Amount outstanding</th>	320	<th style=\"text-align:right;\">Amount outstanding</th>
308	</tr>	321	</tr>
309		322
310	[% FOREACH account IN accounts %]	323	<tr class=\"highlight\">
311	<tr class="highlight">	324	<td>[% debit.date \| $KohaDates%]</td>
312	<td>[% account.date \| $KohaDates%]</td>	325	<td>
313	<td>	326	[% PROCESS account_type_description account=debit %]
314	[% PROCESS account_type_description account=account %]	327	[%- IF debit.description %], [% debit.description \| html %][% END %]
315	[%- IF account.description %], [% account.description \| html %][% END %]	328	</td>
316	</td>	329	<td>[% debit.note \| html %]</td>
317	<td>[% account.note \| html %]</td>	330	<td class=\"debit\">[% debit.amount \| $Price %]</td>
318	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	331	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
319	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	332	</tr>
320	</tr>
321	[% END %]
322		333
323	<tfoot>	334	<tfoot>
324	<tr>	335	<tr>
325	<td colspan="4">Total outstanding dues as on date: </td>	336	<td colspan=\"4\">Total outstanding dues as on date: </td>
326	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	337	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
327	</tr>	338	</tr>
328	</tfoot>	339	</tfoot>
329	</table>', 'print', 'default');	340	</table>', 'print', 'default');

Lines 316-343 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-46 / +56 lines)
316	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');	316	('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 \| $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 \| $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding \| $Price %]\r\n[% END %]', 'email', 'default');
317		317
318	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	318	INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
319	('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>	319	('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
		320	[% PROCESS \"accounts.inc\" %]
		321	<table>
320	[% IF ( LibraryName ) %]	322	[% IF ( LibraryName ) %]
321	<tr>	323	<tr>
322	<th colspan="4" class="centerednames">	324	<th colspan=\"4\" class=\"centerednames\">
323	<h3>[% LibraryName \| html %]</h3>	325	<h3>[% LibraryName \| html %]</h3>
324	</th>	326	</th>
325	</tr>	327	</tr>
326	[% END %]	328	[% END %]
327	<tr>	329	<tr>
328	<th colspan="4" class="centerednames">	330	<th colspan=\"4\" class=\"centerednames\">
329	<h2><u>Fee receipt</u></h2>	331	<h2><u>Fee receipt</u></h2>
330	</th>	332	</th>
331	</tr>	333	</tr>
332	<tr>	334	<tr>
333	<th colspan="4" class="centerednames">	335	<th colspan=\"4\" class=\"centerednames\">
334	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	336	<h2>[% Branches.GetName( credit.patron.branchcode ) \| html %]</h2>
335	</th>	337	</th>
336	</tr>	338	</tr>
337	<tr>	339	<tr>
338	<th colspan="4">	340	<th colspan=\"4\">
339	Received with thanks from [% patron.firstname \| html %] [% patron.surname \| html %] <br />	341	Received with thanks from [% credit.patron.firstname \| html %] [% credit.patron.surname \| html %] <br />
340	Card number: [% patron.cardnumber \| html %]<br />	342	Card number: [% credit.patron.cardnumber \| html %]<br />
341	</th>	343	</th>
342	</tr>	344	</tr>
343	<tr>	345	<tr>
Lines 347-423 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
347	<th>Amount</th>	349	<th>Amount</th>
348	</tr>	350	</tr>
349		351
350	[% FOREACH account IN accounts %]	352	<tr class=\"highlight\">
351	<tr class="highlight">	353	<td>[% credit.date \| $KohaDates %]</td>
352	<td>[% account.date \| $KohaDates %]</td>	354	<td>
353	<td>	355	[% PROCESS account_type_description account=credit %]
354	[% PROCESS account_type_description account=account %]	356	[%- IF credit.description %], [% credit.description \| html %][% END %]
355	[%- IF account.description %], [% account.description \| html %][% END %]	357	</td>
356	</td>	358	<td>[% credit.note \| html %]</td>
357	<td>[% account.note \| html %]</td>	359	<td class=\"credit\">[% credit.amount \| $Price %]</td>
358	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	360	</tr>
359	</tr>	361
		362	[% IF ( tendered ) %]
		363	<tr>
		364	<td colspan=\"3\">Amount tendered: </td>
		365	<td>[% tendered \| $Price %]</td>
		366	</tr>
		367	<tr>
		368	<td colspan=\"3\">Change given: </td>
		369	<td>[% change \| $Price %]</td>
		370	</tr>
		371	[% END %]
360		372
361	[% END %]
362	<tfoot>	373	<tfoot>
363	<tr>	374	<tr>
364	<td colspan="3">Total outstanding dues as on date: </td>	375	<td colspan=\"3\">Total outstanding dues as on date: </td>
365	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	376	[% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance \| $Price %]</td>
366	</tr>	377	</tr>
367	</tfoot>	378	</tfoot>
368	</table>', 'print', 'default');	379	</table>', 'print', 'default');
369		380
370	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES	381	INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
371	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>	382	('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
		383	[% PROCESS \"accounts.inc\" %]
		384	<table>
372	[% IF ( LibraryName ) %]	385	[% IF ( LibraryName ) %]
373	<tr>	386	<tr>
374	<th colspan="5" class="centerednames">	387	<th colspan=\"5\" class=\"centerednames\">
375	<h3>[% LibraryName \| html %]</h3>	388	<h3>[% LibraryName \| html %]</h3>
376	</th>	389	</th>
377	</tr>	390	</tr>
378	[% END %]	391	[% END %]
379		392
380	<tr>	393	<tr>
381	<th colspan="5" class="centerednames">	394	<th colspan=\"5\" class=\"centerednames\">
382	<h2><u>INVOICE</u></h2>	395	<h2><u>INVOICE</u></h2>
383	</th>	396	</th>
384	</tr>	397	</tr>
385	<tr>	398	<tr>
386	<th colspan="5" class="centerednames">	399	<th colspan=\"5\" class=\"centerednames\">
387	<h2>[% Branches.GetName( patron.branchcode ) \| html %]</h2>	400	<h2>[% Branches.GetName( debit.patron.branchcode ) \| html %]</h2>
388	</th>	401	</th>
389	</tr>	402	</tr>
390	<tr>	403	<tr>
391	<th colspan="5" >	404	<th colspan=\"5\" >
392	Bill to: [% patron.firstname \| html %] [% patron.surname \| html %] <br />	405	Bill to: [% debit.patron.firstname \| html %] [% debit.patron.surname \| html %] <br />
393	Card number: [% patron.cardnumber \| html %]<br />	406	Card number: [% debit.patron.cardnumber \| html %]<br />
394	</th>	407	</th>
395	</tr>	408	</tr>
396	<tr>	409	<tr>
397	<th>Date</th>	410	<th>Date</th>
398	<th>Description of charges</th>	411	<th>Description of charges</th>
399	<th>Note</th>	412	<th>Note</th>
400	<th style="text-align:right;">Amount</th>	413	<th style=\"text-align:right;\">Amount</th>
401	<th style="text-align:right;">Amount outstanding</th>	414	<th style=\"text-align:right;\">Amount outstanding</th>
402	</tr>	415	</tr>
403		416
404	[% FOREACH account IN accounts %]	417	<tr class=\"highlight\">
405	<tr class="highlight">	418	<td>[% debit.date \| $KohaDates%]</td>
406	<td>[% account.date \| $KohaDates%]</td>	419	<td>
407	<td>	420	[% PROCESS account_type_description account=debit %]
408	[% PROCESS account_type_description account=account %]	421	[%- IF debit.description %], [% debit.description \| html %][% END %]
409	[%- IF account.description %], [% account.description \| html %][% END %]	422	</td>
410	</td>	423	<td>[% debit.note \| html %]</td>
411	<td>[% account.note \| html %]</td>	424	<td class=\"debit\">[% debit.amount \| $Price %]</td>
412	[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount \| $Price %]</td>	425	<td class=\"debit\">[% debit.amountoutstanding \| $Price %]</td>
413	[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding \| $Price %]</td>	426	</tr>
414	</tr>
415	[% END %]
416		427
417	<tfoot>	428	<tfoot>
418	<tr>	429	<tr>
419	<td colspan="4">Total outstanding dues as on date: </td>	430	<td colspan=\"4\">Total outstanding dues as on date: </td>
420	[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total \| $Price %]</td>	431	[% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance \| $Price %]</td>
421	</tr>	432	</tr>
422	</tfoot>	433	</tfoot>
423	</table>', 'print', 'default');	434	</table>', 'print', 'default');
424	-