projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Include freight_cost in Sales Quotations, Orders in inquiries.
[fa-stable.git]
/
sales
/
inquiry
/
sales_orders_view.php
diff --git
a/sales/inquiry/sales_orders_view.php
b/sales/inquiry/sales_orders_view.php
index 50a232764fdd686ed39e51399be78dafbc608691..667c939e215ca5492b371b6eee5bc5b4627fe6fa 100644
(file)
--- a/
sales/inquiry/sales_orders_view.php
+++ b/
sales/inquiry/sales_orders_view.php
@@
-256,7
+256,7
@@
$sql = "SELECT
."sorder.ord_date,
sorder.delivery_date,
sorder.deliver_to,
."sorder.ord_date,
sorder.delivery_date,
sorder.deliver_to,
- Sum(line.unit_price*line.quantity*(1-line.discount_percent)) AS OrderValue,
+ Sum(line.unit_price*line.quantity*(1-line.discount_percent)
+freight_cost
) AS OrderValue,
sorder.type,
debtor.curr_code,
Sum(line.qty_sent) AS TotDelivered,
sorder.type,
debtor.curr_code,
Sum(line.qty_sent) AS TotDelivered,