1. Start Date 1 is the first date of the first period on the top row - 12 periods in total.
2. Start Date 2 is the first date of the first period on the bottom row - 12 periods in total.

1. 1M - the user is able to compare figures for all 12 months of the entire year.
2. 1W - the user is able to compare figures for all 12 weeks of the entire quarter.
3. Enter other standard Navision intervals: 15D, 1W, 1Q (# is the quantity)
   i. #D = by day
   ii. #WD = by weekday
   iii. #W = by week
   iv. #M = by month
   v. #Q = by quarter
   vi. #Y = by year
   

1. Customer Detail - a detail list of all items that were invoiced to the customer will be presented.
2. Customer Summary - a summary total will display for each period for each customer.

1. Item Quantities - The report will show invoiced item quantities.
2. Item Amount - The report will show invoiced amounts.

1. Landscape - The report has been formatted to Landscape so all 24 periods can be printed on one page.
2. The report header section will show the following information:
   a) Report Title
   b) Company Name
   c) Filters used
   d) 2 rows of dates with 12 periods in each row.
   
3. The report is sorted by Customer. The user can select any sort method Navision normally has for the table such as No. & Search Name.
4. The report shows all items for each customer and all quantities or dollar amounts for each item for the 24 periods specified. At the end of the report, totals for the 24 periods will appear on a separate page.

The user will have normal Navision filtering capabilities of the Customer and Value (Item ledger) entry tables such as Departments and Projects.

The following conditions have been incorporated for this report:

1. For a customer to appear on the report, the sales for the customer and item combination must appear for at least one period.
2. For an Item to appear on the report, at least one period must have a non zero value. Some quantity of this item must have been sold to the customer during any of the 24 periods.
3. Information presented in this report is from the Value (Item Ledger) Entry table for "Entry Type" = Sale only. This includes credit memos that have been posted.

Customer Sales Period Comparison Sample Report

To order enhancements please click here.