|
| |
 General Ledger Record Update Flows
PGL100
- Maintain Chart of
Accounts, - Adding a Subordinate Account Number
Upon accepting the new subordinate account
number:
- Update the Relationship File (REL,
DGLREL.IDX) with two relationship records:
- the parent's new relationship down
record
- the subordinate's relationship up
record.
- Write the new account number to the Chart of
Account File (ACT, DGLACT.IDX).
- Write two records in the Alias File (UNQ,
DGLUNQ.IDX):
- an "F" type record with the full account
number associating itself to the alias
- an "S" type record with the alias
associating itself to the full account number.
- Write multiple records in the Account Part
Cross Reference File (DCX , DGLDCX.IDX). (Records cross referencing the
full account number to each part value are written for all part values
within the account structure.)
(Top)
Adding a Parent or Independent Account
Number
Upon accepting the new parent or independent
account number:
- Write the new account number to the Chart of
Account File (ACT, DGLACT.IDX).
- Write two records in the Alias File (UNQ,
DGLUNQ.IDX):
- an "F" type record with the full account
number associating itself to the alias
- an "S" type record with the alias
associating itself to the full account number.
- Write multiple records in the Account Part
Cross Reference File (DCX , DGLDCX.IDX). (Records cross referencing the
full account number to each part value are written for all part values
within the account structure.)
(Top)
BGL970 - Change Account
Alias
Upon accepting the change:
- Rewrite the "F" type record on the Alias
File (UNQ, DGLUNQ.IDX) associating the full account number to the new
alias.
- Delete the "S" type record on the Alias File
(UNQ, DGLUNQ.IDX) for the original alias association to the full
account number.
- Write a new "S" type record on the Alias
File (UNQ, DGLUNQ.IDX) for the new alias to associate it to the full
account number.
(Top)
PGL750 - Maintain
Relationships
- Transfer a Link
- Checks/transfers balances to new parent
account in the Account Balance File (BAL, DGLBAL.IDX).
- Deletes the old subordinate to parent up
relationship record in the Relationship File (REL, DGLREL.IDX) breaking
the link.
- Creates a new parent to subordinate
relationship down record on the Relationship File (REL, DGLREL.IDX)
establishing a new link.
- Delete the old parent to subordinate down
record on the Relationship File (REL, DGLREL.IDX).
- Creates a new subordinate to parent up
record on the Relationship File (REL, DGLREL.IDX, establishing the new
link.
- Rewrite the Relationship File (REL,
DGLREL.IDX) control record; forcing a Verify Accounts Relationships
(BGL760) before posting is allowed.
(Top)
BGL760 - Verify Account
Relationships
- Rewrite the control record in the
Relationship File (REL, DGLREL.IDX) to indicate that verify was
successful and posting can now take place.
(Top)
PGL220 - General Journal
Entries
- Update the Journal Voucher Control File
(JVC, DGLJVC.IDX) header record with the next available control number
if JV-ENTRY USES BATCH is not used.
- Write a journal voucher control record on
the Journal Voucher Control File (JVC, DGLJVC.IDX).
- Write a header record to the Journal Voucher
File (DGLJVF.nnnnnn).
- Check/update the Encumber and Commit record
(EAC D00200-38) for the transaction's account number when Budget
Control is Used.
- Write a record for each transaction in the
batch to the Journal Voucher File (DGLJVF.nnnnnn).
- Update the Journal Voucher File
(DGLJVF.nnnnnn)header record totals for each transaction added within
the batch.
Repeat Steps 4, 5 and 6 for each detail line
within the journal entry.
- When Updating the batch: Writes a record for
each transaction line within the batch to the Unposted File, (UNT,
DGLUNT.IDX) or for Accounting Treatment sites, to the Unexploded File
(UNX, DGLUNX.IDX).
Note:
For Accounting Treatment sites, Summarize Transactions,BAT750 moves the
treated transaction records from the unexploded to the unposted file.
(Top)
PGL200 - Standard Journal
Entries - Creating a Standard batch
- Create a batch header record for the new
group on the Standard Journal File (STD, DGLSTD.IDX).
- Create a record on the Standard Journal File
(STD, DGLSTD.IDX) for each transaction in the group.
- Update the batch header record on the
Standard Journal File (STD, DGLSTD.IDX) with totals for addition of a
transaction line
Repeat Steps 2 and 3 for each detail line
within the standard journal group.
(Top)
Processing a Standard Journal batch
- Rewrite the control record on the Standard
Journal File (STD, DGLSTD.IDX) with user's password to lock the group.
- Check/update the Encumber and Commit record
(EAC D00200-38) for the group's detail transaction account number if
Budget Control is Used.
- Write a record for the transaction within
the standard batch to the Unposted Transaction File (UNT, DGLUNT.IDX)
or for Accounting Treatment sites, the Unexploded File (UNX,
DGLUNX.IDX).
Repeat Steps 2 and 3 for each detail line of
the.Standard Journal Entry
- Rewrite the control record to unlock the
group in the Standard Journal File (STD, DGLSTD.IDX).
(Top)
PGL210 - Accrual and
Reversal
Entries - Creating an Accrual and Reversal Batch
- Create a batch header record for the new
group on the Accrual and Reversal File (ACR, DGLACR.IDX).
- Create a record on the Accrual and
Reversal File (ACR, DGLACR.IDX) for each transaction in the group.
- Update the batch header record on the
Accrual and Reversal File (ACR, DGLACR.IDX) with totals for addition of
a transaction line.
Repeat Steps 2 and 3 for each detail line within the accrual and
reversal journal entry group.
(Top)
Processing an Accrual and Reversal Batch
- Rewrite the control record on the Accrual
and Reversal File (ACR, DGLACR.IDX) with user's password to lock the
group.
- Check/updates the Encumber and Commit
record (EAC D00200-38) for the group's detail transaction account
number if Budget Control is Used.
- Write a record for the transaction within
the accrual batch in the Unposted Transaction File (UNT, DGLUNT.IDX) or
for Accounting Treatment sites, the Unexploded File (UNX, DGLUNX.IDX).
- Write a record for the transaction within
the reversal batch in the Unposted Transaction File (UNT, DGLUNT.IDX)
or for Accounting Treatment sites, the Unexploded File (UNX, DGLUNX.IDX)
Steps 2, 3 and 4 are repeated for each
detail line of the Accrual and Reversal Entry.
- Rewrite the control record to unlock the
group in the Accrual and Reversal File (ACR, DGLACR.IDX).
(Top)
BGL731 - Posting General
Ledger
Transactions
NOTE:
If your SYSGEN set up includes USE ACCOUNT GENERATION to auto generate
account numbers the new account records will be created in the Chart of
Accounts File (ACT DGLACT.IDX), the new account alias records will be
created in the Alias File (UNQ DGLUNQ.IDX), the new relationships will
be created in the Relationship File (REL, DGLREL.IDX) and the necessary
account cross-reference records will be created in the Account Part
Cross-Reference File(DCX DGLDCX.IDX) before the following:
- Update the appropriate balance buckets
(determined by the transaction type) in the Account Balance File (BAL,
DGLBAL.IDX) for each account number within the posting.
- Write a detail record in the Posted
Transaction File (PST, DGLPST.IDX) for the transaction.
- Delete the transaction from the Unposted
Transaction File (UNT, DGLUNT.IDX).
Repeat Steps 2 and 3 for each transaction.
- Update the last activity date on the Chart
of Accounts File (ACT DGLACT.IDX) for each account number.
(Top)
Contact ISI-Exeter Customer Support for assistance in
analyzing your output.
|
