Jump to content

Edit History

Stickybit

Stickybit

Lad os give revisoren en friaften, og løse det selv. 🙂

Total salgsmoms på ordrer i shoppen Q1 2019: 

SELECT ROUND(SUM(`Presta_orders`.`total_paid_tax_incl` - `Presta_orders`.`total_paid_tax_excl`), 2) AS SalgsMoms FROM `Presta_orders` WHERE `Presta_orders`.`current_state` = 5 AND YEAR(`Presta_orders`.`invoice_date`) = 2019 AND QUARTER(`Presta_orders`.`invoice_date`) = 1

 

Stickybit

Stickybit

Lad os give revisoren en friaften, og løse det selv. 🙂

Total salgsmoms på ordrer i shoppen Q1 2019: 

SELECT ROUND(SUM(`Prestaorders`.`total_paid_tax_incl` - `Prestaorders`.`total_paid_tax_excl`), 2) AS SalgsMoms FROM `Prestaorders` WHERE `Prestaorders`.`current_state` = 5 AND YEAR(`Prestaorders`.`invoice_date`) = 2019 AND QUARTER(`Prestaorders`.`invoice_date`) = 1

 

×
×
  • Create New...