Reports

The How To and FAQ's about Blastramp's Reports feature.
How To ...
View Sales and Bookings by Date Range
This report takes a look at all the orders that match the select search criteria, and display a summary of units and dollars for that date range you select. Once the report is generated you can click into those values for more information.

Navigation: Reports > Sales and Bookings by Date Range

REPORT TYPES

The output of this report depends on the 'Report Type' selected.
Customer - summarize sales/bookings by Customer Name based on the Ship To Address. This groups all orders up according to the customer profile they are associated with.
Orders - summarize sales/booking by Order ID on its own row, with a summary of the quantities associated to each order.
Rep - summarize sales/bookings by Rep Name. This groups all orders together according to the Sales Rep they are associated with.

START DATE / END DATE

Use these two filters to set a start date to match orders on, and to specify which field the start date applies to. The date can be matched against when the order first booked, when the order was allocated, when the order shipped, when the order is expected to start shipping and cancelled.

SELECT LINELIST

Use this filter to look at all the orders that match the linelist season code associated to that order. ALL Linelist will display at all the orders that are associated to a season code.
TIP: If you want to filter more then one specific linelist click the "shift" button on your keyboard.
SELECT PRICELIST

Use this filter to set what price you to want to report on, based on the pricelist you have set up.
Gross Value - Will pull the value of the order.
Net Value (Value of Goods, Addtl Charges, Discounts/Credits) - will pull the value if the orders have any Additional Charges and/or any Discount/Credits applied to the order.

SELECT DATE MODE

Use this filters to limit orders included in the report to those that are currently in the selected Status(es).

SELECT OUTPUT

Use this filter to select Units, Dollars or Both to display on report.

COMBINE ALL WAREHOUSES?

If you have multiple warehouses on your portal, it will allow you to display orders from all warehouses in your search.

INCLUDE BACK ORDERS?

This check box can be used to determine if Back Orders should be included in the report or not.
Note: In this report, back orders are considered to have a '0' value for Booked units, as the booked units are taken into account on the primary order.

BREAKDOWN BY

These check boxes allows you to view the information by Day / Week / Month.
Add Categories to Products
Product categories are a great way to add more information when reporting inventory. You have the ability to add up to 5 different categories to your products and filter them when running your reports in the Inventory tab.
INSTRUCTIONAL VIDEO COMING SOON!
Examples of product categories are:
- Manufacturers / Mens vs. Womens / Type of garment Tees, Pants, Shoes etc. When you select one it will only pull inventory for that category.
- Another area that you can use these product categories is in the Query-Inventory Report under the Reports tab. Just select those categories to generate your report.

ADDING PRODUCT CATEGORIES TO YOUR STYLES

Option 1: Manually through Mass Edit function.

Navigation: Inventory > Mass Edit > Select Linelist > Select your first Product Category (from Field to Edit) > GO.

Then go back and add your next Product Categories as desired. Once done when you run your Inventory report, those categories will display as a dropdown option.

Option 2: Mass upload with your linelist through the utility function.

Navigation: Advanced > Utilities > Upload Linelist via Copy and Paste from Excel.

To add them with your linelist upload, when you create your template, run the macro on your output tab you can add the different categories in the blank columns (up to 5 max).

When you do your upload map your columns (from section 1) by clicking "click here to view more upload options" to view the category fields to map those columns in section 2.

That will upload the information and create that drop down option as well under the Inventory report.
Monitor Daily Warehouse Activity
MAIN TAB

The Main Page is your one stop for an overview of all processes going on in the warehouse. It is a summary of all inbound and outbound activity.

Work in Process: Work in Process outlines all activity in the warehouse. This data is presented in Units, Lines (SKUs), Orders/Receipts and Value. The work categories presented are:

Staged Shipments: Shipments that have been added into staging in the dashboard as arrived but not yet being received.

Being Received: Shipments that have been released to the DC and are currently being received and verified by the warehouse.

Awaiting Download: Orders released to the DC and not yet downloaded and being worked on.

Being Picked: Downloaded Pick tickets on the warehouse floor currently being worked on.

In Pack & Hold: Orders that have been picked and packed and are now being held from shipping until customer release and or payment collection.

Being Shipped: Packed Orders being shipped out of the facility.

These categories are all blue links and when clicked will provide more details on specific Orders/Shipments, notes made against them, and the date the process started and how long the work has been taking. The Order/Shipment ID's are also live links that provide a further level of detail by taking you to the respective summary.

View All Open Orders: At the bottom of the Work in Process box you can "View all open orders”. This is an open pick summary of all open orders and lists the total number of orders, Order ID, Customer Name, Date released, Days since released, Current Status and Comments. The Order ID’s are blue links that when selected dig deeper to an Order Detail summary and the Comments (or the three dots if blank) are a link to a pop up comments box providing the ability to leave a comment.

The Month Summary: The Month Summary reports all the work processed by the facility by date and report type.

Month Summary Report Period lets you select the month and year for the report to display.

Month Summary Report Type lets you select the report type from a drop down for the report to display. The options for report type are:

Receiving: Shipments that have been released to the DC and are currently being received and verified by the warehouse.

Picking – Pick/ Pack: Orders picked, packed and updated by the warehouse.

Shipping – Pick / Pack: Orders picked, packed and shipped by the warehouse.

Shipping – Cross Dock: Pre-packed orders shipped by the warehouse.

Shipping – Both: Shipped orders both from pre-packed orders and pick/pack orders.

Returns: Processed and closed returns inspected by the warehouse.

Once the report period and report type are selected, the report will present by day Units, Lines (SKUs), Orders/ Receipts and Value. Each day is a blue link that when selected will present a summary of units, lines and value for all report types.

On the top right of this summary you can click the “Turn detailed view ON“link. This detailed view displays all the report types for that specific day, but also list the actual Order ID’s, Shipment ID's and Return ID’s, which are all blue links to summary pages.

REPORTS TAB - Daily Warehouse Activity

this report will allow you to enter a date and view all the different activities completed by the warehouse in that date range and the charges associated with these dates.
This report can be exported to excel!

REPORTS TAB - Units left to pick by Order

If you are looking to see the amount of units still on the floor and not updated as picked, this Report will outline for you by Order ID.
Generate Sales Margin Report
This report takes a look at all orders that match the select search criteria, and displays a summary of the charges in the format selected. The output of this report depends on the 'Report Type' selected.

Navigation: Reports > Sales Margin Report

REPORT TYPES

Order: This displays each order on its own row, with a summary of the Booked/Allocated value of goods on the order, and the associated Cost of Goods for each order.
Customer: This groups all orders up according to the customer profile they are associated with, based on the Ship To Address.
Rep: This groups all orders together according to the Sales Rep they are associated with.
Product By SKU: This version still looks at all the orders that match the search criteria, but once it has identified the orders, it then breaks all the orders out into the SKUs on each order, and summarizes the totals, and values of the items on the orders.
Product By Style: Only available if your portal is set up for Apparel Formatting. This acts the same as Product by SKU, but it groups all sizes of each Style-Color into a single row.

ADDITIONAL COLUMNS

Include Additional Charges? This check box can be used to determine if an order had any additional charges on the order and it will display it as a separate column value.
Include Credits? This check box can be used to determine if an order had a credit added on the order and it will display it as a separate column value.

DATE FILTERS

Start Date Field / Start Date: Use these two filters set a start date to match orders on, and to specify which field the start date applies to. The date can be matched against when the Order was first booked, when the order is expected to start shipping, the cancel, or expiry date of the order, or when the order was shipped.
End Date Field / End Date: The same as the filters for Start Date, but this filter applies to the end of the report range.

Start Date: March 28th, 2016 00:00am
End Date: April 28th, 2016 11:59pm

INCLUDE BACK ORDERS?

This check box can be used to determine if Back Orders should be included in the report or not.
Please note: In this report, back orders are considered to have a '0' value for Booked units, as the booked units are taken into account on the primary order.

SALES REPS

This filter can be used to limit orders included in the report to those that are associated with the selected Sales Rep(s).

ORDER STATUS

This filter can be used to limit orders included in the report to those that are currently in the selected Status(es).

WAREHOUSE

If you have rights to view multiple warehouses on your portal, you will be displayed with another drop down, to allow you to include additional warehouses in your search for orders. Please note, when using a Cost of goods price list, each warehouse can have the same price list set up with a different currency code. If this is the case, it is advisable to run the report for each DC separately, rather than just changing the filter from DC to DC as this might impact reporting.
Generate Query-Sales Order Report
Query-Sales Order report will let you customize the report by selecting criteria fields, the option to include order contents and be able to filter your criteria to make your report as specific as you want.

Navigation: Reports > Query-Sales Order

1. To select your fields from the left to the right for a new report, double clicking the word or highlight and click the ">>" icon to add or remove the field.
2. Choose if you would like to Include Order Contents by either selecting "Yes, on the same line" or "Yes, on its own line" and you have the option to Include UPC in Order Contents.

NOTE: UPC's must be uploaded for this feature to display.

3. Select the Product Category of the SKU to include in the report.
To add product category to a SKU, use mass edit or include as part of the linelist upload.
4. The option to add a filter you need to select the Order Field from a drop down, add the Operation and add the Criteria.

NOTE: When selecting the Order Field, you need to ensure you have it selected above. 

5. We have order codes for reporting you can use when you select field "Current Status" as follows:

O1 and O2 = ORDERS CREATED
O3 = ORDERS RELEASED
O4 = ORDERS SHIPPED
OC = CANCELLED

6. If you add a filter to only display shipped orders, you would add O4 in the criteria and it will display only orders with that code.
7. Click Now create your report to view the report.
8. The report will display and you can export it into an Excel document by clicking the icon "export to excel".

If you want to run a specific report on a regular basis, there is an option to Save Template As by entering a name to save the template.

Next time you want to run the report, select it under Load Template > click Load. It load with the settings you selected.
Generate Return Summary Report
This report gives you a summary report of all the returns entered in Blast Ramp for a specific date range, price, and category. You can choose how you want the information to display by either Summary or Detail.
INSTRUCTIONAL VIDEO COMING SOON!
Navigation: Reports > Returns Summary Report

NOTE: The output of this report depends on what parameters you select.

Report Start date and Report End date: These will determine what dates the returns were created in Blast Ramp.
Price List1 and Price List2: You can have up to two price lists to choose from to show the dollar total you specify.
Category: You can select a specific Inventory category or All.
Status: You can select at what stage the return is at either Open, Closed or All.
View: You can choose from a Summary or Detail report output.
CONTACT US
7137 Venture St
Delta, BC V4G 0A2
(604) 940-2228

® Blastramp 2021. All Rights Reserved. Blastramp is a subsidiary of Evolution Group.