Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

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.

Image

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



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions