1 -- modified to fix dupe invoices being created.
3 -- Function: fetchinvcnumber()
5 -- DROP FUNCTION fetchinvcnumber();
7 CREATE OR REPLACE FUNCTION fetchinvcnumber()
10 -- Copyright (c) 1999-2011 by OpenMFG LLC, d/b/a xTuple.
11 -- See www.xtuple.com/CPAL for the full text of the software license.
20 SELECT orderseq_number INTO _invcNumber
22 WHERE (orderseq_name='InvcNumber');
25 SET orderseq_number = (orderseq_number + 1)
26 WHERE (orderseq_name='InvcNumber');
28 SELECT invchead_id INTO _test
30 WHERE invchead_invcnumber = _invcNumber::text;
35 SELECT cobmisc_id INTO _test
37 WHERE (cobmisc_invcnumber=_invcNumber);
49 LANGUAGE plpgsql VOLATILE
51 ALTER FUNCTION fetchinvcnumber()