Index

A  C  D  E  F  G  I  K  L  M  N  O  P  Q  R  S  T  U  V  W 

---

A

AAIautomaticaccounting instructions, 4.2

ACA Most Profitable Brands Data Load program (R80D274)

processing options, 4.7.4

running, 4.7.5

ACA Most Profitable Customers Data Load program (R80D272)

processing options, 4.7.7

running, 4.7.8

ACA Most Profitable Products Data Load program (R80D273)

processing options, 4.7.10

running, 4.7.11

Access the Financial Ratios Account Dimension Configuration form, 5.2.3

accounts payable

alerts, 6.2.2

audit match alerts, 6.3.1

daily counts and amounts, 4.4.7

discounts, 4.4.4

metrics, 1.1.1

open payables, 4.4.10

overview, 4.4.1, 4.4.1, 4.4.1

vouchers paid late, 4.4.13

Accounts Payable Constants form, 6.2.6

accounts receivable

alerts, 6.2.3

daily counts and amounts, 4.5.9

delinquency information, 4.5.15

discounts, 4.5.6

metrics, 1.1.1

open chargebacks, 4.5.18

open receivables, 4.5.12

overview, 4.5.1

total chargebacks, 4.5.21

activity ratios

fixed asset turnover, 4.6.11

inventory turnover, 4.6.12

metrics, 1.1.1

overview, 4.6.2

total asset turnover, 4.6.13

actual versus planned

chart, 4.6.18

operating expense, 4.6.18

operating expense overview, 4.6.5

operating income, 4.6.18

operating income overview, 4.6.5

operating profit, 4.6.18

operating profit overview, 4.6.5

overview, 4.6.5

Add Whistle Blower Recipient List form, 6.6.4

after tax profit on sales

chart, 4.6.20

determining, 4.6.20

overview, 4.6.6

alerts

accounts payable audit match settings, 6.3.1

accounts payable settings, 6.2.2

accounts receivable settings, 6.2.3

compliance metrics, 6.1

credit limit settings, 6.4.1

expense policy settings, 6.5.1

general accounting settings, 6.2.1

generating, 3.4

amount of open invoices

chart, 4.5.12

example, 4.5.11.1

overview, 4.5.1

amount of vouchers paid late

chart, 4.4.13

example, 4.4.12.1

AP daily amounts chart, 4.4.7

AP daily counts and amounts

determining, 4.4.7

overview, 4.4.1

AP Daily Counts and Amounts Aggregate table (F80D253), A.1.5

AP Daily Counts and Amounts program (R80D253)

processing options, 4.4.5

running, 4.4.6

AP daily counts chart, 4.4.7

AP Discount Information Aggregate table (F80D254), A.1.6

AP Discount Information Data Load program (R80D254)

processing options, 4.4.2

running, 4.4.3

AP discounts

analyzing, 4.4.4

chart, 4.4.4

example, 4.4.3.1

overview, 4.4.1

AP open payables

evaluating, 4.4.10

overview, 4.4.1

AP Open Payables Aggregate table (F80D255), A.1.7

AP open payables amounts

chart, 4.4.10

example, 4.4.9.1

AP open payables counts

chart, 4.4.10

example, 4.4.9.2

AP Open Payables Data Load program (R80D255)

processing options, 4.4.8

running, 4.4.9

AP vouchers paid late

analyzing, 4.4.13

overview, 4.4.1

AP Vouchers Paid Late Aggregate table (F80D256), A.1.8

AP Vouchers Paid Late Data Load program (R80D256)

processing options, 4.4.11

running, 4.4.12

APaccounts payable, 4.4.1

APaccountspayable, 1.1.1

AR daily amounts chart, 4.5.9

AR daily counts and amounts

analyzing, 4.5.9

overview, 4.5.1

AR Daily Counts and Amounts Aggregate table (F80D280), A.1.12

AR Daily Counts and Amounts program (R80D280)

processing options, 4.5.7

running, 4.5.8

AR daily counts chart, 4.5.9

AR delinquency amounts

chart, 4.5.15

example, 4.5.14.1

AR delinquency counts

chart, 4.5.15

example, 4.5.14.2

AR Delinquency Data Load program (R80D281)

processing options, 4.5.13

running, 4.5.14

AR delinquency information

determining, 4.5.15

overview, 4.5.1

AR Delinquency Information Aggregate table (F80D281), A.1.13

AR discount information

chart, 4.5.6

example, 4.5.5.1

AR Discount Information Aggregate table (F80D282), A.1.14

AR Discount Information Data Load program (R80D282)

processing options, 4.5.4

running, 4.5.5

AR discount percentage

chart, 4.5.6

example, 4.5.5.2

AR discounts

evaluating, 4.5.6

overview, 4.5.1

AR Open Chargeback Amounts Aggregate table (F80D283), A.1.15

AR Open Chargeback Information Data Load program (R80D283)

processing options, 4.5.16

running, 4.5.17

AR open chargebacks

analyzing, 4.5.18

chart, 4.5.18

example, 4.5.17.1

overview, 4.5.1

AR open chargebacks by reason code

chart, 4.5.18

example, 4.5.17.2

AR open receivables

evaluating, 4.5.12

overview, 4.5.1

AR Open Receivables Aggregate table (F80D284), A.1.16

AR Open Receivables Data Load program (R80D284)

processing options, 4.5.10

running, 4.5.11

AR Total Chargeback Aggregate table (F80D285), A.1.17

AR Total Chargeback Information Data Load program (R80D285)

processing options, 4.5.19

running, 4.5.20

AR total chargebacks

chart, 4.5.21

determining, 4.5.21

example, 4.5.20.1

overview, 4.5.1

AR total chargebacks by reason code chart, 4.5.21

ARaccounts receivable, 4.5.1

ARaccountsreceivable, 1.1.1

automatic accounting instructions, 4.2

average invoice amounts chart, 4.5.9

---

C

charts

actual versus planned, 4.6.18

after tax profit on sales, 4.6.20

amount of open invoices, 4.5.12

amount of vouchers paid late, 4.4.13

AP daily amounts, 4.4.7

AP daily counts, 4.4.7

AP discounts, 4.4.4

AP open payables amounts, 4.4.10

AP open payables counts, 4.4.10

AR daily amounts, 4.5.9

AR daily counts, 4.5.9

AR delinquency amounts, 4.5.15

AR delinquency counts, 4.5.15

AR discount information, 4.5.6

AR discount percentage, 4.5.6

AR open chargebacks, 4.5.18

AR open chargebacks by reason code, 4.5.18

AR total chargebacks, 4.5.21

AR total chargebacks by reason code, 4.5.21

average invoice amounts, 4.5.9

current ratio, 4.6.16

days sales outstanding, 4.5.3

debt to total assets, 4.6.14

fixed asset, 4.6.11

forecasted cash flow, 4.8.10

inventory turnover, 4.6.12

most profitable brands, 4.7.6

most profitable customers, 4.7.9

most profitable products, 4.7.12

number of open invoices, 4.5.12

number of vouchers paid late, 4.4.13

profit margin on sales, 4.6.19

quick acid test, 4.6.17

return on net worth, 4.6.21

return on total assets, 4.6.22

revenue by brand, 4.8.5

revenue by division, 4.8.6

revenue by product, 4.8.7

times interest earned, 4.6.15

total asset turnover, 4.6.13

unposted transactions, 4.9.4

compliance

accounts payable audit match settings, 6.3.1

accounts payable settings, 6.2.2

accounts receivable settings, 6.2.3

alerts overview, 6.1

credit limit settings, 6.4.1

expense policy settings, 6.5.1

general accounting settings, 6.2.1

whistleblower, 6.6.1

compliance metrics, 1.1.1

accounts payable audit match settings, 6.3

credit limits, 6.4

expense policies, 6.5

system constants, 6.2

Copy Process form, 3.3.6

corporate governance

compliance alerts, 6.1

compliance metrics, 1.1.1

segregation of duties, 1.1.1, 3.1

whistleblower, 6.6.1

credit limit settings alerts, 6.4.1

current ratio

chart, 4.6.16

evaluating, 4.6.16

overview, 4.6.4

Customer Master Revision form, 6.4.3

---

D

daily counts and amountsAP daily counts and amounts, 4.4.7

daily counts and amountsAR daily counts and amounts, 4.5.9

Dashboard program (P80D350)

prerequisites, 4.3

data loading, 2.1

days sales outstanding

chart, 4.5.3

determining, 4.5.3

overview, 4.5.1, 4.5.2

debt to total assets

analyzing, 4.6.14

chart, 4.6.14

overview, 4.6.3

Delete Process form, 3.3.7

discountsAP discounts, 4.4.4

discountsAR discounts, 4.5.6

display type, 1.1.1

DSOdayssales outstanding, 4.5.3

---

E

examples

amount of open invoices, 4.5.11.1

amount of vouchers paid late, 4.4.12.1

AP discounts, 4.4.3.1

AP open payables amount, 4.4.9.1

AP open payables count, 4.4.9.2

delinquency amounts, 4.5.14.1

delinquency counts, 4.5.14.2

discount information, 4.5.5.1

discount percentage, 4.5.5.2

forecasted cash flow, 4.8.9.1

number of open invoices, 4.5.11.2

number of vouchers paid late, 4.4.12.2

open chargebacks, 4.5.17.1

open chargebacks by reason code, 4.5.17.2

total chargebacks, 4.5.20.1

unposted expense, 4.9.3.2

unposted income, 4.9.3.1

expense management policy settings alerts, 6.5.1

---

F

F80D010 table, A.1.1

F80D020 table, A.1.2

F80D203 table, A.1.3

F80D241 table, A.1.4

F80D253 table, A.1.5

F80D254 table, A.1.6

F80D255 table, A.1.7

F80D256 table, A.1.8

F80D272 table, A.1.9

F80D273 table, A.1.10

F80D274 table, A.1.11

F80D280 table, A.1.12

F80D281 table, A.1.13

F80D282 table, A.1.14

F80D283 table, A.1.15

F80D284 table, A.1.16

F80D285 table, A.1.17

F80D302 table, A.1.18

F80D701 table, A.1.19

Financial Management and Compliance Console

components, 4.1

data loading, 2.1

integrations, 1.2

load data, 2.1

metric groups, 4.1

overview, 1.1

fixed asset turnover

analyzing, 4.6.11

chart, 4.6.11

overview, 4.6.2

FMCCFinancial Managementand Compliance Console, 1.1

forecasted cash flow

analyzing, 4.8.10

chart, 4.8.10

example, 4.8.9.1

overview, 4.8.1

Forecasted Cash Flow Aggregate table (F80D203), A.1.3

Forecasted Cash Flow Data Load program (R80D203)

processing options, 4.8.8

running, 4.8.9

---

G

general accounting alerts, 6.2.1

General Accounting Constants form, 6.2.5

generate alerts, 3.4

GL Account Balances Fact table (F80D020), A.1.2

G/L Balances Fact Full Load UBE program (R80D0201)

processing options, 4.6.8

running, 4.6.10

usage, 4.6.1

G/L Balances Fact Rebuild UBE program (R80D0202)

processing options, 4.6.9

running, 4.6.10

usage, 4.6.1

goals, 1.1.1

grid for percentage of discounts not taken, 4.4.4

Group and Objects Revisions form, 3.3.5

---

I

integrations, 1.2

inventory turnover

chart, 4.6.12

determining, 4.6.12

overview, 4.6.2

---

K

key performance indicators, 4.1

KPIkey performance indicators, 4.1

---

L

leverage ratios

debt to total assets, 4.6.14

metrics, 1.1.1

overview, 4.6.3

times interest earned, 4.6.15

liquidity ratios

current ratio, 4.6.16

metrics, 1.1.1

overview, 4.6.4

quick acid test, 4.6.17

load data, 2.1

---

M

metric

goals, 1.1.1

type of display, 1.1.1

metric groups

accounts payable activity, 1.1.1

activity ratios, 1.1.1

AR and collections activity, 1.1.1

leverage and liquidity ratios, 1.1.1

profit, 1.1.1

profitability ratios, 1.1.1

profitability with ACA, 1.1.1

revenue management, 1.1.1

Metric ID Time Dimension Cross Reference table (F80D302), A.1.18

Most Profitable Brand Aggregate table (F80D274), A.1.11

most profitable brands

analyzing, 4.7.6

chart, 4.7.6

overview, 4.7.1

Most Profitable Customer Aggregate table (F80D272), A.1.9

most profitable customers

analyzing, 4.7.9

chart, 4.7.9

overview, 4.7.1

Most Profitable Product Aggregate table (F80D273), A.1.10

most profitable products

analyzing, 4.7.12

chart, 4.7.12

overview, 4.7.1

---

N

number of open invoices

chart, 4.5.12

example, 4.5.11.2

overview, 4.5.1

number of vouchers paid late

chart, 4.4.13

example, 4.4.12.2

---

O

open chargebacksAR openchargebacks, 4.5.18

open payablesAP open payables, 4.4.10

overview, 1.1

---

P

percentage of discounts not taken grid, 4.4.4

Policy Definition Entry form, 6.5.3

prerequisites

Dashboard program (P80D350), 4.3

financial ratios metrics, 4.6.7

loading data, 2.1.1

profitability management metrics, 4.7.3

sales revenue metrics, 4.8.2, 4.8.3

whistlblower, 6.6.2

Process Revision form, 3.3.4

Process SOD Violations program (R80D112)

processing options, 3.4.1

running, 3.4.2

profit

forecasted cash flow, 4.8.10

metrics, 1.1.1

profit margin on sales

analyzing, 4.6.19

chart, 4.6.19

overview, 4.6.6

profitability management

metrics, 1.1.1

most profitable brands, 4.7.6

most profitable customers, 4.7.9

most profitable products, 4.7.12

overview, 4.7.1

period balances, 4.7.2

profitability ratios

after tax profit on sales, 4.6.20

metrics, 1.1.1

overview, 4.6.6

profit margin on sales, 4.6.19

return on net worth, 4.6.21

return on total assets, 4.6.22

Purchasing Tolerance Rules Revisions form, 6.3.3

---

Q

quick acid test

chart, 4.6.17

determining, 4.6.17

overview, 4.6.4

---

R

R80D010 program, 4.8.2.1

R80D0201 program

processing options, 4.6.8

running, 4.6.10

usage, 4.6.1

R80D0202 program, 4.6.10

processing options, 4.6.9

usage, 4.6.1

R80D112 program

processing options, 3.4.1

running, 3.4.2

R80D203 program

processing options, 4.8.8

running, 4.8.9

R80D241 program

overview, 4.8.2.2

running, 4.8.4

R80D253 program

processing options, 4.4.5

running, 4.4.6

R80D254 program

processing options, 4.4.2

running, 4.4.3

R80D255 program

processing options, 4.4.8

running, 4.4.9

R80D256 program

processing options, 4.4.11

running, 4.4.12

R80D272 program

processing options, 4.7.7

running, 4.7.8

R80D273 program

processing options, 4.7.10

running, 4.7.11

R80D274 program

processing options, 4.7.4

running, 4.7.5

R80D280 program

processing options, 4.5.7

running, 4.5.8

R80D281 program

processing options, 4.5.13

running, 4.5.14

R80D282 program

processing options, 4.5.4

running, 4.5.5

R80D283 program

processing options, 4.5.16

running, 4.5.17

R80D284 program

processing options, 4.5.10

running, 4.5.11

R80D285 program

processing options, 4.5.19

running, 4.5.20

R80D701 program

processing options, 4.9.2

running, 4.9.3

return on net worth

chart, 4.6.21

evaluating, 4.6.21

overview, 4.6.6

return on total assets

analyzing, 4.6.22

chart, 4.6.22

overview, 4.6.6

revenue by brand

chart, 4.8.5

evaluating, 4.8.5

overview, 4.8.1

revenue by division

chart, 4.8.6

evaluating, 4.8.6

overview, 4.8.1

revenue by product

chart, 4.8.7

evaluating, 4.8.7

overview, 4.8.1

revenue metrics, 1.1.1

rules

hierarchy, 3.3.1

segregation of duties, 3.3.1

---

S

Sales Order Fact Data Load program (R80D010), 4.8.2.1

Sales Order Fact table (F80D010), A.1.1

sales revenue

by brand, 4.8.5

by division, 4.8.6

by product, 4.8.7

days sales outstanding, 4.5.3

metrics, 1.1.1

overview, 4.8.1

segregation of duties, 1.1.1

generating alerts, 3.4

overview, 3.1

rules, 3.3.1

whistleblower, 6.6.1

Send Whistle Blower Message form, 6.6.5

setup

segregation of duties, 3.1

Shipped Orders Aggregate table (F80D241), A.1.4

Shipped Orders Processing program (R80D241)

overview, 4.8.2.2

running, 4.8.4

SODsegregation of duties, 3.1

---

T

table mappings, A.1

times interest earned

chart, 4.6.15

determining, 4.6.15

overview, 4.6.3

total asset turnover

chart, 4.6.13

evaluating, 4.6.13

overview, 4.6.2

total chargebacksAR total chargebacks, 4.5.21

---

U

unposted expense

analyzing, 4.9.4

example, 4.9.3.2

overview, 4.9.1

unposted income

analyzing, 4.9.4

example, 4.9.3.1

overview, 4.9.1

Unposted Transaction Aggregate table (F80D701), A.1.19

Unposted Transaction Data Load program (R80D701)

processing options, 4.9.2

running, 4.9.3

unposted transactions

chart, 4.9.4

expense, 4.9.4

income, 4.9.4

overview, 4.9.1

---

V

vouchers paid lateAP vouchers paid late, 4.4.13

---

W

whistleblower

overview, 6.6.1

prerequisites, 6.6.2

Work With A/R Constants form, 6.2.7

Work With Segregation of Duties Rules form, 3.3.3