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

Page History: County Sales

Compare Page Revisions

9 8 7 6 5 4 3 2 1 0 Current 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 24 Jun 2009 10:44

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Type of Report to Run By Customer Number    Standard Report Fields (Header - CountyCode) =Standard Report Fields (Group Header sotype - CountyCode=)    Standard Report Fields (Group Header state - CountyCode)    Standard Report Fields (Detail - CountyCode)    Standard Report Fields (Group Footer state - CountyCode)    Standard Report Fields (Group Footer sotype - CountyCode) =Standard Report Fields (Page Footer - CountyCode=)    Standard Report Fields (Summary - CountyCode) By County Summary    Standard Report Fields (Header - CountyCodeC)    Standard Report Fields (Group Header sotype - CountyCodeC)    Standard Report Fields (Group Header state - CountyCodeC)    Standard Report Fields (Group Footer - CountyCodeC)    Standard Report Fields (Group Footer state - CountyCodeC)    Standard Report Fields (Group Footer sotype - CountyCodeC)    Standard Report Fields (Page Footer - CountyCodeC)    Standard Report Fields (Summary - CountyCodeC) By State Summary    Standard Report Fields (Header - CountyCodeS)    Standard Report Fields (Group Header sotype - CountyCodeS)    Standard Report Fields (Group Footer state - CountyCodeS)    Standard Report Fields (Group Footer sotype - CountyCodeS)    Standard Report Fields (Page Footer - CountyCodeS)    Standard Report Fields (Summary - CountyCodeS) By State Detail    Standard Report Fields (Header - CountyCodeD)    Standard Report Fields (Group Header sotype - CountyCodeD)    Standard Report Fields (Group Header custno - CountyCodeD)    Standard Report Fields (Detail - CountyCodeD) Standard Report Fields (Group Footer custno - CountyCodeD)    Standard Report Fields (Group Footer sotype - CountyCodeD)    Standard Report Fields (Page Footer - CountyCodeD)    Standard Report Fields (Summary - CountyCodeD) Additional Report Fields for Customization

Default Menu Location¶

Reports >> Sales Force >> County Sales

General Description¶

The County Sales reports allow tracking of missing MBMA county codes.

Click here for a screenshot

Report Filters¶

Date Range: Sales order date

Order Type: Sales order type

Sort Orders: Customer Number, County, State

Report Style: Summary, Detail

Type of Report to Run¶

By Customer Number: CountyCode

By County Summary: CountyCodeC

By State Summary: CountyCodeS

By State Detail: CountyCodeD

By Customer Number¶

Standard Report Fields (Header - CountyCode)¶

Company

• lc_company
  

As of Date

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

Order Type Selected

• '(' + lc_para + ')'
  

=Standard Report Fields (Group Header sotype - CountyCode=)¶

SO Type: Sales order number

• sotype1
  

Standard Report Fields (Group Header state - CountyCode)¶

State

• state
  

State Code

• mbmastate
  

Standard Report Fields (Detail - CountyCode)¶

Customer Number

• custno
  

County

• county
  

County Code

• mbmacounty
  

Sales

• exttot
  

% of Total

• per2
  

Standard Report Fields (Group Footer state - CountyCode)¶

State Subtotal

• exttot
  

Standard Report Fields (Group Footer sotype - CountyCode)¶

Order Type Subtotal

• exttot
  

=Standard Report Fields (Page Footer - CountyCode=)¶

Date/Time

• datetime()
  

• "Page" + alltrim(str(_pageno))
  

Standard Report Fields (Summary - CountyCode)¶

Report Total

• exttot
  

By County Summary¶

Standard Report Fields (Header - CountyCodeC)¶

Company

• lc_company
  

As of Date

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

Order Type Selected

• '(' + lc_para + ')'
  

Standard Report Fields (Group Header sotype - CountyCodeC)¶

SO Type: Sales order number

• sotype1
  

Standard Report Fields (Group Header state - CountyCodeC)¶

State

• state
  

State Code

• mbmastate
  

Standard Report Fields (Group Footer - CountyCodeC)¶

County

• county
  

County Code

• mbmacounty
  

Sales

• countysub
  

% of Total

• repperc
  

Standard Report Fields (Group Footer state - CountyCodeC)¶

State Subtotal

• exttot
  

Standard Report Fields (Group Footer sotype - CountyCodeC)¶

Order Type Subtotal

• exttot
  

Standard Report Fields (Page Footer - CountyCodeC)¶

Date/Time

• datetime()
  

• "Page" + alltrim(str(_pageno))
  

Standard Report Fields (Summary - CountyCodeC)¶

Report Total

• exttot
  

By State Summary¶

Standard Report Fields (Header - CountyCodeS)¶

Company

• lc_company
  

As of Date

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

Order Type Selected

• '(' + lc_para + ')'
  

Standard Report Fields (Group Header sotype - CountyCodeS)¶

SO Type: Sales order number

• sotype1
  

Standard Report Fields (Group Footer state - CountyCodeS)¶

Sales

• exttot
  

% of Total

• round((exttot/xxperc)*100,2)
  

Standard Report Fields (Group Footer sotype - CountyCodeS)¶

Order Type Subtotal

• exttot
  

Standard Report Fields (Page Footer - CountyCodeS)¶

Date/Time

• datetime()
  

• "Page" + alltrim(str(_pageno))
  

Standard Report Fields (Summary - CountyCodeS)¶

Report Total

• exttot
  

By State Detail¶

Standard Report Fields (Header - CountyCodeD)¶

Company

• lc_company
  

As of Date

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

Order Type Selected

• '(' + lc_para + ')'
  

Standard Report Fields (Group Header sotype - CountyCodeD)¶

SO Type: Sales order number

• sotype1
  

Standard Report Fields (Group Header custno - CountyCodeD)¶

Customer

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

Standard Report Fields (Detail - CountyCodeD)¶

Sales Order #

• sono
  

State

• state
  

State Code

• mbmastate
  

County

• county
  

County Code

• mbmacounty
  

Order Date

• ttod(sodate)
  

Sales

• exttot
  

% of Total

• per2
  

Standard Report Fields (Group Footer custno - CountyCodeD)¶

Customer Subtotal

• exttot
  

Standard Report Fields (Group Footer sotype - CountyCodeD)¶

Order Type Subtotal

• exttot
  

Standard Report Fields (Page Footer - CountyCodeD)¶

Date/Time

• datetime()
  

• "Page" + alltrim(str(_pageno))
  

Standard Report Fields (Summary - CountyCodeD)¶

Report Total

• exttot
  

Additional Report Fields for Customization¶