Revision cbebaf93
Von Philip Reetz vor mehr als 17 Jahren hinzugefügt
| SL/CA.pm | ||
|---|---|---|
| 266 | 266 |
$dpt_join . |
| 267 | 267 |
qq|WHERE | . $where . $dpt_where . $project . |
| 268 | 268 |
qq| AND ac.chart_id = ? | . |
| 269 |
qq| AND ac.trans_id = a.id | . |
|
| 269 | 270 |
|
| 270 |
qq|UNION | . |
|
| 271 |
qq|UNION ALL | .
|
|
| 271 | 272 |
|
| 272 | 273 |
qq|SELECT a.id, a.invnumber, c.name, ac.transdate, | . |
| 273 | 274 |
qq| a.invoice, ac.amount, 'ar' as module | . |
| ... | ... | |
| 276 | 277 |
qq|WHERE | . $where . $dpt_where . $project . |
| 277 | 278 |
qq| AND ac.chart_id = ? | . |
| 278 | 279 |
qq| AND NOT a.storno | . |
| 280 |
qq| AND ac.trans_id = a.id | . |
|
| 279 | 281 |
qq| AND a.customer_id = c.id | . |
| 280 | 282 |
|
| 281 |
qq|UNION | . |
|
| 283 |
qq|UNION ALL | .
|
|
| 282 | 284 |
|
| 283 | 285 |
qq|SELECT a.id, a.invnumber, v.name, ac.transdate, | . |
| 284 | 286 |
qq| a.invoice, ac.amount, 'ap' as module | . |
| ... | ... | |
| 286 | 288 |
$dpt_join . |
| 287 | 289 |
qq|WHERE | . $where . $dpt_where . $project . |
| 288 | 290 |
qq| AND ac.chart_id = ? | . |
| 291 |
qq| AND ac.trans_id = a.id | . |
|
| 289 | 292 |
qq| AND NOT a.storno | . |
| 290 | 293 |
qq| AND a.vendor_id = v.id |; |
| 291 | 294 |
|
Auch abrufbar als: Unified diff
Mehrere Fehler in der Kontenuebersicht behoben