Talk:De/EÜR
From GnuCash
Neustart mit MySQL
- CREATE OR REPLACE VIEW `GCfibu`.`UStVa` AS SELECT YEAR( `transactions`.`post_date` ) AS `Y`, QUARTER( DATE_ADD( `transactions`.`post_date`, INTERVAL 2 HOUR) ) AS `Q`, `accounts_ext`.`UStVa`, SUM( `splits`.`value_num` )/100 AS `EUR` FROM `GCfibu`.`transactions` AS `transactions`, `GCfibu`.`splits` AS `splits`, `GCfibu`.`accounts` AS `accounts`, `GCfibu`.`accounts_ext` AS `accounts_ext` WHERE `transactions`.`guid` = `splits`.`tx_guid` AND `accounts`.`guid` = `splits`.`account_guid` AND `accounts`.`code` = `accounts_ext`.`codeID` GROUP BY `Y`, `Q`, `accounts_ext`.`UStVa` HAVING ( ( `accounts_ext`.`UStVa` > 0 ) ) ;