Welcome to the new BBC Data Warehouse System. This program houses a wealth of information for users across all disciplines on the wholesale side of the operation. What follows is a brief overview of the modules and the reports and the navigation screen. Please note that not all modules/reports will be available to all users.
Module: Sales
This module will house all sales and profitability reports. You can review product performance, customer performance and salesperson performance.
Reports that are available within the Sales Module:
- Sales Summary: This is the report that has the Sales and Forecasts. It can be run by division/customer, customer/division, or if you are a sales manager you can see it across multiple sales people.
- Salesperson: This is a quick report to see all business assigned to the specific salesperson defined by the year/season selected. This is a great drill-down report
- Product Performance: This will give the top performing styles as defined by specific criteria chosen
- Customer Performance: This will give the top customers for a defined set of criteria
- New Orders: This report lists all the orders entered for a defined period
- Estimated Gross Profit (limited): This report will list all orders entered for a defined period that exceed or fail to meet specific gross profit requirements
Module: Inventory
This module will house all inventory and availability reports and analysis on aging and purchasing
Reports that are available within the Inventory Module:
- Summary by Status: Gives a snapshot of the current availability by status including picked, overbooked, available, on hand etc. Gives a good idea where inventory is and in what stage of progress.
- Availability: This has been referred in the past as the Salesman Stock recap. For any business you can see the availability by size for all stock numbers within the defined parameters. This will include current and future availability
- Availability at Once: This report only includes the inventory that is available today in the warehouse
- On Hand: This report lists by style/size the inventory that is currently in the warehouse regardless of the orders pending against it
- Exposure Season Analysis: This is a report used to analyze the currency of the inventory. The pairs are broken down by year/season and can be drilled into to determine exactly where liabilities may be
- Product: This will give a snapshot of a specific stock number (please note you must include gender for this to work). The output includes the basics of the shoe construction, HTS, inventory position, and the top customers who have purchased the model
- Inventory Purchase Tool: A limited availability report for the planners/buyers to make the inventory buys and manage the assortments
- Warehouse: A snapshot by warehouse of the current inventory status
Module: Customer orders
This module will provide access to all customer orders and associated information
Reports that are available within the Customer Orders Module:
- Customer Order Detail: This report provides all of the data on an order or a group of orders. This may be limited to the specific customers assigned to the salesperson. This report will display the lines of the order including the sizes. Please note that this report has a lot of data and will be timely to run. It is highly suggested you limit the parameters of the report to speed up processing times.
- Customer Order summary: This is a slimmed down version of the Customer Order report above with only the vital information and rolls up the sizes of each stock number into one line
- Customer Order: This provides the details of a specific order
- Customer: This is a great drill down report which displays all order totals by state (invoiced, open) for specific customers rolled up over a number of years.
- Discounted Orders: This report is limited in availability and will detail all order discounts for all customers given a set of criteria
- Division: Similar to the customer report this is a nice drilldown report that lists all orders by state (invoiced, open) for a particular division over a number of years.
Module: Production
This module will provide access to all Production and Factory Information
Reports that are available within the Customer Orders Module:
- Factory annual totals: This is a management report that lists all production orders flowing through the wholesale factory base by month.
- Factory Orders: This is a detailed report of all factory orders for given set of criteria. This report will show each line by style/color/size. It can take time to process and is highly suggested you narrow down the search parameters to speed up processing time.
- Factory Order Logistics: This is a report used by the transportation department to manage inbound shipments
- Factory PO: This provides the details of a specific Factory Order
- Factory: This allows the user to run a report by division for a particular factory or a group of factories
- Orders received: This report will detail out the receipts for a given period of time and set of criteria
Module: Management
This module will provide access to all Management Reports
Currently this module is in production