The Invoice Category Charges by Cost Center inquiry produces
a stacked vertical bar chart that shows each invoice
category's charges for the preceding month. Each bar is
composed of the charges for each high-level cost center.
Figure 6-38 is a sample of the chart.
INTENDED USE:
The bar chart shows the Invoice Category Charges for various
high-level cost centers.
DATA SOURCE (file):
ACTRCP - Financial Recap File
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
RCPTYPE - Financial Recap Type
(Charges, Credits, zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM4, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTPM4 - Invoice Category Charges by Cost Center | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 01 - _____________________________________ | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | +----------------------------------------------------------------------------------+
Invoice Category Charges by Cost Center HERNDON DEVELOPMENT FOR NOVEMBER, yyyy INQUIRY: ACTPM4 RUN DATE: 14DECyy Charges Sum | DDDDD | DDDDD | DDDDD 600000 + DDDDD | DDDDD | DDDDD | DDDDD 500000 + DDDDD | DDDDD | DDDDD | DDDDD 400000 + DDDDD | DDDDD | DDDDD | DDDDD 300000 + DDDDD | DDDDD | DDDDD | AAAAA DDDDD 200000 + AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA 100000 + AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA DDDDD | AAAAA AAAAA DDDDD -------------------------------------------- C C T E H E N A R T N M R N I A E N L L A S L P S R O C E S S O Invoice Category Symbol COSTCTR1 Symbol COSTCTR1 A ALF D DEP
Figure 6-38. Invoice Category Charges by Cost Center
The Invoice Credits by Cost Center inquiry produces a pie
chart depicting how credits are distributed to the various
high-level cost centers. Figure 6-39 is sample of the chart.
INTENDED USE:
The bar chart shows that each slice represents a cost
center's relative share of the total credits.
DATA SOURCE (file):
ACTRCP - Financial Recap File
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
RCPTYPE - Financial Recap Type
RCPCHG - Amount Billed (format MONEY is used for this
chart. If RCPCHG value is large you can
modify the format to meet your need (e.g.
format BEST.)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM5, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | | | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTCM5 - Invoice Credits by Cost Center | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 01 - _____________________________________ | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | +----------------------------------------------------------------------------------+
Invoice Credits by Cost Center HERNDON DEVELOPMENT FOR NOVEMBER, yyyy INQUIRY: ACTPM5 RUN DATE: 21DECyy Sum of RCPCHG by COSTCTR1 *************** ALF ****** ****** **** **** *** *** ** ** ** ** ** ** * * ** ** ** ** ** ** ** 191398.7 ** * 63.17% * ** ** * * * * * * * * * * * * * * * * * + . . .. . .. . .. . .. . .. . .. . * * . * * . . * * . . * * .. . * * . . * * . . * * .. . * * . . * ** . . 89645.16 ** * .. . 29.59% * ** . . ** ** . 21936.31 . ** ** .. 7.24% . ** ** . . ** * .. . * ** . ** ** . ** ** . ** IIS *** . *** DEV **** . **** ****** ****** ***************
Figure 6-39. Invoice Credits by Cost Center
The Cost Center Charges by Invoice Category inquiry produces
a stacked vertical bar chart that shows the preceding month's
charges for any or all high-level cost centers. Figure 6-40
is sample of the chart.
INTENDED USE:
The chart shows that each bar depicts charges applicable to
the different invoice categories.
DATA SOURCE (file):
ACTRCP - Financial Recap File
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
RCPTYPE - Financial Recap Type
(Charges, Credits, discounts, surcharges,
zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM6, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTCM6 - Cost Center Charges by Invoice Category | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 01 - _____________________________________ | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | +----------------------------------------------------------------------------------+
Cost Center Charges by Invoice Category HERNDON DEVELOPMENT FOR NOVEMBER, yyyy INQUIRY: ACTPM6 RUN DATE: 14DECyy Charges Sum | BBBBB | BBBBB 700000 + BBBBB | BBBBB | BBBBB | BBBBB | BBBBB 600000 + BBBBB | BBBBB | BBBBB | BBBBB | BBBBB CCCCC 500000 + BBBBB CCCCC | BBBBB CCCCC | BBBBB BBBBB | BBBBB AAAAA | BBBBB AAAAA 400000 + BBBBB AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA 300000 + AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA 200000 + AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA 100000 + AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA | AAAAA AAAAA -------------------------------- ALF DEP Cost Center Symbol INVCCAT Symbol INVCCAT Symbol INVCCAT A CENTRAL PROCESSOR B CHANNELS C TERMINALS
Figure 6-40. Cost Center Charges by Invoice Category
The Invoice Discounts by Cost Center inquiry produces a pie
chart depicting how credits are distributed to the various
high-level cost centers. Figure 6-41 is sample of the chart.
INTENDED USE:
The chart shows that each slice represents a cost center's
relative share of the total credits.
DATA SOURCE (file):
ACTRCP - Financial Recap File
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
RCPTYPE - Financial Recap Type
RCPCHG - Amount Billed (format MONEY is used for this
chart. If RCPCHG value is large you can
modify the format to meet your need (e.g.
format BEST.)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM7, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTPM7 - Invoice discounts by Cost Center | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 01 - _____________________________________ | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | +----------------------------------------------------------------------------------+
Invoice Discounts by Cost Center TESTING AT SAS V913 FOR DECEMBER, yyyy INQUIRY: ACTPM7 RUN DATE: 21DECyy Sum of RCPCHG by COSTCTR1 *************** ****** ****** **** **** *** *** ** . ** ** .. ** ** . ** DEP * . * ** . ** ** . ** ** . ** ** . 65000.00 ** * .. 8.61% .. * ** . .. ** * . . . * * . . . * * . . . * ALF * . . . * * . .. 62570.00 * * .. .. 8.29% * * . .. * * .. * * + . . .. . .. . .. . .. . .. . .. . * * * * * * * * * * 627570.1 * * 83.11% * * * * * ** ** * * ** ** DEV ** ** ** ** ** ** * * ** ** ** ** ** ** *** *** **** **** ****** ****** ***************
Figure 6-41. Invoice Discounts by Cost Center
The Monthly Net Revenue Summary inquiry produces a vertical
bar chart that represents net revenue for a selected number
of months for any or all high-level cost centers. Figure 6-42
is sample of the chart.
INTENDED USE:
The bar chart shows monthly revenue for each month at
high-level cost centers.
DATA SOURCE (file):
ACTRCP - Financial Recap File
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
RCPTYPE - Financial Recap Type
(Charges, Credits, discounts, surcharges,
zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM8, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | | | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTPM8 - Monthly Net Revenue Summary | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 12 - 01 | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | +----------------------------------------------------------------------------------+
Monthly Net Revenue Summary HERNDON DEVELOPMENT INQUIRY: ACTPM8 RUN DATE: 14DECyy Net Revenue Sum | ***** 500000 + ***** | ***** | ***** | ***** ***** | ***** ***** 400000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 300000 + ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** 200000 + ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** 100000 + ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** -------------------------------------------- yyyy/ 2 yyyy/ 3 yyyy/ 4 Month
Figure 6-42. Monthly Net Revenue Summary
The Monthly Invoice Credit/ Discount Summary inquiry produces
a stacked vertical bar chart depicting the credits and
discounts provided each month over a specified period of
months for any or all high-level cost centers. Figure 6-43
is sample of the chart.
INTENDED USE:
The bar chart shows the relative share of credits and
discounts for each month at any level of cost center.
DATA SOURCE (file/timespan):
ACTLGR - Ledger File at the MONTHS timespan.
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
LGRCHG - Amount Billed
RCPTYPE - Financial Recap Type
(Charges, Credits, discounts, surcharges,
zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPM9, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | | | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTPM9 - Monthly Invoice Credit/Discount Summary | | | | ------------------------------------------------------------------------------ | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 12 - 01 | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | +----------------------------------------------------------------------------------+
Monthly Invoice Credit/Discount Summary HERNDON DEVELOPMENT INQUIRY: ACTPM9 RUN DATE: 16DECyy Cost Revenue Sum | ..... | ..... ..... | ..... ..... 600000 + ..... ..... | ..... ..... | ..... ..... | ..... ..... | ..... ..... 500000 + ..... ..... | ..... ..... | ..... ..... | ..... ..... | ..... ..... 400000 + ..... ..... | ..... ..... | ..... ..... | ..... ..... | ..... ..... 300000 + ..... ..... | ..... ..... | ..... ..... | ..... ..... | ..... ..... 200000 + ..... ..... | ..... ..... | ..... ..... | ..... ..... | ..... ..... 100000 + ..... ..... ..... | ..... ..... ..... | ..... ..... ..... | ..... ..... ..... | ..... ..... ..... -------------------------------------------- yyyy/ 7 yyyy/ 8 yyyy/9 Month Symbol CATEGORY .
Figure 6-43. Monthly Invoice Credit/ Discount Summary
The Weekly Processing Charges Summary inquiry produces a
vertical bar chart showing the total charges processed during
the preceding seven days for any or all high-level cost
centers. Figure 6-44 is sample of the chart.
INTENDED USE:
The bar chart shows each day charges for any high-level cost
centers.
DATA SOURCE (file/timespan):
ACTLGR - Ledger File at the DAYS timespan.
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
LGRCHG - Amount Billed
RCPTYPE - Financial Recap Type (Charges ,Credits, discounts,
surcharges, zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPW1, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+----------------------------------------------------------------------------------+ | ------------------------- Execution-Time Parameters ------------------------ | | Command ===> Scroll ===> CSR | | | | Executing CA MICS Inquiry: ACTPW1 - Weekly Processing Charges Summary | | | | ------------------------------------------------------------------------------ | | Enter the Data Base ID. (1 character) for the Data Base to be processed. | | _____________________________________ - _____________________________________ | | | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 07 - 01 | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | +----------------------------------------------------------------------------------+
Weekly Processing Charges Summary HERNDON DEVELOPMENT INQUIRY: ACTPW1 RUN DATE: 14DECyy Charges Sum | ***** 900000 + ***** | ***** | ***** | ***** | ***** 800000 + ***** | ***** | ***** | ***** | ***** 700000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 600000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 500000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** ***** | ***** ***** ***** 400000 + ***** ***** ***** | ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** 300000 + ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** 200000 + ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** ***** 100000 + ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** ***** -------------------------------------------------------------------------------------------- yyyy/12/ 6 yyyy/12/ 7 yyyy/12/ 8 yyyy/12/ 9 yyyy/12/10 yyyy/12/11 yyyy/12/12 Date
Figure 6-44. Weekly Processing Charges Summary
The Weekly Processing Charges by Invoice Category inquiry
produces a vertical bar chart showing the total charges
processed during the preceding seven days for any or all
high-level cost centers. Figure 6-45 is sample of the
chart.
INTENDED USE:
The bar chart shows each day's charges for any high-level
cost centers by Invoice Category.
DATA SOURCE (file/timespan):
ACTLGR - Ledger File at the DAYS timespan.
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Categories
LGRCHG - Amount Billed
RCPTYPE - Financial Recap Type
(Charges, Credits, discounts, surcharges,
zero balance adjustments)
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTPW2, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+-----------------------------------------------------------------------------------+ | | | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> CSR | | | | Executing CA MICS Inquiry: ACTCW2 - Weekly Charges by Invoice Category | | | | ------------------------------------------------------------------------------ | | Enter the Data Base ID. (1 character) for the Data Base to be processed. | | _____________________________________ - _____________________________________ | | | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 07 - 01 | | | | Specify the Cost Centers to be reported or leave blank to report all. | | _____________________________________ - _____________________________________ | | | | Specify the invoice categories to be reported or blank to report all. | | _____________________________________ - _____________________________________ | | | +-----------------------------------------------------------------------------------+
Weekly Processing Charges by Invoice Category HERNDON DEVELOPMENT INQUIRY: ACTPW2 RUN DATE: 14DECyy ---------------------------------------------- Invoice Category=CENTRAL PROCESSOR(S) ----------------------------------------------- Charges Sum | ***** | ***** | ***** 350000 + ***** | ***** | ***** | ***** | ***** 300000 + ***** | ***** | ***** | ***** | ***** ***** 250000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 200000 + ***** ***** ***** | ***** ***** ***** | ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** 150000 + ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** 100000 + ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** ***** 50000 + ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** ***** -------------------------------------------------------------------------------------------- yyyy/12/ 6 yyyy/12/ 7 yyyy/12/ 8 yyyy/12/ 9 yyyy/12/10 yyyy/12/11 yyyy/12/12 Date
Figure 6-45a. Weekly Processing Charges by Invoice Category (Part 1 of 2)
Weekly Processing Charges by Invoice Category HERNDON DEVELOPMENT INQUIRY: ACTPW2 RUN DATE: 14DECyy ---------------------------------------------------- Invoice Category=CHANNELS ----------------------------------------------------- Charges Sum | ***** | ***** 500000 + ***** | ***** | ***** | ***** ***** | ***** ***** 400000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 300000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** ***** | ***** ***** ***** 200000 + ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** 100000 + ***** ***** ***** ***** | ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ***** -------------------------------------------------------------------------------------------- yyyy/12/ 6 yyyy/12/ 7 yyyy/12/ 8 yyyy/12/ 9 yyyy/12/10 yyyy/12/11 yyyy/12/12 Date
Figure 6-45b. Weekly Processing Charges by Invoice Category (Part 2 of 2)
This Inquiry enables you to generate a Comma Separated Value
(CSV) file extracted from the Accounting Financial Recap
file. The ACTRCP inquiry also creates a Data Transfer
Profile that provides descriptive information about the CSV
file metrics. Data Transfer Profiles are used by the iCan
Provider Suite when processing CSV files.
INTENDED USE:
Generated CSV file that will allow the iCan chargeback
solution to utilize data from CA MICS Accounting and
Chargeback.
DATA SOURCE (file/timespan):
ACTRCP - Financial Recap file at the MONTHS/TABLES
timespan.
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
RCPCHG - Amount Billed
ACTINVTS - Invoice Timestamp
ACTMONTH - Accounting Month
ACTYEAR - Accounting Year
DATASRC - Data Source (Component or File ID)
INVCCAT - Invoice Category
INVCAT - Invoice Category (Description)
MONTH - Month of Year
RCPCLVL - Cost Center Level
RCPCPC - Billable Computation Code
COMPCODE - Billable Computation code(Description)
RCPILVL - Invoice Level
RCPQNT - Number of Billable Items
RCPRAT - Billing Rate
RCPSTAT - Billing Status
RCPSTYPE - Record Sub-type
RCPTYPE - Record Type
SYSID - System Identifier
YEAR - Year of Century
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTRCP, whose Catalog Group is FINANCE.
o Complete the Execution-Time Parameters panel illustrated
below. (If you are not familiar with MICF, see the
CA MICS MICF Reference Guide.)
+---------------------------------------------------------------------------------+ | | | ------------------------- Execution-Time Parameters ------------------------- | | Command ===> Scroll ===> PAGE | | | | Executing CA MICS Inquiry: ACTRCP - Generate CSV file from Financial Recap | | | | ------------------------------------------------------------------------------ | | Enter range of CA MICS online file cycles or enter ARCHIVE for archive files. | | 01 - _____________________________________ | | | +---------------------------------------------------------------------------------+
The Budget Threshold Report lists the percentage of the
budget that has been expended. This report is produced when
actual month-to-date charges in the ledger file exceed the
percentage of the budget allocated for each month, as
specified in user-defined thresholds. One of the options when
you produce this report is to activate alerting through an
interface with the ServicePlus Service Desk when the
thresholds have been exceeded.
The report is generated by executing MICF inquiry ACTSVD.
We recommend that you schedule this MICF inquiry weekly in
production reporting so you can use it to adjust the
budget. Figure 6-46 is sample of the report.
INTENDED USE:
One of the options when you produce this report is to
activate alerting through an interface with the ServicePlus
Service Desk when the thresholds have been exceeded.
DATA SOURCE (file/timespan):
ACTRCP - Current Ledger File at the MONTHS timespan.
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Category
RCPCHG - Amount Billed
RCPCPC - Billable Computation Code
RCPRAT - Billing Rate
RCPSTAT - Billing Status
HOW TO PRODUCE THE REPORT:
o Enter the CA MICS Workstation Facility (MWF).
o Choose option 2, CA MICS Information Center Facility
(MICF).
o Choose option 2, Database Inquiries.
o Select ACTSVD, whose Catalog Group is FINANCE.
o Select options for Budget Threshold Report
+------------------------------------------------------------------------------------------------+ | | |----------------------- Budget Threshold Report ---------------------------------------- | | Command ===> | | | | Threshold Alerting ===> YES (YES/NO) | | | | Report format name ===> COSTCTR (COSTCTR/COMPCODE) | | | | Cost center level of line items ===> 1 (1 - 3 ) | | | | Generate report when budget amount exceed percent ===> 25_ (0-999) | | threshold | | | | Budget Table number ===> 01 (00 = Work or 01 = Active) | | | | | | Press ENTER to validate, END to run, or CANCEL to terminate execution. | +------------------------------------------------------------------------------------------------+
Threshold Alerting - YES|NO. Defaults to NO.
If the option is set to YES, the ServicePlus Service Desk
will be alerted when the percent of the budget actually
used exceeds the threshold specified by the Percent
Budget Amount Threshold option.
For more information on using the ServicePlus Service
Desk alert facility, see Section 4.9 of the PIOM.
Report Format - COMPCODE | COSTCTR. Defaults to COMPCODE.
Computation code format prints line items that are
summarized by computation code and rate. Cost center
format prints line items that are summarized at the cost
center level.
Cost Center Level - 1 | 2 | 3. Defaults to 1.
This field defines the cost center level at which line
items will be summarized on the report. Valid values are
1 to 3.
Percent Budget Amount Threshold - 0-999. Defaults to 0.
This field defines the threshold. Use it to specify what
percent of the budget is allocated for each month. The
Budget Threshold Report will be produced when the percent
of the budget actually used exceeds this threshold.
Budget Table - Work | Active. Defaults to Work.
The active budget table contains budgeted amounts for the
last accounting period. The active budget is referred to
as (01).
The work budget table contains all the budgeted amounts in
the active table, plus budgeted amounts for future
accounting periods, such as next month or next fiscal
year. Budgeted amounts are copied from the work table to
the active table by the CLOSETBL batch job when they
become effective. The work budget table is referred to as
(00).
USAGE CONSIDERATIONS
This inquiry provides a user exit that you can use to
perform additional data selection from the CA MICS database.
To invoke this exit, you must first copy the shared inquiry
into your private MICF catalog; then select it for
modification. Finally code SAS statements in the SELECT
macro, bracketed by the %MACRO and %MEND statements.
The default for the SELECT macro is null. This macro is
invoked when the observations are read from the specified
CA MICS files. You can use it to delete observations from
the data as it is selected. For example, in a system
activity study, you could select the cost centers that start
with A. You would then code the following:
%MACRO SELECT;
IF COSTCTR1 =:'A';
%MEND SELECT;
Note that you do not have to code the %MACRO and %MEND
statements; they are already provided for you.
COMPLEX REPORT CA MICS IS Management Support System Budget Threshold Report TO: Security DEVELOPMENT: Security FMT: Computation Code 1034 Wood Oak DR. PAGE NO. - 1 Reston, VA. 21234 BILL DATE - 08/16/07 STATUS: BILL Budget Used: 25% CATEGORY RESOURCE / UNITS QUANTITY RATE CHARGES BUDGET % BUDGET EXPENDED ---- -------------------------- ------------- ------------- ----------------- -------------- ----------------------- 1100 CENTRAL PROCESSOR(S) (0023) TCB SECONDS 7687.799 $3.0000 $23,063.40 $50,000 46.13 (0024) SRB SECONDS 491.690 $4.0000 $1,966.76 $7,000 28.10 (0252) STEPS 18744.000 $6.0000 $112,464.00 $150,000 74.98 1200 CHANNELS (0097) 1000 EXCPS 11624.121 $5.0000 $58,123.79 $75,000 77.50
Figure 6-46. Budget Threshold Report
|
Copyright © 2014 CA.
All rights reserved.
|
|