1. I'm setting up a view for "Orders" that should reflect what comes out on the customer review and invoice.
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.
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:
Is there a way to coose either the 7% or 19% tax rate when selecting the "Order: Line item: Tax amount"?
Comment | File | Size | Author |
---|
Comments
Comment #2
TR CreditAttribution: TR commentedFor #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.
Comment #3
ebo1958 CreditAttribution: ebo1958 commentedThank 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".
What I'm looking for is the next field "Customer purchase price".
Would this work somehow?
Comment #4
ebo1958 CreditAttribution: ebo1958 commented