CREATE OR REPLACE FUNCTION transactions.get_closing_stock(_on_date date, _office_id integer) RETURNS numeric LANGUAGE plpgsql AS $function$ BEGIN RETURN 0;--TODO END $function$