MSI MS-6540G- Manuals

vi Lesson 4 Posting transaction batches 4.1 Batch status .......................................................................................................... 4:1 4.2 Backing up before posting ................................................................................... 4:2 4.3 Individual...

vii Appendix B Solutions to self-testing questions .......................................................................................................................... B:1 Appendix C Managing budget data C.1 Entering and editing budget data ........................................................

Computer Tutorial 3 Introduction  1 Introduction to Computer Tutorial 3 Purpose of the tutorial The purpose of this tutorial is to present the basic features of the accounting software Sage Accpac ERP. The CGA Educational version provided with this tutorial will enable you to apply the techniques d...

2  Introduction Computer Tutorial 3 Reference material The material presented in this tutorial can be used without referring to other sources. The authoritative reference to the software is the documentation provided with the CGA Educational version of Sage Accpac ERP on the CD. First-time users ar...

Computer Tutorial 3 Lesson 1  1 LESSON 1 Basic concepts of a general ledger and Sage Accpac ERP CGA 5.6A Topic outline 1.1 Journals and ledgers 1.2 Overview of a general ledger 1.3 The chart of accounts 1.4 Manual accounting systems 1.5 Computerized accounting systems 1.6 Introducing Accpac General...

2  Lesson 1 Computer Tutorial 3 TOPIC 1.1 Journals and ledgers With a manual accounting system, each transaction is recorded in chronological order in a book of original entries called the journal . If all the transactions are recorded in one master journal, the journal is called the general journa...

Computer Tutorial 3 Lesson 1  3 EXHIBIT 1-2 Examples of a partial general ledger and a subsidiary ledger Partial general ledger NAME: CASH ACCOUNT NO. 1100 Date 2001 Explanation Post Ref Debit Credit DR CR Balance 1-Jan Dr $ 8,000.21 31-Jan Month-end deposits CR-21 126,225.49 Dr 134,225.70 31-Jan P...

4  Lesson 1 Computer Tutorial 3 TOPIC 1.2 Overview of a general ledger To record the assets, liabilities, and shareholders’ equity (including revenues and expenses) of a company in an orderly manner, accounting information is grouped into accounts. For example, all information relating to changes i...

Computer Tutorial 3 Lesson 1  5 TOPIC 1.3 The chart of accounts A chart of accounts is a logical structure of account numbers designed to make it easier and faster to look up an account in the general ledger. A chart of accounts is basically a table of contents for a general ledger. For a complex g...

Computer Tutorial 3 Lesson 1  9 6620 Shop supplies Active I,DR,F 6640 Subcontract costs Active I,DR,F 6660 Traveling expenses Active I,DR,F 6680 Telephone, telex, fax Active I,DR,M 6700 Utilities Active I,DR,M 6720 Wages & benefits, direct Active I,DR,F 6725 Employer taxes, direct Active I,DR,M...

10  Lesson 1 Computer Tutorial 3 The trial balance worksheet also forms the basis of financial statements because it contains a detailed listing of the balances of all accounts in the general ledger. Adjusting entries may be added to the trial balance for information not previously recorded in the ...

Computer Tutorial 3 Lesson 1  11 The direct-entry method enables you to enter the transactions directly, which reflects the results of the transactions immediately. The disadvantage, however, is that control over transaction entry is significantly weaker than with the batch method because there is ...

12  Lesson 1 Computer Tutorial 3 TOPIC 1.7 Installing the program and data files The procedure for installing Sage Accpac ERP CGA 5.6A is described in Topic A.1 of Appendix A. This version can co-exist with other versions of Accpac. It is designed to avoid conflict with other versions of Accpac tha...

Computer Tutorial 3 Lesson 1  13 EXHIBIT 1-4 Using the Start button 2. The Open Company sign-on window appears (Exhibit 1-5). Click the drop-down arrow to the right of the Company field to display the list of companies whose data is included for this tutorial. Sample Company Ltd. will be used for t...

14  Lesson 1 Computer Tutorial 3 EXHIBIT 1-5 Open Company sign-on window TOPIC 1.9 The company desktop After you have selected a company, Accpac displays the company desktop (Exhibit 1-6). If it is not displayed, select “Sample Company Ltd.” from the left navigation pane. EXHIBIT 1-6 Accpac company...

Computer Tutorial 3 Lesson 1  15 Accpac uses a design similar to Windows Explorer. On the left-hand side is a navigation pane that shows services and the general ledger application. Within these folders are icons for specific tasks, which may be contained within a subfolder. A plus sign indicates a...

16  Lesson 1 Computer Tutorial 3 To use this data, select Sample Company Inc. from the Open Company window upon starting Accpac. The Open Fiscal Period is also 2010. You can use this other set of data to practise on without altering the tutorial data. Work through the self-testing questions in the ...

Computer Tutorial 3 Lesson 2  1 LESSON 2 Working with a chart of accounts Topic outline 2.1 Using an input window 2.2 The G/L Accounts window 2.3 Using Accpac Help 2.4 Printing an opening trial balance 2.5 Printing and reviewing the chart of accounts 2.6 Adding, modifying, and deleting accounts 2.7...

2  Lesson 2 Computer Tutorial 3 Input features in the G/L Accounts window Fields Fields are often text boxes into which you type characters; some fields are filled out by selecting values from drop-down lists. To illustrate these fields, an input window — the G/L Accounts window — will be used. Som...

Computer Tutorial 3 Lesson 2  3 EXHIBIT 2-2 Finder - Accounts window 3. If you click the Find by: drop-down arrow, you can choose the column by which Accpac will conduct the search. For example, you can search by account number, description, or type. Select Description from the drop-down list. 4. I...

4  Lesson 2 Computer Tutorial 3 TOPIC 2.2 The G/L Accounts window You need to know what each field in the G/L Accounts window means. With the G/L Accounts window open, read the following explanations of the fields: Account. This field displays the alphanumeric identifier of an account in the chart ...

Computer Tutorial 3 Lesson 2  5 appears when you select this option. This is where you would choose the accounts to which you would have amounts allocated. Multicurrency. Select this option if the account will be using a currency other than the functional currency. Multicurrency must be allowed in ...

6  Lesson 2 Computer Tutorial 3 EXHIBIT 2-4 Accpac System Manager Help window 2. To access General Ledger Help, you need an open General Ledger window. You can do this by clicking on any item under General Ledger on the left navigation pane, then double-clicking on any icon on the right. For exampl...

Computer Tutorial 3 Lesson 2  7 System Manager Help will provide information on Accpac services that are not dependent on any particular module such as GL or AP. General Ledger Help provides information on the General Ledger module. Accpac also comes with manuals that are helpful in learning the pr...

8  Lesson 2 Computer Tutorial 3 3. In the G/L Trial Balance Report window (Exhibit 2-7), click the drop-down arrow to the right of the Report Format field and select Report. EXHIBIT 2-7 G/L Trial Balance Report window 4. In the For Year/Period field, click the drop-down arrow to change the year and...

Computer Tutorial 3 Lesson 2  9 EXHIBIT 2-8 Print dialog box 6. Close the G/L Trial Balance Report window to return to the company desktop. Your printout of the Trial Balance should resemble Exhibit 2-9.

10  Lesson 2 Computer Tutorial 3 EXHIBIT 2-9 Sample Company Ltd. opening trial balance for 2010

12  Lesson 2 Computer Tutorial 3 The net income for fiscal Period 1 in 2010 is $88,538.81. TOPIC 2.5 Printing and reviewing the chart of accounts You can view the chart of accounts on the screen or print a copy for future reference. It is a good idea to have an up-to-date printed chart of accounts ...

Computer Tutorial 3 Lesson 2  13 EXHIBIT 2-10 G/L Chart of Accounts Report window

14  Lesson 2 Computer Tutorial 3 EXHIBIT 2-11 Chart of Accounts

18  Lesson 2 Computer Tutorial 3  The following column displays the account configuration: B for balance sheet or I for income statement accounts, DR (debit) or CR (credit) signifies normal balance of the account, F for functional currency, and M for multicurrency.  The Post in column then follow...

Computer Tutorial 3 Lesson 2  19 Adding more new accounts Add more new accounts to complete the chart of accounts for Sample Company Ltd. 11. Use the method illustrated in steps 2 to 9 to add the following new accounts. Accept the default unless specified below: Account Description Structure Accoun...

20  Lesson 2 Computer Tutorial 3  Some settings are permanent. In the initial setup process, for example, you can create a format for the segmented account number. But once these formats have been set up, they cannot be changed. In Exercise 2.7, you delete an account added in Exercise 2.5. EXERCIS...

Computer Tutorial 3 Lesson 2  21 Database Dump Database Dump allows you to externally extract an Accpac data set. The data can then be stored as a type of backup, loaded into another Accpac database, or used when converting a database from one format to another. 1. You will find Database Dump under...

22  Lesson 2 Computer Tutorial 3 4. You should get a message box indicating the operation is complete (see Exhibit 2-13). Click on OK. Then close the Dump Accpac Data window. EXHIBIT 2-13 Summary box General comments You should back up your data whenever you have done a significant amount of work. ...

Computer Tutorial 3 Lesson 3  1 LESSON 3 Managing transactions Topic outline 3.1 Accpac journal entries and transaction batches 3.2 G/L Journal Entry window 3.3 Viewing and printing a transaction batch 3.4 Entering transactions 3.5 Modifying a transaction batch 3.6 Deleting a transaction batch 3.7 ...

2  Lesson 3 Computer Tutorial 3 TOPIC 3.1 Accpac journal entries and transaction batches When using Accpac, you are required to organize accounting events into transactions that are entered as journal entries. Each entry or transaction is composed of as many debits and credits as necessary to descr...

Computer Tutorial 3 Lesson 3  3 No accounting program can check for incorrect accounting treatment — you can still credit or debit the wrong account as long as the account number exists. TOPIC 3.2 G/L Journal Entry window There are two ways to access the G/L Journal Entry window. The first is throu...

Computer Tutorial 3 Lesson 3  5 EXERCISE 3.1 Creating a batch 1. The G/L Batch List window should still be open. If not, follow the instructions at the beginning of Topic 3.2 to open it. 2. Click New. The G/L Journal Entry window opens (Exhibit 3-2). EXHIBIT 3-2 G/L Journal Entry window 3. Leave th...

Computer Tutorial 3 Lesson 3  7 The following columns appear in Multicurrency ledgers only:  Currency  Source Debit (instead of the Debit column)  Source Credit (instead of the Credit column)  Rate Type  Rate Date  Rate  Functional Debit  Functional Credit After you have finished studying t...

8  Lesson 3 Computer Tutorial 3 In Exercise 3.3, you print a batch. EXERCISE 3.3 Printing transaction batches Printing from the G/L Batch List window 1. In the G/L Batch List window, select batch 146, then click Print. The G/L Batch Listing Report window opens. 2. Ensure you have chosen your prefer...

Computer Tutorial 3 Lesson 3  9 Study the report and notice the following:  The date shown in the upper-left corner is the system date from your computer based on when the report was printed.  A total is calculated for each entry. The total for the entire batch appears beside Batch Total.  In ba...

Computer Tutorial 3 Lesson 3  11 8. In the Account field, you can directly enter the account number by typing it into the field. If the account number you want to enter does not exist in the chart of accounts, you will have to enter it into the chart of accounts first. If you do not know the accoun...

12  Lesson 3 Computer Tutorial 3 13. Enter the remaining two transactions for Batch 148, then create a new batch and enter the last entry. 14. Close the G/L Journal Entry window but leave the G/L Batch List window open for the next exercise. TOPIC 3.5 Modifying a transaction batch You have been inf...

Computer Tutorial 3 Lesson 3  13 TOPIC 3.6 Deleting a transaction batch When there are many errors in a transaction batch, it may be simpler to delete the entire batch and start over rather than edit the batch. You cannot re-use a deleted batch number. As a precaution, before you delete one or more...

Computer Tutorial 3 Lesson 4  1 LESSON 4 Posting transaction batches Topic outline 4.1 Batch status 4.2 Backing up before posting 4.3 Individual posting of batches 4.4 Range posting of batches 4.5 Correcting transaction errors after posting 4.6 Self-testing questions Overview In Lesson 3, you pract...

2  Lesson 4 Computer Tutorial 3 In Exercise 4.1, you view the G/L Batch List before posting the transaction batches. EXERCISE 4.1 Viewing a batch status 1. Click G/L Transactions on the left navigation pane, then double-click the Batch List icon on the right. The G/L Batch List window is displayed ...

Computer Tutorial 3 Lesson 4  3 TOPIC 4.3 Individual posting of batches In Accpac there are several methods of posting batches. The simplest method is individual batch posting. It enables you to post batches one at a time. In Accpac, it is possible to set up a large number of user types on the syst...

4  Lesson 4 Computer Tutorial 3 3. In the G/L Batch List window, click Post. The batch is now posted to the general ledger. 4. Leave the G/L Batch List window open. TOPIC 4.4 Range posting of batches Range posting of batches enables you to post all batches available or to post a range of batches. T...

Computer Tutorial 3 Lesson 4  5 TOPIC 4.5 Correcting transaction errors after posting Once transactions are posted to the general ledger, you generally cannot delete or modify them. As noted previously, if a transaction does not balance, it will not be posted to the general ledger. Accpac is design...

Computer Tutorial 3 Lesson 5  1 LESSON 5 Printing reports and making adjusting entries Topic outline 5.1 G/L reports 5.2 Printing a transactions listing 5.3 Printing a trial balance 5.4 Adjusting entries 5.5 Making an adjustment to a prior period 5.6 Self-testing questions Overview After you have e...

2  Lesson 5 Computer Tutorial 3  Batch Status : prints a record of all G/L batches  Batch Listing : prints a record of transactions that have not been posted to the G/L  Posting Journals : prints a record of transactions that have been posted to the G/L Setup reports include:  Chart of Accounts...

Computer Tutorial 3 Lesson 5  3 EXERCISE 5.1 Printing the transactions listing 1. Close any windows that you may have open and return to the company desktop. Click G/L Reports on the left navigation pane, then double-click the Transactions Listing icon on the right. 2. Choose your preferred print d...

4  Lesson 5 Computer Tutorial 3 EXHIBIT 5-1 Print Destination window 2. Click G/L Reports, then double-click the Transactions Listings icon. Ensure the From Period is 2010 1 and the To Period is 12. Click Print. The Export window opens (Exhibit 5-2). EXHIBIT 5-2 Export dialog box 3. Accept the defa...

Computer Tutorial 3 Lesson 5  5 EXHIBIT 5-3 Choose Export File window 4. In the Choose Export File window, there is a field for entering the file name. Type TransList in the File name field, then click the Save in drop down menu, select Desktop or My Documents, where you can easily locate the saved...

6  Lesson 5 Computer Tutorial 3 EXHIBIT 5-4 Transactions Listing report displayed on the screen One use of displaying a report on the screen is to verify that it is correct prior to sending it to a supervisor or manager. Once you have verified it, you can send it in hardcopy or by e-mail as an atta...

Computer Tutorial 3 Lesson 5  7 EXERCISE 5.4 Printing a trial balance 1. Click G/L Reports, then double-click the Trial Balance icon. The G/L Trial Balance Report window opens. 2. In the Report Format drop-down list, select Report. The For Year/Period field should be changed to 2010-12 . Accept all...

8  Lesson 5 Computer Tutorial 3 EXERCISE 5.5 Making and posting adjusting entries 1. Add the following account to your chart of accounts (see Topic 2.6 for an explanation of this process): Account Description Structure Account Normal Account code type balance group 2090 Accrued ACC Balance Credit C...

Computer Tutorial 3 Lesson 5  9 EXHIBIT 5-5 Batch listing TOPIC 5.5 Making an adjustment to a prior period There are situations where you may need to make changes to prior periods, such as adjustments that came to light during an audit that need to be reflected in the financial statements of the pe...

Computer Tutorial 3 Lesson 5  11 EXERCISE 5.6 Posting an adjustment to a previous year Assume that the inventory value was overstated at the end of the previous year by $50,000. The amount is material, and the books have already been closed but no financial statements have been published yet. It is...

Computer Tutorial 3 Lesson 6  1 LESSON 6 Designing and printing financial statements Topic outline 6.1 Printing a financial statement 6.2 Modifying a financial statement 6.3 Modifying a specification file 6.4 Creating a specification file 6.5 Self-testing questions Overview The most important outpu...

2  Lesson 6 Computer Tutorial 3 EXERCISE 6.1 Printing a balance sheet 1. Click Financial Reporter on the left navigation pane, then double-click the Print Financial Statements icon on the right. The G/L Print Financial Statements window opens (Exhibit 6-1). EXHIBIT 6-1 G/L Print Financial Statement...

Computer Tutorial 3 Lesson 6  3 TOPIC 6.2 Modifying a financial statement Accpac uses MS Excel to produce its financial statements, both in creation and output. Accpac uses an Excel spreadsheet called a specification file to produce the financial statements. You can also specify that the output (th...

4  Lesson 6 Computer Tutorial 3 EXHIBIT 6-3 Preliminary balance sheet 3. Combine all the bank accounts into one entry. (Assume the foreign bank accounts are presented in Canadian dollars so you can simply sum them.) Record the total amount of cash in all banks in cell C12. Change cell B12 to read “...

Computer Tutorial 3 Lesson 6  5 EXHIBIT 6-4 Balance sheet with bank accounts combined 4. In this manner, combine the following accounts: Prepaid insurance, Prepaid rent, and Prepayment AP purchases into one account called Prepaids. Prepayment liability, Accts payable clearing, and Accrued liabiliti...

6  Lesson 6 Computer Tutorial 3 EXHIBIT 6-5 Final combined balance sheet In this way, you can modify the financial statement to suit your needs. You can also use any Excel functions or formatting to modify your statements. For example, if you want to show only dollar amounts on the statements, you ...

Computer Tutorial 3 Lesson 6  7 scratch or modify one of the specification files provided with the General Ledger. The default location for the specification files is C:\Program Files\AccpacCGA\GL56A\ENG. You open and save a working copy of the quikbal1.xls specification file in Exercise 6.3. EXERC...

8  Lesson 6 Computer Tutorial 3 EXHIBIT 6-7 Spreadsheet with new filename Columns With your working copy of the quikbal1.xls specification file open, read the following description of the purpose of the columns in specification files. The first four columns of a specification file (columns A throug...

Computer Tutorial 3 Lesson 6  9 Missing from this specification file is a title row. This would appear as “/T”. Anything on a title row would appear on each page of the report. Column B If Column A is being used as a body specification row and specifies a range of accounts, then this column control...

10  Lesson 6 Computer Tutorial 3 Row 14 has a formula that generates the account balance for the period from the general ledger. This particular formula treats debits as positive and credits as negative. Row 16 has a “\” which repeats information above it. In this case, it repeats the formula that ...

Computer Tutorial 3 Lesson 6  11 EXERCISE 6.4 1. On your working copy of the quikbal1.xls spreadsheet, click FR, FR View. The G/L Financial Statement Designer window opens (Exhibit 6-8). Ensure the Year/Period is 2010-12. EXHIBIT 6-8 G/L Financial Statement Designer window 2. Click OK. A Financial ...

12  Lesson 6 Computer Tutorial 3 EXHIBIT 6-9 Sample Company Limited balance sheet 3. You will make changes to the current asset section of the balance sheet first. You will combine all the Bank accounts into one line, and all the prepaid accounts into one line. Place your cursor on line 17 and clic...

Computer Tutorial 3 Lesson 6  13 EXHIBIT 6-10 Current asset section of balance sheet 9. Now you will combine accounts in the current liabilities section. You will combine all the employee deduction accounts into one line, and all the tax payable accounts into one line. Place your cursor on line 35 ...

14  Lesson 6 Computer Tutorial 3 In this way, you can modify specification files to suit your needs. Any future balance sheets will be produced according to the new specification file. You would not have to repeat these steps if you reprinted the balance sheet. However, if you added new accounts in...

Computer Tutorial 3 Lesson 6  15 cell to show a leading dollar sign by clicking Format Cells. Click the number tab, and choose Accounting as the category. Choose $ as the symbol. Click OK. 11. In cell A10, enter 3300 , the account number for Dividends. 12. In cell F10, enter Dividends . 13. In cell...

16  Lesson 6 Computer Tutorial 3 EXHIBIT 6-13 Specification file showing formulas 22. Click FR, FR View. Ensure the Year/Period is 2010-12. Click OK. Your retained earnings statement should look like Exhibit 6-14. If it does not, compare your formulas and statement to those in Exhibits 6-12 to 6-14...

Computer Tutorial 3 Lesson 7  1 LESSON 7 Maintaining Accpac Topic outline 7.1 A logical chart of accounts 7.2 Maintenance procedures 7.3 Operating procedures 7.4 Month-end procedures 7.5 Year-end procedures 7.6 Starting a new fiscal year 7.7 Internal controls 7.8 Self-testing questions 7.9 Taking s...

2  Lesson 7 Computer Tutorial 3 5. If you are working with more than one general ledger, try to standardize the charts of accounts. Use account numbers rather than account names Accpac has a very flexible structure. As previously mentioned in Topic 1.3, with the commercial version of the program yo...

Computer Tutorial 3 Lesson 7  3 There are two common ways to include the Accumulated amortization contra accounts in a chart of accounts: 1. Place them in a block, for example: 1500 Warehouse 1510 Delivery truck 1520 Office computer 1600 Accum. amortization – warehouse 1610 Accum. amortization – de...

4  Lesson 7 Computer Tutorial 3 Use meaningful names for account descriptions In the G/L Account window, each account is assigned a description. It is important to use meaningful names for these account descriptions. The benefits are: You minimize the chance of error when posting transactions if th...

Computer Tutorial 3 Lesson 7  5 before year-end close after setting up Accpac before and after creating a new company before year-end close before moving data or applications to another server Accpac is designed to ensure maximum accuracy and integrity of your accounting data. Occasionally, however...

6  Lesson 7 Computer Tutorial 3 EXHIBIT 7-1 Data Integrity window 2. In the Available Applications section, click General Ledger 5.6A, then click Include. You can also click All to select all applications in the list. However, for this exercise, insert only General Ledger 5.6A. 3. Click Check to be...

Computer Tutorial 3 Lesson 7  7 EXHIBIT 7-3 Integrity Check Log 5. Close the Integrity Check Log and the Data Integrity window to return to the company desktop. By following these steps, you ensure the integrity of your data under most normal operating circumstances. However, it is no guarantee tha...

8  Lesson 7 Computer Tutorial 3 4. Always back up the data before posting. 5. Post the batches, which will trigger the printing of the posted batch. 6. Collect the batch listings and posting journals in a file. This file constitutes a complete audit trail. TOPIC 7.4 Month-end procedures To ensure s...

Computer Tutorial 3 Lesson 7  9 7. Print the month-end financial statements. Make sure the balance sheet balances and the net income amount in the income statement matches that on the balance sheet. (See Lesson 6.) 8. Print a transactions listing for the entire month. (See Lesson 5.) 9. Assemble in...

10  Lesson 7 Computer Tutorial 3 TOPIC 7.5 Year-end procedures One major benefit of using Accpac is that year-end procedures are significantly simpler than with a manual general ledger. However, a systematic approach is necessary to ensure all the steps are followed and completed efficiently. Recom...

Computer Tutorial 3 Lesson 7  11 TOPIC 7.6 Starting a new fiscal year When the recommended year-end procedures are almost complete and you are ready to start entering transactions for a new fiscal year, there are two major steps to take: 1. Create a new fiscal year. 2. Perform period-end maintenanc...

12  Lesson 7 Computer Tutorial 3 Following is a basic set of internal controls that can be used to protect the financial information in a general ledger: 1. Control access to general ledger data. 2. Do routine backups. 3. Store the backups off-site to control access and to ensure that if the buildi...

Computer Tutorial 3 Lesson 7  13 type of service for a fee. Banks are also good choices because most backup media are small enough to fit into a safety deposit box. If neither is feasible, the next best alternative is a fireproof safe or locked cabinet in another office or branch of the same organi...

14  Lesson 7 Computer Tutorial 3 8. Torban is a new accountant for a small, privately held firm. He is surprised to find that computer printouts from the general ledger are regularly discarded in the waste basket with no concern about the environment. During the first week of his employment, Torban...

Computer Tutorial 3 Appendix A  1 APPENDIX A Installing Sage Accpac ERP CGA 5.6A This appendix describes how to install and remove Sage Accpac ERP CGA 5.6A. Before installation, make sure your computer meets the minimum system requirements as published by your regional CGA office. The Sage Accpac E...

2  Appendix A Computer Tutorial 3 3. Click Microsoft SQL Server 2005 Express Edition and choose Uninstall. Wait for the uninstall to complete. 4. Select the ACCPAC53CGAR2 Database Engine instance and click OK to continue. Wait for the uninstall to complete. 5. Click the Microsoft SQL Server Native ...

Computer Tutorial 3 Appendix A  3 EXHIBIT A-2 Setup Menu 3. Click Install Microsoft .NET Framework 3.5 SP1. The files are extracted and the setup starts. EXHIBIT A-3 Extracting Files If your computer already has .NET Framework 3.5, you may see a Maintenance Mode dialogue. Click Cancel to abort the ...

4  Appendix A Computer Tutorial 3 EXHIBIT A-4 Maintenance Mode If a message appears recommending that you “...download and install the latest service packs and security update...,” this can be ignored for now. 4. Click Install Windows Installer 4.5. The installation opens a “command prompt” Window ...

Computer Tutorial 3 Appendix A  5 EXHIBIT A-6 Windows Update Standalone Installer 5. You may need to restart your computer at this point. If so click Restart Now. When your computer has restarted, reinsert the Sage Accpac DVD and click to accept the autorun.exe or start the autorun.exe as you did i...

6  Appendix A Computer Tutorial 3 EXHIBIT A-8 Windows Update Message 7. Click Install PowerShell 1.0. As with the previous item, a command window is opened and the update may not apply to your system. Follow the prompts accepting all defaults. 8. On the Microsoft SQL Server 2008 Express menu, click...

8  Appendix A Computer Tutorial 3 3. Click the option to accept the terms of the license agreement, and click Next. EXHIBIT A-12 User License Agreement 4. Click Next to accept the default installation folders.

Computer Tutorial 3 Appendix A  9 EXHIBIT A-13 Sage Accpac Folders 5. At the Select Features dialogue, ensure that the Multicurrency and Financials Suite (including the General Ledger) options are selected , and click Next. EXHIBIT A-14 Select Features

10  Appendix A Computer Tutorial 3 6. Click Next to accept the default shortcut location, and then click Install to begin the installation. EXHIBIT A-15 Program Folder 7. At the Sage Accpac ERP License Maker Page, click close to accept the defaults.

Computer Tutorial 3 Appendix A  11 EXHIBIT A-16 License Manager 8. Click Finish on the Sage Accpac 5.6A InstallShield Wizard page. ( Note: The Read Me page does not contain information needed for your coursework or running Accpac.) EXHIBIT A-17 Installation Complete

12  Appendix A Computer Tutorial 3 Data Loader Sage Accpac ERP CGA 5.6A does not come with any company’s dataset installed. You must download the data that is used in this tutorial from http://www.cga-education.org/2011- 12/ct3/ . Follow the instructions on that page to download and extract the dat...

Computer Tutorial 3 Appendix A  13 EXHIBIT A-19 Sage Accpac CGA Data Loader A company’s dataset is simply a folder that contains five items:  One folder containing the company database  One folder containing the system database  Three files needed in the Data Load process (two .dct files and one...

14  Appendix A Computer Tutorial 3 EXHIBIT A-20 Locating a dataset 4. Click on the dataset you want to load and click Load (Exhibit A-21). EXHIBIT A-21 Selecting a dataset 5. The data will load. When complete, you should see the message in Exhibit A-22.

Computer Tutorial 3 Appendix A  15 EXHIBIT A-22 Successful completion Loading from a backup You may wish to load a backup copy of the data, rather than the original data provided. To do this, you need to create a new dataset. Remember that a dataset is only a folder containing the five items needed...

16  Appendix A Computer Tutorial 3 TOPIC A.5 Uninstalling Sage Accpac ERP CGA 5.6A To remove Sage Accpac ERP 5.6A, follow these steps: 6. Make sure you have exited Accpac. 7. From the Windows desktop, click Start, select Settings, then Control Panel. 8. In the Control Panel window, double-click Uni...

Computer Tutorial 3 Appendix B  1 APPENDIX B Solutions to self-testing questions Lesson 1 1. A computerized general ledger keeps financial information electronically in a database. The database contains account numbers, names, budget information, and balances for each account (in the chart of accou...

Computer Tutorial 3 Appendix C  1 APPENDIX C Managing budget data Topic outline C.1 Entering and editing budget data C.2 Viewing and printing budget data Overview In addition to historical data and opening balances, many general ledgers contain information about budgets for the current year and sev...

2  Appendix C Computer Tutorial 3 TOPIC C.1 Entering and editing budget data When using Accpac to create a budget, there is a range of built-in calculations to create the numbers for the budget in the Budget Maintenance window. Using Accpac to create a budget In Exercise C.1, using the Budget Maint...

Computer Tutorial 3 Appendix C  3  In the Year fields, you can select any year established in the fiscal set of the general ledger.  In the Fiscal Set field, you can use the drop-down arrow to select either Actual or Budget numbers for the Inquiry Amount column. 3. Enter 4000 in the Account field...

4  Appendix C Computer Tutorial 3 EXHIBIT C-3 Enquiry Amount column showing amounts 7. You are now able to modify Budget Set 1 based on Actual 2009 data. 8. Leave the Budget Maintenance window open for the next section. The Budget Maintenance window is used to create or modify monthly budget amount...

6  Appendix C Computer Tutorial 3 5. Click the radio button next to Copy, As Is. Click Replace. Note the amounts from the Inquiry Amount column have been copied to the Budget Amount column. Clicking Add to doubles the amount in the Budget Amount column. 6. In this manner, you can select different B...

Computer Tutorial 3 Appendix D  1 APPENDIX D Glossary Some of the technical terms used in this tutorial are listed and defined below. Certain definitions are specific to Accpac. Account An account is a type of record where individual transactions are recorded. It may contain up to 45 alphanumeric c...