Revision 1a5eedd6
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
SL/IR.pm | ||
---|---|---|
269 | 269 |
|
270 | 270 |
# allocated >= 0 |
271 | 271 |
# add entry for inventory, this one is for the sold item |
272 |
$query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey, tax_id) VALUES (?, ?, ?, ?, |
|
272 |
$query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey, tax_id, chart_link) VALUES (?, ?, ?, ?,
|
|
273 | 273 |
(SELECT taxkey_id |
274 | 274 |
FROM taxkeys |
275 | 275 |
WHERE chart_id= ? |
... | ... | |
280 | 280 |
WHERE chart_id= ? |
281 | 281 |
AND startdate <= ? |
282 | 282 |
ORDER BY startdate DESC LIMIT 1), |
283 |
(SELECT chart_link FROM chart WHERE id = ?))|;
|
|
283 |
(SELECT link FROM chart WHERE id = ?))|; |
|
284 | 284 |
@values = ($ref->{trans_id}, $ref->{inventory_accno_id}, $linetotal, $ref->{transdate}, $ref->{inventory_accno_id}, $ref->{transdate}, $ref->{inventory_accno_id}, $ref->{transdate}, |
285 | 285 |
$ref->{inventory_accno_id}); |
286 | 286 |
do_query($form, $dbh, $query, @values); |
287 | 287 |
|
288 | 288 |
# add expense |
289 |
$query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey, tax_id) VALUES (?, ?, ?, ?, |
|
289 |
$query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, taxkey, tax_id, chart_link) VALUES (?, ?, ?, ?,
|
|
290 | 290 |
(SELECT taxkey_id |
291 | 291 |
FROM taxkeys |
292 | 292 |
WHERE chart_id= ? |
... | ... | |
297 | 297 |
WHERE chart_id= ? |
298 | 298 |
AND startdate <= ? |
299 | 299 |
ORDER BY startdate DESC LIMIT 1), |
300 |
(SELECT chart_link FROM chart WHERE id = ?))|;
|
|
300 |
(SELECT link FROM chart WHERE id = ?))|; |
|
301 | 301 |
@values = ($ref->{trans_id}, $ref->{expense_accno_id}, ($linetotal * -1), $ref->{transdate}, $ref->{expense_accno_id}, $ref->{transdate}, $ref->{expense_accno_id}, $ref->{transdate}, |
302 | 302 |
$ref->{expense_accno_id}); |
303 | 303 |
do_query($form, $dbh, $query, @values); |
Auch abrufbar als: Unified diff
Einkaufsrechnung buchen bei Bestandsmethode: falsche Spaltennamen/-anzahl gefixt