Please enable JavaScript to view this site.

 

mouse

Reports Menu > Sales Analysis > Invoice Based Sales Reports > Sales Invoice Price Exception Report

 

The Sales Invoice Price Exception Report allows users to generate a report displaying sales invoices where the sell prices have been manually changed from the customers default price, or where a discount % has been applied.

 

Sales Invoice Price Exception Report Screen

Sales Invoice Price Exception Report Screen

 

 

Parameter Name

Description

Starting Date

Ending Date

The starting and ending dates for the sales invoices you wish to see on the report.

Starting Customer

Ending Customer

Selected Customers

Starting Invoice Rep Code

Ending Invoice Rep Code

Selected Invoice Rep Codes

Starting Market Code

Ending Market Code

Selected Market Codes

Selected Classes

Selected Customer Groups

Parameters to restrict the customers you wish to see on the report.

Include Invs Excluded from S/A

Yes - Invoices that have been marked to be excluded from sales analysis will be displayed on the report.

Exceptions to Report

Discounts - Only sales invoices where the price charged was lower that the customer's default price, or where a discount % has been applied, will be displayed on the report.

Markups - Only sales invoices where the price charged was higher that the customer's default price will be displayed on the report.

Both - Sales invoices where any price other than the customer's default price has been charged will be displayed on the report.

Include Unupdated Invoices

Yes - Invoices that have NOT been updated will be displayed on the report.

Sort By

Invoice Date - The report will sort and display by invoice date.

Customer - The report will sort and display by customer.

Customer/Delivery Code - The report will sort and display by customer delivery code.

Account Manager - The report will sort and display by account manager.

Sales Rep (Invoice) - The report will sort and display by invoice sales rep.

Market Code - The report will sort and display by market code.

Customer Group - The report will sort and display by customer group.

Referral Source - The report will sort and display by referral source.

Warehouse - The report will sort and display by warehouse.

New Page per Section

Yes - When printed the report will print on separate pages when sorted by any of the Sort By parameters

 

When the required parameters have been entered, the Sales Invoice Price Exceptions Report will be generated.

 

Example of Sales Invoice Price Exception Report for Discounts only

Example of Sales Invoice Price Exception Report for Discounts only

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC