Revaluation Request - Calculations

A.   Housekeeping

1.   The CPF file access status codes (category 015) are retrieved from the Reference file (REFERP).

2.   The default company/location (category 119) is retrieved from the Reference file (REFERP) using the common subroutine ZDFLO.

3.   The Management Account Processing Option is retrieved from Reference File category 133 and an indicator is set appropriately.

B.   Mainline

1.   The company/location is validated as follows:

a.   Both company and location fields must be filled.

b.   The company/location must exist on the Reference file (REFERP).  This is checked using the common subroutine ZCHKLO, which references category 002.

c.   The user must be authorized to the company/location.  This is checked using the common subroutine ZATHLO, which references category 120.

d.   The company/location must be demand posted in the current period.  This is checked using Reference File category 106.

e.   The current period must be open to accept journal entries.  This is checked using Reference File category 123.

2.   The sequence code indicates the reporting sequence.  The reporting sequence is validated to be either:

A    -           Account sequence

C    -           Center sequence

F    -           Currency (financial) sequence

3.   The revaluation flag indicates whether the revaluation request should generate accounting transactions.  The revaluation flag is validated to be either:

P    -           Post and report

R    -           Report only

4.   The account/center fields are validated depending upon the state of the revaluation flag:

a.   If the revaluation flag is set to P then all account/center fields must be blank meaning all accounts are to be revalued.

b.   If the revaluation flag is set to R then the following conditions apply :

(1)  The account field must be filled if the center field is entered.

(2)  If a to account is entered than a from account must be entered.

(3)  If a range of account centers is entered then the to and from account/centers must be in the sequence specified by the sequence code.

(4)  If a single account/center is specified then it must exist on the Multi-currency Master file (GLMLTL).

(5)  If a range of accounts is specified then an account must exist within the range specified.

(6)  If the Management Account Processing Option in category 133 is set to yes, the Reporting Class must be either blank, F(fiscal) or M(management).

5.   The currency field is validated according to the state of the sequence code:

a.   If the sequence code is A or C then the currency field must be blank.

b.   If the sequence code is F then the currency field may be blank or may be a selected currency code.  A selected currency code is validated against the Currency Rate Master file (CF240M).

6.   Only when all the conditions are valid will the program allow the user to generate a revaluation request job.

7.   The Revaluation Select program (GL270E) calls the Command Language program (CLP) GL271C, and is called by the (CL) program GL270C.

Data Field Validation

GL270S01--Revaluation Selection Screen

GL270E Program Menu

• Purpose
• Calculations
• Files
• Screens