Navigation¶

• Adjutant Wiki Home
  

• CRM Wiki
  

• AFI Wiki
  

• Categories
• All Pages
• Create a new Page
  

• Administration
• File Management
  

• Login/Logout
• Consultant Guide
• Your Profile
• Create Account
  

Quick Search
»


Advanced Search »

County Sales

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Type of Report to Run By Customer Number - CountyCode    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 - CountyCodeC    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 - CountyCodeS    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 - CountyCodeD    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.

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 - CountyCode¶

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 - CountyCodeC¶

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 - CountyCodeS¶

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 - CountyCodeD¶

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¶