Welcome Guest, you are in: <root>AFIweb • Login

Page History: Customer Bookings Report

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Tue, 19 May 2009 11:06

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Group Header 1:Sales Order Type Standard Report Fields(Line Items)    Group Footer 1: Sales Order Type Standard Report Fields(Summary)

Default Menu Location¶

Reports >> Order Entry >> Customer Bookings Report

Click here for screenshot

General Description¶

Customer Bookings Report displays Sales Orders by type, by company, and their spending per year.

Fields/Filters¶

Date Range: Specific time frame for the report

Custno: Customer number or customer code

Order Type: Order type for the report

Sales Person: Sales person for the report

Whse: Warehouse location

Report Style: Can either be a Summary or Detail report

Standard Report Fields(Page Header)¶

Company

• lc_company
  

Date Range

• ' As of ' + dtoc(date())
• '( ' + lc_para + ' )'
  

Group Header 1:Sales Order Type¶

Sales Order Type

• sotype1
  

Standard Report Fields(Line Items)¶

Custno

• alltrim(company) + ' ( ' + alltrim(custno) + ' )'
  

Sales

• extstot
  

% of Type

• per1
  

% of Type

• per2
  

YTD Sales

• ytdsales
  

Group Footer 1: Sales Order Type¶

Sales

• exttot
  

YTD Sales

• ytdsales
  

Standard Report Fields(Summary)¶

Report Total

• exttot
• ytdsales