Adjutant Wiki MW Pivot Skin

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