9. Checking for Consistency in Data

9.1 Introduction

The information required to calculate profit and charges is maintained using different maintenance functions. The information that you maintain should be authorized and complete in all respects. For example, you cannot calculate profit or charges for an account, or an account class, that is yet authorized. You would be using incomplete information to calculate profit for an account if you have built a formula into a profit rule after you have linked the rule to a product.

Before you liquidate profit for an account or account class, you must ensure that inconsistencies in data do not exist. The ‘IP Consistency Check’ function checks and reports inconsistencies in the data that you have maintained.

9.2 Maintenance Consistency Check

This section contains the following topics:

9.2.1 Running Maintenance Consistency Check

The IP Maintenance Consistency Check is run automatically when the end of transaction input is marked. When you liquidate profit on an ad-hoc basis, the IP Consistency Check function automatically checks for inconsistent data. You can also generate the maintenance consistency check report, anytime.

The IP Maintenance Consistency Check reports the following inconsistencies in data:

Note

Before you liquidate profit for an account manually, you must generate the Maintenance Consistency Check Report from the Application Browser.

9.2.2 Unauthorized Accounts

You cannot liquidate profit for an account that is unauthorized. When you run the auto liquidation process at the end of day, the IP Consistency Check reports all unauthorized accounts, which fall due for profit liquidation for the day. Before you can go ahead with the automatic liquidation process, you must authorize all accounts that were reported by the consistency check.

Note

You cannot liquidate profit for an account class if an account belonging to the account class is unauthorized.

9.2.3 Unauthorized Account Classes

You cannot liquidate profit using the auto liquidation function, when a class of accounts is unauthorized. When you run the auto liquidation process for the day, IP Maintenance Consistency Check reports all unauthorized account classes, which fall due for profit liquidation. Before you run the auto liquidation function, you must authorize all unauthorized account classes.

Similarly, you cannot liquidate profit for an unauthorized account class using the ad hoc liquidation function.

9.2.4 Unauthorized Currency Details

You cannot liquidate profit using the auto liquidation function, if a currency that you have maintained is unauthorized. Typically, such a situation would arise when you modify the financial details relating to a currency, in the Currency Maintenance table, and do not authorize it before you run the automatic profit liquidation function.

Authorize the reported currency before you run the automatic liquidation function again.

9.2.5 Details of Invalid Products or Rules

You cannot liquidate profit for accounts that are linked to unauthorized products or profit rules. Inconsistencies in data, maintained for all product–rule combinations, will be reported by IP Consistency Check function. Inconsistent data for each combination will be reported under three heads:

Unauthorized product

The IP Maintenance Consistency Check function reports all products that you have linked to an unauthorized profit or charge product.

You have to authorize any modification of a rule before you attempt to liquidate profit for the accounts on which you have applied the rule.

Unauthorized rule

The IP Maintenance Consistency Check will report an unauthorized profit or charge rule.

Invalid Accounting Entry Setup

If you have defined a product with an imperfect account entry setup, the IP Maintenance Consistency Check will report it. Typically, the IP Maintenance Consistency Check reports an invalid accounting entry setup when you modify an profit rule and do not make the required changes to the products (on which you have applied the rule).

It is vital that when you create or make changes to a profit rule you change the corresponding details, for products linked to the rule.

If you have allowed accruals for a Profit rule, but have not maintained the Accounting Roles and Heads for the accrual entries, while defining the product on which you apply the rule, the Maintenance Consistency check will report this as an inconsistency. Similarly if you have disallowed accruals for a Profit Rule but have specified accounting roles and heads for the product the maintenance consistency will report this as an inconsistency.

For example, if you modify or create a new formula for a rule, the accounting entries setup for the products to which you have linked the rule would change. If you do not make the required changes for the product, the maintenance check will report the inconsistency as an ‘invalid account entry setup’.

The other inconsistencies reported as ‘invalid account entry setup’ could be caused when

Original Formula Type Changed Formula Type Product setup to be changed
Non Booking Booking Accounting Role and Head, and the accounting entries to be posted for the event not defined.
Non Booking Tax Accounting Role and Head, and the accounting entries to be posted for the event not defined.
Booking Tax Accounting Role and Head, and the accounting entries to be posted for the event not defined.

When an invalid accounting entry setup is reported for a product–rule combination, rectify it in the product screens.

9.2.6 Unauthorized General Conditions

All unauthorized changes to any General Condition, that you have defined, will be reported by the IP Consistency Check. You will recall that when you define preferences for a product, you can indicate if you wish to apply the product to a specific account or to an account class or classes. When a product is applied on an account class rather than a specific account, it is referred to as a ‘General Condition’.

The account class, the currency of the account class, the product to which the account class is linked and the unauthorized UDE values will be reported.