Merchandiser Report

Merchandiser Report

This document outlines the procedure for running the Merchandiser Report in KNAPS.

Step 1. Navigate to the Merchandiser Report screen

To open the Merchandiser Report screen, on the main KNAPS menu click on Reports, then click Merchandising, then click the Merchandiser menu item.

The following screen will be displayed

Running the Merchandiser Report

Step 1.

As necessary, fill in the fields to filter the report search and results. Alternatively, you may leave all fields empty for maximum report output.

Step 2.

Select any of the following options.

Step 3.

Click the button to run the report.

You may also download the report results in CSV format by clicking the button.

The following is the information displayed on the report CSV file.

Column Name	Column Description
code	Product Code
name	Product Name/Description
brand_name	Brand of Product
product_category	Category Product belongs to
core_group	Core Group Product belongs to
on_hand	Number of items in stock for that product
on_order	Number of items on order for that product
on_sale	Number of items sold yet to be delivered
status	Active or Inactive
total_sales	Total sales for that product
total_orders	Total orders for that product
go	Go Price
go_special	Special Go price
rrp	Recommended Retail Price
rrp_special	Special Recommended Retail Price
trade	Trade Price
off_invoice	Off Invoice value
invoice	Invoice Value
vendor_percent	Applicable Vendor discount percentage value
vendor_dollar	Applicable Vendor dollar discount value
bonus_percent	Applicable percentage bonus value
bonus_dollar	Applicable dollar bonus value
brand_percent	Applicable brand percentage value
hoff_percent	Support Office percentage discount value
hoff_dollar	Support Office dollar discount value
net	Product Net value
sellthru_dollar	Applicable Sell Through dollar value
nac	Net After Clam value (Excl. tax.)
catalogue	Special Catalogue value
net_incl	Net Value (Incl. tax)
nac_incl	Net After Claim value (Incl. tax)
gp	Gross Profit value
gp_nac	Gross Profit Net After Claim
12-2023-orders	Any Orders placed for product on this date

To print ticket lists of the products in the report results, click the button. Clicking this button will bring up the following pop-up screen.

The fields marked in pink are mandatory fields.