1. I'm setting up a view for "Orders" that should reflect what comes out on the customer review and invoice. order review
The order subtotal which I imagine is based on the "Sell Price" is not given in the field selection list. If I set up a view using "Ordered Products" "Sell Price" is listed as an available field. On the other hand "Order: Total Cost" is available as a field for an "Orders" view so I would have thought that "Sell Price" would be available as well. Because it's a "Orders" view, it doesn't seem to make a difference if I try to create a computed field on the content type. It still isn't available. How can I get the information over to the field list for an "Orders" view?

2. I am also using "Order: Line item: Tax amount". The difficulty here lies in the fact that I have 2 tax rates creating two records which works out to be a double order. table view
This is set up as a data export .xls but the table isn't usable. This is how I'd like the table to look:
desired table
Is there a way to coose either the 7% or 19% tax rate when selecting the "Order: Line item: Tax amount"?

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

ebo1958 created an issue. See original summary.

TR’s picture

Status: Active » Fixed

For #1, the subtotal field you're looking for is:
"Order: Total cost (Total cost) - The total cost of the products in the order."

For #2, that's the way Views works. If you want to combine the two returned rows and display one column with the sum of both taxes, you can use a SUM() aggregation, which is built into Views. If you want to combine the two returned rows and display the two taxes as separate columns, you'll also have to use aggregation but I don't think the built-in Views aggregation will allow you to do that, instead you can use a helper module like the views_aggregator to get that functionality.

ebo1958’s picture

FileSize
66.14 KB

Thank you for your reply. For #1, It seems that the "Order: Total cost (Total cost) - The total cost of the products in the order." is reading out the field "Costs: Your store's costs," on the product form which is mostly "0".
costs
What I'm looking for is the next field "Customer purchase price".
Would this work somehow?

ebo1958’s picture

Status: Fixed » Active