Documentation >
MAC-PAC Technical Library >
Financial >
General Ledger >
Programs >
Adjustment Post - Purpose >
Adjustment Post - Calculations
Adjustment Post - Calculations
GL230P
A. Mainline
1. Account Master Summary Record
Only the account master records used in transactions are processed during a posting run. Adjustment journal transactions are posted against the fields in this record, and beginning and ending balances are shown on the posting report for each account.
2. Account Master Detail Record
If in a multi-currency environment, each financial adjustment journal is posted to the appropriate account master detail record, by currency, for each account. The sum of all multi-currency transactions posted to these records, for a single account, is posted to the account master (summary) record. The account master (summary) record and the account master detail records are always synchronized.
3. Adjustment Journal Transaction Record
If the account number on the journal transaction matches a valid account number on the Account Master file record, the debit or credit amount is added to the appropriate accumulators, the transaction is listed on the post, and the record is deleted from the Adjustment Journal Transaction file.
4. Cumulative Journal Transaction Record
Each valid journal transaction processed during a post is used to format a record which is written to the Cumulative Journal Transaction file.
5. Cumulative Journal Transaction Control Record
This record is updated for posting during end of location processing. Beginning balances are saved and printed, posted activity is accumulated and printed, and ending controls are calculated and printed. For financial controls, transaction counts and converted debit amounts are maintained. For statistical controls, transaction counts and converted quantities are maintained. Posted activity is added to the beginning balance to obtain the ending balance.
6. Date and Period Record
This Reference file record is used to determine whether or not a demand post has been performed for the current period, and whether the location uses a 12 or 13-period fiscal year.
7. Version Records
To ensure file synchronization, four version records are used. These records are on both the financial and statistical record formats for the Cumulative Journal Transaction and Control file (GLCMTRL and GLCMCTL). These numbers are compared in Housekeeping, and if they are not equal, a program message is printed and program processing terminates.
8. Year-to-Date Retained Earnings
The adjusting period profit or loss for the current period is posted to the year-to-date retained earnings account in the balance sheet. The profit or loss is determined by accumulating the adjusting period transactions for balance sheet accounts. A net debit balance for the balance sheet transactions indicates a profit for the adjusting period; a net credit balance indicates a loss. The profit or loss amount is then posted to the year-to-date retained earnings account, after reversing the sign to maintain the equality of debits and credits within the balance sheet accounts.
If the Management Account Reporting Option in category 133 is set to yes, the adjusting period profit or loss resulting from fiscal and common accounting transactions is posted to the fiscal year-to-date retained earnings account. The adjusting period profit or loss resulting from management and common accounting transactions is then posted to the management year-to-date retained earnings account.
9. Inception-to-Date Retained Earnings
This account is processed the same as the Year-to-Date Retained Earnings. The profit or loss is posted to the Inception-to- Date Retained Earnings account if the adjustment is for a period in the previous year. Only periods 01 through the current period may be affected. If the Management Account Reporting Option in category 133 is set to yes, fiscal and/or management inception-to-date retained earnings accounts are posted.
10. Suspense Processing
An Account Master file suspense record exists only on the Financial Account Master file. For each transaction printed on the Financial Transaction Error Listing, a line is also printed under the suspense account on the posting report, and the suspense account balance is updated with the transaction amounts. These transactions are also written to the Cumulative Transaction file using the suspense account number. For statistical reporting, no suspense record exists on the Statistical Account Master file. Invalid transactions are listed on the Statistical Transaction Error Listing only, and the transactions are deleted from the Adjustment Journal Transaction file.
11. Controls
The following controls are accumulated and printed at the period-year and company-location levels:
a. Balance Sheet Posted -- The total debits and total credits posted to the Account Master file balance sheet accounts.
b. Income Sheet Posted -- The total debits and total credits posted to the Account Master File Income Statement accounts.
c. Inception-to-Date Profit/Loss -- The profit or loss amount posted to the retained earnings account for the previous year.
d. Year-to-Date Profit/Loss -- The profit or loss amount posted to the retained earnings account for the current year.
e. Suspense -- The debit and credit amounts posted to the suspense account for financial processing, and the quantity listed on the Statistical Transaction Error Listing for statistical processing.
f. Mismatches -- The number of journal transactions that did not have valid account records on the Account Master file.
g. Number of Posted Accounts -- The number of Account Master file accounts that were posted. If the Management Account Reporting Option in category 133 is set to yes, separate control totals are accumulated for fiscal and management transactions. Common accounting transactions are accumulated into both fiscal and management totals.
12. Control Breaks
a. Account Number
When a company-location-year-period-account-center control break occurs on the Adjustment Journal Transaction file, the accumulated debits and credits or quantity are printed on the posting report, and the account is posted and the account record updated.
b. Year-Period
When a company-location-year-period control break occurs on the Adjustment Journal Transaction file, a fiscal period for a company-location has ended. Control totals for the fiscal period are then calculated and printed.
c. Location
This control break indicates the end of financial or statistical Account Master file records for the company-location. When a location break occurs, control file ending balances are calculated and the Cumulative Transaction Control file balances are printed. Updated Cumulative Control records are written, and location controls are printed.
d. LR -- End of Job
When end of job is reached, the Reference File Date and Period record is updated for a demand or final post.
13. Error Processing
Processing errors encountered during program execution that are not within the normal realm of processing are handled with the routines listed below.
a. *PSSR--Exception/Error
This common subroutine is executed whenever a program execution or program detected error occurs and causes control to pass to subroutine ABNEND.
b. FILERR--File Error
This common subroutine is executed whenever a file error occurs which is not otherwise trapped by an error indicator or an input, update or output operation. This subroutine causes control to be passed either to subroutine ABNEND or to the appropriate screen with an error message.
c. ABNEND--Abnormal Termination
This common subroutine is called by the mainline when the value of error severity is greater than 1. This module terminates the program by setting on indicator LR and executing a return statement.