What is a Report Base?

Report Base is an important field used to create reports in the vinSUITE Report Builder. Report Base provides a list of basic reports with standard information and fields that serve as the starting point before you customize your own reports. The Report Base Definitions section provides a brief summary of each basic report included in the Report Base list.

Report Base Definitions

Allocation Offering

Summary report for the members an allocation or allocations have been offered to and the open period for that allocation.

Club Member Report

This report will give you member details and club membership information for anyone who has a club membership (both active and cancelled) on the eWinery system. The report defaults to looking for Active members only, to view both active and cancelled remove the ?ActiveClubMember?? filter in Step 2.

Gift Card Usage Report

This report will show you a list of all orders that used a eWinery gift Certificate as tender.

Member

This report is the widest net you can cast against member data in your database. This report will show you any attribute for your members with the exception of sales data.

Member Addresses

This is a summary report for all of the address info for each member. Results will be the member name, billing address, shipping address (primary from address book) and club shipping address.

Member Value Report

This report looks at the spending habits of all of your customers. It takes into account all sales channels and returns results for Total spend, average spend and last purchase. This is an excellent report for identifying your top customers.

Payment Detail

Offers a list of sales with Order Type and Payment Type details. Used for reconciling credit card statements and sales.

This is a sales report that looks breaks down orders by line item. This is the most detailed information you can get against sales records.
*The Report Base list also displays a modified version of this report which reports the void orders which are normally excluded from this report.

Sales Summary

This is a summarized version of the report above, one line per order with no item breakdown.
*The Report Base list also displays a modified version of this report which reports the void orders which are normally excluded from this report.

Sales Tax by State

This is a version of the sales Summary Report above that looks specifically at Ship to States and Sales Tax.

TPI Report

This report pulls the data required for the Quickbooks integration utilizing the Transaction Pro Importer tool.

Will Call Report

This is another version of the Sales Summary report that only looks at orders that have a shipping type of ?Will Call?. This report includes the ability to filter by whether or not the order has been picked up.