+*/
+ $sql = "SELECT ".TB_PREF."stock_master.category_id,
+ ".TB_PREF."stock_category.description AS cat_description,
+ ".TB_PREF."stock_master.stock_id,
+ ".TB_PREF."stock_master.description,
+ ".TB_PREF."stock_moves.loc_code,
+ ".TB_PREF."debtor_trans.debtor_no,
+ ".TB_PREF."stock_moves.tran_date,
+ -".TB_PREF."stock_moves.qty*".TB_PREF."stock_moves.price*(1-".TB_PREF."stock_moves.discount_percent) AS amt,
+ -".TB_PREF."stock_moves.qty *(".TB_PREF."stock_master.material_cost + ".TB_PREF."stock_master.labour_cost + ".TB_PREF."stock_master.overhead_cost) AS cost
+ FROM ".TB_PREF."stock_master,
+ ".TB_PREF."stock_category,
+ ".TB_PREF."debtor_trans,
+ ".TB_PREF."stock_moves
+ WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id
+ AND ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id