County Sales

Modified on Tue, 30 Mar 2021 08:50 by Ryan Horne — Categorized as: Metal Construction Industry, Order Entry, Sales Force

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¶