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

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

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