1 ## -*- coding: utf-
8 -*-
2 <%page
args=
"account, formatLang" />
3 %if account.grouped_ledger_lines and account.partners_order:
5 account_total_debit =
0.0
6 account_total_credit =
0.0
7 account_balance_cumul =
0.0
8 account_balance_cumul_curr =
0.0
10 %for partner_name, p_id, p_ref, p_name in account.partners_order:
11 <div class=
"account_title bg" style=
"width: 1080px; margin-top:
12 20px; font-size: 12px;">${account.code} - ${account.name} -- ${partner_name or _('No Partner')}
</div>
16 %for curr, grouped_lines in account.grouped_ledger_lines.get(p_id, []):
21 cumul_balance_curr =
0.0
23 part_cumul_balance =
0.0
24 part_cumul_balance_curr =
0.0
26 <div class=
"act_as_table list_table" style=
"margin-top: 5px;">
27 <div class=
"act_as_caption account_title">
28 <b>${curr or company.currency_id.name}
</b>
30 <div class=
"act_as_thead">
31 <div class=
"act_as_row labels">
33 <div class=
"act_as_cell first_column" style=
"width: 60px;">${_('Date')}
</div>
35 <div class=
"act_as_cell" style=
"width: 70px;">${_('Period')}
</div>
37 <div class=
"act_as_cell" style=
"width: 100px;">${_('Entry')}
</div>
39 <div class=
"act_as_cell" style=
"width: 70px;">${_('Journal')}
</div>
41 <div class=
"act_as_cell" style=
"width: 100px;">${_('Reference')}
</div>
43 <div class=
"act_as_cell" style=
"width: 180px;">${_('Label')}
</div>
45 <div class=
"act_as_cell" style=
"width: 80px;">${_('Rec.')}
</div>
47 <div class=
"act_as_cell" style=
"width: 60px;">${_('Due Date')}
</div>
49 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Debit')}
</div>
51 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Credit')}
</div>
53 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Cumul. Bal.')}
</div>
55 <div class=
"act_as_cell amount sep_left" style=
"width: 80px;">${_('Curr. Balance')}
</div>
57 <div class=
"act_as_cell amount" style=
"width: 30px; text-align: right;">${_('Curr.')}
</div>
60 <div class=
"act_as_tbody">
67 return text.replace('-', '
‑') # replace by a non-breaking hyphen (it will not word-wrap between hyphen and numbers)
69 %for line in grouped_lines:
71 total_debit += line.get('debit') or
0.0
72 total_credit += line.get('credit') or
0.0
74 label_elements = [line.get('lname') or '']
75 if line.get('invoice_number'):
76 label_elements.append(
"(%s)" % (line['invoice_number'],))
77 label = ' '.join(label_elements)
79 <div class=
"act_as_row lines ${line.get('is_from_previous_periods') and 'open_invoice_previous_line' or ''} ${line.get('is_clearance_line') and 'clearance_line' or ''}">
81 <div class=
"act_as_cell first_column">${formatLang(line.get('ldate') or '', date=True)}
</div>
83 <div class=
"act_as_cell">${line.get('period_code') or ''}
</div>
85 <div class=
"act_as_cell">${line.get('move_name') or ''}
</div>
87 <div class=
"act_as_cell">${line.get('jcode') or ''}
</div>
89 <div class=
"act_as_cell">${line.get('lref') or ''}
</div>
91 <div class=
"act_as_cell">${label}
</div>
93 <div class=
"act_as_cell">${line.get('rec_name') or ''}
</div>
95 <div class=
"act_as_cell">${formatLang(line.get('date_maturity') or '', date=True)}
</div>
97 <div class=
"act_as_cell amount">${formatLang(line.get('debit') or
0.0) | amount }
</div>
99 <div class=
"act_as_cell amount">${formatLang(line.get('credit') or
0.0) | amount }
</div>
101 <% cumul_balance += line.get('balance') or
0.0 %
>
102 <div class=
"act_as_cell amount" style=
"padding-right: 1px;">${formatLang(cumul_balance) | amount }
</div>
104 <div class=
"act_as_cell sep_left amount">${formatLang(line.get('amount_currency') or
0.0) | amount }
</div>
106 <div class=
"act_as_cell" style=
"text-align: right; ">${line.get('currency_code') or ''}
</div>
109 <div class=
"act_as_row lines labels">
111 <div class=
"act_as_cell first_column"></div>
113 <div class=
"act_as_cell"></div>
115 <div class=
"act_as_cell"></div>
117 <div class=
"act_as_cell"></div>
119 <div class=
"act_as_cell"></div>
121 <div class=
"act_as_cell">${_('Cumulated Balance on Partner')}
</div>
123 <div class=
"act_as_cell"></div>
125 <div class=
"act_as_cell"></div>
127 <div class=
"act_as_cell amount">${formatLang(total_debit) | amount }
</div>
129 <div class=
"act_as_cell amount">${formatLang(total_credit) | amount }
</div>
131 <div class=
"act_as_cell amount" style=
"padding-right: 1px;">${formatLang(cumul_balance) | amount }
</div>
132 %if account.currency_id:
134 <div class=
"act_as_cell sep_left amount" style=
"padding-right: 1px;">${formatLang(cumul_balance_curr) | amount }
</div>
136 <div class=
"act_as_cell sep_left amount" style=
"padding-right: 1px;">${ u'-' }
</div>
139 <div class=
"act_as_cell" style=
"text-align: right; ">${ account.currency_id.name if account.currency_id else u'' }
</div>
144 account_total_debit += total_debit
145 account_total_credit += total_credit
146 account_balance_cumul += cumul_balance
147 account_balance_cumul_curr += cumul_balance_curr
151 <div class=
"act_as_table list_table" style=
"margin-top:5px;">
152 <div class=
"act_as_row labels" style=
"font-weight: bold; font-size: 12px;">
153 <div class=
"act_as_cell first_column" style=
"width: 450px;">${account.code} - ${account.name}
</div>
155 <div class=
"act_as_cell" style=
"width: 320px;">${_(
"Cumulated Balance on Account")}
</div>
157 <div class=
"act_as_cell amount" style=
"width: 80px;">${ formatLang(account_total_debit) | amount }
</div>
159 <div class=
"act_as_cell amount" style=
"width: 80px;">${ formatLang(account_total_credit) | amount }
</div>
161 <div class=
"act_as_cell amount" style=
"width: 80px; ">${ formatLang(account_balance_cumul) | amount }
</div>
162 ## currency balance cumulated
163 %if account.currency_id:
164 <div class=
"act_as_cell amount sep_left" style=
"width: 80px;">${ formatLang(account_balance_cumul_curr) | amount }
</div>
166 <div class=
"act_as_cell amount sep_left" style=
"width: 80px; padding-right: 1px;">${ u'-' }
</div>
169 <div class=
"act_as_cell amount" style=
"width: 30px; text-align: right;">${ account.currency_id.name if account.currency_id else u'' }
</div>