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

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) Standard Report Fields (Header - CountyCodeD) Standard Report Fields (Group Header sotype - CountyCode) Standard Report Fields (Group Header custno - CountyCodeS) Standard Report Fields (Detail - CountyCodeS) 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)

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
  

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

SO Type: Sales order number

• sotype1
  

Standard Report Fields (Group Header custno - CountyCodeS)¶

Customer

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

Standard Report Fields (Detail - CountyCodeS)¶

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