projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Error in two comment lines in demo and new sql file.
[fa-stable.git]
/
reporting
/
rep301.php
diff --git
a/reporting/rep301.php
b/reporting/rep301.php
index 403e4b4ba28c89ccf5947a29a870d4b589b4989b..30cc9ac947d8826fca08568a08c2b49738646a79 100644
(file)
--- a/
reporting/rep301.php
+++ b/
reporting/rep301.php
@@
-105,8
+105,8
@@
function getTransactions($category, $location, $date)
item.description, item.inactive,
move.loc_code,
SUM(move.qty) AS QtyOnHand,
item.description, item.inactive,
move.loc_code,
SUM(move.qty) AS QtyOnHand,
- item.material_cost
+ item.labour_cost + item.overhead_cost
AS UnitCost,
- SUM(move.qty) *
(item.material_cost + item.labour_cost + item.overhead_cost)
AS ItemTotal
+ item.material_cost AS UnitCost,
+ SUM(move.qty) *
item.material_cost
AS ItemTotal
FROM "
.TB_PREF."stock_master item,"
.TB_PREF."stock_category category,"
FROM "
.TB_PREF."stock_master item,"
.TB_PREF."stock_category category,"