In order to report on Consignment Items

Go To:

Reports > Reports > Sales Analysis > Product Sales Report

The product sales report query window will open up.

Here you create a new report.

Click on the New button on the Task Bar

Enter in a Report Name, I've entered a report name of Consignment Sales. Keep the Use Default Design box checked and click on the Apply button

A new window will appear where you will refine the design of your report. The name on the window header will be the name you entered as a report name. Mine reads Consignment Sales.

In the Detail section of the window click on the Design Detail Layout button

The Report Column Designer will appear.

Click on the Column Select button on the Task Bar

The Column Select window will appear

• Start by clicking on the In Use button, this will show you the columns that are currently on your new report.
• Since you are looking to report on Consignment Sales by Vendor (Consignor) there are a few columns here you don't need.
• In the Use Field check boxes uncheck Discount Retail and Cost of On-Hand. Uncheck any others that you don't think you need on the report as well.

Now we are going to add a column to the report.

• Click on the Product button
• Scroll down to the bottom and check the Use Field box next to Vendor Name
• Click on the Apply button

You will be brought back into the Report Column Designer

Here you will see Vendor Name on the far right of the report

• Click on the Column Header and drag the name to the far right.
• You will probably want to drag the Sales Cost column over to the left of Total Net as well.

Once you have the columns in the correct positions click on the Apply button

You are now back at the Consignment Sales window.

Within the Detail section click on the Sorts and Groupings button

Here you will want to add a Vendor grouping

• Click on the Add button just below the Apply button (it is pink with a yellow plus sign
• A new row under Group will appear
• Click on the dropdown bar and select Vendor Name
• Check the box under Header if you want the Vendor Name to be the Heading of the Group
• Check the box under Footer if you want the Vendor Name to be the Footing of the Group
• If you want a page break after every grouping, check that box as well.
• Choose whether you'd like the Sort Order to Descend or Ascend (A-Z or Z-A in the case of a Vendor Name)
• You can also choose to Group the Report by Store Number if you are running this report for multiple stores, if you choose to group by store, that ruler should be above the Vendor Name Grouping.

When you are done adding groupings click on the Apply button

You are brought back to the Consignment Sales window, click on the Save button

Now you are back in the Query - Product Sales Report

In the Select Using section of the window

• Click on the Manage Saved Queries button
• Select the Create a new query to save option
• Enter in a name for this query, call it Consignment and click the OK button
• Under Select Field click on the dropdown bar and choose New Used
• Under Select Operation click on the drop down bar and choose =
• Under Choose Value click on the drop down bar and choose Consignment Product
• Click on the Add button to the right
• Click on the Manage Saved Queries button again and now choose Save the current query, you see a quick message pop up once the query is saved.

From here you could select your type of Period (Week, Month, Day), choose your start and end dates and click on the Submit button in the task bar to run your report.

Or you can add another Query that will allow you to run the report based on Vendor Name.

In order to add another query to run the report by looking up a specific vendor

• Click on the Manage saved queries button and select Create a new query from this query
• You will be prompted to name the new query, lets call it Consignment Vendor
• Click on the OK button
• In Select Field click on the dropdown bar and choose Vendor Name
• In the Select Operation choose =
• in Choose Value you will enter the vendor name with quotations like "Mark Hochreiter"
• Again click on the Manage saved queries button and select Save the current query
• Fill out Period on Which to Report fields
• Click on the Submit button and you get your report for the specific vendor (consignor)