projekt kivitendo

         ct.name, ct.ustid,

         c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,

         ar.invoice,

       FROM acc_trans ac

       LEFT JOIN ar          ON (ac.trans_id    = ar.id)

       LEFT JOIN customer ct ON (ar.customer_id = ct.id)

         ct.name,ct.ustid,

         c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,

         ap.invoice,

       FROM acc_trans ac

       LEFT JOIN ap        ON (ac.trans_id  = ap.id)

       LEFT JOIN vendor ct ON (ap.vendor_id = ct.id)

         gl.description AS name, NULL as ustid,

         c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,

         FALSE AS invoice,

       FROM acc_trans ac

       LEFT JOIN gl      ON (ac.trans_id  = gl.id)

       LEFT JOIN chart c ON (ac.chart_id  = c.id)

      # Problem: we can't distinguish between AR and AP and normal invoices via boolean "invoice"

      # for AR and AP transaction exit the loop as soon as an AR or AP account is found

      # there must be only one AR or AP chart in the booking

        $notsplitindex = $j;   # position in booking with highest amount

        $absumsatz     = $trans->[$j]->{'amount'};

        last;