( SELECT SUM (`INI-amount-INV-currency`) AS total FROM `VIEW_REPORT_INVOICEITEM` WHERE `INI-invoice#`=`#invoice` GROUP BY `INI-invoice#` ) AS `INV-amount-INV-currency`