View source for County Sales

__NOTOC__

==Default Menu Location==

Reports >> Sales Force >> County Sales

==General Description==

The County Sales reports allow tracking of missing MBMA county codes.

[[File:County_Sales.png]]

==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==

[[Category:Order Entry]]