Tax Totals with Rates by Order Report

[lin-d-hop]

Description

As a hub manager I want to be able to view report that includes a breakdown of what is paid per order for each tax rate.

A mock of the report data in CSV form is available here.

• Enterprise: The hub for which the correlating order was placed
• Order cycle: Identifier for the order cycle in which the order was placed
• Tax Category: Self explanatory.
• Tax Rate: Self explanatory.
• Total (tax excl): Total of orders without tax
• Total (tax): Total tax applied in orders
• Total (tax incl): Total including tax (eg sum of last two rows)
• First Name: First name of the shopper
• Last Name: Last name of the shopper
• Customer Code: Self explanatory
• Email: From the order

Note that after each Order a row of totals will be displayed.

The filters for this report will be the same as #6848. The only addition required for this report will be to enable the user to select between 'By Producer' and 'By Order'

• By Producer/By Order (Dropdown): Allows user to view the report sorted by Producer or by Order

Acceptance Criteria & Tests

1. All fields described above are present and data matches the description
2. Report can be downloaded as a CSV
3. Report can be accessed via the UI
4. Report can be filtered on all fields mentioned above
5. Totals row show correctly summed total amounts
6. In the UI figures should be rounded to 2 decimal places. In the CSV figures should be rounded to 6 decimal places.
7. All fields are translatable

[kirstenalarsen]

Can we please repeat any identifying and context information on the Totals rows when they are included, and that info makes sense in an 'aggregate' - so that when the user filters to use only the Totals rows they have the info about Enterprise, OrderID etc easily to hand