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:27

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Type of Report to Run 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) 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) 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)

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

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
  

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
  

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