Annotation: transactions.opening_inventory_exists

Information: transactions.opening_inventory_exists

Implementation: transactions.opening_inventory_exists

CREATE OR REPLACE FUNCTION transactions.opening_inventory_exists(_office_id integer)
 RETURNS boolean
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    IF EXISTS
    (
        SELECT 1
        FROM transactions.transaction_master
        WHERE book = 'Opening.Inventory'
        AND office_id = _office_id
    ) THEN
        RETURN true;
    END IF;

    RETURN false;
END
$function$