ams advantage financial general accounting user … · ams advantage financial ... journal voucher...
TRANSCRIPT
-
AMS Advantage Financial
General Accounting User Guide Release 3.9.0.1
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 2
This document contains information proprietary to CGI Technologies and Solutions Inc. Unauthorized reproduction or disclosure of this information in whole or in part is prohibited.
AMS Advantage is a registered trademark of CGI Technologies and Solutions Inc.
Due to the nature of this material, numerous hardware and software products are mentioned by name. In most, if not all, cases, the companies that manufacture the products claim these product names as trademarks. It is not our intention to claim these names or trademarks as our own.
Copyright 2006, 2016, CGI Technologies and Solutions Inc. All Rights Reserved.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 3
Table of Contents Business Area Overview ............................................................................................................... 16
Features ..................................................................................................................................... 16
Common Terminology ................................................................................................................... 21
Document Information ................................................................................................................... 24
Journal Voucher (JV) Document Type ....................................................................................... 24
JV Delivered Document Codes .............................................................................................. 27
Standard Journal Voucher (JV) .............................................................................................. 28
Purpose ............................................................................................................................... 28
Structure ............................................................................................................................. 28
Tasks .................................................................................................................................. 29
Header ................................................................................................................................ 29
Line Group .......................................................................................................................... 34
Accounting .......................................................................................................................... 43
Advanced Journal Voucher (JVA) .......................................................................................... 57
Purpose ............................................................................................................................... 57
Structure ............................................................................................................................. 57
Tasks .................................................................................................................................. 57
Annual Close Journal Voucher (JVAC) .................................................................................. 57
Purpose ............................................................................................................................... 57
Structure ............................................................................................................................. 58
Tasks .................................................................................................................................. 58
Bank Transfer Journal Voucher (JVBK) ................................................................................. 58
Purpose ............................................................................................................................... 58
Structure ............................................................................................................................. 58
Tasks .................................................................................................................................. 58
Cost Accounting Journal Voucher (JVC) ................................................................................ 58
Purpose ............................................................................................................................... 59
Structure ............................................................................................................................. 59
Tasks .................................................................................................................................. 60
JV - Clearing Account Maintenance (JVCAM) ....................................................................... 60
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 4
Purpose ............................................................................................................................... 60
Structure ............................................................................................................................. 60
Tasks .................................................................................................................................. 60
Journal Voucher Income Allocation (JVIA) ............................................................................. 60
Purpose ............................................................................................................................... 60
Structure ............................................................................................................................. 61
Tasks .................................................................................................................................. 61
Investment Journal Voucher (JVIN) ....................................................................................... 61
Purpose ............................................................................................................................... 61
Structure ............................................................................................................................. 61
Tasks .................................................................................................................................. 61
Payroll Journal Voucher (JVP) ............................................................................................... 61
Purpose ............................................................................................................................... 61
Structure ............................................................................................................................. 61
Tasks .................................................................................................................................. 63
Restricted Journal Voucher (JVR) .......................................................................................... 63
Purpose ............................................................................................................................... 63
Structure ............................................................................................................................. 64
Tasks .................................................................................................................................. 65
Journal Voucher Cash Sweep (JVSW) .................................................................................. 65
Purpose ............................................................................................................................... 65
Structure ............................................................................................................................. 65
Tasks .................................................................................................................................. 65
Accounting Based Spending (ABS) Document Type................................................................. 65
ABS Document Sub Types ..................................................................................................... 67
Modification to ABS documents with Discounts ................................................................. 67
ABS Delivered Document Codes ........................................................................................... 69
General Accounting Expense/Expenditure (GAX) ................................................................. 70
Purpose ............................................................................................................................... 70
Structure ............................................................................................................................. 70
Tasks .................................................................................................................................. 70
Header ................................................................................................................................ 70
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 5
Vendor ................................................................................................................................ 80
Accounting .......................................................................................................................... 97
General Accounting Encumbrance Correction (GAEC) ....................................................... 117
Purpose ............................................................................................................................. 117
Structure ........................................................................................................................... 117
Tasks ................................................................................................................................ 118
Interest Payment Request (IPR) .......................................................................................... 118
Purpose ............................................................................................................................. 118
Structure ........................................................................................................................... 118
Tasks ................................................................................................................................ 120
GA Intercept Payment (GAIP) and Federal Offset Payment (GAOP) .................................. 120
Purpose ............................................................................................................................. 120
Structure ........................................................................................................................... 120
Tasks ................................................................................................................................ 123
General Accounting Pre Encumbrance (GAP) ..................................................................... 123
Purpose ............................................................................................................................. 123
Structure ........................................................................................................................... 123
Tasks ................................................................................................................................ 128
Internal Requisition (IRQ) ..................................................................................................... 128
Purpose ............................................................................................................................. 128
Structure ........................................................................................................................... 128
Tasks ................................................................................................................................ 129
Internal Purchase Order (IPO) ............................................................................................. 129
Purpose ............................................................................................................................. 129
Structure ........................................................................................................................... 129
Tasks ................................................................................................................................ 129
General Accounting Encumbrance (GAE) ........................................................................... 130
Purpose ............................................................................................................................. 130
Structure ........................................................................................................................... 130
Tasks ................................................................................................................................ 130
Accounting Based Document Lapse (ABDL) ....................................................................... 130
Purpose ............................................................................................................................. 130
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 6
Structure ........................................................................................................................... 130
Tasks ................................................................................................................................ 130
Retainage Payment Forfeiture (RTGPF) .............................................................................. 130
Purpose ............................................................................................................................. 130
Structure ........................................................................................................................... 131
Tasks ................................................................................................................................ 131
Travel Encumbrance (TE) .................................................................................................... 131
Purpose ............................................................................................................................. 131
Structure ........................................................................................................................... 132
Tasks ................................................................................................................................ 140
Travel Advance (TA) ............................................................................................................ 140
Purpose ............................................................................................................................. 140
Structure ........................................................................................................................... 140
Tasks ................................................................................................................................ 148
Travel Payments (TP) .......................................................................................................... 148
Purpose ............................................................................................................................. 148
Structure ........................................................................................................................... 148
Tasks ................................................................................................................................ 160
Internal Document Types ......................................................................................................... 160
Internal Exchange Transaction (IET) Document Type ......................................................... 161
Purpose ............................................................................................................................. 161
Structure ........................................................................................................................... 162
IET Document Sub Types ................................................................................................. 162
IET Delivered Document Codes ....................................................................................... 163
Header .............................................................................................................................. 163
Exchange Details .............................................................................................................. 171
2nd Party Accounting ........................................................................................................ 188
Intercept Transfer (IT) .......................................................................................................... 202
Purpose ............................................................................................................................. 202
Structure ........................................................................................................................... 202
Tasks ................................................................................................................................ 206
Federal Offset Transfer (ITO) ............................................................................................... 206
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 7
Purpose ............................................................................................................................. 206
Structure ........................................................................................................................... 207
Internal Exchange Transaction Maximo Integration (IETM) .............................................. 207
Purpose ............................................................................................................................. 207
Structure ........................................................................................................................... 208
Internal Transaction Initiator (ITI) Document Type............................................................... 208
Purpose ............................................................................................................................. 208
Structure ........................................................................................................................... 208
ITI Delivered Document Codes......................................................................................... 209
Header .............................................................................................................................. 209
Vendor .............................................................................................................................. 217
Accounting ........................................................................................................................ 223
Internal Transaction Agreement (ITA) Document Type ....................................................... 236
Purpose ............................................................................................................................. 236
Structure ........................................................................................................................... 236
ITA Delivered Document Codes ....................................................................................... 237
Header .............................................................................................................................. 237
Initiator Reference ............................................................................................................ 244
2nd Party Accounting ........................................................................................................ 264
Payroll (PYRL) Document Type ............................................................................................... 278
PYRL Document Sub Types ................................................................................................ 279
PYRL Delivered Document Codes ....................................................................................... 279
Payroll Expenditure (PREXP)............................................................................................... 281
Purpose ............................................................................................................................. 281
Structure ........................................................................................................................... 281
Tasks ................................................................................................................................ 281
Header .............................................................................................................................. 281
Accounting ........................................................................................................................ 287
Payroll Expenditure Correction (PREXC) ............................................................................. 302
Purpose ............................................................................................................................. 303
Structure ........................................................................................................................... 303
Tasks ................................................................................................................................ 304
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 8
Payroll Contract Encumbrance (PRLCE) ............................................................................. 304
Purpose ............................................................................................................................. 304
Structure ........................................................................................................................... 304
Tasks ................................................................................................................................ 307
Payroll Liability (PRLIA) ........................................................................................................ 307
Purpose ............................................................................................................................. 307
Structure ........................................................................................................................... 307
Tasks ................................................................................................................................ 307
Payroll Leave Liability (PRLLL) ............................................................................................ 307
Purpose ............................................................................................................................. 307
Structure ........................................................................................................................... 307
Tasks ................................................................................................................................ 309
Payroll Internal (PRLID) ....................................................................................................... 310
Purpose ............................................................................................................................. 310
Structure ........................................................................................................................... 310
Tasks ................................................................................................................................ 320
Payroll Net Pay (PRLNP) ..................................................................................................... 320
Purpose ............................................................................................................................. 320
Structure ........................................................................................................................... 320
Tasks ................................................................................................................................ 320
Payroll Vendor Payment Request (PRLVP) ......................................................................... 320
Purpose ............................................................................................................................. 320
Structure ........................................................................................................................... 321
Tasks ................................................................................................................................ 339
Charge (CH) Document Type .................................................................................................. 339
Delivered Accrual Document Codes .................................................................................... 340
Manual Accrual (ACC) .......................................................................................................... 341
Purpose ............................................................................................................................. 341
Structure ........................................................................................................................... 341
Header .............................................................................................................................. 341
Accounting ........................................................................................................................ 345
Manual Accrual Clearing (ACL) ............................................................................................ 359
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 9
Purpose ............................................................................................................................. 359
Structure ........................................................................................................................... 360
Automated Accrual (ACCA) .................................................................................................. 360
Purpose ............................................................................................................................. 360
Structure ........................................................................................................................... 360
Automated Accrual Clearing (ACLA) .................................................................................... 360
Purpose ............................................................................................................................. 360
Structure ........................................................................................................................... 360
Accrual Disallowance (ACD) ................................................................................................ 360
Purpose ............................................................................................................................. 360
Structure ........................................................................................................................... 361
Common Business Tasks ............................................................................................................ 362
Create Manual Journal Entries ................................................................................................ 362
Adjust a Journal Entry .......................................................................................................... 363
Reverse a Journal Entry ....................................................................................................... 365
Correct a Journal Entry ........................................................................................................ 367
Record Bond Proceeds ........................................................................................................ 370
Create a Non-Commodity Request for Payment ..................................................................... 374
Create a Non-Commodity Order .............................................................................................. 376
Create a Non-Commodity Requisition ..................................................................................... 378
Correct a Non-Commodity Order ............................................................................................. 380
Encumber Funds for Future Travel .......................................................................................... 382
Request Payment for Travel in Advance ................................................................................. 385
Request Travel Reimbursement .............................................................................................. 388
Reallocate Travel Costs ........................................................................................................... 391
Single Internal Document ......................................................................................................... 394
Two Internal Documents .......................................................................................................... 398
Correct Payroll Costs ............................................................................................................... 402
Research Balance Sheet Accounts ......................................................................................... 405
Research Nominal Accounts .................................................................................................... 407
Journals and Ledgers .................................................................................................................. 409
Journals and Ledgers Defined ................................................................................................. 409
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 10
Delivered Journals and Ledgers .............................................................................................. 409
1099 Journal ......................................................................................................................... 411
Accounting Journal ............................................................................................................... 411
Cost Accounting Journal ...................................................................................................... 413
Budget Fiscal Year Not Equal Fiscal Year Journal .............................................................. 413
Cash Journal ........................................................................................................................ 413
Internal Journal ..................................................................................................................... 413
Fixed Asset Accounting Journal ........................................................................................... 414
Fixed Asset Component Journal .......................................................................................... 414
Budget Journal ..................................................................................................................... 414
Commodity Journal .............................................................................................................. 415
Accounting Ledgers - APD, FY, BFY, and ITD .................................................................... 415
Cost Accounting Ledgers - APD, FY, BFY, and ITD ............................................................ 415
Fixed Asset Accounting Ledger ........................................................................................... 415
Generic Ledgers - 001 to 010............................................................................................... 416
Full Detail Accounting Ledger .............................................................................................. 416
System Assurance Ledger ................................................................................................... 416
Inquiries ....................................................................................................................................... 417
Accounting Journal & Ledger Query ........................................................................................ 418
Purpose ................................................................................................................................ 418
Accrual Inquiry ......................................................................................................................... 420
Purpose ................................................................................................................................ 420
Accrual Clearing Management ................................................................................................. 421
Purpose ................................................................................................................................ 421
Cash Balance Inquiries ............................................................................................................ 422
Purpose ................................................................................................................................ 422
Fund Balance Inquiries ............................................................................................................ 426
Purpose ................................................................................................................................ 426
FY Balance Details .................................................................................................................. 429
Purpose ................................................................................................................................ 430
Tasks .................................................................................................................................... 430
ITD Balance Summary & Detail ............................................................................................... 431
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 11
Purpose ................................................................................................................................ 431
Journal/Ledger Cross-Reference ............................................................................................. 432
Purpose ................................................................................................................................ 432
Ledgerization Log .................................................................................................................... 433
Purpose ................................................................................................................................ 433
Advanced - Setup ........................................................................................................................ 436
System Configuration ............................................................................................................... 436
Application Parameters ........................................................................................................ 436
System Options .................................................................................................................... 444
Expense Controls ............................................................................................................. 445
General Controls ............................................................................................................... 449
Revenue Controls ............................................................................................................. 451
Fixed Asset Controls ......................................................................................................... 458
Date Tables .......................................................................................................................... 458
Fiscal Year ........................................................................................................................ 459
Fiscal Year by Fund .......................................................................................................... 460
Accounting Period ............................................................................................................. 460
Accounting Period by Fund............................................................................................... 462
Calendar Date ................................................................................................................... 463
Document Usage .............................................................................................................. 464
Default Accounts ...................................................................................................................... 465
Special Accounts & Special Fund Accounts ........................................................................ 466
Accounts Payable Defaults ............................................................................................... 467
Purchasing and Procurement Defaults ............................................................................. 472
Revenue Defaults ............................................................................................................. 475
Miscellaneous Defaults ..................................................................................................... 481
Fixed Assets Defaults ....................................................................................................... 485
Internal Costing Defaults .................................................................................................. 487
Investments Defaults ........................................................................................................ 488
Bank ..................................................................................................................................... 490
Revenue Source & Billing Profile ......................................................................................... 490
Warehouse & Inventory Maintenance .................................................................................. 490
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 12
Fixed Asset Type .................................................................................................................. 490
Internal Vendor Accounting Data ......................................................................................... 490
Accounting Template & Other COA Inference Tables ......................................................... 490
Accounting Configuration ......................................................................................................... 491
Event Category ..................................................................................................................... 492
Event Type Processor .......................................................................................................... 498
Generic Event Type Processor ......................................................................................... 498
Accounts Payable Event Type Processor ........................................................................ 499
Accounts Receivable Event Type Processor.................................................................... 500
Disbursements Event Type Processor ............................................................................. 501
Disbursement Reclassification Event Type Processor ..................................................... 502
Double Non-Offsets Event Type Processor ...................................................................... 503
Fixed Assets Event Type Processor ................................................................................. 504
Internal Accounting Event Type Processor ...................................................................... 518
Inventory Event Type Processor ...................................................................................... 519
Investments Event Type Processor .................................................................................. 523
Payroll Clearing Fund Event Type Processor ................................................................... 524
Payroll Disbursements Event Type Processor ................................................................. 524
Manual Accrual Clearing Event Type Processor .............................................................. 525
Automated Accrual Clearing Event Type Processor ........................................................ 525
Event Type ........................................................................................................................... 525
Event Type Requirements .................................................................................................... 533
Posting Code ........................................................................................................................ 537
Posting Code Closing Classification .................................................................................... 548
Accounting Group ................................................................................................................. 558
Accounting Model Delivered Configuration .......................................................................... 559
Referencing....................................................................................................................... 560
Accounts Payable Accounting Model ............................................................................... 564
Accounts Receivable Accounting Model .......................................................................... 578
Bond / Debt Accounting Model ......................................................................................... 594
Budgeting Accounting Model ............................................................................................ 597
Cost Accounting - Accounting Model ................................................................................ 602
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 13
Disbursements Accounting Model .................................................................................... 603
Disbursement Reclassification Accounting Model ............................................................ 621
Fixed Assets Accounting Model ....................................................................................... 629
Internal Accounting - Accounting Model ........................................................................... 643
Inventory Accounting Model ............................................................................................. 660
Payroll Accounting Model ................................................................................................. 696
Procurement Accounting Model ....................................................................................... 714
Travel Accounting Model .................................................................................................. 719
Treasury Accounting Model .............................................................................................. 721
Miscellaneous Accounting ................................................................................................ 724
Document Configuration .......................................................................................................... 728
Document Category ............................................................................................................. 730
Document Type .................................................................................................................... 731
Document Sub Type ............................................................................................................. 735
Document Code (Document Control) ................................................................................... 740
Document Accounting Controls ............................................................................................ 763
Allowed Event Types for Document Type ........................................................................ 763
Allowed Event Types for Document Code ........................................................................ 764
Event Type Defaults ......................................................................................................... 765
AP Event Type Crosswalk ................................................................................................ 767
MD Default Event Type ..................................................................................................... 768
DC Event Type Cross Walk .............................................................................................. 770
Payroll Event Type Defaults ............................................................................................. 771
Miscellaneous Document Controls ....................................................................................... 775
Procurement Document Controls ..................................................................................... 776
Allowed Accounting Periods for Document Code ............................................................. 776
Document Allowable References ..................................................................................... 777
Document Copy Forward Control ..................................................................................... 779
Tolerances ........................................................................................................................ 780
Automatic Document Numbering ...................................................................................... 789
Setting Up a New Document Code ...................................................................................... 792
BFY Staging Configuration ...................................................................................................... 794
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 14
Setup Tables ........................................................................................................................ 795
Budget Fiscal Year Stage Profile Select ........................................................................... 795
BFY Staging Profile .......................................................................................................... 795
BFY Stage Definition ........................................................................................................ 800
Setup Hints ........................................................................................................................... 803
Document Editing ................................................................................................................. 804
Cost Accounting Staging ...................................................................................................... 805
Journal and Ledger Configuration............................................................................................ 805
Journal Engine ..................................................................................................................... 805
Ledger Engine ...................................................................................................................... 806
Journal/Ledger Control ......................................................................................................... 806
Implementation Concerns .................................................................................................... 819
Balance Sheet Account Balances ............................................................................................ 823
Balance Controls .................................................................................................................. 823
Record Creation ................................................................................................................... 825
Cash Balance Tracking & Control ............................................................................................ 825
Cash Balance Setup ............................................................................................................. 825
Application Parameters ..................................................................................................... 825
Posting Codes .................................................................................................................. 826
Cash Balance Detail Maintenance ................................................................................... 827
Cash Balance Summary Maintenance ............................................................................. 830
Cash Balance Errors ............................................................................................................ 832
Fund Balance Tracking & Control ............................................................................................ 833
Fund Balance Setup ............................................................................................................. 833
Posting Codes .................................................................................................................. 833
Fund Balance Detail Maintenance .................................................................................... 834
Fund Balance Summary Maintenance ............................................................................. 837
Fund Balance Errors ............................................................................................................ 839
Advanced - Batch Processing ..................................................................................................... 840
Batch Jobs ............................................................................................................................... 840
Chain Jobs ............................................................................................................................... 844
Annual Close ........................................................................................................................ 848
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 15
Automated Accrual Process ................................................................................................. 850
Automated Accrual Clearing Process .................................................................................. 851
Automated Bank Account Transfer Process ........................................................................ 853
Clearing Account Maintenance ............................................................................................ 853
Contract Roll ......................................................................................................................... 854
Future Document Trigger ..................................................................................................... 855
Journal Ledger Archiving ...................................................................................................... 855
New Year Table Initialization ................................................................................................ 856
Open Activity Lapse, Open Activity Roll, and Open Activity & Budget Roll ......................... 856
System Assurance 1 ............................................................................................................ 857
System Assurance 2 ............................................................................................................ 858
System Assurance 12 .......................................................................................................... 858
System Assurance 13 .......................................................................................................... 858
Report Jobs .............................................................................................................................. 859
Advanced - Reports ..................................................................................................................... 863
AMS Advantage Financial Reports .......................................................................................... 863
AMS infoAdvantage ................................................................................................................. 864
Universes.............................................................................................................................. 864
Reports ................................................................................................................................. 864
Frequently Asked Questions ....................................................................................................... 866
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 16
Business Area Overview General Accounting is a large functional area of AMS Advantage Financial that consists of a collection of many parts of the application that encompasses many sub functional areas.
Features The following features exist in the General Accounting area:
Create Manual Journal Entries
The General Accounting functional area provides a vehicle, the Journal Voucher document, for recording manual journal entries that do originate from standard business functions covered in other functional areas. Data entry of this document is unlike any other in that individual debit and credit accounts are manually entered instead of being generated from the application.
Common business tasks (see later section) for the Journal Voucher include adjusting/correcting entries, reversing entries, and accruals. Other uses include recording accounting that is not suited to any other functional area and interfacing accounting activity from other systems.
Procurement and Payment without Commodity
While the Procurement and Accounts Payable functional areas provide a means to request, order and request payment for goods and services at a commodity code level of detail, the General Accounting area provides the same functionality but without commodity codes. It is quite common to have both a commodity and non-commodity basis for these activities in place simultaneously. All procurement and payables may not have to have commodity details or the ability to enter receivers and invoices into the procurement process. When this is the case, the Accounting Based Spending or the Internal documents are used.
Common business tasks (see later section) for the Accounting Based Spending documents include requisitioning, ordering, requesting payment, and recording travel costs. Other uses include encumbrance corrections, expenditure corrections, and a variety of other activities because of the simple interface and flexibility of this document.
Common business tasks (see later section) for the Internal documents include internal reimbursement purchasing, quasi-external purchasing, operating transfers, and internal loans. Other uses include recording payment intercept and cost accounting reimbursement activity which is internally funded.
Expenditure Accruals & Clearings
The General Accounting functional area provides several methods for accurately recording expenditure accruals to reflect goods or services received in a prior year but without having a disbursement or request for payment processed. Accurately recording every dollar is a goal that would cost more to achieve than it is worth. For this reason, many rely on a manual review of current year expenditures that occurred just after a new fiscal year has started to determine what amounts should be removed from the current year and accrued into the prior year. Likewise the review will also look at expenditures
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 17
booked into the prior year to determine what amounts should be removed from the prior year and put into the current year.
1. The Journal Voucher can be used to record the accrual along with use of the reversal functionality of that document to invoke Future Document Triggering to reverse the accrual in the current year.
2. Another method is the recording an accrual directly within the ordering document and reducing an existing accounting line. This method can be done manually and with the Open Activity Roll chain process. A later request for disbursement will then liquidate that accrual and create another along with a payable.
3. As an alternative to performing accruals with the journal voucher, Advantage Financial provides an alternative where users enter a single accounting line on a Manual Accrual (ACA) and Manual Accrual Clearing (ACL) document instead of debit and credit lines with posting codes. Users not familiar with the journal voucher will find these documents easier to enter.
4. Advantage Financial contains an automated alternative or supplement to the manual review that is based on service dates. The automated alternative is comprised of two chain jobs Automated Accrual and Automated Accrual Clearing to create documents to move expenditures based on the percentage of time in the prior year based on the service dates.
If either or both of the latter two methods are used, there is an Accrual Inquiry (ACRI) page for researching accruals by those ultimately charged with reviewing for accurate accounting. From that page there is the ability to create a Disallowance document when an accrual clearing was not accurate.
Record Payroll
The General Accounting area provides two methods of recording the accounting from payroll. The first is the Journal Voucher. The second is a specialized document, called the Payroll document. The document has been design to work with AMS Advantage HRM, but can also be used for other payroll applications.
Common business tasks (see later section) for the Payroll document include encumbering for contracts, accruing leave liabilities, recording payroll expenditures as well as liabilities, requesting external payment of external deductions and fringe costs, and recording internally funded deductions and fringe costs. Other uses include the correction of chart of account information within AMS Advantage Financial when updates to the payroll application are not necessary.
Configurable Accounting Setup
In addition to the several types of documents, the General Accounting area provides a large number of setup tables that control accounting and budgeting entries as well as when such activity can occur. In addition to setup that states what documents can perform what activity, there is a host of setup tables that control various aspects of the application. More information can be found in the Advanced Setup section of this guide.
Common business tasks (see later section) include setting up a new document code and setting up a new event type. Tasks in this area are not frequent.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 18
Journals and Ledgers for online inquiry and reporting needs
To provide access to detail activity as well as summarized totals for online queries, reports, and batch processing, a large set of journals and ledgers have been provided. As what chart of account information is important to a site varies, the summarization settings for each ledger can be configured online to present summarized totals at a level that is most helpful.
The common business task (see later section) for online journal and ledger inquiry is research such as: What is the account balance? What are the individual transactions that comprise an account balance?
Balance Sheet Account Balances
Advantage Financial provides three specialized inquiry pages [that is, Inception-To-Date Balance Detail (BBALD), Inception-To-Date Balance Summary (BBALS) and Fiscal Year Balance Details (BBALFY)] for Balance Sheet Account (BSA) balances, each at a different level of detail. The "Inquiries section in this user guide contains more information on each of these pages.
All updates to these pages happen with common logic that is shared by all documents and is not driven by any table controls. If a BSA is used, then these tables are updated. This is an important point because the other Accounting Control tables for Fund Balance and Cash Balance have table controls.
Balance Sheet Account balances can be tracked only or controlled to issue document processing errors when an account gets a balance contrary to the normal balance for the account type. More information on this topic can be found in the "Advanced Setup > Balance Sheet Account Balances > Balance Controls section.
Cash Control
The General Accounting area provides five levels of tracking and optionally controlling cash accounts:
1. Fund Type
2. Fund
3. Fund and Sub Fund
4. Fund and Balance Sheet
5. Fund, Sub Fund, BSA, and Sub Balance Sheet
The last two are a form of the Balance Sheet balance control mentioned in the previous feature where only one cash account is evaluated. The first three allow for just one cash account also as well as grouping multiple cash accounts together. The first three also allow for tracking activity prior to becoming cash activity, for example, receivables and requests for payment.
Fund Control
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 19
The General Accounting area provides four levels of tracking and optionally controlling equity accounts:
1. Fund
2. Fund and Sub Fund
3. Fund and Balance Sheet
4. Fund, Sub Fund, BSA, and Sub Balance Sheet
The last two are a form of the Balance Sheet balance control mentioned in the previous feature where only one equity account is evaluated. The first two allow for just one equity account also as well as grouping multiple equity accounts together. The first two also allow for tracking activity prior to becoming equity activity at annual close, for example, revenues and expenditures.
Note: This section refers to controlling Fund Balance, but not all fund codes use that type of equity model. Some choose to use Retained Earnings instead. The Fund Balance feature allows for both, and also allows for the definition of other equity accounts into the control than just a single Fund Balance or Retained Earnings account. Funds that use the Agency Due account (a liability balance) will not use this equity control feature.
CAFR Reporting
AMS Advantage Financial has the capability to define chart of accounts to assist you in producing the Comprehensive Accounting and Financial Reports (CAFR) in compliance with the Government Accounting Standards Board. All accounting activity is also tracked journals and ledgers in such a way to allow for report generation.
To accommodate the recent GASB changes special rollups and indications are provided to the fund accounting elements (Fund, Object, Revenue Source, and Balance Sheet) and Activity . Major and Minor CAFR rollups exist for all five. The nature of these rollups make them hierarchical, meaning the minors are tied to a major, which is inferred when a minor is associated with one of these element codes. Reporting indications exist on the Fund table depicting the major fund(s) and component units.
AMS Advantage identifies the components in your accounting application that correspond to the components of CAFR. The CAFR components are:
Component Unit Funds
Major Funds
CAFR Fund Type and Group
CAFR Major and Minor Expense Types
CAFR Major and Minor Revenue Types
CAFR Major and Minor BSA Groups
CAFR Activity Units
CAFR Major and Minor Activity Types
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 20
Distinct Posting Codes for Accounting-Basis Selection
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 21
Common Terminology This section contains an alphabetical list of terms that are common in the General Accounting area, and a definition for each one.
0-9 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
Accounting Line
The level in a document where, at a minimum, a set of chart of account codes comprising a funding distribution, an event type, and a line amount are entered to create one or more journal postings.
CAFR
Comprehensive Annual Financial Reporting.
Centralized Organizational Structure
The term often associated with the organizational chart of account elements: Government Branch, Cabinet, and Department.
Default Code
A code in a document that is supplied as a result of the use of another code. For example, when a particular fund code is specified in a document, a specific bank code will be defaulted.
Effective dates
The date range during which a code can be used. When a document is dated outside of the range, the code is considered invalid.
Event Type
A high level of accounting activity assigned to a documents accounting line. The event type controls smaller components of accounting activity that are used to perform a specific accounting, budgeting or non-accounting activity. It brings in specific rules for data entry concerning referenced transactions, customer codes, vendor codes, and all defined chart of account elements in the system.
Journal
A detailed historical record of processed data that is stored by document in order of processing.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 22
Ledger
A summarized historical record of data organized by one or more elements of the accounting distribution and by an established period of time.
Nominal Account Activity
The accounting line of a document is said to have nominal activity when a Object or revenue source is used to update a budget. Examples are encumbrances, accrued expenditures, and collected revenue. Another way to identify nominal activity is activity closed into an equity account at year-end which is a broader classification than just a budget update.
Open Item Roll Process
A process that rolls open pre-encumbrances, encumbrances, receivables, and a selected group of the other accounting activity form one budget and accounting fiscal year into the next.
Posting Code
An indication to the system called from an event type during document processing that determines many updates to budget and accounting control tables, posting of journals, default elements with the sequence for finding them and editing any associated balance sheet codes.
Posting Line
The level in a document with the most detailed accounting information that is a common source of information used to update many areas of the application. At this level individual debits and credits are recorded in either a combined posting line (both the debit and credit together) or two half posting lines (separate lines for debit and credit). a very limited number of situations exist where there is only a half posting line: journal vouchers and certain cost accounting activity.
The following are the three types of posting line:
Liquidation Line - A posting line that backs out all or a portion of accounting activity recorded on a referenced posting line.
Standard Line - A posting line that records new accounting activity that if referenced by another document will be liquidated.
Non-Standard Line - A posting line that records new accounting activity that will not be liquidated if referenced by another document.
Real Account Activity
The accounting line of a document is said to have real account activity when balance sheet is used on a generated posting line. Examples are reserve for encumbrances,
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 23
disbursements payable, and cash. While real account activity is most often used in conjunction with nominal activity, an accounting line can have only real account activity.
Tolerance
Ensures that the amount of total activity on a referenced line of a document does not exceed defined limits. They can be defined at several levels for accounting lines: system-wide (STOL), by document code (DTOL), by fund code (FUND). Tolerances can be defined in terms of percentages and/or fixed amounts for underage and/or overage at all three levels. Tolerances are also available at the commodity line level of the Purchase Order and Master Agreement document types, but those settings are done on an individual document and line combination. Defaults for those settings are available from the Procurement Document Control (PRDOC) table.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 24
Document Information This section includes detailed information regarding the documents used in the General Accounting area. The documents are organized first by Document Type and then by Document Code within each type.
Journal Voucher (JV) Document Type
Accounting Based Spending (ABS) Document Type
Internal Exchange Transaction (IET) Document Type
Internal Transaction Initiator (ITII) Document Type
Internal Transaction Agreement (ITAI) Document Type
Payroll Document Type
Journal Voucher (JV) Document Type The Journal Voucher (JV) Document Type is a document that is not based on a single business function. The primary use of the Journal Voucher is to record accounting activities that cannot be accomplished with other documents or do not fit the business function of any other document. The only updates made by this document are to reference queries, accounting control tables, budgets, and journals.
The Journal Voucher is structured with a single document Header, as all documents are. The Header is then followed by a document section called the Line Group. Below the Line Group is the Accounting Line section. There can be one or more Line Groups within a single Journal Voucher document. An Accounting Line has to be defined within a single Line Group. However the numbering of Accounting Lines is one sequence of numbers for the entire document and not within each Line Group.
The actual number of records permitted for any document section of the JV Document Type is controlled by records with a Property of MAX_LINE_LIMIT on the Document Component Requirements (DCREQ) table in the Administration Application.
Important features for the Journal Voucher Document Type:
Referencing
The Journal Voucher line group provides fields for document referencing information that will default to all accounting lines in the line group for data entry assistance. A user may also choose to change the references at the line level to other lines or documents. When the user changes the defaults entered at the line group, all references on the accounting lines defined for it are changed. When the reference fields on the line group are blank, there is no defaulting to the accounting lines.
Like the accounting lines of other document types, the Journal Voucher lines follow the same reference requirement rules that may exist on the Event Type and Document Control tables. In addition to those tables that have reference requirement rules, the Document Allowable References table also controls what document codes a document code of the Journal Voucher can reference. The Journal Voucher is limited in the Reference Type that it can perform. Only a Memo reference can be performed to another document. Partial and Final references are not allowed on the Journal Voucher.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 25
However, the Memo reference will update all reference queries and will be recorded in journals.
Referencing by Journal Vouchers is highly recommended when the document is being used to adjust previous accounting from another document. The recommended approach is to modify the original document to make the correction there, but that is not always possible and not always a desired procedural solution. However, it should be noted that if the Journal Voucher is used to adjust the amount or chart of account information from a previous document, any subsequent changes or references to that original document will still use the amount and chart of accounts prior to the correction.
Balancing
Balancing is a very important feature for the Journal Voucher. For other document types balancing is performed by the application. Line groups have three different types of balance edits:
One edit ensures that the total debit lines equals the total credit lines defined to a line group.
A second balancing edit is that all debit lines for a particular fund (including a sub fund if available) equal the credit lines for that same fund (and sub fund) within a given accounting period and fiscal year. This edit is often referred to as intra-fund balancing. The Include BFY in JV Balancing field on Document Control (DCTRL) can extend this intra-fund balancing to include budget fiscal year in addition to accounting period and fiscal year.
There is a third optional and configurable edit for balancing cash updates. The Cash Balance Level field on Document Control (DCTRL) has two settings that ensure balancing on accounting lines that use a cash posting code. The first is a balance across the document and the second is a balance within Fund and Sub Fund.
Defaulting Balance Sheets
Unlike other documents, Journal Vouchers do not default balance sheet accounts from settings on the Posting Code table. The user must enter these accounts on the document, where as other accounting documents will infer such accounts for users. For example, when an internal exchange is done between a seller and buyer where cash is to be used as the offset, the Internal Exchange (IET) document will infer the cash account from the bank of both parties. The same accounting event entered on a Journal Voucher would require the user to enter a cash account for both parties. The reason for this behavior is two-fold - one functional and one technical:
1. The Journal Voucher is an advanced accounting document where accounts that would normally default on other documents are not to be used in lieu of manual specification of another account.
2. The Journal Voucher does not use the generic or any other type of event type processor to generate posting lines, but rather creates posting lines with document-specific logic. This is possible since an accounting line on a Journal Voucher is entered with much of the same detail as system-generated posting lines on other documents. It is the use of these event type processors that allows for other documents to default accounts.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 26
Automatic Reversals
The Journal Voucher is capable of performing one action that no other document type can perform. This action creates a second Journal Voucher in the future exactly like the first one except that the debit and credit amounts on the accounting lines are reversed. This action can only be performed once in the future, making it different than the main trigger type - Recurring. The same table that controls all automatically triggered documents, the Future Document Triggering (FDT) table, handles this reversing action.
Information to establish reversals is contained in the header section of the Journal Voucher. Two fields make up the information. One is the Reversal Date, which is when the automatic creation of the reversing Journal Voucher is to be performed. It must be a date in the future. The second field, Create Reversal Document on Hold, is an indication of whether or not the reversing Journal Voucher will be created in the Hold document status or with a status of Ready.
When the reversal is created, line groups and accounting lines will contain memo references to the original Journal Voucher. If there were references already on the first document, the second document replaces them. Because of this reference, when a user retrieves the history of either Journal Voucher, they will see that there is a second Journal Voucher that relates to the first. Another way to locate the reversing Journal Voucher is to search for the original Journal Voucher on the Future Document Triggering (FDT) table as it will list that reversing document in the Generated Document ID (Gen. Doc. ID) column. This second method is not as permanent as using the document reference query because triggers are removed based on the Expire Date found on the FDT table.
A Journal Voucher may not contain both recurring and reversing information. You can only have one of either type.
Document Control Settings and Security
The Override of BFY Staging Allowed flag will not apply if an Event Type is not supplied. In this case the Journal Voucher will skip BFY Staging editing. If entered, posting lines must meet BFY Staging rules. If not, a reject error will occur unless the Override of BFY Staging Allowed flag is checked, in which case the error will be an overrideable one.
The Event Type Required flag is only read by the JV document type. If checked, the document code will always require an event type. Such a requirement will ensure users enter only the posting codes defined to an Event Type and do not used posting codes they shouldnt.
The many other controls in the Allowable Elements section of Document Control will often be checked for journal voucher document codes because the document is a tool for recording events after the fact or for accounting corrections. For this reason, security for journal vouchers is often tightly controlled.
Related Topic(s):
The "JV Delivered Document Codes" section provides a list of all document codes that are delivered with the JV Document Type.
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 27
For a description of the delivered event types allowed for the JV Document Type, please see the following sections in the Accounting Model Delivered Configuration section: Bond/Debt Accounting Model, Cost Accounting - Accounting Model, and Miscellaneous Accounting.
For instructions on how to create manual journal entries, refer to the "Create Manual Journal Entries" section under Common Business Tasks.
JV Delivered Document Codes
This document type contains several delivered document codes. Many of these codes relate to a batch program that is creating journal vouchers for a specific processing need. In each case, a document code has been established to provide quick recognition of these documents on the Document Catalog and for reporting. Further needs often exist for these document codes to have different security and Document Control table settings. There are also several other document codes that are not tied to a specific batch job.
The full list of delivered document codes is as follows:
Document Code Document Name Intended Use
JV Standard Journal Voucher Data entry where an event type is required to control posting code entry
JVA Advanced Journal Voucher Data entry where an event type is not required to control posting code entry
JVAC Annual Close Journal Voucher
Annual Close chain job to record closing activity in a year closed and roll balances into the next year
Should be the only document code on the Allowed Accounting Periods for Document Code table with access to periods 0 and 99
JVBK Bank Transfer Journal Voucher Bank Account Transfer chain job to move cash between banks used other than the Master Bank for a fund and that Master Bank
JVC Cost Accounting Journal Voucher
Reimbursable Expense Adjustment chain job to adjust funding lines to defined percentages
Manual entry of cost accounting activity because of an expanded Detail Accounting section.
JVCAM JV - Clearing Account Maintenance
Created by the Clearing Account Maintenance Chain Job when clearing Due To and Due From accounts though Cash
JVIA Journal Voucher Income Allocation chain job for Treasury
-
AMS Advantage Financial General Accounting User Guide
3.9.0.1 Release CGI Technologies and Solutions Inc. Proprietary and Confidential Page 28
Income Allocation Accounting that allocates investment income to the Participatory funds
JVIN Investment Journal Voucher
Manual entry for the acquisition and sale of investments with the Treasury Accounting subsystem
JVP Payroll Journal Voucher Record expenditures, liabilities, and/or generate payments related to payroll activity
JVR Restricted Journal Voucher
Provides a feature to pre-populate all accounting lines with COA established at the line group to assist with data entry or ensure that all accounting lines have the same COA value(s)
The reclassification revenues and expenditures is an example where certain COA values between the accounting line being reduced and the one being increased should be the same
JVSW Journal Voucher Cash Sweep
Cash Sweep chain job for Treasury Accounting taking cash from Participatory funds and giving to the Pool fund
Standard Journal Voucher (JV)
Purpose
The Standard Journal Voucher (JV) Document Code is one of several Document Codes of the JV Document Type that can be created manually by a user (JV, JVA, JVC, JVIN and JVR). All others should be created by chain jobs. The JV Document Code should be used when an event type and posting pair is required to control posting code entry. Event Type and posting pairs specified on the JV Line Group limits the choice of posting codes that can exist on the JV Accounting Lines under that line group. As the JV can perform any type of accounting, having the restriction on Posting Code choice based on a selected Event Type provides end user control. For this reason, when the creation of