Revision 6c9c012e
Von Kivitendo Admin vor mehr als 11 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 211 | 211 |
|
| 212 | 212 |
$sth->finish; |
| 213 | 213 |
|
| 214 |
# filter for opening and closing bookings |
|
| 214 | 215 |
# if l_ob is selected l_cb is always ignored |
| 215 |
if ( $form->{l_ob} ) {
|
|
| 216 |
$where .= ' AND ac.ob_transaction is true ' |
|
| 217 |
} elsif ( not $form->{l_cb} ) {
|
|
| 218 |
$where .= ' AND ac.cb_transaction is false '; |
|
| 216 |
if ( $last_period ) {
|
|
| 217 |
# ob/cb-settings for "as of" balance |
|
| 218 |
if ( $form->{l_ob_compared} ) {
|
|
| 219 |
$where .= ' AND ac.ob_transaction is true ' |
|
| 220 |
} elsif ( not $form->{l_cb_compared} ) {
|
|
| 221 |
$where .= ' AND ac.cb_transaction is false '; |
|
| 222 |
}; |
|
| 223 |
} else {
|
|
| 224 |
# ob/cb-settings for "compared to" balance |
|
| 225 |
if ( $form->{l_ob} ) {
|
|
| 226 |
$where .= ' AND ac.ob_transaction is true ' |
|
| 227 |
} elsif ( not $form->{l_cb} ) {
|
|
| 228 |
$where .= ' AND ac.cb_transaction is false '; |
|
| 229 |
}; |
|
| 219 | 230 |
}; |
| 220 | 231 |
|
| 232 |
|
|
| 221 | 233 |
if ($fromdate) {
|
| 222 | 234 |
$fromdate = conv_dateq($fromdate); |
| 223 | 235 |
if ($form->{method} eq 'cash') {
|
| templates/webpages/rp/report.html | ||
|---|---|---|
| 137 | 137 |
<tr> |
| 138 | 138 |
<th align=right>[% 'as at' | $T8 %]</th> |
| 139 | 139 |
<td> [% L.date_tag('asofdate', asofdate) %]</td>
|
| 140 |
<td><input name=l_cb class=checkbox type=checkbox value=Y> [% 'CB Transactions' | $T8 %]</td> |
|
| 141 |
<td><input name=l_ob class=checkbox type=checkbox value=Y> [% 'only OB Transactions' | $T8 %]</td> |
|
| 142 |
</tr> |
|
| 143 |
</tr> |
|
| 140 | 144 |
<th align=right nowrap>[% 'Compare to' | $T8 %]</th> |
| 141 | 145 |
<td>[% L.date_tag('compareasofdate', compareasofdate) %]</td>
|
| 146 |
<td><input name=l_cb_compared class=checkbox type=checkbox value=Y> [% 'CB Transactions' | $T8 %]</td> |
|
| 147 |
<td><input name=l_ob_compared class=checkbox type=checkbox value=Y> [% 'only OB Transactions' | $T8 %]</td> |
|
| 142 | 148 |
</tr> |
| 143 | 149 |
<tr> |
| 144 | 150 |
<th align=right>[% 'Decimalplaces' | $T8 %]</th> |
| ... | ... | |
| 153 | 159 |
<input name=l_subtotal class=checkbox type=checkbox value=Y> [% 'Subtotal' | $T8 %] |
| 154 | 160 |
<input name=l_accno class=checkbox type=checkbox value=Y> [% 'Account Number' | $T8 %]</td> |
| 155 | 161 |
</tr> |
| 156 |
<tr> |
|
| 157 |
<th></th> |
|
| 158 |
<td><input name=l_cb class=checkbox type=checkbox value=Y> [% 'CB Transactions' | $T8 %] |
|
| 159 |
<input name=l_ob class=checkbox type=checkbox value=Y> [% 'only OB Transactions' | $T8 %]</td> |
|
| 160 |
</tr> |
|
| 161 | 162 |
[%- END %] |
| 162 | 163 |
|
| 163 | 164 |
[%- IF is_trial_balance %] |
Auch abrufbar als: Unified diff
Bilanz-Bericht: eigene EB/SB-Filter für Gegenüberstellung
Jetzt kann man sowohl die Bilanz zum Stichtag, als auch zum
Gegenüberstellungstag, mit Filtern für EB- und SB-Buchungen ziehen.
Ein nützlicher Vergleich ist z.B.:
Zum Stand: 31.12.2012 (keine Haken gesetzt)
Gegenüberstellen zu: 01.01.2013 Haken bei: "nur EB-Buchungen"
um zu sehen ob alle Salden korrekt übertragen worden sind.