Хөөрхөнүүд мэйлийн жагсаалтын архивууд
Архивыг үзэх
Select ( s.price_unit * s.prod [...]
аар
Дэлгэрцэцэг.С
Select ( s.price_unit * s.product_uom_qty) as qrt, al.credit , al.date, s.date, al.id, s.price_unit * s.product_uom_qty - al.credit
FROM stock_move s
JOIN account_move_line as al on s.id = al.stock_move_id
WHERE al.date >= '2018.04.30' and al.date <= '2018.04.30' and al.credit>0 ;