|
Lines 1403-1409
sub ModReceiveOrder {
Link Here
|
| 1403 |
# Recalculate tax_value |
1403 |
# Recalculate tax_value |
| 1404 |
$dbh->do(q| |
1404 |
$dbh->do(q| |
| 1405 |
UPDATE aqorders |
1405 |
UPDATE aqorders |
| 1406 |
SET tax_value = quantity * ecost_tax_excluded * tax_rate |
1406 |
SET |
|
|
1407 |
tax_value_on_ordering = quantity * ecost_tax_excluded * tax_rate_on_ordering, |
| 1408 |
tax_value_on_receiving = quantity * unitprice_tax_excluded * tax_rate_on_receiving |
| 1407 |
WHERE ordernumber = ? |
1409 |
WHERE ordernumber = ? |
| 1408 |
|, undef, $order->{ordernumber}); |
1410 |
|, undef, $order->{ordernumber}); |
| 1409 |
|
1411 |
|
|
Lines 1411-1417
sub ModReceiveOrder {
Link Here
|
| 1411 |
$order->{budget_id} = ( $budget_id || $order->{budget_id} ); |
1413 |
$order->{budget_id} = ( $budget_id || $order->{budget_id} ); |
| 1412 |
$order->{quantity} = $quantrec; |
1414 |
$order->{quantity} = $quantrec; |
| 1413 |
$order->{quantityreceived} = $quantrec; |
1415 |
$order->{quantityreceived} = $quantrec; |
| 1414 |
$order->{tax_value} = $order->{quantity} * $order->{unitprice_tax_excluded} * $order->{tax_rate}; |
1416 |
$order->{tax_value_on_ordering} = $order->{quantity} * $order->{ecost_tax_excluded} * $order->{tax_rate_on_ordering}; |
|
|
1417 |
$order->{tax_value_on_receiving} = $order->{quantity} * $order->{unitprice_tax_excluded} * $order->{tax_rate_on_receiving}; |
| 1415 |
$order->{datereceived} = $datereceived; |
1418 |
$order->{datereceived} = $datereceived; |
| 1416 |
$order->{invoiceid} = $invoice->{invoiceid}; |
1419 |
$order->{invoiceid} = $invoice->{invoiceid}; |
| 1417 |
$order->{orderstatus} = 'complete'; |
1420 |
$order->{orderstatus} = 'complete'; |
|
Lines 1571-1577
sub CancelReceipt {
Link Here
|
| 1571 |
# Recalculate tax_value |
1574 |
# Recalculate tax_value |
| 1572 |
$dbh->do(q| |
1575 |
$dbh->do(q| |
| 1573 |
UPDATE aqorders |
1576 |
UPDATE aqorders |
| 1574 |
SET tax_value = quantity * ecost_tax_excluded * tax_rate |
1577 |
SET |
|
|
1578 |
tax_value_on_ordering = quantity * ecost_tax_excluded * tax_rate_on_ordering, |
| 1579 |
tax_value_on_receiving = quantity * unitprice_tax_excluded * tax_rate_on_receiving |
| 1575 |
WHERE ordernumber = ? |
1580 |
WHERE ordernumber = ? |
| 1576 |
|, undef, $parent_ordernumber); |
1581 |
|, undef, $parent_ordernumber); |
| 1577 |
|
1582 |
|
| 1578 |
- |
|
|