Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: County Sales

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Wed, 24 Jun 2009 10:10



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





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