Create a customer invoice report INVOICE The Sample Outdoors Company 3755 Riverside Drive Ottawa, Ontario K1G 4K9 613-555-1440 INVOICE NUMBER: 806445 DATE: Mar 15, 2016 PAGE: 1 ustomer Name Action Fact ales Person Agnes Ramos hip Date Mar 20, 2012 rder erms Web Net 30 Item Number Unit sale price Quantity Price 6 301.8 143120 Trendi Trendi sunglasses feature a sporty, stylish, wrap-around design. Soft rocker nose pads and rubberized temple ends provide the ultimate in comfort 50.30 Order Number 806445 301.8 Please make check payable to: THE SAMPLE OUTDOORS COMPANY. Tax Exempt # 538576 1. NO RETURNS without RMA (Return Merchandise Authorization) 2.15% restocking charge will be applied to returned merchandise 3.18% interest per annum will be charged on overdue accounts. SUBTOTAL TAX TOTAL S301.80 $24.14 S325.94 Thank you for your business! As a report author for The Sample Outdoors Company, you have been asked to create a standardized invoice that can be sent to customers whenever an order is processed. You will use the query items from the GO data warehouse (query) packagelSale and Marketing (query) folderSales (query) namespace To build this report you will start with a blank report, and build a query, named OrderNumber, based on the Order number data item . create a prompt page with two value prompts, one to select the customer Retailer name from Retailers) and one to select sales representative Employee name from Employee by region) Rename the queries as follows: . Query 1: Retailer Name Query Query2: Sales Rep query specify that the data for each order should be on a new page by defining a page set associated with the OrderNumber query, grouping by order number, and defining a detail page associated with the OrderNumber query . . create a page header with the company logo (logojpg) and address: The Sample Outdoors Company 3755 Riverside Drive Ottawa, Ontario K1G 4K9 613-555-1440 add invoice information to the header, for example: Invoice number, Date, and Page create the top portion of the page body with general information about the order for example: Customer Name, Sales Person, Order Method, Ship Date and Terms . . . add a list report to the page body with the following columns: Order number, . combine the product and description into a single column and change the title of . using a block and a table, add the order number group footer, tax calculation, and Product number, Product, Description, Unit Sale Price, Quantity and Revenue the product number column to Item Number closing information Create a customer invoice report INVOICE The Sample Outdoors Company 3755 Riverside Drive Ottawa, Ontario K1G 4K9 613-555-1440 INVOICE NUMBER: 806445 DATE: Mar 15, 2016 PAGE: 1 ustomer Name Action Fact ales Person Agnes Ramos hip Date Mar 20, 2012 rder erms Web Net 30 Item Number Unit sale price Quantity Price 6 301.8 143120 Trendi Trendi sunglasses feature a sporty, stylish, wrap-around design. Soft rocker nose pads and rubberized temple ends provide the ultimate in comfort 50.30 Order Number 806445 301.8 Please make check payable to: THE SAMPLE OUTDOORS COMPANY. Tax Exempt # 538576 1. NO RETURNS without RMA (Return Merchandise Authorization) 2.15% restocking charge will be applied to returned merchandise 3.18% interest per annum will be charged on overdue accounts. SUBTOTAL TAX TOTAL S301.80 $24.14 S325.94 Thank you for your business! As a report author for The Sample Outdoors Company, you have been asked to create a standardized invoice that can be sent to customers whenever an order is processed. You will use the query items from the GO data warehouse (query) packagelSale and Marketing (query) folderSales (query) namespace To build this report you will start with a blank report, and build a query, named OrderNumber, based on the Order number data item . create a prompt page with two value prompts, one to select the customer Retailer name from Retailers) and one to select sales representative Employee name from Employee by region) Rename the queries as follows: . Query 1: Retailer Name Query Query2: Sales Rep query specify that the data for each order should be on a new page by defining a page set associated with the OrderNumber query, grouping by order number, and defining a detail page associated with the OrderNumber query . . create a page header with the company logo (logojpg) and address: The Sample Outdoors Company 3755 Riverside Drive Ottawa, Ontario K1G 4K9 613-555-1440 add invoice information to the header, for example: Invoice number, Date, and Page create the top portion of the page body with general information about the order for example: Customer Name, Sales Person, Order Method, Ship Date and Terms . . . add a list report to the page body with the following columns: Order number, . combine the product and description into a single column and change the title of . using a block and a table, add the order number group footer, tax calculation, and Product number, Product, Description, Unit Sale Price, Quantity and Revenue the product number column to Item Number closing information
