I want to get a report similar to the Sales Detail Report but that shows all the SKUs in the same field or row - I need one row per order. Also, I want to be able to see the subtotal and the total as would appear on the Doc60. <COMMENTS> Steven Chung On Thu, 13 Jan 2022 at 13:59, Steven Chung < steven@ollieorder.com > wrote: Andrew and Justin, We have an existing Sales by SKU Report and I've attached a sample report. What's missing from this report to address your needs? --- From: Andrew Doyle < andrew@lonetreecellars.com > Date: Thu, Jan 13, 2022 at 5:09 PM Subject: Re: Sales by SKU Report To: Steven Chung < steven@ollieorder.com > Cc: Justin Pineau < justin@lonetreecellars.com > Hey Steven, We looked at that report, and it really has no value to us (it seems to be redundant to the other reports). Our goal is to show sales of 1 SKU by Customer, and be able to show cases or dollars as the value. I have pasted below a screenshot of the info we pulled from the PIVOT. In the pivot, I have filter by product name "Blasted Church Pinot Gris". In my rows, I see the customers that are buying it and in the values the cases they have orders over the time period selected, 0 · Internal · January 18, 2022 · Reply Alison Costello Is it possible to select multiple warehouses when pulling this report? Right now you can only select all or select one. 0 · September 14, 2021 · Steven Chung Kristina Dyk Could you let me know if the following report addresses this need? https://app.ollieorder.com/sellers/18367/reports/sales_report?reset=true&q%5Bfirst_dimension%5D=sku&q%5Bsecond_dimension%5D=product_name&q%5Bthird_dimension%5D=none&q%5Bpivot_dimension%5D=month&q%5Bmeasure%5D=net_revenue&q%5Bdate_between_dates%5D=2021-01-01+00%3A00+to+2021-09-08+23%3A59 0 · Internal · September 8, 2021 · Reply Sophie Oliver marked this post as PLANNED Hi there! We will be building the Ollie Order equivalents of the Ollie Logistics Sales Summary & Sales Expanded reports. These reports will include 1 row per order and will include the subtotals, totals, deposits, and taxes on the order. The Sales Expanded report will include columns for your SKUs. 0 · May 7, 2021 dogwood@dogwoodbrew.com Sophie Oliver: Thanks for the update. Do you know when I can expect this report to be available for me to use?
