Documentation >
MAC-PAC Technical Library >
Financial >
General Ledger >
Programs >
General Ledger Post Multi-currency Update - Purpose >
General Ledger Post Multi-currency Update - Calculations
General Ledger Post Multi-currency Update - Calculations
GL202P
A. Housekeeping
1. Parameters and key lists are set up, fields and constants are defined and initialized, and information is retrieved from the Reference file.
2. Calculations are performed to determine the values for current period, last period, current year, last year, and the appropriate quarter.
B. Mainline
1. If this is not a new year (the new year indicator (NEWYR) = NO), the Multi-currency Account Master file (GLMLTL) is accessed for the current year. Otherwise, it is a new year and the file is accessed for the previous year. The first account record is read from the file. If any errors occur, an error message is displayed and processing either ends abnormally or continues, depending on the severity of the error.
2. The following processing occurs until an end-of-file message is encountered (MLSTAT = MSGEOF):
a. The Financial Cumulative Transaction file (GLCMTRL6) is accessed to retrieve the transaction data for the multi-currency record. If a corresponding transaction record is not found, then the Entered Amount (CMEAMT) and Converted Amount (CMCAMT) are set to zero, since no new transaction amounts exist for the period.
b. Depending on whether it is a new year or not, the following processing occurs:
(1) If it is a new year, then a new multi-currency record is created and account balances are initialized to zero.
(2) If it is not a new year, the balances from the existing multi-currency record are loaded. If the account is a balance sheet account, then the last year's ending balance is retrieved for the year-to-date calculation.
c. The appropriate statistics and account balances are calculated as follows:
(1) If the account is a balance sheet account (MCACTP = ASSET or LIABY or EQUTY), then the new entered and converted amounts (CMEAMT, CMCAMT) are added to the previous period account balances (MCF, MCB) to create the currency period account balances. If the account is an income statement account (MCACTP = REVEN or EXPEN or SUSPN), then the current period account balances are set to zero, and the new entered and converted amounts become the current period account balance.
(2) The current period amount is formatted, and the quarter to date (QTD), year to date (YTD) and change amounts are calculated according to the account type (balance sheet or income statement).
d. The updated account information is written to the Multi-currency Account Master file.
e. The next multi-currency account record is retrieved and processing returns to Mainline step 2a.
3. The first transaction for which an account does not exist is read from the Transactions Without Accounts file (GLCMTRL5).
4. The following processing occurs until the end of the Transactions Without Accounts file is reached (TRSTAT = MSGEOF).
a. A check is made to ensure that no multi-currency account exists for the transaction. If an account does exist, processing skips to Mainline step 4(f). Otherwise, processing continues as below.
b. The descriptive record for the account type is retrieved from the Descriptive Account Master file (GLFILEL5).
c. A new record is created with the account balances initialized to zero.
d. The appropriate statistics and account balances are calculated as follows:
(1) If the account is a balance sheet account (MCACTP = ASSET or LIABY or EQUTY), then the new entered and converted amounts (CMEAMT, CMCAMT) are added to the previous period account balances (MCF, MCB) to create the currency period account balances. If the account is an income statement account (MCACTP = REVEN or EXPEN or SUSPN), then the current period account balances are set to zero, and the new entered and converted amounts become the current period account balances.
(2) The current period amount is formatted, and the quarter to date (QTD), year to date (YTD) and change amounts are calculated according to the account type (balance sheet or income statement).
e. The updated account information is written to the Multi-currency Account Master file.
f. The next transaction for which an account record does not exist is read from the Transactions Without Accounts file.
5. Multi-currency post updating is complete and processing ends normal.