Report Export Quety

Receipt Report

SELECT
    fy.fiscal_year,
    r.receipt_number,
	pp.full_name AS vendor,
	r.bill_number,
    s.full_name AS store,
    sig.full_name AS item_group,
    i.full_name AS item,
    rd.rate,
    rd.item_discount_amount,
    rd.net_rate,
    rd.quantity,
    rd.total_tax,
    cc.cost_center_name as cost_center,
    rd.sub_store_id
FROM inv.tbl_receipt_detail rd
JOIN app.tbl_cost_center cc
	ON rd.cost_center_id = cc.id
JOIN inv.tbl_item i
    ON rd.item_id = i.id
JOIN inv.tbl_store_item_group sig
    ON i.store_item_group_id = sig.id
JOIN inv.tbl_store s
    ON rd.store_id = s.id
JOIN inv.tbl_receipt r
    ON rd.receipt_id = r.id
JOIN app.tbl_payable_profile pp
	ON r.payable_profile_id = pp.id
JOIN app.tbl_fiscal_year fy
    ON r.fiscal_year_id = fy.id
WHERE fy.id = 6
    AND rd.is_active = TRUE
    AND rd.is_deleted = FALSE;

Issue Report Substore

SELECT
    fy.fiscal_year,
    issu.transaction_date,
    fs.full_name AS from_store,
    ts.full_name AS to_substore,
    r.receipt_number AS from_batch,
    issu.issue_direct_number AS to_batch,
    itg.full_name AS item_group,
    i.full_name AS item,
    iss.rate AS rate,
    iss.quantity AS qty
FROM inv.tbl_issue_sub_store AS iss
JOIN inv.tbl_receipt AS r
    ON iss.receipt_id = r.id
JOIN inv.tbl_issue AS issu
    ON iss.issue_id = issu.id
JOIN inv.tbl_item AS i
    ON iss.item_id = i.id
JOIN inv.tbl_store AS fs
    ON i.store_id = fs.id
JOIN inv.tbl_store AS ts
    ON iss.to_sub_store_id = ts.id
JOIN inv.tbl_store_item_group AS itg
    ON i.store_item_group_id = itg.id
JOIN app.tbl_fiscal_year AS fy
    ON issu.fiscal_year_id = fy.id
WHERE fy.id = 6 AND
	iss.is_active = true AND
	iss.is_deleted = false;