Home

General Ledger

1. f Change Fields Commands Edit Modes Other Scroll Commands Help 2xt malmal lee o Field ID GL ACCOUNT 4 Print Log Original Value New Value File Description Time Tag 100100 100001 E Tax Location Header File Long Ed 200100 200001 a Tax Location Header File Long Y 2 Tax Location Header File Long v F Bank Accounts File Short Ea Distribution Codes File Long EI Distribution Codes File Long Distribution Codes File Long Distribution Codes File Long AP Check History File Short AP Purchase History File Short Material Requisitions Det Long E Recurring Line Items Long v E Transaction Line Items Long g E AP Vendor File Long Y Line No 000001 of 000002 Begin code change l Header Eield ID l Years Switch to tag l Enter edit Append None Got Company H 11 9 2007 Terminal Too OVR General Ledger 8 49 CHAPTER 8 File Maintenance Change Fields Header Values 8 50 The screen contains three sections The top Header section which includes the Field ID and Print Log fields is where you select the code or ID to change and whether you want to produce the printed log The lower left Values section is where you build a list of the values you want to change by specifying the old value and the new value The lower right Files section contains a list of
2. 3 Click OK or press Enter to continue 4 When available either select Standard or enter S if you want to view the report in standard width or select Compressed or enter C if you want to view it in compressed width 5 Press Enter The Print Preview screen displays the report as it will look when printed out in hard copy 6 To print from this screen select Print from the File menu To exit from this screen select Exit from the File menu Save the Report as a PDF PDF output is available for OSAS systems using BBj The data path set up for the workstation in the Preferences function appears If necessary enter a new data path or click the Browse button to navigate to the correct directory then enter the file name followed by the PDF extension The file name plus extension that you enter must be less than 35 characters Press Enter to save the report as a PDF file in that directory General Ledger Reports Introduction CHAPTER 1 To save the report as a text file select File or enter F The data path set up for the workstation in the Preferences function appears If necessary enter a new data path or click the Browse button to navigate to the correct directory then enter the file name followed by the txt extension The file name plus extension that you enter must be less than 35 characters Press Enter to save the report in that directory Note To preserve spacing and formatting view text file reports with a fixed wid
3. 8 6 Account Mask Description If you are not using one of these account segments in your account number format press Enter to skip it If you are using any or all of these segments enter the position in the account number where each segment begins Then enter the length of the segment The length can be 1 6 characters If you want to use a fill character between account segments you must leave a blank space between the segments For example if you used a three digit main account segment followed by a two digit subaccount segment and if you wanted a fill character between the two you would enter 5 in the Subaccount Position field If you left spaces between segments you must enter the character you want inserted in those spaces For example you might enter a hyphen to separate a four character main account number and a two character division segment You can enter two additional sort configurations for use in printing various reports Your account mask is considered a sort configuration Enter the sequence of account number segments for each user defined account sort For example if the mask is MMM112233 you might enter 3M21 or 23M1 f you try to delete or change sort configurations this message appears Warning Changing the account sort will require re creating the GLJRxxx and the GLMKxxx files The account number format is displayed When you start this function the default format is MMMMMMMMMMMM Th
4. The current and last year files access the same GLALxxx file Changes made to allocation records while working with last year files also affect current year files and changes made while working with current year files affect last year files Allocations Screen Select Allocations from the File Maintenance menu The Allocations screen appears a 2007 Allocations el Commands Edit Modes Other Help 2xu pajau 0o 0s ok Abandon Account to Allocate 534000 4 UTILITIES EXPENSE Description Utilities Exp Allocation GL Account Percent GL Account Percent GL Account Percent 01 534001 a 60 00 16 0 31 4 02 534002 a 10 00 17 4 00 32 00 03 1534003 a 30 00 18 00 33 00 04 al 00 19 4 90 34 4 00 05 4 00 20 4 10 36 4 0 06 q 00 21 q 00 36 q 00 07 q 00 22 q 00 37 q 00 08 4 00 23 4 00 38 4 00 09 4 00 24 4 00 39 4 00 10 4 00 25 4 00 40 4 00 11 4 00 26 4 Do 41 4 00 12 4 00 27 4 00 42 4 00 13 4 00 28 4 00 43 A 00 14 4 00 29 4 00 44 4 00 15 q oo 30 q 00 45 q 0 Percentage to allocate 00 Company H 1171972007 Terminal T000 OVR 8 32 General Ledger Allocations File Maintenance CHAPTER 8 If you have not defined the account mask for the company this message appears Mask is not defined for this company Exit from the Allocations function and define the company s account mask before you enter the allocation records
5. To Customer ACE0O1 la la bhumphrey aceplumbingsupply com garry deacon bigmail com CC Employee Bouoo1 a La bourne builders_supply com BCC Employee STO001 a faj asotckard builders_supply com Subject AR Analysis Report Attachment Type YES y Attachment File C OSAS76 data Onpqq79x005 TXT Enter Edit Append Go to Header Done Company H 10 26 2010 Terminal T000 OVR 2 The E Mail From field displays the originating e mail address Change it if you want the return e mail address to be different from the one set up in the E Mail Setup function in Resource Manager General Ledger Reports General Ledger Introduction e CHAPTER 1 In the To carbon copy CC and blind carbon copy BCC fields select Other and enter the e mail address or select Vendor Customer or Employee and choose from the e mail addresses on file for those respective categories depending upon installed applications or select None to leave the field blank you must choose at least one To CC or BCC address The name of the report appears in the Subject field Change the subject line if necessary Select Yes in the Attachment field to send the report as a text file attachment to the e mail message select No to send the report in the body of the e mail or select PDF to attach the report as a PDF file The E Mail Message dialog box appears EN E Mail Message oJ O Bag Commands Edit Modes Other
6. 3 If you want to save only the noncash flow transactions select the box or enter Y in text mode if not clear the box or enter N in text mode 4 Make sure that no one else is using the GLJRxxx or GLMAxxx files Then use the Proceed OK command to begin processing When processing finishes the Periodic Processing menu appears 7 20 General Ledger Consolidate Master Files o MM Use the Consolidate Master Files function to consolidate the account balances from one GLMAxxx Master file into another if you have General Ledger files with the same company ID on two computers You can also use this function to consolidate the accounts from several GLMAxxx files on the same computer into one file Printing Consolidated Financial Statements You do not have to use this function to print consolidated financial statements If you want to print consolidated financial statements for multiple companies use one of these methods e Use the Statements function page 6 9 to print statements for two or more companies e Set up the statement contents to print consolidated reports for the companies If you have General Ledger files on another computer you can copy the GLMAxxx files from one computer to another and then print consolidated statements If you use the Consolidate Master Files function to consolidate a company with another active company your balances will be overwritten Instead print consolidated statements for the comp
7. CHAPTER 7 Periodic Processing Consolidate Master Files Consolidate Master Files Screen Select Consolidate Master Files from the Periodic Processing menu The Consolidate Master Files screen appears a 2007 Consolidate Master Files Last Year kelaji Commands Edit Modes Other Help 2xt mealma l ee OK Abandon Copy From Company 1 q in File ID GLMAA with Step Number 1 into Company H 2 Company H 1118 2007 Terminal TODO INS Inquiry 1 Enter the ID of the company you want to consolidate 2 Enter the name of the branch GLMAxxx file for the company ID you entered Enter the file name exactly as it appears in the file directory If you are consolidating several branches with the main company GLMAxxx file you must perform this function for each branch 3 If you are consolidating accounts by steps enter the step number you are consolidating at this time Inquiry 4 Enter the ID of the company in the main GLMAxxx file with which you want to consolidate the branch company 7 24 General Ledger Consolidate Master Files Periodic Processing CHAPTER 7 5 Make sure that no one else is using the GLMAxxx file Then use the Proceed OK command to begin consolidating 6 Repeat the function for each branch file until all the branch companies you want are in the main GLMAxxx file After You Consolidate When you are finished printing consolidated statements restore the original main G
8. Field Description Run Code Run codes group particular recurring entries together For example you can copy specific run codes and then post all the weekly transactions at the same time Assign run codes with care For example weekly recurring entries can be assigned a run code of 1 biweekly recurring entries a run code of 2 and so on Cash Flow If you want the transaction to be included in the Transaction statement of cash flow select the box or enter Y if not clear the box or enter N Source Allocate Enter the source code for the recurring entry RE and R1 are the only valid choices If you did not elect to use allocations in the Resource Manager Options and Interfaces function you cannot access this field If you want the transaction to be distributed to the accounts set up in the allocation record select the box or enter Y in text mode if not clear the box or enter N in text mode Offsetting Amounts If the balance of the entries is a debit the offsetting credit amount appears in the Credit field of the next transaction If the balance is a credit the offsetting debit amount appears in the Debit field To approve the offsetting amount enter the account number Then press Enter at the appropriate field If the offsetting amount should be split between two or more accounts enter each additional transaction until the balance at the bottom of the screen is zero 8 38 General Ledger Recurring Entries F
9. Inquiry 1 Enter the number of the major account whose journal entries you want to allocate to other accounts The description of the account appears for verification Note if the account has been marked inactive you will receive the message Warning This account is currently marked as Inactive 2 Enter a description of the allocation It prints in the Allocations List 3 Enter the number of each account to which to allocate entries made to the major account Because the system cannot split a penny the first account in the record receives all the rounding adjustments 4 Enter the percentage to be allocated to each account Before you can save a record the sum of the allocation percentages must equal 100 percent the percentage of the allocation left to distribute appears at the bottom of the screen When that number is zero you have allocated the total amount Use the Proceed OK command to save the record The cursor returns to the Account to Allocate field Enter the next allocation record or use the Exit F7 command to return to the File Maintenance menu After You Allocate After you have saved the allocations records print the Allocations List to make sure that everything is correct and to use as a reference when you enter journal transactions General Ledger 8 33 Recurring Entries MM Journal entries made regularly every week every month are called recurring entries Use the Recurring Entries fun
10. Select Budget Import from the File Maintenance menu The Budget Import screen appears A Budget Import fo Es Commands Edit Modes Other Help RX te e lm2 amp 0K _ Abandon LayoutID a File Type File Name la GL Account Period No CY Budget Forecast NY Budget Begin 00 00 00 1 00 00 00 2 00 00 00 3 00 00 00 a 00 00 00 5 00 00 00 6 00 00 00 7 00 00 00 8 00 00 00 9 00 00 00 10 00 00 00 11 00 00 00 12 00 00 00 13 00 00 00 Status Bar Company H 08 19 2010 Terminal T000 OVR Inquiry 1 Select the Layout ID for the import file use the Import Definitions function in the Resource Manager System File Utilities menu to add or edit a layout ID The File Type for the Layout ID is displayed General Ledger 8 25 CHAPTER 8 File Maintenance Budget Import 8 26 2 Enter or browse to the File Name you would like to import 3 The import information populates the Budget Import detail area Press N to review the next page or P to review the previous page 4 Press W to write the changes to a transaction 5 When you write the changes you will be prompted to commit the budget import Use the Proceed OK command to continue or the Exit F7 command to quit Select the output device to begin printing the import budgets journal See Reports on page 1 39 for more information After the journal is produced the Daily Work menu appears Ge
11. 1 28 General Ledger Reports MM OSAS applications contain a variety of reports that help you make the best decisions for your business With reports you can view transaction summaries print audit trails of activity managed through OSAS functions make lists of your basic master file information for reference and analyze all aspects of your company s cash flow This section summarizes the basics of using reports For detailed information on a specific report see that report s description in the appropriate section Selecting a Range of Information To produce a report you must specify what information you want to include in the report e To produce a report that includes all information available leave the From Thru fields on the report screen blank For example if you want to include information about all the vendors you work with in a report leave the Vendor ID From and Thru fields blank e To limit the amount of information in the report enter a range in the From Thru fields For example if you want a report to include information only about vendor ACE001 enter ACE001 in both the Vendor ID From and Thru fields If you want the report to include information only about vendors that start with CO enter CO at From and COZZZZ at Thru e You can also select the Tag check mark next to a selection to select a non contiguous range of information In fields where you ve tagged individual choices the selection will appear a
12. Before you set up a statement determine what you want on it the kind of balance information column layouts calculations and so on You can design statement layouts that display different companies periods or account segments in side by side columns You can also define a company and an account mask for each column that references amounts in the chart of accounts With these masks you can define a column to contain one company all companies one account segment or a combination of these factors The General Ledger application contains the following sample statement layouts Layout ID Description BALA Current Budget Comparison BALB Current Last Year Comparison BALC Current Budget and Last Year Comparison BALD Change from Last Year BALE Current Period Year to Date BALF Current Period Year to Date BALG Six Month Comparison INCA Budget Comparison Current YTD 9 2 General Ledger Layout ID INCB INCC INCD INCE INCF INCG INCH INCI INCJ INCK INCL INCM INCN INCO INCP RATA Statement Maintenance CHAPTER 9 Description Last Year Comparison Current YTD Budget Comparison Current QTD YTD Last Year Comparison Current QTD YTD Budget Last Year Comparison Current Y TD Budget Variance Current YTD Last Year Variance Current YTD Budget Variance Current QTD YTD Last Year Variance Current QTD YTD Current Period Previous Period YTD Current Period YTD Current Period QTD YTD YTD Divisional Side by S
13. C Reconciliation A A C BOMKitting Enter edit Gott Adjustment i Sale J Purchase DD FA GL GN IN JO Q Company H 12 29 2010 Terminal T000 OVR You can move around the MDI menu these ways e To view an application s menus click that application s tab To view the functions a menu contains click the menu name The menu expands to list the functions it contains Click the function name to enter the function The function screen appears in the right pane e To exit from a menu click a different menu name or application tab To exit from OSAS click the Close box in the upper right corner of the screen press F7 or select Exit from the File menu General Ledger 1 17 CHAPTER 1 Introduction Function Screens Navigating OSAS Graphical screens contain the same functionality as text screens presented in a graphical format that includes easy access to commands via the mouse Tax Tax Tax Location MN Level 1 Authority MN Liability Acct 203800 Class Description Name Tax on Tax Refundable Acct Sales Tax Purch Tax Misc 203800 Tax Collected ar Consumer Goods 01 Resale Sales 0 000 0 000 00 00 a 02 Exempt Sales 0 000 0 000 00 00 a 03 Ind Agr Prod 0 000 0 000 00 00 04 Interstate Comm 0 000 0 000 00 00 05 Motor Vehicles 0 000 0 000 00 00 06 Food Products
14. Page Account Code D D D c D D D D D D D D D D D D D D D D D c D D D D D D c D D c c 10 7 Chart of Accounts List o MM After you enter the accounts for a company print the Chart of Accounts List to make sure that you entered all the accounts You can also use it as a reference when you set up recurring entries enter transactions and so on Interfaced Applications If General Ledger interfaces with another application make sure that the other application s account numbers in the tables and records that affect General Ledger match the proper accounts in the ledger If they do not the journal entries from the other applications are not posted correctly Use the hard copy of the chart of accounts as a reference and see the appropriate user s manual for your other OSAS applications to learn how to interface them with General Ledger Accounts Out of Order If the accounts are not listed in the expected order refer to the explanation of how the system sorts on page 3 1 You might not have set up the account numbers correctly the account mask might be wrong or you might have entered your sort selection incorrectly General Ledger 10 9 CHAPTER 10 Master File Lists Sample List 12 23 2007 Builders Supply 4 30 PM Company H CHART OF ACCOUNTS DECEMBER 31 GL Account Description 100000 CASH IN BANK ist NATIONAL 100100 CASH IN BANK 2nd NATIONAL 100500 PETTY CASH 1010
15. Use the Post to Master function page 5 31 to post the period 1 transactions to the GLMAxxx file 6 Printa Trial Balance see Trial Balance on page 6 3 for period 1 to check for errors 7 If you find errors in the Trial Balance use the Transactions function to make correcting entries Then post the entries to the GLMAxxx file and reprint the Trial Balance 8 Use the Statements function page 6 9 to print financial statements for period 1 9 Repeat steps 1 8 for each past period in the current fiscal year When you finish entering the activity for the past periods you can begin entering the transactions for the current period Out of Balance Entries For every debit you enter in the GL Journal you must enter an offsetting credit and vice versa If entries are out of balance during setup you can use the forced balance password to exit from the Transactions function without balancing the entry 3 20 General Ledger Setup Functions Setup CHAPTER 3 Roles General Ledger If you use the Recurring Entries function and accounts are out of balance even if the overall totals are in balance you must enter a forced balance password If you use the forced balance password print the GL Journal to find out why the journal is out of balance Then correct the situation as soon as possible To safeguard your system you ll need to prevent access by unauthorized people Use the Resource Manager Roles function to set up
16. allocated entries in the GLJRxxx file these entries are not allocated 4 If you want to print the total debits and credits posted for each period you selected select the box or enter Y in text mode if not clear the box or enter N in text mode 5 32 General Ledger Post to Master Journal Transactions e CHAPTER 5 5 If you want to print detail select the box or enter Y in text mode if not clear the box or enter N in text mode 6 Select the output device to produce the GL Master Posting Log See Reports on page 1 29 for more information on output devices After the log is produced the Journal Transactions menu appears GL Master Posting Log General Ledger The GL Master Posting Log shows the debits and credits that were posted for each period and the entries that were automatically allocated If the message Invalid GL account prints in the log the account for the transaction has been deleted Use the Edit Transactions function page 5 27 to assign a valid account to the journal entry Then post again to put the ledger back into balance 5 33 CHAPTER 5 Journal Transactions Post to Master Log 08 19 2007 11 44 AM Company H Entry Period End of Report 5 34 Post Date 08 18 2007 08 07 2007 08 18 2007 08 07 2007 08 18 2007 08 07 2007 08 18 2007 08 07 2007 08 18 2007 08 07 2007 08 18 2007 08 07 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 15 2007 08 17
17. anyone in your organization runs the report from the menu Whether or not you set saved criteria as a default you can load any report criteria you have saved by clicking Shift F3 and choosing the description you want Consult the Resource Manager User s Guide for more information about reports General Ledger Installation Conversion General Ledger CHAPTER2 2 1 Installation and Conversion Installation Before You Install General Ledger Make sure your system meets these minimum requirements before you install General Ledger The General Ledger system needs a minimum of eight megabytes 8 Mb of disk space to work correctly with programs sample data data dictionaries system files and graphics files Having more disk space available is necessary for the data files you will create and maintain The OSAS system requires at least one megabyte 1 Mb of main memory to run More memory may be necessary in certain environments and operating systems Installing General Ledger Use the Install Applications function in Resource Manager see your OSAS Installation User s Guide to install General Ledger Then install your other applications Setting up General Ledger Once you have installed General Ledger on your system you must prepare your data files for everyday use 2 1 CHAPTER 2 Installation and Conversion You can prepare files for use with General Ledger in one of two ways you can create and set up your f
18. e Ifa screen contains more than one section press Page Down when prompted to move to the next section e Ifa menu appears prompting you for the kind of information to enter or maintain such as in the example and on Transaction and File Maintenance screens select the appropriate option and press Enter e To exit the screen and return to the menu press F7 Menus Like the graphical mode the text mode also includes menus that give you access to commands that open additional utilities show additional information about the task at hand or set up a custom menu that contains frequently used commands Refer to Appendix A in the Resource Manager User s Guide for full details about the menus available in OSAS The Other Commands or F4 menu gives you access to additional utilities and commands not directly related to the function you re currently using In text mode press F4 twice on the menu or once on function screens to access this menu See page 1 19 for more information on this menu The Information or Shift F2 menu gives you access to additional information about a customer vendor item job bill of material or employee In text mode this menu is available when the Info flag appears at the bottom of a function screen 1 25 CHAPTER 1 Introduction Navigating OSAS Favorites Menu 1 26 The commands on the menu are available only as they are relevant to the task you are performing For example if you are entering
19. multiply or divide They are performed left to right For accurate results multiply before you divide You cannot use parentheses To use column data in formulas use variable Cx x is the column ID For example use the formula CC CA to print the difference between the balances in columns C and A Columns used in formulas must precede the calculation column For example if column D contains a calculation values from columns A B and C can be used but values from columns E F G and so on cannot You can use any of the nine totals from the statement content in a formula The specific total balance is determined by the type of balance actual last year forecast or budget amounts in that column type Use variable Tnx n is the number of the Total field 1 9 and x is the letter of the column that specifies the type of balance to use For example with the following specifications you can use formula T9F to print this period s total revenue for the same period in column H Total field 9 in the statement content stores Total Revenue 9 11 CHAPTER 9 Statement Maintenance Field Description Column F in the statement layout specifies column type 3 Actual Balance Column H in the layout specifies column type 5 Last Year Balance You can store numbers that you want to use in formulas in the balances of memo accounts For example in the sample Ratio Analysis layout ID RATA statement the total r
20. 111 characters You can have part of the title change each time you print the report to include current or changing data For example you can print the current period s beginning and ending dates See Print Time Inserts on page 9 16 for more information Allow Column Shift If you want to shift column totals to the right or left to improve readability select the box or enter Y in text mode if not clear the box or enter N in text mode If you elect to shift columns leave a blank column in the statement layout to receive the shifted lines You specify which lines you want shifted in the Statement Contents function If you elect not to shift columns the system ignores column shifts in the statement content and you can fit more information on the page Print Page No If you want page numbers to print in the upper right corner of each page select the box or enter Y in text mode if not clear the box or enter N in text mode No Of Blank Line s Enter the number of blank lines to print between the r title and the text or press Enter to leave two lines Statement Footer No The statement footers print at the bottom center of 1 4 each report page The footers are automatically centered when the statement prints Enter the footer using no more than 111 characters You can have part of the footer change each time you print the report For example you can print the period beginning and ending dates See Print Time
21. 2007 08 15 2007 08 17 2007 Post to Master GL Posting Log Periods 07 Thru 08 GL Account Description Source Reference 806000 Tax loc oo 806000 AP Tax loc 00 806000 AP Tax loc 00 806000 AP Tax loc oo 806000 AP Tax loc oo 808000 AP Tax loc 00 806000 AP GOODS RCVD Exp Accrual 806000 AP INV RCVD Exp Accrual 999900 PA Credit Union PAYROLL 999900 Dues PAYROLL TOTAL POSTED THIS RUN TOTAL POSTED PERIOD 07 TOTAL POSTED PERIOD 08 1 860 911 51 Post to Master Credit Alloc 1 860 911 General Ledger CHAPTER 6 Trial Balance 6 3 R r Audit Trial Balance 6 7 epo Is Statements 6 9 Cash Flow Statement 6 21 General Ledger 6 1 Trial Balance o M If you want to check on individual account balances or make sure that an out of balance condition has been corrected print the Trial Balance You can print actual budget last year or forecast balances Trial Balance Screen Select Trial Balance from the Reports menu The Trial Balance screen appears EN 2007 Trial Balance Commands Edit Modes Other Help gt xa a ma 2e es OK Abandon Period 12 Print by Account Types Account Number Sort M1 Main Account From 4000 l q Thru 9999 a Print Division Frm 0 a Actual Amounts Thru 03 a Current Year Budget Amounts Department From Next Year Budget Amounts Thru Last Year Amounts Subaccount From n Forecast Amounts Thru Year to Date Actuals Only Li
22. 3 1 income statement accounts numbers changed during conversion 2 4 incorrect entries 5 10 incorrect transactions Edit Transactions function 5 27 initial balances entering 3 19 setup 3 5 3 19 Inquiry F2 button 1 22 flag 1 27 Install Applications function 2 1 2 3 installing General Ledger 2 1 interfaces General Ledger 3 12 3 15 5 3 5 21 8 35 10 9 B 2 with Accounts Receivable 1 4 J journal entries correcting B 1 Journal file 1 7 Journal Transactions function 1 4 3 14 IX 5 INDEX L last year balance setup 3 13 last year files allocations 8 32 recurring entries 8 35 launching OSAS in other operating systems 1 11 OSAS in Windows 1 11 Lists printing 10 1 Locations function 8 49 Lotus 6 15 spreadsheet 6 14 main account numbers 3 12 main menu graphical 1 16 MDI 1 17 navigating graphical 1 16 navigating MDI 1 17 navigating text 1 23 text 1 23 toolbars 1 21 Maintain Batch Statements function 9 36 Maintain Statement Layout function 9 5 Maintenance F6 flag 1 27 icon 1 22 mapping 1 22 1 27 master chart of accounts GL Accounts function 8 15 Master File Lists 1 5 Master Lists printing 10 1 memo accounts 3 13 numbers changed during conversion 2 4 setup 8 16 menus IX 6 drop down menus 1 19 graphical main menu 1 16 MDI 1 17 shortcut 1 19 text main menu 1 23 messages in text mode 1 27 modes graphical 1 15 text 1 23 Month End Mainte
23. 3 15 3 16 Statement Layout List function 9 15 10 15 sample 10 15 Statements General Ledger function 3 18 3 20 6 9 7 21 9 1 9 21 9 25 9 31 protecting with roles 3 21 subaccount 3 11 setting up in Account Segments 8 9 Symphony 6 15 T T accounts allocations 8 31 Tables function 8 41 Tables List function 10 23 sample 10 24 text mode command line 1 27 commands 1 26 flags 1 26 function screens 1 24 main menu 1 23 messages 1 27 toolbars 1 20 function screens 1 21 main menu 1 21 Transaction Inquiry screen 4 7 Transaction Work file 1 6 Transactions double entry bookkeeping 5 10 function 1 4 1 6 1 8 3 20 4 8 5 3 5 18 5 27 7 12 B 1 B 2 B 3 incorrect entries 5 10 protecting with roles 3 21 reversing 5 27 source codes 5 4 Trial Balance function 1 4 3 14 3 20 6 3 6 9 protecting with roles 3 21 report 1 8 U unposted transactions 7 13 Remove Prior Year Files 7 28 Update Current Year 7 17 Unwritten Transactions Report 5 7 General Ledger INDEX Update Current Year back up files before using 3 22 checklist 7 15 function 1 10 7 10 7 15 8 15 B 6 protecting with roles 3 22 quarterly systems 7 17 results 7 15 screen 7 16 unposted transactions 7 17 updating beginning balances 7 10 7 16 current year file at year end 7 3 user defined account sorts 3 10 in GL Activity Report 5 24 in GL Journal 5 20 WwW workstation date
24. 9 39 9 42 screen 9 42 previous year files 8 9 account masks 8 5 in Statement Content 9 23 in Statement Layout 9 4 printing reports B 3 General Ledger INDEX statements B 3 print time inserts 9 16 examples 9 16 Proceed OK command 1 2 programs backing up 3 23 R ranges in reports 1 29 Ratio Analysis using content RATI 3 18 Recurring Entries file 1 6 function 1 5 1 8 5 15 5 17 in last year files 8 35 setup 3 5 3 15 Recurring Entries List function 5 17 10 13 reference field 3 15 Remove Prior Year Files function 1 9 7 27 reports 1 8 Audit Trial Balance 1 9 Cash Flow Statement 1 9 e mailing 1 34 formatting 1 36 including information 1 29 previewing 1 32 printing 1 31 ranges 1 29 saving to a file 1 33 selecting information 1 29 sorting information 1 30 Trial Balance 1 8 viewing on screen 1 33 Resource Manager Data File Conversion function 2 3 2 5 Data File Creation function 2 2 Install Applications function 2 1 2 3 reversing transactions 5 27 right click menu See shortcut menu 1 19 Roles setting up 3 21 IX 7 INDEX roles company specific information 3 21 setting up 3 5 Run Code Balances 8 39 run codes 1 8 in recurring entries 3 15 setup 3 15 S screens graphical function 1 18 graphical main menu 1 16 navigating graphical 1 18 navigating text function 1 25 OSAS MDI menu 1 17 text function 1 24 text main menu 1 23 setting up account
25. 9 are not included in the sort since they fall after 20 in an alphabetical sort To prevent this situation pad extra spaces in codes and IDs with zeros so that numbers in alphabetical order are also in numerical order In the example above the items could be labeled 000001 through 000020 Outputting Reports 1 30 You can output reports in a variety of ways but keep in mind that the mode you use controls which output options are available to you If you use graphical function screens you have the following output options Printer Print Preview PDF File or E mail for selected reports If you use text function screens you have these options Printer File Screen or E mail for selected reports General Ledger Reports Introduction e CHAPTER 1 General Ledger If you use graphical screens the Output Information dialog box appears after you select the range of information to include in the report EN Output Information tela Es LPL System Default Printer Laser Bann PDL Print Dialog Laser Standard Print Preview LPD System Default Printer Dot Matrix andar PDF PDD Print Dialog Dot Matrix Compressed LPW System Default Printer Wide Carriage File PDW Print Dialog Wide Carriage Dot Matrix Email File Name data Q0000H pdf Browse Cancel If you use text screens these options appear at the bottom of the screen after you select what to include in the report and how to organize it Output P rinter p Rjev
26. A YTD balance is not zero The year to date balance of the account you are trying to delete is not zero Use the Transactions function page 5 3 to close the account balance to another account Then delete the account General Ledger A 9 APPENDIXB Journal Entries Reports and Statements Period End Closing Accounts General Ledger B 1 B 3 B 5 B 6 B 6 Common Questions These commonly asked questions about the General Ledger system are divided into the following categories Journal Entries Reports and Statements Period End Closing and Accounts Journal Entries I made a mistake on some journal entries What should do If you have not posted the entries to the GLMAxxx Master file use the Edit Transactions function page 5 27 to change the entries You need to know the transaction entry numbers which are listed in the GL Journal and the GL Activity Report If you have posted entries to the GLMAxxx file make reversing entries to balance the incorrect transactions that is enter a credit of the same amount for each wrong debit and vice versa Use the Description and Reference fields to indicate clearly the transactions you are cancelling When the incorrect transactions are reversed enter the correct ones Then post to the GLMAxxx file and print the Trial Balance to make sure that the account balances are correct B 1 APPENDIX B Common Questions Why does the Transactions screen show the wro
27. A collection of records stored under a particular name Function screens often represent files but you do not directly see a file See also table A menu item that leads to a full screen Most functions have a corresponding program See also table A record of accounts in terms of a chart of accounts and accounting periods The General Ledger application tracks the effects on accounts from transactions entered in General Ledger and interfaced applications and it is updated by other applications interfaced with it An intangible asset representing the potential earning power of a business in excess of the current market value of its net assets The excess of revenues over expenses in an accounting period A standard financial statement that shows revenues expenses gains and losses for an accounting period An account that holds the net income temporarily in closing the books before distributing it to various equity accounts The process of adding an application to an existing system See also conversion To join to another application for the purpose of having information entered in one application update information in another application s files The goods a business owns at a particular time whether held for direct sale or for use in manufacturing goods for future sale Manufacturing inventory is usually divided into raw material work in process and finished goods Gl 3 GLOSSARY journal journal entries lever
28. CNVTxxx table must be set up using the Resource Manager Period Setup function before you can begin using the General Ledger system See the Resource Manager User s Guide for more information Account Mask Before setting up a company s chart of accounts define the account mask The account mask determines the format of the account numbers Account numbers can be 12 characters long and can have four segments the main account number division department and subaccount The main account number segment is required the other segments are optional You can arrange the segments in any order omit segments you do not need and use fill characters for example a hyphen to separate segments General Ledger 3 9 CHAPTER 3 Setup Setup Functions Any character can serve as a fill character but only one type of fill character can be used in an account number format That is you can use a hyphen or a period but not both A fill character takes up one position in the account number and it appears in every blank position between account segments You might use the first four positions for the main account number the next two positions for the subaccount the following three positions for the division and the final three positions for the department MMMM33111222 You might use a two segment mask where the first four positions denote the division and the final four denote the main account number 1111MMMM Or you might use a three segme
29. CR Reverse E Shift Columns Right Shift Columns Left Single Underscore Double Underscore Print Heading Center Heading xtra ooooHroo000 10 17 Batch Statements List When you need to see the contents of a batch statements record print the Batch Statements List Sample List 12 19 2007 Builders Supply 10 33 AM Batch Statements List Batch Statement ID BATCH1 Monthly Financials Batch Statement Begin End Segment Statement Title Lines Layout Content Per Dates Det Sort ie From Thru Statement Footer Lines BALA BALL Dep Sub BALANCE SHEET WITH BUDGET COMPARISON Company ID Print Time Date Time YES AS OF PEDW INCA INCL Div CONA Dep Sub INCOME STATEMENT WITH BUDGET COMPARISON Company ID Print Time Date Time YES FOR THE PERIOD FROM PEDW THROUGH PEDW YES Div CONA Dep Sub PATIO ANALYSIS Company ID Print Time Date Time YES AS OF PEDU End of Report General Ledger 10 19 Cash Flow Contents List o MM After you finish setting up the cash flow contents list them to make sure that everything is correct and to use as a reference You should print a new list each time you add or change cash flow contents Sample List 12 19 2007 10 34 AM Sequence Cash Flow Content CFCH CASH FLOW FOR COMP H Company ID H 000001 000002 000003 000004 000005 000006 000007 000008 000009 000010 000011 000012 000013 000014 000015 000016 Financing Activities of Report General Led
30. Column Length 30 Builders Supply CHART OF ACCOUNTS DECEMBER 31 2005 Table ID GLPRAH Description No of Columns 6 Column Length Build ers Supply ACTIVITY RE PORT AL LEDGER 12 31 0 5 10 24 Tables List General Ledger GL Account Audit Report oo B Use the GL Account Audit Report function to scans all tables and data files in the current company for selected applications and verifies the presence and validity of the General Ledger account numbers stored there This function is also available in the Master Files List menu of each application that stores GL account numbers in its files or tables but is limited to auditing GL account information for that application only To perform the audit select GL Account Audit Report in the Master File Lists menu The GL Account Audit Report screen appears EN GL Account Audit Report cee Commands Edit Modes Other Scroll Commands Help 2xt malaol 7 l ee Select the Applications to Include in the Audit Accounts Payable Include AR Accounts Receivable a Include BK Bills of Materials Kitting 2 Include BR Bank Reconciliation Include GL General Ledger Include IN Inventory Include JO Job Cost Include PA Payroll Include PO Purchase Order Include RM Resource Manager Include so Sales Order g L Enter toggle All l None Done Company H 0972672007 Terminal Tooo ovR The scr
31. Help 2xe ae ma amp Ok Abandon Got your message Here s the report you requested Thanks Enter the message you would like included in the body of the e mail and use the Proceed OK command You are returned to the E Mail Information Screen Use one of the following commands in the Attachment File scroll region e Press Enter to edit the highlighted attachment if any Browse to or enter the name of the file you would like to attach in the Edit Attachment dialog box see Edit Append Attachment dialog box on page 1 36 e Press A to add an attachment to the e mail Browse to or enter the name of the file you would like to attach in the Append Attachment dialog box see Edit Append Attachment dialog box on page 1 36 1 35 CHAPTER 1 Introduction 1 36 Reports e Press Gto go to a specific attachment line item this command is only available if there are more than six attachments to the e mail e Press H to change the header information of the e mail including the E Mail From field the recipient s the subject line and the attachment type e Press D when done entering the e mail information and you are ready to process the e mail 8 If you choose No in the Send E Mails Immediately option in the Resource Manager Options and Interfaces see Options and Interfaces List on page 3 47 the e mail will be held in the E Mail Queue for processing see E
32. ID for the new copy of the layout The system recognizes the difference between uppercase and lowercase so if you use all uppercase letters or a mixture of cases keep track of which case you used If you enter the ID of a layout that already exists a warning appears If you override the warning by pressing Enter and then PgDn the existing layout is replaced by the new copy Do not enter the ID of a layout you want to keep If the ID you enter is the same as the ID of the layout you are copying an error message appears 9 17 CHAPTER 9 Statement Maintenance 3 Use the Proceed OK command to copy the statement layout The message Copy complete Press any key to continue appears after the layout is copied Press any key to return to the From Statement Layout ID field 4 Enter the next statement layout you want to copy or exit to the Statement Layout menu 9 18 General Ledger Statement Maintenance CHAPTER 9 Delete Statement Layout Screen Use the Delete Statement Layout screen to delete statements you no longer need Do not delete layouts you might modify later When you select Delete Statement Layout from the Statement Layout selection screen this screen appears A 2007 Delete Statement Layout lola Commands Edit Modes Other Help 2xt malma l2 ee _ ok Abandon Delete Statement Layout ID BALE a Company H 11 9 2007 Terminal TODO OVR Inquiry 1 Enter the ID of the statemen
33. Inserts on page 9 16 for more information 9 6 General Ledger Field Footer Starting Line No Statement Maintenance CHAPTER 9 Description Press Enter to print the footers on line 56 or enter the number of the line on which you want the footers to print The number you enter must be between 20 and 99 If the page is 11 inches long do not enter a number greater than 62 When you are finished use the Proceed OK command to save the information on this screen and proceed to the next General Ledger Screen Two a 2007 Maintain Statement Layout Commands Edit Modes Other Help xae eleno 20188 OK Abandon Statement Layout ID BALA CONA Column ID E No of Columns 4 What Is In The Column 3 4 Actual Report Width 78 As Of When 1 Current Period Year How Far Back 3 Year To Date Company Formula Scaling 1 Heading No 1 CURRENT Addnl Trailing Spaces Heading No 2 YEAR Print This Column Vv Heading No 3 Format RAHA 00 C E G DESCRIPTION CURRENT YEAR BUDGET XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX HH 00 HHHHHHHH 00 CompanyH 11192007 Terminal tooo OVR The number of columns in the report so far and the total width of the report appear on the screen at the upper right The report width cannot exceed the width of your printer the maximum is generally 132 spaces 9 7 CHAPTER 9 Statement Maintenance Field Description Column ID Each column is identi
34. Mail Queue on page 3 49 Otherwise the e mail will be sent immediately Note To preserve formatting view e mailed reports or e mail attachments with a fixed width or monospaced font Courier or Lucida Console for example Edit Append Attachment dialog box The Edit Append Attachment dialog box appears when you press Enter or A in the Attachment File scroll region of the E Mail Information screen EN Append Attachment fo es Commands Edit Modes Other Help 2xX Bealmal amp e fak Abandon File Name C OSAS76 data Onpqq79x005 TXT 1 Enter the File Name of the file you want to attach to the e mail or click the browse button C to navigate to the file 2 Use the Proceed OK command to add the attachment to the e mail and return to the E Mail Information Screen General Ledger Reports Introduction e CHAPTER 1 Commands Use the following commands when a report appears on the screen Key Operation PgUp PgDn Home End F7 Left Right Tab Up Down Moves to the previous page of the report Moves to the next page of the report Moves directly to the top of a group of pages Moves directly to the bottom of a group of pages Exits to the menu from any point in the report Moves left one character Moves right one character Toggles between the left and right halves of a report Moves a line up and down the screen to line up information when you toggle betwe
35. Modes Other Scroll Commands Help gt Xt h aa 280 e OK Abandon GL Account Debit Credit Reference Run CFlw Description Src Allc 153500 4405 77 10000001 B DEPRECIATION FURN amp FIX RE m 2 521000 4405 77 10000002 1 7 a DEPRECIATION FURN amp FIX RE 154500 2621 07 10000003 1 DEPRECIATION AUTOS RE m 521000 2621 07 10000004 1 WW DEPRECIATION AUTOS RE 181000 5 58 110000005 1 Y AMORTIZATION GOODWILL RE Mi 531000 5 58 10000006 1 Y z AMORTIZATION GOODWILL RE B Balance 00 Enter edit Append aLloc On l Balance Go to CompanyH 111972007 Terminai Tooo OVR Use the commands to work with the information on the screen e Press Enter to edit the selected recurring entry line See Adding or Editing a Line Item on page 8 37 for more information e Press A to add a recurring entry to the end of the list See Adding or Editing a Line Item on page 8 37 for more information e Press L to switch the allocation status of a line from selected or Y in text mode to cleared or N in text mode or vice versa e Press O to change the default allocation setting for appended lines from selected or Y in text mode to cleared or n in text mode or vice versa e Press B to view the run code balances General Ledger Recurring Entries Recurring Entries File Maintenance CHAPTER 8 e Press Gto move to a specific line This command is available only when
36. Only one person at a time can print statements To prevent more than one person at a time from printing statements the system creates the GLLOCK file Normally the system deletes the GLLOCK file when the first person is done printing statements However if there was a problem while the statements were being printed perhaps the system went down or the computer was turned off the GLLOCK file would still exist Delete the GLLOCK file from the General Ledger program directory Hov can print consolidated statements every period If all the companies you want to include in the consolidated statements are on the same General Ledger system you have two options General Ledger B 3 APPENDIX B Common Questions e Specify the IDs of all the companies up to 20 when you print the statements e Set up the statement content to consolidate totals for all the companies The consolidation will not work unless all companies have the same current year If the companies you want to consolidate are on different General Ledger systems use the Consolidate Master Files function see page 7 21 Why do all the results of my calculations in statements come out zero or wrong You might have tried to print the wrong total When calculations are made the result is stored in the first total mentioned in the formula and that is the total you should print to get the result For example if the formula is T8B T9B you should use the T8 function to pr
37. Shift number of characters to shift the numeric columns Columns will not be shifted unless the statement layout permits it and if there is a blank column in which to print the shifted characters Extra Blank Lines Enter the number of lines you want to leave blank after this line prints Press Enter if you do not want to leave any lines blank or enter 99 if you want to start a new page after this line To print a header longer than 30 characters enter the parts of the header in consecutive lines and enter 1 in this field Then in the Desc Tab field above enter the number of spaces to shift the later parts When you save your entries the cursor returns to the Statement Contents screen Enter another statement content ID or exit to the Statement Maintenance menu After you add a statement content produce the Statement Contents List to make sure that everything is correct Then use the Statements function to test the content with a corresponding layout to make sure that it works properly Assign Account Mask to Statement Contents If you change your company s account mask you must reassign the account mask to the statement contents the company uses so that the correct mask will be used when financial statements are produced If you upgraded to General Ledger version 6 5 from version 4 1x or lower you must assign account masks to the contents that were not previously assigned one Reassigning Account Masks When you reassign the ma
38. Trans Desc SALES Reference AJR Trans Date 12 03 2007 E GL Period 2 Source Allocate v Cash Flow Transaction v You can change any field except Source Field GL Account Debit Credit Trans Desc General Ledger Description The number of the account the transaction will be posted to appears The account name appears for verification Use the Maintenance F6 command to open the GL Accounts function to add or edit accounts For a debit transaction the dollar amount appears in the Debit field For a credit transaction the amount appears in the Credit field A description of the transaction for example SALES appears 5 29 CHAPTER 5 Journal Transactions Field Reference Post Date GL Period 1 13 Source Allocate Cash Flow Transaction Edit Transactions Description A reference identifies the origin of the transaction If the transaction originated in General Ledger the reference entered in the Transactions function appears If the transaction originated in another application the application initials appear for example if the transaction was posted from Fixed Assets FA appears The date the transaction was posted to General Ledger appears The accounting period that corresponds to the transaction date appears If the transaction originated in General Ledger source code M1 manual entry R1 or M plus any other character appears If the transaction originated in an
39. Type Enter the account type you want for the end of the statement range Description Enter a description for the statement Use the Proceed OK command to save your changes and return to the Cash Flow Contents screen Next add or edit another line return to the header and use the Abandon F5 command to enter a new cash flow contents ID to work with or use the Exit F7 command to return to the Statement Maintenance menu General Ledger 9 47 Financial Statement Verification MM Use the Financial Statement Verification function to check your statement contents for errors The function examines the statement contents for duplicated and missing accounts In addition the function checks the Reverse Sign to Print flag in the statement contents for credit balance accounts and warns you if the flag 1s not set Financial Statement Verification Screen Select Financial Statement Verification from the Statement Maintenance menu The Financial Statement Verification screen appears A 2007 Financial Statement Verification le Commands Edit Modes Other Help 2xea aemo l e ee a ee Statement Content ID 7 Include in Statement Division From 01 fa Verify Thru 03 a Main Account From la Department From Thru a Thru 7 Account Type From a Subaccount From Thru la Thru Company H Print Account numbers that are duplicated W Account numbers that are excluded El Account numbers that use Reverse Sign Printing El Comp
40. a record you want to keep If the ID you enter is the same as the ID of the record you are copying an error message appears 3 Use the Proceed OK command to copy the batch statements record The message Press any key to continue appears after the record is copied Press any key to return to the From Batch Statement ID field 9 40 General Ledger Batch Statements Statement Maintenance CHAPTER 9 4 Enter the next batch statements record you want to copy or exit to the Batch Statements selection screen Delete Batch Statements Use the Delete Batch Statements option to delete batch statements records you no longer need Do not delete records you might modify later When you select Delete Batch Statements from the Batch Statements selection screen the Delete Batch Statements screen appears A 2007 Delete Batch Statements Commands Edit Modes Other Help 2xa me mo l e ee Delete Batch Statement ID BATCH2 a Company H 1111912007 Terminal TODO OVR Inquiry 1 Enter the ID of the batch statements record you want to delete 2 Select Yes or use the Delete F3 command to confirm that you want to delete the batch statements record The message Press any key to continue appears after the record is deleted Press any key to return to the Delete Batch Statement ID field 3 Enter the next batch statements record ID you want to delete or exit to the Batch Statements selection scre
41. a safe place If you use a printed copy for reference make sure that you have the most recent version GL Journal Screen Select GL Journal from the Transactions menu The GL Journal screen appears a 2007 GL Journal a Commands Edit Modes Other Help 2xt malma l 2 ee ok Abandon Pick Period From Print by Thru 12 Entry Number Source Code From Account Number Thru Source Code Main Account From 4000 a Thru 9999 a Account Number Sort Division From 01 a E Thu 03 a Print Department From q Posted Transactions Thru 4 Unposted Transactions Subaccount From 4 Both Thru 4 Entry From Thru Date to Print Post y Headings Line 123456789012345678901234567890 de Builders Supply 2 3 GENERAL LEDGER JOURNAL 4 12 31 07 Company 1118 2007 Terminal T000 ovr 1 Enter the range of periods you want to include in the journal 1 13 General Ledger 5 19 CHAPTER 5 Journal Transactions GL Journal 10 11 12 13 Enter the range of source codes you want to include in the journal Enter the range of main account numbers you want to include in the journal Enter the range of divisions you want to include in the journal Enter the range of departments you want to include in the journal Enter the range of subaccounts you want to include in the journal Enter the range of entries you want to include in the journal Select the order in which you want to organize the journal Sele
42. and records in the other applications match the appropriate accounts in the GLMAxxx Master file If tables and records do not match the appropriate general ledger accounts the journal entries from the other applications will not be posted properly Copying the Chart of Accounts If you use the same account numbering structure for several companies you can save time by building one company s chart of accounts and then copying it to each of the other companies see page 8 27 You can also copy budget last year balances and forecast amounts from one company to another if the companies use the same account mask from one division to another or from one department to another within the same company Account Number Structure Account numbers can consist of any combination of numbers letters and dashes but the account numbers must conform to the account mask see Account Mask above To ensure that the accounts are organized correctly in reports and statements all the account numbers should be the same length The system forces all account numbers to fit the mask by filling in zeros or letters if you leave spaces Main account numbers should indicate significant groups assets liabilities equity revenues and expenses For example main account numbers 1000 to 1999 could be assets 2000 to 2999 could be liabilities and so on Use the same ranges of main account numbers for the same account categories for all companies It si
43. e Assign a character to each week in the period When you print a GL Journal that contains transactions with the same source code you can see the entries for a particular week e Assign a different character to each person who makes entries so that you will know who entered each transaction The system assigns some source codes automatically Code Source of Entry AL General Ledger Automatic Allocation AP Accounts Payable Purchase Order AR Accounts Receivable Sales Order BK Bill of Materials Kitting BR Bank Reconciliation CL GL Year End Closing General Ledger Transactions Journal Transactions e CHAPTER 5 Code Source of Entry FA Fixed Assets IN Inventory JC Job Cost PA Payroll R1 GL Auto Reversing Accrual entered R2 GL Auto Reversed Accrual generated reversal RE General Ledger Recurring Entry The system assigns source code R2 to the transactions that automatically reverse R1 transactions Automatic Reversal of Accrual Entries If you want the General Ledger system to reverse accrual entries automatically enter the accrual transaction with source code R1 The system generates a transaction for the next period that reverses the accrual entry The reversing entry has a source code of R2 For example suppose that your company usually has accrued wages at the end of the month You could enter R1 transactions to account for the accrued wages expense The next month the system would generate R2 transactions that re
44. edit l Append aLloc Allocations On Write Print report Goto Company H 118 2007 Terminal T000 OVR If no transactions are on file the Append Line screen appears See Append Edit Line Screen on page 5 8 for more information If transactions exist they are listed in the screen s scroll region Use the commands to work with these transactions e Press Enter to edit the selected transaction line See Append Edit Line Screen on page 5 8 for more information 5 6 General Ledger Transactions General Ledger Journal Transactions e CHAPTER 5 Press A to add a new transaction See Append Edit Line Screen on page 5 8 for more information Press L to change the allocation flag of the current transaction line Press O to toggle the default status for the Allocate field in the Append Line screen from selected or YES to cleared or NO Press W when you have made the last journal entry to save the transactions The information stored in the temporary file is written to the GLJRxxx file Use the Exit F7 command to return to the Journal Transactions menu When you write transactions to the GLJRxxx file they are cleared from the temporary work file and thus from the Transactions screen Use the Edit Transactions function page 5 27 to edit transactions in this file Press P to produce a list of the unwritten transactions for the terminal being used then select the output dev
45. edit these transactions When you select NO recurring entries are copied to the temporary transaction work file Use the Transactions function to edit verify and write these transactions to the GL Journal 2 Press Enter to toggle between YES or NO to indicate whether you use period 13 for normal processing General Ledger Setup Functions Setup CHAPTER 3 3 Toggle between YES or NO to indicate whether you want to be able to enter transactions adjustments for example in period 13 If you use period 13 for normal processing you cannot set this option to NO 4 Toggle between YES or NO to indicate whether you want to use allocations If you select NO you cannot access the Allocations or Allocations List functions 5 Toggle between YES or NO to indicate whether you want to be able to edit current and last year balances in file maintenance 6 When you finish selecting options press W to save your entries Then exit to the Options and Interfaces screen Select another application whose options and interfaces you want to change or exit to the Resource Manager Company Setup menu Period Setup The CNVTxxx Period Conversion table in Resource Manager stores the general ledger accounting periods and their corresponding months in the fiscal year The general ledger period that corresponds to the system date is displayed in the Resource Manager Period Setup function and in other OPEN SYSTEMS Accounting Software applications The
46. entries you set up through the Recurring Entries function 2 Enter the date you want to use for the recurring entries 3 Enter the period to which you want to copy the recurring entries 1 13 4 Select the output device to produce the Copy Recurring Entries Log See Reports on page 1 29 for more information on output devices 5 16 General Ledger Copy Recurring Entries Journal Transactions CHAPTER 5 Out of Balance Entries The system verifies the balances of all the recurring entries If some entries are out of balance the following message appears Recurring entries are out of balance The Password Entry screen appears and the Recurring Entry screen behind it changes to list the total debit and credit balances for each run code A xm Commands Edit Modes Other Help 2xe emo reee A Password Entry Commands Edit Modes Other Help xelaelma Haan Enter Password to Continue Without Balancing Amounts Shown Are Totals of Selected Run Code Balances for Companies H Run Code Balance Run Code 0 0 00 5 0 00 0 22 6 0 00 N yn a oo Company 11182007 Terminal T000 ovR The balance shown for a run code is for all companies A zero balance indicates that the entries are in order for that run code any other amount indicates that at least one entry is out of balance for that run code Note the run codes that are out of balance and
47. files also affect previous year files Account Mask You must assign an account mask to each statement content so that the financial statements will be printed correctly You must set up separate contents with the correct account masks for companies that have different account masks If you use the same account mask for several companies you can set up only one content that can be shared by all of them If you upgraded to General Ledger version 6 5 from version 4 1x or lower you must assign an account mask to each existing content that is not already assigned one General Ledger 9 23 CHAPTER 9 Statement Maintenance Statement Contents Screen Statement Contents Select Statement Contents from the Statement Maintenance menu The Statement Contents screen appears 9 24 f 2007 Statement Contents Commands Edit Modes Other Scroll Commands Help 2xu ea mu 20e es Statement Content ID BAL1 4 Use Acct Mask for Company H a Mask MMMM11 Act on Total Seq No Fnc Co Beg Acct Type End Acct Type Description 123456789 000001 HP ASSETS 000002 HP i CURRENT ASSETS 2 000003 AD 110002 109972 a 000004 US 000005 CR 000006 T1 TOTAL CURRENT ASSET 0 000007 CL 000008 HP LONG TERM ASSETS 000009 AD 15002 15992 000010 US 000011 CR y 000012 T1 TOTAL LONG TERM ASS 0 y 000013 CL Y Line of Enter edit Append Header Goto Company H 11 9 2007 Terminal TOD
48. first time review the sample statement layouts and contents provided with General Ledger You can use the sample statement layouts and contents to print your own financial statements modify the samples to suit your needs or set up your own statement layouts and contents Before you print financial statements make sure that all transactions have been entered corrected and posted to the GLMAxxx Master file Then print a Trial Balance Report or an Audit Trial Balance Report to check the account balances If you find problems enter adjusting transactions Then post the transactions to the GLMAxxx file General Ledger 6 9 CHAPTER 6 Reports Statements Screen 6 10 Statements Select Statements from the Reports menu The Statements screen appears CONA a AS OF PEDU Field Batch ID Active Financials TIEN 2007 Statements fe Commands Edit Modes Other Help xalaemo l e ee OK Abandon Batch ID 4 Active Financials Pick Statement Layout ID BALA a Pick Division From 01 a Statement Content ID BAL1 al Thu 03 a Department From q Period 12 Thru 4 Beginning Date 12 01 2007 E Subaccount From q Ending Date 12 31 2007 El Thru q Company ID H Print Segment Detail 7 Segment Sort Print Accounts With Zero Balances El Print Workstation Date and Time Change Footers Line Statement Titles 12345678901234567890123456789012345678901234567890 BALANCE SHEET WITH BUDGET COMPARISON Company H 0
49. five types of balances actual budgets last year actual next year budget and forecast General Ledger 1 5 CHAPTER 1 Introduction The General Ledger System 1 6 The GLALxxx Allocations file stores the account numbers and percentages used to allocate transactions When you use the Post to Master function the system compares the account numbers in the transactions being posted to the records in this file This file stores the ratios of how money is to be allocated for account numbers with an allocation record as a result specifying the account sends the proper amounts to the proper accounts Attribute Files The attribute files hold data that you can assign to each account The GLMSK Account Mask file stores a mask that defines each company s account structure The structure defines the positions used for the main account number the division the department and the subaccount The GLSExxx Account Segments file stores an ID of each division department and subaccount You enter each ID through the Account Segments function these IDs are used to sort information in reports The GLAT Account Type file stores the account type codes and descriptions used throughout the system When you define a type you assign a number a description and an account class to it Twelve account classes are available The GLRExxx Recurring Entries file stores journal transactions that you regularly write to the GLJRxxx file You enter the
50. highlighted GL period press D e To view total details for the highlighted GL period press T For an explanation of the fields on the screen see GL Accounts on page 8 15 You can press Shift F3 or double click on any line in which amounts appear in blue to drill down for more information When you drill down from the Accounts Inquiry screen you ll see the GL transactions that make up that period s activity for this account When you are finished looking at the GL Accounts Inquiry screen use the Exit F7 command to return to the main menu 4 6 General Ledger Transaction Inquiry o MM Select Transaction Inquiry from the Information Inquiry menu The Transaction Inquiry screen appears EN 2010 Transaction Inquiry cra Commands Edit Modes Other Scroll Commands Help 4 2xu6 najaa 206 00 OK GL Post Code 4 Status Active GL Account 100000 x CASH IN BANK 1st NATIONAL GL Period From 12 GL Period Thru 12 Post Date Pd Src Description Amount Pst Ref All CASH SALES 12388 25 B 12 04 2010 12BR Transfer of Funds 500 00 TRSFR El 2 11270412010 12BR Stop Payment Charge 7 50 ans a 4 12 04 2010 12BR Pymts to Affiliates 11416 25 DISB a 12 07 2010 12M1 Period 12 Adjusting Entr 100 00 9 Ed 12 02 2010 12AP Checking Acc 225648 66 AP El 12 12 2010 12AR PAYMENTS RECEIVED 333602 55 AR
51. in Account Segments 8 9 double entry bookkeeping 5 10 E Edit Transactions function 3 20 5 10 5 18 5 27 5 33 B 2 printing GL Journal before using 5 27 protecting with roles 3 21 screen 5 28 e mail e mailing reports 1 34 ending balances in Statement Contents 9 27 F F2 Inquiry IX 4 button 1 22 flag 1 27 F6 Maintenance flag 1 27 icon 1 22 File Maintenance functions 1 5 files backing up 3 22 fill characters 8 4 in account segments 3 10 financial statements 9 1 9 21 at year end 7 2 consolidated 7 21 printing 3 18 setup 3 5 3 15 flags in text mode 1 26 forced balance password 3 20 3 22 5 10 8 41 8 42 format columns in statement layouts 9 13 formulas in statement layouts 9 11 9 12 from thru ranges 1 29 G General Ledger before converting 2 3 before you install 2 1 converting to version 7 0 2 5 installation 2 1 installing new version before converting 2 3 setup considerations 2 4 system requirements 2 1 General Ledger interfaces 1 4 3 15 GL Account Audit Report 10 25 GL Accounts correcting 8 20 deleting 8 17 function 1 5 7 10 7 12 7 22 8 15 8 37 B 6 in GLMAxxx file 1 5 protecting with roles 3 21 GL Activity Report 3 19 8 37 B 2 function 1 8 3 13 5 4 5 23 B 3 printing after clearing and closing steps 7 14 General Ledger before posting 5 31 uses for 5 23 using for month end maintenance 7 19 GL Journal balances 5 21 func
52. in Accounts Receivable e You can copy recurring entries to a journal transaction Use the Recurring Entries function to define the run codes that identify recurring entries The information is kept in the GLRExxx file When the transaction comes up enter the run code in the Transactions function Journal Transaction Reports and Posting The Journal Transaction reports provide information about activity before you post The GLJRxxx file provides information for the GL Journal and GL Activity Report The GL Journal provides information about transactions for the specified periods Note Produce the GL Journal and the GL Activity Report before you use the Post to Master function When you post information is changed in the GLJRxxx file and you cannot retrieve it Reports The Reports functions provide information about activity after you post overall balances and other key historical statistics that you can compare with reports you produced before you posted e The Trial Balance function provides debit or credit balances of general ledger accounts for the current period and the year so far This information comes from the GLMAxxx file This report is useful when you want to test the balance of debits and credits in General Ledger General Ledger The General Ledger System Introduction CHAPTER 1 e The Audit Trial Balance function provides debit or credit balances of general ledger accounts for the specified period of time l
53. is only available in BBj graphical mode La Active Financials Viewer Commands Viewer Other Help olas 2xXic Ba moa 0 0909 Ok Abandon BALA BAL1 INCA INC1 RATA RATA Builders Supply BALANCE SHEET WITH BUDGET COMPARISON AS OF JAN 31 2010 ACCT DESCRIPTION NO CURRENT ASSETS 1000 CASH IN BANK 1st NATIONAL 1005 PETTY CASH 1010 ACCOUNTS RECEIVABLE 1020 ALLOWANCE FOR BAD DEBT 1040 INVENTORY RAW MATERIALS 1042 INVENTORY WORK IN PROCESS 1044 INVENTORY FINISHED GOODS 1060 MARKETABLE SECURITIES TOTAL CURRENT ASSETS Status Bar CURRENT YEAR 4865 62 115 00 16234 40 324 68 999510 75 1053848 86 882747 02 571329 82 3528326 79 BUDGET 4630 00 55 00 2226725 445 33 1010546 64 1055235 49 860880 32 603409 03 m 3556578 40 Company H 12 29 2010 Terminal T000 OVR To drill down to view source inquiries and other information click on blue highlighted data This will open the appropriate inquiry function or formula information for the highlighted data If you have opened more than one statement using the batch function each statement is opened as a separate tab Click on the tab to view the specific statement you want read choose Green Bar from the Viewer menu To view the report using a green bar format that makes the lines easier to General Ledger Statements Reports CHAPTER 6 e To exp
54. mask 3 5 3 9 account segments 3 5 3 10 account types 3 5 3 11 allocations 3 5 3 14 backup schedule 3 5 3 22 chart of accounts 3 5 3 11 CNVTxxx table 3 5 3 9 codes 3 1 financial statements 3 5 3 15 IDs 3 1 initial balances 3 5 3 19 options 3 5 recurring entries 3 5 3 15 roles 3 5 setting up Accounts Payable roles 3 21 shortcut menu 1 19 sorting alphabetical 3 2 codes and IDs 3 1 principles of 3 1 3 2 source codes automatic 5 4 Transactions function 5 4 starting OSAS IX 8 in other operating systems 1 11 in Windows 1 11 Statement Contents account balances 9 26 account mask 9 23 9 29 assigning account mask to 9 31 beginning balances 9 26 consolidated statements 9 28 ending balances 9 27 file 1 7 function 1 9 3 15 3 17 3 18 6 9 7 11 9 1 9 21 B 5 previous year files 9 23 sample balance sheets 3 17 9 22 income statements 3 18 9 22 ratio analysis 3 18 9 22 setting up for consolidating companies 7 21 setup 3 15 3 17 Statement Contents List function 9 31 10 17 sample 10 17 Statement Layout account balances 9 9 account masks 9 10 calculations 9 11 copying 9 17 deleting 9 19 examples 9 2 file 1 7 function 1 9 3 15 3 16 3 18 6 9 7 11 9 1 9 21 9 24 previous year files 9 4 print time inserts 9 16 sample balance sheets 3 16 9 2 income statements 3 16 9 2 ratio analysis 3 17 9 3 samples 3 16 of numeric formats 9 15 setup
55. month or the previous year General Ledger The General Ledger System Introduction CHAPTER 1 File Maintenance Use the functions on the File Maintenance menu to set up and maintain information in the system For example use the GL Accounts function to establish and update information about accounts throughout the system Master File Lists Information that you enter in the File Maintenance functions is kept in master files Use the Master File Lists functions to produce the contents of the files account segments and types recurring entries allocations and so forth File Information Like all OSAS applications General Ledger stores information in files Each file falls into one of four categories master files attribute files temporary files and statement files OSAS does not distinguish between categories of files The files are described in terms of categories to give you a better idea of how each fits in Master Files The master files hold information about general ledger accounts The GLMAxxx Master file holds the general ledger accounts and their balances To update the balances use the Post to Master function Each record holds the following information which you can enter through functions on the File Maintenance menu or by updating information from interfaced applications e account number and description e the account code debit credit or memo beginning balances and balances for each period for
56. number enter 1 in the Main Account Position field and 4 in the Main Account Length field see the field descriptions below When you enter the length of a segment the Account Number Mask field is updated Here s what the entries mean MMain account number 1Division 2Department 3Subaccount General Ledger 8 3 CHAPTER 8 File Maintenance Account Mask The terms division department and subaccount are only labels Use segments in whatever way is necessary for your numbering structure See chapter section for more information The default mask is MMMMMMMMMMMM which indicates that the main account number segment takes up all 12 positions You cannot delete a mask you can only change it You can arrange the segments in any order omit segments you do not need and use fill characters for example a hyphen to separate segments Any character can serve as a fill character but only one type of fill character can be used in an account number format That is you can use a hyphen or a period but not both A fill character takes up one position in the account number and it appears in every blank position between account segments Here are some examples of account masks Fill Characters MMM111222333 mmmMmAal N Main Division Department Account Subaccount Main vr Number Account Su aceonnt Division Department Number Fill Character Fill Characters 1111 2222 MM 1111 MMMM gt ae Division Division Main Department Ma
57. on page 1 29 for more information on output devices After the GL Journal is produced the Journal Transactions menu appears Error Messages in the Report After the report prints check it If the message Missing entries or Account not on file appears something may be wrong between the GLJRxxx Journal file and the GLMAxxx Master file See appendix A for advice on what to do before you go on Do not post to the GLMAxxx file until the situation is corrected Notes on the GL Activity Report The GL Activity Report can be produced in a number of formats The example at the end of the section shows transactions for a range of periods Period end balances are printed for each period in the range General Ledger 5 25 CHAPTER 5 Journal Transactions GL Activity Report GL Activity Report 12 19 2007 Period 06 Thru 08 11 24 AM Company H GL Account Post Date 806000 06 07 2007 07 03 2007 08 05 2007 08 12 2007 08 12 2007 08 12 2007 08 12 2007 08 12 2007 08 12 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 08 18 2007 999900 08 15 2007 08 15 2007 End of Report 5 26 Description OTHER EXPENSES Period 06 Activity Period 07 Activity Tax Tax Tax Tax Tax Tax Tax Tax Tax Tax Tax Tax Tax Tax loc loc loc loc loc loc loc loc loc loc loc loc loc loc ca CA CA CA ca ca ca CA CA CA CA CA CA CA cls cl
58. percentages must equal 100 percent You cannot access this function if you did not elect to use allocations in the Resource Manager Options and Interfaces function How Allocations Work With this function you enter the major account number each account to which to distribute transactions and the percentage of the amount each account receives When you enter a transaction for an account set up in the GLALxxx Allocations file you indicate that the transactions should be allocated when you post the system creates journal entries to the accounts specified in the allocation record For example you could have an allocation record in which your main utilities expense account is 534000 with 60 percent distributed to division account 534001 10 percent distributed to division account 534002 and 30 percent distributed to division account 534003 You enter a journal transaction that debits utilities expense account 534000 and credits accounts payable account 200000 for 100 You indicate that the transaction should be automatically allocated Here is the original journal entry Utilities Expense Accounts Main Account Payable 100 100 General Ledger 8 31 CHAPTER 8 File Maintenance Allocations When you post the transaction the system creates this journal entry Utilities Utilities Utilities Utilities Expense Expense Expense Expense Main Account Division 01 Division 02 Division 03 100 60 10 30 Last Year Files
59. period activity Then post the entries to the appropriate general ledger periods e For the current period enter individual transactions and post them to the current general ledger period e Ifan audit trail is not required enter the beginning balances and the ner change in each period for each account when setting up a company s chart of accounts When you print the GL Activity Report after entering the balances the message Missing Entries is printed for each account that has a period balance different from the beginning balance You can ignore the message e See Chart of Accounts above and on page 8 15 for information about entering account balances in this manner Entering Initial Balances Follow the steps below when entering initial balances to produce an audit trail of the current year s past period activity General Ledger 3 19 CHAPTER 3 Setup Setup Functions 1 Use the Transactions function page 5 3 to enter all the transactions or the total period activity for each account for period 1 2 Copy recurring entries for period 1 to the GtttxxxW Transaction Work where ttt represents the terminal ID number file Then use the Transactions function to edit them and write them to the GL Journal 3 Print the GL Journal for period 1 and check it see GL Journal on page 5 19 4 Use the Edit Transactions function page 5 27 to correct transactions that have errors Then print the GL Journal again 5
60. s are skipped Thru If you are using one or more of these account number segments enter the range of segments you want in the statement The length of each field relates to the number of characters the segment occupies in your account mask 9 38 General Ledger Batch Statements Field Print Segment Detail Segment Sort Print Accounts With Zero Balances Print Workstation Date and Time Statement Maintenance CHAPTER 9 Description Select the box or enter Y in text mode to include the information for each segment in the statement Clear the box or enter N in text mode to summarize the information for all segments of a main account into the main account number If you are using only one segment in addition to the main account segment this field is skipped If you are using two or three segments in addition to the main account segment enter the order you want the account segments to be organized For example if you want them organized first by division then by department and then by subaccount enter 123 If you always want to include accounts with zero balances when you print the statement select the box or enter Y in text mode If you always want to exclude accounts with zero balances when you print the statement clear the box or enter N in text mode If you want the workstation date and time to be listed on the financial statements select the box or enter Y in text mode if not clear the
61. s basic accounting period is one month you can use period 13 for year end audit adjustments and to clear and close entries 7 1 CHAPTER 7 Periodic Processing If your basic accounting period is one week you must close the books once every quarter since only 13 periods are available 13 weeks x 4 quarters 52 weeks per year You must enter adjustments along with the regular transactions in period 13 The Year End Procedure 7 2 Follow these steps to close the books at year end 1 Back up your files 2 Consolidate your GLMAxxx files if you want to print consolidated financial reports for companies that are on different computers see page 7 21 3 Create the last year GLMAxxx and GLJRxxx Journal files for each company see page 7 5 4 Switch to last year files and use the Transactions function page 5 3 to finish entering the transactions in the last accounting period for each company When the transactions are correct post them to the GLMAxxx file page 5 31 and print financial statements for the last period page 6 9 5 Use the Transactions function page 5 3 to enter the yearly or quarterly audit adjustments and post them to the GLMAxxx file page 5 31 6 Print the year end financial statements for each company page 6 9 7 Use the Update Current Year function page 7 15 to update the beginning balances for the current fiscal year Repeat steps 4 7 until you have made all adjusting entries for t
62. statement layouts Each of these tasks is explained in this section 9 4 General Ledger Statement Maintenance CHAPTER 9 Maintain Statement Layout Screens General Ledger Use the Maintain Statement Layout screens to add or change statement layouts Screen One When you select Maintain Statement Layout from the Statement Layout menu the first screen appears A 2007 Maintain Statement Layout LO Commands Edit Modes Other Help zxaaelmo l e ee OK Abandon Statement Layout ID Statement Title No 1 Statement Title No 2 Statement Title No 3 Statement Title No 4 Allow Column Shift Print Page No No of Blank Line s Statement Footer No 1 Statement Footer No 2 Statement Footer No 3 Statement Footer No 4 Footer Starting Line No BALA 4 CONA BALANCE SHEET WITH BUDGET COMPARISON AS OF PEDW UNAUDITED 56 Company H 11 9 2007 Terminal T000 OVR Field Statement Layout ID Statement Title No 1 4 Description Enter the ID of the statement layout Because you can specify ranges of layouts to print or copy it is helpful to group similar layouts together for example the sample balance sheets are BALA through BALG The statement titles print at the top center of each report page The titles are automatically centered when the report prints 9 5 CHAPTER 9 Statement Maintenance Field Description Enter the title using no more than
63. the Resource Manager Change File Size function to reduce the size of the file see the Resource Manager User s Guide If you print the GL Activity Report after you delete journal entries the message Missing entries is printed for the periods for which you deleted entries If the end of the month is also the end of the year you can use the Create Last Year Data function instead of the Month End Maintenance function Creating last year data erases all the transactions in the GLJRxxx file Before You Begin Before using the Month End Maintenance function post the journal entries for the corresponding periods to the GLMAxxx Master file make sure that the ledger is in balance and back up your data files General Ledger 7 19 CHAPTER 7 Periodic Processing Month End Maintenance Month End Maintenance Screen Select Month End Maintenance from the Periodic Processing menu The Month End Maintenance screen appears a 2007 Month End Maintenance aS Commands Edit Modes Other Help 2xt malma l2 ee OK Abandon Delete Journal Entries for Periods From 1 Thru 6 Remove Unposted Entries Remove Cash Flow Exception Entries E Company H 1118 2007 Terminal TODO INS 1 Enter the range of periods for which you want to delete entries from the GLJRxxx file 2 Clear the box or enter N in text mode to prevent the system from removing entries that have not posted because of invalid account numbers
64. the business and not distributed retained earnings The transfer of the balances from revenue and expense accounts to an equity account at the end of the fiscal year or quarter to clear the accounts for the next year s entries In OSAS a business record associated with its own files tables and menu of applications A journal entry in which a debit is offset by more than one credit or vice versa Financial statements prepared by using the sum of the accounts of several companies as ifthey were one company You can print consolidated statements for companies that are on the same computer or for companies that are on different computers The process of updating existing files programs or applications to the current version See also installation The allocation of the cost of using up fixed assets over time in the form of a particular portion per accounting period General Ledger dividends expenses field file function general ledger goodwill income income statement income summary account installation interface inventory General Ledger GLOSSARY The portion of the net income paid out directly to the stockholders as a return on their capital investment The costs incurred in earning the revenue the cost of goods sold wages rent and so on A region on the screen that accepts input from the user also one element of a record in a file On the screen most fields are labeled
65. the files that are changed in the applications you installed on your system 1 Enter the Field ID you want to change You can change only General Ledger fields from the General Ledger menu To change IDs and codes from other applications run the Change Fields function in the respective application 2 Select the Print Log check box to print a list of the files that are changed 3 After you enter the Field ID and indicate your preference for printing the log use the Proceed OK command to begin entering field values to change 4 To edit or add original new values in this section select a line and press Enter to edit the current line The Edit Original New Values dialog box appears Press A to append another value to the list The Add Original New Values dialog box appears 5 Enter the current field value you want to change in the Original Value box 6 Enter the new value that you want to use for this field in the New Value box 7 Select a command e Press S to switch to the File Description section to specify which files change during processing e Press Enter to edit the current line e Press A to append another value to the list e Press B to begin the change field process General Ledger Change Fields Files General Ledger 8 File Maintenance CHAPTER 8 Press H to return to the header section to change the selection you made for printing the log Press G to go to a particular entry This option is only
66. the year of the previous period beginning balance Print beginning balance for the same relative period in the previous quarter period 5 beginning balance Print beginning balance for the previous quarter period 4 beginning balance Ending Balance Detail or Summary Print ending balance for the specified period period 8 ending balance Print ending balance for previous period period 7 ending balance Print ending balance for the previous period period 7 ending balance Print ending balance for the previous period period 7 ending balance Print ending balance for the same relative period in the previous quarter period 5 ending balance Print ending balance for the same relative period in the previous quarter period 5 ending balance 9 33 CHAPTER 9 Statement Maintenance Period or Quarter Prev Otr YTD Result 9 34 Activity Detail or Summary Print YTD balance for the same relative period in the previous quarter period 5 ending balance Balance Detail or Summary Print beginning balance for the year the previous quarter is in beginning balance Statement Contents Ending Balance Detail or Summary Print ending balance for the same relative period in the previous quarter period 5 ending balance General Ledger Batch Statements ooo MW Usually when you print statements you must specify the statement content and statement layout IDs and the printing paramet
67. up for the company that is shown in the message Exit from the function and set up the mask for the company Then try printing the statement s again General Ledger A 1 APPENDIX A System Messages Account Number is not on file The account number you entered is not in the GLMAxxx Master file Enter a different account number use the Inquiry F2 command to look up and select an account number from the list that appears or exit from the function and add the account number to the GLMAxxx file Account Number is not the proper length The account you entered is in the wrong format Use the format shown in the message when you reenter the account Accounts file GLMAxxx for Company xxx is not found The GLMAxxx Master file does not exist for the company that is shown in the message You cannot print statements for the company until you have set up its chart of accounts If this message appears when you are trying to consolidate companies through statements verify that the current year is the same for all companies Allocations are not on file for this account The account from which you are trying to copy allocations does not have any allocations set up Enter a different account number or use the Inquiry F2 command to look up and select the account from the list that appears A question mark is not allowed in the Account Number Because the Statement Contents function allows question marks as wildcard characte
68. year These files provide information for multiyear reports statements and so on e The beginning ending and 13 period actual balances of each of the company s accounts in the current year GLMAxxx file are transferred to the Last Year column and each account s ending balance is transferred to the beginning balance e The company s entries are removed from the current year GLJRxxx file Before You Begin Before you create last year data do these tasks e If necessary copy a chart of accounts or consolidate GLMAxxx files that are on different computers You cannot use the Copy Chart of Accounts function with last year files General Ledger 7 5 CHAPTER 7 Periodic Processing Create Last Year Data e Because creating last year files changes information in the GLMAxxx and GLJRxxx files back up your data files e Print the Chart of Accounts List page 10 9 and make sure that each account is assigned the correct account type and that you have assigned a clear to account and step to every income statement account e Make sure that no one else is using the GLMAxxx and GLJRxxx files Create Last Year Data Screen Select Create Last Year Data from the Periodic Processing menu The Create Last Year Data screen appears EN 2010 Create Last Vear Data fol gt Commands Edit Modes Other Help zx ejaan 2 99 OK Abandon S Have You Backed Up Your Current Y ear Files Reset Current Year Journal E
69. your account mask is MMMMII the beginning main account number is 1000 your ending main account number is 1999 and you want to include all divisions in this row of the content enter 10002 and 19992 if your account division mask is in this format When you print a statement using this content you can specify a range of divisions for which to print the statement You can use wildcards for account segments but not for main account numbers If you want to be able to select the ranges of segments for which to print a financial statement you must enter in each segment position Field Beginning Ending Account Type Description Description Select the account type if you have not selected an account number For functions HC and HP enter the text to print on this line For functions T1 T9 AS BS and ES enter a description of the summary line for example Current Assets For functions AD BD and ED press Enter to skip this field The name of each account prints in the Description column in the report 9 29 CHAPTER 9 Statement Maintenance Statement Contents Field Description Desc Tab For functions HP T1 T9 AD BD ED AS BB BS and ES enter the number of spaces to indent the description from the left margin Totals 1 9 Use these fields to add or subtract the balances or total amounts on a line in any of the nine totals If you do not want anything done to a total leave the field blank To adjust t
70. 0 other e Income statement accounts have an account type of 530 other e Memo account types have an account type of 999 not defined These account types require manual adjustments in the Account Types function If you are converting from version 4 10 or lower each General Ledger account will have 999 not defined as the account type for all converted accounts After conversion print a detailed chart of accounts Use the Account Types function page 8 13 to make the necessary changes To use the Cash Flow Contents function you must make adjustments to the account types unique to each account number For example cash accounts must be defined using 005 cash on hand and or 010 cash on deposit Use the Account Types function page 8 13 to make changes individually or in groups General Ledger Conversion Installation and Conversion CHAPTER 2 If you are converting from version 4 1 through 4 6 the account mask is already assigned If you want to change the mask as you convert files the new mask must be defined in the older version before converting You can change the mask after conversion but don t change it until all application conversions are complete If you do not change account masks before you convert your other application masks will not match Converting to Version 7 6 Select Data File Conversion from the Company Setup menu in Resource Manager The Data File Conversion screen appears fi
71. 0 000 0 000 00 00 07 Clothing 0 000 0 000 00 00 08 Gasoline 0 000 0 000 00 00 09 Services 0 000 0 000 00 00 E Total 1307 00 00 Calculated 1307 01 00 Over Short 01 00 Enter edit taxLoc First Last Next Prev view Header Goto Class You can move around the screen in these ways Company H 10 04 2007 Terminal T000 OVR Use the mouse or press Tab to move from field to field Use the scroll buttons to move from line to line in scrolling regions If a screen appears prompting for the kind of information to enter or maintain such as on File Maintenance or Transactions screens select the appropriate option and click OK to continue Press Page Down if prompted to move to the next section Click Header when it appears to return to the screen s header section Press F7 to exit the screen and return to the main menu General Ledger Navigating OSAS Introduction CHAPTER 1 Shortcut Menu Other Commands Menu Information Menu General Ledger Menus Both the graphical main menu and graphical function screens contain drop down menus that give you access to additional commands without using the function keys While you can use the function keys to access commands in graphical mode you may find it easier to access command through these menus To access a menu s commands click a menu title The commands for that menu appear followed by any associated hot key
72. 00 ACCOUNTS RECEIVABLE 102000 ALLOWANCE FOR BAD DEBT 104000 INVENTORY RAW MATERIALS 104200 INVENTORY WORK IN PROCESS 104400 INVENTORY FINISHED GOODS 105000 PREPAID EXPENSES 106000 MARKETABLE SECURITIES 151000 LAND 152000 MACHINERY amp EQUIPMENT 152500 ACCUM DEPR MACHINERY amp EQUIP 153000 OFFICE MACHINES 153500 ACCUM DEPR OFFICE MACHINES 154000 AUTOMOBILES 154500 ACCUM DEPR AUTOMOBILES 150000 GOODWILL 18 ACCOUNTS LISTED End of Report 10 10 CR DB DEBIT DEBIT DEBIT CREDIT DEBIT DEBIT DEBIT DEBIT DEBIT DEBIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT 2007 Type Clear Acct Chart of Accounts List Step o gt O0O0ODO ooo Consol Acct Step o0000 o0000 ooo General Ledger Allocations List o MM After you finish setting up the allocation records produce the Allocations List to make sure that everything is correct and to use as a reference when you enter journal transactions Print a new list each time you add or change allocation records You cannot access this function if you did not elect to use allocations in the Resource Manager Options and Interfaces function Sample List 12 19 2007 Builders Supply Page 10 32 AM Allocations List Allocation Description 510000 SALARIES EXPENSE Salary Allocation GL Account Percent GL Account Percent GL Account Percent 510001 75 00 510002 10 00 510003 15 00 1 2 3 4 5 6 7 8 General L
73. 003 Function AD Account Detail Print Row El Company amp Beginning Account No 10002 a Beginning Account Type 4 Ending Account No 10997 a Ending Account Type 4 Description Desc Tab Action on Totals For Add For Subtract 0 For Zero Total 1 Total2 Total 3 Total 4 Total 5 Total 6 Total 7 Total 8 Total 9 Print Debit Credit or Both Both y Reverse Sign to Print Oo Print Dollar Signs E Number of Chars to Shift Extra Blank Lines 0 99 New Page Field Description Sequence Number The sequence number identifies each line and specifies the order 1t will be executed when you run the Statements function When you add a statement content the system assigns the sequence numbers General Ledger 9 25 CHAPTER 9 Statement Maintenance Statement Contents Field Description Function The function specifies what the line does When you enter one of these functions a description of the function appears at the right See the end of this section for a table illustrating activity and balance results for various periods and quarters Enter AD to print each account number and its account balance in the specified range The actual budget or last year balances and the period s that print are determined by the columns in the statement layout You can enter the balances in one or more of the Total fields at the same time see the Totals 1 9 field below The account name prints in the description column unless y
74. 1 13 Y year end processing 7 2 IX 9
75. 1 la To u al Main Account From 4000 fa Thu 9999 la Department From Thru 4 Account Type From a Thru la Edit Account Descriptions El Copy Current Year Budget Amounts o Copy Next Year Budget Amounts a Copy Last Year Amounts a Copy Forecast Amounts o Replace Existing Accounts in Destination Company a Company H 111912007 Terminal TODO OVR 1 Enter the type of copy you want to perform You can copy accounts from one company to another from one department to another or from one division to another The screen differs slightly depending on the type of copy you choose Inquiry 2 Enter the range of the companies divisions or departments from which you want to copy 3 If you are copying the chart of accounts for a company and you want to use wildcards when you enter the range of account numbers to copy select the Use Wildcards box or enter Y in text mode if not clear the box or enter N in text mode Inquiry 4 Enter the range of accounts you want to copy 8 28 General Ledger Copy Chart of Accounts File Maintenance CHAPTER 8 10 11 12 If you are copying the chart of accounts for a company enter the range of GL accounts you want to copy You can use the and characters as wildcards Enter the range of account types you want to copy If you are copying accounts for a division or department and you want to edit the account descriptions select the box or enter Y in text m
76. 2 and page 1 26 for more information on these commands When you see the phrase use the Proceed OK command in this guide press Page Down in either text or graphical mode to continue In graphical mode you can also click OK to proceed General Ledger The General Ledger System oo M Use the General Ledger system to consolidate information about your business You can use it alone but it works best when interfaced with other applications You can set up accounts and produce statements that include debit and credit information from the interfaced applications Application Interaction General Ledger can be used as a standalone application but you get optimal use from it when you interface it with other applications Purchase Order mn Bank r Reconciliation Bill of Materials Kitting General Ledger Inventory Becounts Receivable Job Cost ll A Go Payroll Sales Order Fixed Zi Assets Interfacing applications means that the information you enter in one application can be transferred to and used in other applications reducing data entry time and the number of errors that might creep in along the way General Ledger 1 3 CHAPTER 1 Introduction The General Ledger System Menu Structure The General Ledger menu structure is similar to the structure of other OSAS applications functions appear roughly in order of use Journal T
77. 5 50 18067 75 12155 50 4078 90 10111 75 2088 80 4078 90 2 2 2250 75 8550 50 8005 50 2250 75 4 148628 58 1268 20 1500 00 3990 65 4 10111 75 2088 80 2250 75 10111 75 5 8550 50 8005 50 4078 90 8550 50 1268 20 1500 00 3990 65 1268 20 8005 50 4078 90 8550 50 8005 50 8 2088 80 2250 75 10111 75 2088 80 1500 00 3990 65 1268 20 1500 00 10 4400 00 995 50 2250 75 4400 00 BE 995 50 1268 20 4078 90 995 BE 00 4400 00 3990 65 00 13 00 00 00 me End 157620 48 6269 45 12155 50 5001 25 GL Account First kast J Next Prev l Alt budget Switch to Balance l account Detail Totals Use account format MMMM11 Company H 12 29 2010 Terminal T000 ovr Use the commands to view transaction information or change the account e To view information for a different account press G Next enter the number of the account whose transactions you want to view use the Inquiry F2 command to look up the account number or press Enter to begin with the first record in the GLMAxxx Master file for the company specified 4 5 CHAPTER 4 Information Inquiry Accounts Inquiry e To view information for the first last previous or next account on file press F L P or N respectively e To toggle the last column between forecast and next year budget amounts press A e To toggle between viewing the amounts as balances or activity press S e To view account detail for the
78. 50 00 235 166 41 37 751 37 6 5 Audit Trial Balance MM Use the Audit Trial Balance as a worksheet at the end of the year It shows year to date account balances and last year budget or forecast balances and provides space for you to write down adjusting entries Audit Trial Balance Screen Select Audit Trial Balance from the Reports menu The Audit Trial Balance screen appears EN 2007 Audit Trial Balance le Commands Edit Modes Other Help gt Xt elm 280 e e OK Abandon Print Last Year Amounts Current Y ear Budget Amounts Next Year Budget Amounts Forecast Amounts Account Number Sort M1 Headings Line 1234567890123 45678901234567890 1 Builders Supply AUDIT TRIAL BALANCE December 31 2007 uN Company H 111812007 Terminal T000 OVR 1 Select the type of balances or amounts you want the worksheet to list 2 Select the sort configuration you want to use for the worksheet If you created user defined sorts through the Account Masks function valid entries appear at the bottom of the screen General Ledger 6 7 CHAPTER 6 Reports Audit Trial Balance 3 Enter the title you want on the worksheet four lines of 30 characters each Use the numbers above the fields to help center the text 4 Before you continue make sure that no one else is using the system 5 Select the output device See Reports on page 1 29 for more information on output devices Afte
79. 9 26 2007 Terminal T000 OVR Description If you want to print a group of statements that you set up in a batch statements record enter the batch ID If you have not set up any batch statements records or if you do not want to print a group of statements that you set up in a batch statements record press Enter to skip this field If you want the statement to be displayed with the active financials viewer select the box or enter Y in text mode if not clear the box or enter N in text mode The active financials viewer is available in graphical workstations only For more on the active financials statement viewer see Income Statement on page 6 18 General Ledger Statements Field Inquiry Pick Statement Layout ID Inquiry Pick Statement Content ID Period 1 13 Beginning Ending Date Company ID General Ledger Reports CHAPTER 6 Description If you entered a batch ID this field is skipped Enter the statement layout ID for the statement you want to print The heading lines from the statement appear If you entered a batch ID this field is skipped Enter the statement content ID for the statement you want to print The heading lines from the statement appear Enter the period for which to print the report The statement or report covers the entire accounting period to date After you enter the period the beginning and ending dates for that period appear from the CNVTxxx table in Res
80. A Data File Conversion AMEN Commands Edit Modes Other Help 2Xt m ma l e ee ok Abandon Select directory on which to create files data Enter directory that contains the files to be converted C osas65 data la Do you want source files erased after conversion E Do you want conversion to pause if a problem is found E Appl Description Version Appl Description Version IN Inventory 6 50 RM Resource Manager 6 50 so Sales Order 6 50 AR Accounts Receivable 6 50 GL a General Ledger 6 50 Company H 1111872007 Terminal Tooo OVR 1 The system displays all valid OSAS data paths Select the destination directory where your new data files will reside 2 Enter the path drive and directory that has the files you want to convert You cannot enter the same path as the path you selected as the destination General Ledger 2 5 CHAPTER 2 Installation and Conversion Conversion 2 6 10 11 If you want source files to be erased after conversion select the box or enter Y in text mode if not clear the box or enter N in text mode If you want the conversion process to pause if a problem occurs select the box or enter Y in text mode if not clear the box or enter N in text mode The system considers file corruption or evidence of data not converting correctly a problem Enter GL in the Appl column General Ledger appears Enter your earlier version number of General Ledger and press Enter You
81. D Period From Thru 1 13 Beginning Ending Date Years Company ID Pick Division Department Subaccount From Thru Print Detail Print Workstation Date and Time Cash Flow Statement Description Enter the ID of the cash flow statement you want to produce Enter the range of periods for which to print the statement After you enter the range of periods the beginning and ending dates for the periods appear from the CNVTxxx table Press Enter to use those dates or enter different dates The system uses the most recent account balances for the selected range of periods regardless of the dates you enter The current year appears Press Enter to accept the current year or enter a different year to print Then enter a different year for comparison purposes or leave the year blank to use the current year only You can enter 20 company IDs After you have entered the ID of the last company press Enter If your account mask does not include one or more of these segments the appropriate fields are skipped Enter the range of account segments you want in the statement To include all the account segments leave the From and Thru fields blank If you want each account listed with the account description select the box or enter Y in text mode If you want all accounts in each account type totalled with the cash flow content description clear the box or enter N in text mode If you want the statement t
82. EXPENSES SELLING EXPENSES SALARIES EXPENSE TRAVEL AND ENTERTAINMENT EXP AUTO EXPENSE ADVERTISING EXPENSE TOTAL SELLING EXPENSES MANUFACTURING EXPENSES PAYROLL EXPENSE DEPRECIATION EXPENSE MAINTENANCE EXPENSE APPLIED OVERHEAD TOTAL MANUFACTURING EXP 6 18 INCOME STATEMENT WITH BUDGET COMPARISON 2007 THROUGH AUG 31 Builders Supply CURRENT THIS YEAR 280994 85 656133 38 6061 33 115 42 931182 32 151672 26 363495 10 29791 05 539041 48 392140 84 57307 43 252 11 2017 66 62135 76 105646 68 20090 34 1226 38 4795 42 131758 82 30 18 70 46 65 206993 82 13155 65 6404 23 100 00 713745 24 103482 68 253159 42 25128 73 381770 83 331974 41 57267 06 245 12 2431 13 62693 89 104230 85 18391 65 1241 09 4792 22 128655 81 29 00 71 90 90 100 00 tet 2007 THIS YEAR 2257140 94 4864964 42 56489 90 115 42 7065730 88 1054815 38 2581499 73 227136 35 3857534 53 3208196 35 452918 90 1912 07 134335 91 176605 24 76577Z 12 825692 70 153518 55 9372 05 38525 50 1027108 80 YEAR 31 94 68 85 80 2085824 53 4873087 23 59946 40 100 00 6898965 36 100 00 14 93 36 54 3 21 1057495 60 2665847 47 234655 58 54 59 3957998 65 45 41 2940966 71 457122 67 1837 00 18471 17 10 84 496983 89 11 69 2 17 13 832001 155217 9311 14 54 1035407 General Ledger Statements Balance Sh
83. El 12 14 2010 12PA Net Cash Entry 17443 71 PAYROLL Y 12 12 2010 12BR BR DEPOSIT 3000 00 OT INC Y B 12 12 2010 12BR BR DISBURSEMENT 300 00 EXPENSE Y Unposted Trans Pd 12 Beg Bal Posted Trans Pd 12 End Bal 91254 18 4940 66 100 00 4840 66 GL Post Code First Last Next Previous l Sort View gO to Totals Company H 12 29 2010 Terminal T000 OVR e Enter or choose the GL Post Code for which you want to see transaction inquiry information Leave the field blank to view information for all post codes as well as information unrelated to a post code e Enter or choose the GL Account for which you want to see transaction inquiry information Choose the range of periods for which you want to see transaction inquiry information General Ledger 4 7 CHAPTER 4 Information Inquiry Transaction Inquiry Use the navigation buttons to further manipulate the inquiry e To view information for the first last previous or next account on file press F L P or N respectively e Press S to select a different sorting method for the inquiry e Press V to view the GL Transaction Detail for the selected GL account The following information appears e post date period source code description and reference of the transaction e dollar amount of the transaction debits are displayed as positive amounts and credits are displayed as negative amounts e allocation status of the transaction e p
84. General Ledger OSAS 7 6 User Guide OSAS OSAS General Ledger User s Guide Version 7 6 2210 GL76 2010 Open Systems Holdings Corp All rights reserved Document Number 2210 GL76 No part of this manual may be reproduced by any means without the written permission of Open Systems Inc OPEN SYSTEMS and OSAS are registered trademarks of Open Systems Holdings Corp All other product names are trademarks or registered trademarks of their respective companies Printed in U S A This manual is recyclable October 2010 Release 7 6 This document has been prepared to conform to the current release version of OPEN SYSTEMS Accounting Software Because of our extensive development efforts and our desire to further improve and enhance the software inconsistencies may exist between the software and the documentation in some instances Call your customer support representative if you encounter an inconsistency Open Systems Inc 4301 Dean Lakes Boulevard Shakopee Minnesota 55379 General Telephone 952 403 5700 General Fax 952 496 2495 Support Telephone 800 582 5000 Support Fax 952 403 5870 Internet Address www osas com CONTENTS General Ledger Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Introduction The General Ledger System 222 Starting OS AS iia ad Navigating OSAS 0 00 0 0 0002 eee REPONSE ernennen Bun Bi Installation and Conversion CON
85. Help 2xu e mu 2e es OK Abandon Account Mask MMMM11 Account Segment 1 Segment ID 01 a Description Minneapolis 1119 2007 Terminal T000 OVR Company H Field Account Mask Account Segment 8 10 Description The mask for the company appears Enter the number associated with the account segment 1 2 3 for which you are entering a description If you enter the number of a segment that is not defined in your account mask that is it is not displayed in the Account Mask field an invalid entry message appears Enter the number of a defined segment for which you want to enter a description General Ledger Account Segments File Maintenance CHAPTER 8 Field Description Inquiry Segment ID Enter the ID of the segment for which you are entering a description For example if you have three divisions you can number them 01 02 and 03 Then enter a description to distinguish each division see below If you want to delete the segment use the Delete F3 command Description Enter a description of the account segment For example if you have three divisions you can enter a description based on location such as Minneapolis Oakland and Dallas Use the Proceed OK command to save the segment definition After you save the segment description enter the next segment description or exit to the File Maintenance menu General Ledger 8 11 Account Types ooo MM Account types are pre
86. LMAxxx file Then erase the branch GLMAxxx files from the hard disk General Ledger 7 25 Remove Prior Year Files MM Use the Remove Prior Year Files function to erase GLMAxxx Master GLJRxxx Journal and GLMKxxx Master Key files stored for any year other than the current fiscal year Remove Prior Year Files Screen Select Remove Prior Year Files from the Periodic Processing menu The Remove Prior Year Files screen appears You must be in the current year to use this function EN 2008 Remove Prior Year Files camz Commands Edit Modes Other Help gt Xt a lin amp se OK Abandon Have You Backed Up Your General Ledger Data Files y Year to Remove 2007 a Company H 111812007 Terminal TODO INS 1 If you have backed up your General Ledger data files select the box or enter Y in text mode if not clear the box or enter N in text mode General Ledger 7 27 CHAPTER 7 Periodic Processing Remove Prior Year Files Inquiry 2 Enter the year for which you want to delete data If there are unposted transactions in the prior year GLJRxxx file the following prompt appears if you choose to delete data for last year Warning There are unposted entries Do you want to continue Either continue with the Remove Prior Year Files function or exit to the Periodic Processing menu and post these transactions 3 Make sure that no one else is using the data files for the year y
87. Lookup ID in the Company Setup function to direct your web browser to a mapping website and generate the map Note Before you can view maps you must set up mapping website information in the Resource Manager Web Setup function select the Map Lookup ID to use in the Resource Manager Company Information function and enter the path to your workstation s web browser in the Resource Manager Defaults function General Ledger Navigating OSAS Introduction CHAPTER 1 Text Mode The OSAS text mode is available on all operating systems If you use OSAS on an operating system that does not have graphical capabilities the text mode is the only mode available In text mode all screens are presented in an easy to use textual interface that you navigate through using keyboard commands Main Menu The text main menu is shown below EN osas 1000 Sa Settings Edit Print Help 11 27 2007 Company H Builders Supply 4 25 PM Main Menu Bills of Materials Kitting TOOO _ OPEN SYSTEMS R Accounting Software When you select an application the application s menu is superimposed over the main menu Selecting an entry on an application menu opens a function screen or a submenu You can move around the text main menu in these ways e Use the arrow keys to move the cursor up and down to highlight the application you want Then press Enter to select it General Ledger 1 23 CHA
88. NVENTORY TURNOVER SALES RATE OF RETURN ON FIXED ASSETS RATE OF RETURN ON TOTAL ASSETS LEVERAGE RATIOS DEBT TO ASSETS DEBT TO EQUITY 6 20 LAST YEAR Statements General Ledger Cash Flow Statement MM The Cash Flow Statement provides information about sources and uses of cash and cash equivalents within a business The Financial Accounting Standards Board FASB has determined that a Cash Flow Statement should be part of a complete set of financial statements The Cash Flow Statement is generated according to the Indirect Method as described in FASB Statement 95 You can produce a consolidated Cash Flow Statement for 20 companies Cash Flow Statement Screen Select Cash Flow Statement from the Reports menu The function screen appears H 2007 Cash Flow Statement Commands Edit Modes Other Help RX tz e mo 209 008 OK Abandon Cash Flow Content ID CFCH a Years 2007 Pick Period From 8 Pick Division From 01 a Thru 12 Thu 03 a Department From 4 Beginning Date 08 01 2007 E Thru 4 Ending Date 12 31 2007 ec Subaccount From 4 Thru q Company ID H Print Detail Y Change Footers Print Workstation Date and Time Line Statement Titles 12345678901234567890123456789012345678901234567890 qe Builders Supply da Cash Flow Statement 3 4 CompanyH 11 18 2007 Terminal T000 INS General Ledger 6 21 CHAPTER 6 Reports 6 22 Field Cash Flow Content I
89. O OVR Using only numbers and letters of the same case you used in the Statement Layout function enter the statement content ID Enter the ID of the company whose mask you want to use for the content The company s account mask appears in the Mask field Use the commands to work with the information in the scroll region e To edit the selected line item press Enter See Edit or Append a Line Item on page 9 25 for more information e Toadd a line item press A See Edit or Append a Line Item on page 9 25 for more information General Ledger Statement Contents Statement Maintenance CHAPTER 9 e To insert a line between two existing lines select the sequence number where you want to insert a line and press the Insert key The system automatically inserts a line and renumbers subsequent lines then opens the Insert Line screen This screen is identical to the Edit Line screen see below Use this screen to enter values for the new line e To return to the header portion of the screen press H e To go to a particular line item press G This command is available only when there is more than one screen of items Edit or Append a Line Item The only differences between the Edit Line and Append line screens are the title and the fact that data appears in the Edit Line window a Edit Line el Commands Edit Modes Other Help 2xa melmoa e ee OK Abandon Sequence Number 000
90. PTER 1 Introduction Navigating OSAS 1 24 Press the first letter of the application you want to move the cursor to the first application beginning with that letter Continue to press the letter key or the down arrow until the application you want is highlighted then press Enter to select it Use the mouse to click an application to view that application s menu To move to the first application on the menu press Home To move to the last application on the menu press End On an application menu press Page Up to move to the menu immediately behind it If you are several levels away from the main menu you can return to the main menu by pressing Page Up repeatedly or by pressing Tab once To exit from OSAS press F7 Function Screens Like the text menu OSAS text function screens can be used on all operating systems and in combination with graphical menus Settings Edit Print Help Orders General Ledger Navigating OSAS Introduction CHAPTER 1 Other Commands Information Menu General Ledger You can move around the screen these ways e Press Enter or the down arrow to move from field to field e To use a command that is listed in the command bar press the highlighted letter e Use hot key commands to access information screens or to toggle commands on and off Refer to Appendix B in the Resource Manager User s Guide for more information on these commands and their corresponding hot keys
91. S OF PEDW 1 2 3 4 UNAUDITED XXXXXXXXXXXX DESCRIPTION CURRENT YEAR HERERFERE DO iggggggggg DO What As of When How Far Back Scaling What As of When How Far Back Scaling Account No Description Actual Current Period Year To Date CY Budget Current Period Year To Date Print Page YES Extra Lines 2 Allow Shift NO Addnl Spacing Printing Col Addnl Spacing Printing Col Addnl Spacing Printing Col Year Addnl Spacing Printing Col 10 15 Statement Contents List To make sure that everything in a statement content is correct produce a hard copy of each new statement content Sample List 12 19 2007 10 33 AM Statement Contents ID BAL1 Account Mask MMMM11 Sequence 000044 000045 000046 000047 000048 000049 000050 000051 000052 000053 Beginning Acct Type Ending Acct Type 999727 Builders Supply Statement Contents List Description From GL NET PROFIT Columns Right 15 TOTAL STOCKHOLDERS EQUITY Columns Left 15 Columns Right 30 TOTAL LIABILITIES EQUITY Account Detail Account Summary Beg Balance Detail Beg Balance Summary End Balance Detail End Balance Summary General Ledger to Functions No No No No No 1 2 3 4 5 o T6 T Ts T9 H or 2 o 5 4 o 5 0 4 o Actions on Totals Tab 123456789 Total No Total No Total No Total No Print Row DB
92. Segment Value Description Account Mask MMMM11 Main Minneapolis Dallas Oakland End of Report General Ledger 10 5 Account Types List After you enter account types print the Account Types List to verify that your entries are correct Sample List 12 19 2007 10 32 AM Account Type General Ledger Builders Supply Account Types List Description Cash On Hand Cash On Deposit Accounts Receivable Allowance for Bad Debts Employee Receivables Other Receivables Notes Receivable Raw Materials and Supplies Work in Process Finished Goods Inventory Prepaid Expenses Marketable Securities Other Other Other Land Buildings Machinery and Equipment Furniture and Fixtures Motor Vehicles Leasehold Improvements Accumulated Depreciation Other Other Other Other Other Intangible Assets Accumulated Amortization Other Other Accounts Payable Notes and Interest Payable Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Other Other Other Other Current Liabilities Current Liabilities Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets Assets
93. Select Import Transactions from the Daily Work menu The Import Transactions screen appears EN import Transactions ee Es Commands Edit Modes Other Scroll Commands Help z2xelae ma e o0 OK Layout ID GLimport 4 GL Import File Type Comma Delimited File Name C GLFILE txt GL Account Debit Credit Reference Pd CFlow Description Date Src Alloc onar FRE Entry 0000 of 0000 Total Debits Total Credits Balance 00 00 00 Status Bar Company H 08 19 2010 Terminal T000 OVR Inquiry 1 Select the Layout ID for the import file use the Import Definitions function in the Resource Manager System File Utilities menu to add or edit a layout ID The File Type for the Layout ID is displayed 2 Enter or browse to the File Name you would like to import General Ledger 5 13 CHAPTER 5 Journal Transactions Import Transactions 5 14 3 The import information populates the Import Transactions scroll area Press W to write the changes to a transaction or press L to return to the Layout ID field and begin again 4 When you write the changes you will be prompted to commit imported transactions Press OK to continue or Cancel to quit Select the output device to begin printing the import transaction journal See Reports on page 1 39 for more information After the journal is produced the Daily Work men
94. Trial Balance 11 19 2007 Period Beginning Balances 11 54 AM Company H GL Account 100000 100100 100500 101000 102000 104000 104200 104400 105000 106000 151000 152000 152500 153000 153500 154000 154500 180000 181000 200000 201000 202000 203000 203200 203400 Description CASH IN BANK lst NATIONAL CASH IN BANK Znd NATIONAL PETTY CASH ACCOUNTS RECEIVABLE ALLOWANCE FOR BAD DEBT INVENTORY RAW MATERIALS INVENTORY WORK IN PROCESS INVENTORY FINISHED GOODS PREPAID EXPENSES MARKETABLE SECURITIES LAND MACHINERY amp EQUIPMENT ACCUM DEPR MACHINERY amp EQUIP OFFICE MACHINES ACCUM DEPR OFFICE MACHINES AUTOMOBILES ACCUM DEPR AUTOMOBILES GOODWILL ACCUM AMORTIZATION ACCOUNTS PAYABLE TRADE ACCOUNTS PAYABLE AFFILIATES PAYROLL CLEARING ACCOUNT FEDERAL WITHHOLDING PAYABLE FICA WITHHOLDING PAYABLE STATE WITHHOLDING PAYABLE General Ledger Builders Supply TRIAL BALANCE August 19 2007 Actual Current Period 4 514 50 0 00 100 00 12 155 50 998 335 14 1 035 227 71 858 345 62 0 00 561 455 26 450 000 00 1 387 674 92 493 241 67 84 996 32 25 000 00 530 121 10 259 661 27 32 749 31 6 250 00 235 166 41 37 751 37 Reports CHAPTER 6 Actual Year to Date Balance o 100 12 155 998 335 1 035 227 858 345 o 561 455 450 000 1 387 674 493 241 84 996 25 000 Credit 530 121 10 259 661 27 32 749 31 6 2
95. VETSION ii AA Be ok Setup Setup Checklist 0 0 0 0 0000000000 Setup Functions 0 00 0 000000000 Information Inquiry Chart of Accounts Inquiry Accounts Inquiry 02 0 0 eee ee eee eee Transaction Inquiry 22 22222220 00 00 0200 0 Journal Transactions Transaction eae Skee GA Amen Import Transactions 0 0 0 e eee eee Copy Recurring Entries o oo oooooooo o GL Joumal ioe oe cda a a GL Activity Report 0 00 0 0000 Edit Transactions 0 0 0 e ee eee eee eee Post to Master 0 0 0 eee eee eee ee Reports iii CONTENTS Cash Flow Statement Chapter 7 Periodic Processing Create Last Year Data Clear and Close Last Year Update Current Year Month End Maintenance Consolidate Master Files Remove Prior Year Files Chapier 8 File Maintenance Account Mask 005 Account Segments Account Types 0000 GL Ace unts unsre arg Account Budgets 22 Budget Import o o o o o Copy Chart of Accounts AllOCAtI0NS ooooooooooocmooooo Recurring EntrieS o o o o A E Copy Account Balances Assign Account Types Change Fields 22 2220 Import Definition Chap
96. Y 104400 6934 94 A R 12 El INVENTORY 12 03 2007 AR E 104200 25039 40 AP 12 v E AIP LINE ITEMS 12 03 2007 AP Y E Entry 000001 Balance 00 Enteredit aLlocate l Go to Company 1118 2007 Terminal T000 OVR Use the commands to edit the transactions that appear e Press Enter to edit the selected transaction line See Edit Line Screen on page 5 29 for more information e Press Lto change the allocation flag of the selected transaction line e Press Gto go to a transaction line then enter the account number This command is available only if there is more than one screen of transactions 5 28 General Ledger Edit Transactions Journal Transactions CHAPTER 5 Edit Line Screen When you press Enter on the command bar the Edit Line screen appears If you edit a transaction that originated in another OSAS application a warning message appears to alert you that you are editing a transaction that is not a manual recurring or reversing transaction Use caution when editing transactions that originate in other applications as it can cause discrepancies between files It may be better to enter a reversing transaction in the originating application and post it to General Ledger than edit the transaction directly here EJ Edit Line lees Commands Edit Modes Other Help 2 xa nma mu gt e 0s Go tandon Entry 000001 GLAccount 401000 a Debit Credit 00 11838 80
97. a transaction in Accounts Receivable you can access comments or documents about items or customers but not about employees or vendors See page 1 19 for more information The Favorites menu allows you add the OSAS menus or functions you use most frequently to a custom menu After you ve set up the menu select Change to Favorites from the graphical Favorites menu or press F2 to access the functions To add a function to the Favorites menu select the function you want to add from the main menu and press F10 To remove a function from the menu select the function on the Favorites menu that you want to remove and press F10 again See page 1 20 for more information on this menu Commands and Flags Both the text menu and text function screens let you use commands to drill down to more information change companies switch to sample data and perform tasks related to the function you are using These commands are analogous to the commands contained on drop down menus in graphical mode You access commands by pressing the hot key combination for the command you want to use If you re working with a keyboard that lacks function keys labeled with an F followed by a number or if you re working with an emulator in UNIX which can cause function keys to become unavailable press the appropriate alternate key combination to access the command Refer to Appendix B in the Resource Manager User s Guide for a list of all OSAS commands and their assoc
98. account types for income investing activities financing activities cash and cash equivalents and adjustments to reconcile net income to net cash from operating activities Cash Flow Contents Screen Select Cash Flow Contents from the Statement Maintenance menu The Cash Flow Contents screen appears a Cash Flow Contents Commands Edit Modes Other Scroll Commands Help 2 gt xu mnaj mu 20e 068 Oh Cash Flow Content ID CFCH 4 Use Acct Mask for Company H Mask MMMM11 Description CASH FLOW FOR COMP H Beginning Ending Seq No Sec Acct Type Acct Type Description A Changes in receivables 000002 100 125 Net purch sale of property a 000003 A 165 165 Amortization 5 000004 A 130 130 Depreciation 000005 A 045 055 Changes in inventory 000006 A 060 060 Changes in prepaid expenses 000007 A 200 200 Changes in accounts payable 000008 A 210 210 Income taxes payable 000009 A 230 230 Changes in payroll taxes payab 000010 A 240 240 Changes in deductions payable 000011 A 245 245 Changes in pension fund payabl DI 000012 l 065 065 Markstable securities E 000013 F 400 405 Proceeds from stock issue E Line 001 of 016 Enter edit Append Header Company H 1149 2007 Terminal Too ovR Inquiry 1 Enter the cash flow content ID you want to view edit or create General Ledger 9 45 CHAPTER 9 Statement Maintenance Cash Flow Conten
99. ad it with an earlier version of 1 2 3 The WKS file is saved to the print file directory you set up in the Defaults function on the Resource Manager Workstation Configuration menu You can copy it to a different directory to be used with the spreadsheet package if necessary The cells in the WKS file are in Protected mode The statement columns are stored in the same column letter in the spreadsheet like in the statement layout Blank columns have a width of 1 The page and column headings are stored in column A Column shifts are ignored Only the results of formula columns are stored in the spreadsheet cells the formulas are not saved You must define the formulas in Lotus if you want to use them in the spreadsheet The results of formula columns types 6 and 7 are stored in spreadsheet cells only if they are set up to be printed If the Print This Column field in the statement layout is set to NO for the formula column the formula result is not stored in a cell To get the spreadsheet pages to break properly with the default margin settings print statement footers on line 48 CHAPTER 6 Reports Active Financials Statement Viewer 6 16 Statements If you elected to view your statement with the active financials statement viewer the statement will open in a separate active financials statement viewer The viewer allows you to view statements and drill down to view source information for the statement data This viewer
100. adjust the next year budget press N The beginning actual current year budget last year and forecast or next year budget figures appear You can change only the current year budget next year budget and forecast balances The 13 period actual current year budget last year budget and forecast figures appear If you elected to enter budgets and forecasts manually enter the amounts in the appropriate fields If you elected to use the special functions to calculate budget and forecast balances in the Manual Entry field select one of the following functions when prompted Manual entry Enter a budget amount for this field only Duplicate Duplicate an amount in this field and subsequent fields Allocate Equally allocate an amount between this field and subsequent fields General Ledger Account Budgets Field End Actual CY Budget Last Year Forecast or Next Year Budget File Maintenance CHAPTER 8 Description L Y Adjust the balances in this field and subsequent fields to the corresponding balances in the Last Year column plus or minus a dollar amount L Y Adjust the balances in this field and subsequent fields to the corresponding balances in the Last Year column plus or minus a percentage Chg Change the balances in this field and subsequent fields by a dollar amount You cannot use this function in period 1 Chg Change the balances in this field and subsequent fields by a percentag
101. age ratios liabilities liquidity ratios memo account menu post profitability ratios program purge quarterly system Gl 4 A chronological record of transactions Transactions recorded in a journal Ratios used to determine how much the business is encumbered by its liabilities the ratio of debt liabilities to assets and of debt to equity The claims of creditors upon the business s resources assets accounts salaries taxes and so on payable to parties other than the owners Ratios that indicate the amount of cash that could be available for investment after meeting short term obligations The current liquidity ratio is the ratio of current assets to current liabilities The quick ratio is the ratio of current assets less inventory to current liabilities An account that stores various numbers you may need in calculations for example the number of shares of stock outstanding or the number of days in each month for sales reports A list of applications functions options or other menus To transfer information from one place to another usually at the end of the day or at a distinct break in business An indication of how much the net profit is in relation to the size of the business The net profit margin is the ratio of net profit to sales the return on assets and return on equity are the ratios of the profit to total assets and to equity respectively The earnings per share show t
102. al Ledger creates the file and adds a TXT extension Changing the Separator Character You can change the character that separates the records in the file from a comma to another printable character a tilde or semi colon for example You cannot change the separator character to a tab or similar non printing character Follow these steps to change the separator character 1 Select Application Tables from the Resource Manager Data File Maintenance menu The Application Tables screen appears 2 Enter RMTB in the Enter File Name field and press Enter 3 Enter DELIM in the Table ID field and press Enter The DELIM table appears and lists a comma in the first field as the separator character 4 Change the separator character to the character of your choice then use the Proceed OK command to save your changes When General Ledger exports statements the file is saved with a TXT extension instead of a CSV extension Change the separator character back to a comma to use the CSV extension 5 Use the Exit F7 command to return to the Resource Manager Data File Maintenance menu Lotus Spreadsheet Notes These points apply when you read statements into a Lotus spreadsheet 6 14 General Ledger Statements General Ledger Reports CHAPTER 6 You can read the WKS file into 1 2 3 versions 1 1A and 2 and Symphony versions 1 and 1 1 Once you save a WKS file with Symphony or 1 2 3 version 2 you might not be able to re
103. anies Consolidation Methods Use one of the following methods to consolidate companies General Ledger 7 21 CHAPTER 7 Periodic Processing Consolidate Master Files e Consolidate all companies into one GLMAxxx file For example to include the accounts of a department at a branch office consolidate that company s accounts with those of a company in the GLMAxxx file at your main office Then you can use the consolidated company in statements with other companies in the main office s GLMAxxx file e Consolidate the companies into two or more GLMAxxx files for example to print separate consolidated statements for several departments If you want to print financial statements from a consolidated GLMAxxx file they should use the same account mask otherwise the financial statements might not print correctly The First Time You Consolidate Before you consolidate the first time use the GL Accounts function page 8 15 to specify the main company s accounts in the Consol To Account field with which the branch company s accounts are consolidated If all the branch company s accounts are the same as the main company s accounts skip the Consol To Account field Each account also has a two digit Step field so you can consolidate in steps to provide an audit trail For example you might consolidate all asset accounts in one step all liability accounts in the next step and so on If you do not want to consolidate an ac
104. any H 11 19 2007 Terminal T000 OVR General Ledger 9 49 CHAPTER 9 Statement Maintenance Financial Statement Verification 9 50 Field Description Statement Content Enter the statement content ID you want to verify ID Verify Main Account Enter the range of main accounts that you want to use to verify that all accounts are included in the content Verify Account Type Enter the range of account types that you want to use to verify that all accounts are included in the content Include in Enter the division department and subaccount Statement Division ranges you will use when you print the statement Department Subaccount Next enter the company IDs for which the statements Company are printed The system uses this information to check for duplicated accounts in the statement Print Account If you want the report to list account numbers that numbers that are appear in the statement more than once select the box duplicated or enter Y in text mode if not clear the box or enter N in text mode Print Account If you want the report to list account numbers that are numbers that are missing from the statement but are within the excluded verification criteria you entered select the box or enter Y in text mode if not clear the box or enter N in text mode Print Account If you want the report to list credit balance accounts numbers that use for which the Reverse Sign to Print flag is not se
105. arter to date QTD statements use 3 periods If you use a quarterly system that is each of the 13 periods equals one week in the quarter print a current YTD report to get QTD information Contents Use the Statement Contents function to control the rows of the report and to determine which accounts to include The General Ledger application contains the following sample statement contents Content ID Description BAL1 Detailed Balance Sheet BAL2 Summary Balance Sheet General Ledger 3 17 CHAPTER 3 Setup Setup Functions 3 18 Content ID Description INC1 Detailed Income Statement INC2 Summary Income Statement RAT1 Ratio Analysis Detailed statements show the individual accounts Summary statements show only the major account categories current assets current liabilities and so on Print the sample statements to find which ones you can use You can produce both summary and detailed versions of each balance sheet and income statement by producing each layout ID with both content IDs When selecting layouts to use set up the contents so that they use the appropriate account numbers To print consolidated statements for more than one company you may want to set up additional statement contents for that purpose To use the ratio analysis content RAT1 set up a special memo account in the chart of accounts to hold the number of shares of stock outstanding Then modify the content of RAT1 to identify the memo account
106. ast year s actual next year s budget forecast this year s actual or this year s budgeted This information comes from the GLMAxxx file This report is useful when you want to produce an audit trail e The statements which you define in the Statement Layout and Statement Contents functions provide account information for the specified ranges of time companies divisions departments and subaccounts This information comes from the GLSCF and GLSLF files You can consolidate information about 20 companies in any statement e The Cash Flow Statement function provides information about the sources and uses of cash in the specified ranges of time companies divisions departments and subaccounts This information comes from the GLMAxxx file You can consolidate information about 20 companies in the Cash Flow Statement Periodic Work When your files get large you can clear some data from the files using the functions on the Periodic Processing menu Use the Remove Prior Year Files function to remove files associated with the specified year Removing files from past years when they are no longer required can free up valuable disk space At the end of a year use the Create Last Year Data function to create last year GLMAxxx and GLJRxxx files and prepare the current files for the new year When you create last year files the GLMAxxx and GLJRxxx files are automatically assigned the extension Ynn where nn is the two digit year T
107. available when there is more than one page of entries Press F to choose a new field ID this abandons any field changes you entered but have not yet saved Continue entering old values and new values until you have specified all of the values you want to change in the Values section The files that contain the Field ID you selected appear in the File Description section You should change IDs in all of the files as a general rule Exclude files from the change process only when your reseller or support representative instructs you to so 9 10 11 The Time field gives you an idea of the relative time it takes to change the field in a given file Files where this code or ID are a part of the key to the file can be changed more quickly than files where each record in the file must be scanned for the code or ID Each file is rated as Short or Long to denote the estimated time required to change the field The Tag field denotes whether the file is affected by the copy process Tag the file to change fields in the file Select a command Press S to switch to the Values section of the screen Press Enter to toggle a file as included or excluded from the copy process Press A to tag all of the files Press N to untag all of the files 8 51 CHAPTER 8 File Maintenance Change Fields e Press B to begin the change field process e Press H to return to the header section to change the selection you made for printing th
108. balance of the entries is zero If you are writing transactions to the journal in an out of balance situation you can enter the forced balance password Incorrect Entries If you save an incorrect transaction use the Edit Transactions function page 5 27 to correct the problem or enter a reversing transaction and then enter the transaction correctly Each time you enter journal transactions for a company print the GL Journal page 5 19 for that period so that you have an audit trail of the transactions If there are no next year files reversing entries are made in period 99 If reversing entries are out of balance the forced balance password is required even if transactions are in overall balance The system defaults to R1 if R1 is out of balance and a warning appears when you enter or leave transactions 5 10 General Ledger Transactions Journal Transactions e CHAPTER 5 Unwritten Transactions Report 08 19 2007 Builders Supply 10 55 AM Unvritten Transactions Report Company H GL Account Description Cflow Ref i Credit Alloc 08 19 2007 201000 Gas amp Oil Expense GAS OIL 08 19 2007 101000 Gas amp Oil Expense GAS OIL 08 19 2007 100500 Conference Materials TRAVEL 08 19 2007 100100 Materials TRAVEL ENDING BALANCE PERIOD 08 BALANCE End of Report General Ledger 5 11 Import Transactions o MM Use the Import Transactions function to import a text file directly into General Ledger transactions
109. box or enter N in text mode When you save the batch statement the cursor returns to the Batch ID field Press Enter to add another sequence number to the same batch ID enter the next batch ID you want to work with or exit to the Batch Statements selection screen After You Enter Batch Statements After you have entered a batch statements record select the Pretest Batch Statements option on the Batch Statements selection screen to test the record so that you do not run into problems when you print the group of statements See Pretest Batch Statements on page 9 42 for more information General Ledger 9 39 CHAPTER 9 Statement Maintenance Batch Statements Copy Batch Statements Use the Copy Batch Statements option to copy one batch statements record to another or to rename a batch statements record When you select Copy Batch Statements from the Batch Statements selection screen the Copy Batch Statements screen appears fi 2007 Copy Batch Statements ES Commands Edit Modes Other Help 2xame mo l e ee OK Abandon From Batch Statement ID BATCH To Batch Statement ID BATCH2 on Company H 11 19 2007 Terminal TODO OVR Inquiry 1 Enter the batch statement ID you want to copy 2 Using only numbers and capital letters enter an ID for the new batch If an existing batch statements record has the ID you enter that record is replaced by the new copy do not enter the ID of
110. bs at the top of the screen their menus and functions appear in a navigation pane on the left side of the screen and function screens appear in the large pane on the right Using this menu you can open more than one function screen at a time and move or minimize screens as needed However you cannot open two functions that lock the same data file at the same time N OPEN SYSTEMS R Accounting Software ee File Views Tools Other User Window Help O Ae mE Company H Builders Supply OSAS Date 12 29 2010 User ID scottm ns Commands Edit Modes Other Scroll Commands Information Help Information Inquiry Daily Work 2xe ke mn 2 00 Ok Inventory Transactions Location Transfers Transaction Journal Transfers Journal 55 TX0001 6 0000 PKG 4 Post Transactions Adjustment 250 IMN0001 15 0000CS 12 14 2010 d GL Adjustments Journal Adjustment 250 TX0001 32 0000CS 12 14 2010 2 4 2 Type Item Loc ID Quantity Units Date Stat 32 Post GL Adjustments Reorder Processing Purchase 350 CA0001 2 0000EA 12 14 2010 Reports Analysis Reports Adjustment 700100 IMN0002 170 0000EA 12 14 2010 de Productivity Rpts Inventory da Productivity Rpts Lot Serial La Periodic Processing Physical Inventory File Maintenance Code Maintenance Master File Lists de Master Codes List oag EEE Line No 000001 of 000005
111. can determine the version by looking at the copyrights screen when you start OSAS or in most versions by using the Application Information tool button on the menu screen in graphical mode or by pressing Shift F2 in text mode If data files already exist for General Ledger in the intended destination path the GL data files exist Do you want this task to erase them prompt appears If you want to erase the existing files and convert the files from the version in the source path select Yes or enter Y in text mode if not select No or enter N in text mode If you elect not to erase existing files you must change your directory choices so that no conflict exists To convert use the Proceed OK command The Do you want a printout of error log after each application prompt appears If you want the error log to be produced after files are converted for each application select Yes or enter Y in text mode if you want the log to be produced after files for all applications are converted select No or enter N in text mode If you are converting only General Ledger files your answer to this prompt makes no difference Answer the questions that appear relating to the conversion of the employee history and last year files If a problem occurs and you indicated that you want the system to pause when a problem occurs a prompt alerts you To stop the conversion process select Yes or enter Y in text mode To let the conversion run its cours
112. ccount mask is different from the mask that is set up for the statement content You can use the statement content for the company if you reassign the account mask in the statement content to the companies for which you are printing the statement Company xxx is not on file The company you entered is not set up Content and layout have no company specific entries for consolidation A company must be specified before printing No ID was specified in the content or layout that is being used The companies you are printing the consolidated statement for are not the ones assigned to the statement content layout Enter the company IDs set up in the content layout or leave the Company ID field blank Content ID xxxx is not on file The statement content ID is not on file Enter a different ID or use the Inquiry F2 command to look up and select an ID from the list that appears Enter for print time substitutions If you want to identify the company when you print the statement enter a question mark If you want to assign specific companies up to ten enter each company ID A 4 General Ledger System Messages APPENDIX A General Ledger data files are not set up for company xxx You have not created General Ledger data files for the specified company so you cannot copy accounts to or from it Invalid entry Destination balances cannot be the same as source balances When you copy account balances you cannot enter the sam
113. combinations in brackets lt gt To use a command click the command name or press the hot key combination Refer to the Resource Manager User s Guide for more information on the menus available in OSAS and their commands OSAS gives you quick access to commands relating to the screen you re using via a shortcut menu The commands that are available depend on the function and the field you are currently using To use these commands click the right mouse button and select the command from the menu that appears On the main menu the shortcut menu gives you access to commands that help you manage your Favorites menu switch between sample and live data perform certain setup tasks and view function information On function screens this menu helps you access help documentation move around the function screen work with EIS dashboards and so on The Other Commands or F4 menu is available on both graphical and text menu and function screens and gives you access to additional utilities and commands not directly related to the function you re currently using Among other things these commands open calculators or allow you to view or enter additional information In text mode press F4 twice on the menu or once on function screens to access this menu Consult Appendix A in the Resource Manager User s Guide for more information on the commands available on the Other Commands menu The Information or Shift F2 menu is available in some gra
114. contents of your statements account types balances what each statement line does and so forth The GLCFC Cash Flow Contents file stores specifications for the Cash Flow Statement The specifications include account types balances what each statement line does and so forth File Interaction The General Ledger system tracks accounts you can use throughout the OSAS product line When you enter and post transactions in this application or interfaced applications account information is retained in or distributed to the appropriate files to keep the information up to date make the information available through reports and keep the system in balance Journal Transactions You can enter transactions in one of these ways General Ledger 1 7 CHAPTER 1 Introduction The General Ledger System 1 8 e You can enter transactions through an application that General Ledger interfaces with When you post the information is copied from the appropriate file in the interfaced application to the GLJRxxx file Which information gets copied depends on the interfaced application see its user s manual for more information You can enter transactions through the Transactions function Reserve this function for transactions not handled by an interfaced application For example if you use Accounts Receivable to track sales be wary when you enter journal transactions that pertain to revenue collected that information may have been entered
115. count enter O in the Step field Consolidation Steps 7 22 Take these steps to consolidate GLMAxxx files 1 Use the GL Accounts function page 8 15 to verify that the branch company s accounts are set up to consolidate with the main company s accounts 2 Back up the data files on all computers see the Resource Manager User s Guide General Ledger Consolidate Master Files Periodic Processing CHAPTER 7 3 Copy each branch company s GLMAxxx file to a different diskette Then copy each one to the hard disk directory with the main company s GLMAxxx file You must rename the GLMAxxx files that have the same company ID as the one on the computer you are copying the files to so that they will not overwrite the existing file For example if the GLMAxxx files for branch offices 1 and 2 are on a diskette and the main GLMAxxx file is on hard disk drive C the DOS commands to copy the branch GLMAxxx files without renaming them are C gt copy a glma1 c osas data C gt copy a glma2 c osas data The DOS commands to copy and rename the branch GLMAxxx files are C gt copy a glma1 c osas data bran1 C gt copy a glma2 c osas data bran2 4 Use the Consolidate Master Files function to consolidate the branch GLMAxxx files with the main GLMAxxx file 5 Print the consolidated financial statements see page 6 9 6 Restore the main GLMAxxx file from the backup and resume normal Operation General Ledger 7 23
116. count into the main account number If you are printing consolidated statements select the box or enter Y in text mode to print each company on a separate line Clear the box or enter N in text mode to summarize the information for all segments of an account into the main account number If your account is made up of only a main account or if you entered a batch ID above this field is skipped If your account mask is divided into segments or if you did not enter a batch ID enter the order in which you want account segments to be organized For example if you are using all the account segments and you want the account numbers to be arranged by division then by department and then by subaccount enter 123 If you want the statement to include accounts with zero balances select the box or enter Y in text mode if not clear the box or enter N in text mode If you want the statement to include the workstation date and time select the box or enter Y in text mode if not clear the box or enter N in text mode General Ledger Statements Field Statement Titles 1 4 Change Footers Reports CHAPTER 6 Description Press Enter to use the current title from the statement layout or enter a title for the statement Changes you make here do not change the layout permanently If you entered more than one company ID you might want to use these fields to list the companies that are consolidated in the statemen
117. count number segments those fields are skipped General Ledger 8 45 CHAPTER 8 File Maintenance Copy Account Balances 8 46 Select the source of the account balances you want to copy e Actual balances e Current year budget Last year balances e Forecast balances e Next year budget Select the destination of account balances you want to copy e Current year budget e Forecast balances e Next year budget Enter the percentage by which to increase the balances Use the Proceed OK command to begin copying balances When the balances are copied the File Maintenance menu appears General Ledger Assign Account Types MM Use the Assign Account Types function to assign an account type to a range of account numbers Assign Account Types Screen Select Assign Account Types from the File Maintenance menu The Assign Account Types screen appears A 2007 Assign Account Types cisz Commands Edit Modes Other Help 2zxe ee ma ejee OK _ Abandon Pick GLAccount From 100000 la Thru 100500 la Account Type 010 s Note This function may also change the Debit Credit flag for the accounts you specify in addition to the account type Print the chart of accounts before and after using this function to assure the changes you made are correct Company H 11 9 2007 Terminal TODO OVR 1 Enter the range of accounts to which you want to assign account types Inquiry 2 Enter th
118. counts and account segments to use e add balances and print the totals e print lines of text e underline and shift columns of figures Generally each line of the statement contents represents a row on the statement The rows are printed in the order of the sequence numbers in the first column General Ledger 9 21 CHAPTER 9 Statement Maintenance Statement Contents Planning and Examples 9 22 Enter statement contents one line at a time Before you begin read the rest of this section to get an idea of what can be done Then write down all the lines of your statement content before you modify existing statement contents or create new ones If you plan to create statements with side by side formats follow these directions e Specify the company ID in the Use Acct Mask for Company field to assign an account mask to your statement content e Skip the Company field Do not define the company in the content it is selected through the statement layout e Use the wildcard character for all account segments except the main account segment when specifying beginning and ending account numbers General Ledger contains the following sample statement contents Content ID Description BAL1 Detailed Balance Sheets BAL2 Summary Balance Sheets INC1 Detailed Income Statements INC2 Summary Income Statements RAT1 Ratio Analysis Detailed statements show the individual accounts Summary statements show only the major account categ
119. ct the sort configuration you want to use for the journal If you created user defined sorts through the Account Mask function they appear at the bottom of the screen Select the transactions posted or unposted you want to list in the journal Enter P if you want to print the post date or T if you want to print the transaction date Enter the title you want on the journal four lines of 30 characters each Use the numbers above the fields to help center the text The system does not use different heading lines for previous year and current year files If you created previous year files and you frequently switch between the previous year and current year files check the heading lines to make sure that the displayed information is correct Before you go on make sure that no one else is using the GLJRxxx file Select the output device See Reports on page 1 29 for more information on output devices After the GL Journal is produced the Journal Transactions menu appears General Ledger GL Journal Journal Transactions e CHAPTER 5 Balances and Offsetting Accounts If you elect to list a range of accounts the debit and credit balances might not balance because not all offsetting transactions will be listed You must list all accounts to verify that the transactions are in balance Posting From Other Applications If other OSAS applications interface with General Ledger check the posting totals report produced by the othe
120. ction Because tables are also converted when you convert data files any changes made including those in Options and Interfaces since the initial set up may be lost Check table settings and verify your options and interfaces selections after converting all companies If you need to reconvert a company either reset your options after conversion or back up the xxTB files before converting Before you convert an application s files back up your data files General Ledger 2 3 CHAPTER 2 Installation and Conversion Conversion Consider Your Setup Before you try to convert from your version of General Ledger consider the exact setup of your system Since OSAS code can be customized modifications to your system might be lost if you install a new version of a program or update a file If you are not sure if your system is ready for conversion consult your value added reseller Follow these guidelines to convert your files to version 7 6 Converting from Versions 4 6x and Earlier 2 4 The account numbers may have to change to be brought into compliance with the account mask During conversion the system makes a suggestion for the new account number which you can accept or edit The GLCGxxx file is created to record these changes and other applications access this file to change their own account numbers Account types from versions 4 11 through 4 6x are converted as follows e Balance sheet accounts have an account type of 08
121. ction to set up groups of recurring entries Use the Copy Recurring Entries function to copy the recurring entries to the GtttxxxW Transaction Work where ttt is the terminal ID file or directly to the GLJRxxx Journal file You can select this option in the Resource Manager Options and Interfaces function If General Ledger interfaces with other OPEN SYSTEMS Accounting Software applications some recurring entries may be better tracked through those applications For example you can use Accounts Payable to print monthly rent checks and create the proper GL entry Debits and Credits Each recurring entry must consist of at least one debit and one credit transaction and the total debits must equal the total credits before you can exit from this function or change the Run Code fields Last Year Files The current year and the last year files access the same GLRExxx Recurring Entries file Changes made to recurring entries while working with last year files also affect current year files and changes made to recurring entries while working with current year files also affect last year files General Ledger 8 35 CHAPTER 8 File Maintenance Recurring Entries Screen 8 36 Select Recurring Entries from the File Maintenance menu This screen appears TIE 2007 Recurring Entries lec ae Commands Edit
122. ctions you need To add a function to the Favorites menu select the function you want to add and press F10 Press F2 to switch to the Favorites menu to confirm that your selection was added To remove a function from the menu select the function on the Favorites menu that you want to remove and press F10 again Toolbars As with menus graphical screens also contain toolbars that give you fast access to the most frequently used OSAS commands The toolbar for the main menu differs slightly from that of function screens General Ledger Navigating OSAS Introduction CHAPTER 1 Main Menu The toolbar for the main menu is shown below Click a button to access that Toolbar command Workstation Command Calendar Toggle Date Help Favorites N ow 78 SC ON Application Calculator Call a BBj Pro5 Versions Program Function The toolbar for function screens is shown below Click a button to access that Screen command Toolbar File Start Paste Calendar Online Maintenance Over Documentation Rx BR MH amp al Delete Copy Calculator Field Address Help Mapping Date Fields If you use BBj in graphical mode click the Calendar button when it appears next to date fields to open a calendar so that you can select the date you want to enter into that field General Ledger 1 21 CHAPTER 1 Introduction Navigating OSAS 1 22 Browse If you use BBj in graphical mode you can use the Browse button when it appea
123. d A 6 General Ledger System Messages APPENDIX A Percentages do not equal 100 00 The allocation percentages must equal 100 before you can save the record Period 13 is not defined in the Period Conversion table You cannot print the statement for period 13 because period 13 was not set upin the Period Setup function in Resource Manager Recurring entries are out of balance The total credits do not equal the total debits for the specified run code Make sure that you did not use the same reference for the debit and credit portions of the same entry Report is too wide You must increase the 123 Cell No in Workstation Defaults The definition of the statement layout you are trying to print to a worksheet WKS file is too wide for the workstation default Use the Defaults function on the Resource Manager Workstation Configuration menu to increase the value in the 123 Cell No field see the Resource Manager User s Guide Source code must be Mx R1 or RE The source code of the entry must be Mx R1 or RE Statement is too wide for the printer or file The statement you are trying to produce is too wide for your printer or it is too wide to save to a file The Account Mask is missing for this company You cannot use the GL Accounts or the Account Budgets functions until you define the account mask for the company The value must be between 1 and n You must enter a value within the range shown in the message General Led
124. defined codes used to group accounts together and to create financial reports such as the Cash Flow Statement Account types are stored in the GLAT file Each account type has an account class and code associated with it The class is the general category the type fits into long term asset current asset cash and so on Within each class are accounts such as cash on hand and accounts receivable Several account types are described as other To accommodate special needs they can be included when you set up the Cash Flow Statement General Ledger 8 13 CHAPTER 8 File Maintenance Account Types Screen Account Types Select Account Types from the File Maintenance menu This screen appears r A Account Types oja Commands Edit Modes Other Scroll Commands Help 2xt malmal lee Ok Type Description Account Class Code 5 Cash On Hand Current Assets D E 010 Cash On Deposit Current Assets D l2 020 Accounts Receivable Current Assets D fa 025 Allowance for Bad Debts Current Assets c 1030 Employee Receivables Current Assets D 035 Other Receivables Current Assets D 040 Notes Receivable Current Assets D 045 Raw Materials and Supplies Current Assets D 050 Work in Process Current Assets D 055 Finished Goods Inventory Current Assets D 060 Prepaid Expenses Current Assets D 065 Marketable Securities Current Assets D 070 Other Current Assets D 075 Other C
125. dgets or transactions from a file created by another system into General Ledger This format tells the OSAS system where information is located in the file whether default values should be used when null or empty fields are encountered and how to place the imported data into General Ledger tables You then use the formats you create here when you use the Import Budgets and Import Transactions function To use the Import Definition function select Import Definition from the File Maintenance menu The Import Definition screen appears To create a transaction or budget import definition follow the instructions below General Ledger 8 55 CHAPTER 8 File Maintenance Import Definition Import Definition Screen 8 56 Select Import Definitions from the File Maintenance menu The Import Definitions screen appears Import Definition lo al Commands Edit Modes Other Scroll Commands Help 2xt malmal e OK Layout ID GLimport 4 Description GL Import Import Type GL Transactions File Type Comma Delimited Record Length 0 File Name Field Name Type Field Start Length Default Force Translate CA TO B Amount Number 0 0 0 A 7 2 CashFlow Transaction Text 0 0 0 a a a Debit Credit Flag Text 0 0 0 E Description Text ol 0 0 GL Account Text do d 0 GL Period Number do d 0 Reference Text o 0 0 Sourc
126. dule before you begin day to day operations You can lose files because of disk drive problems power surges and outages and other unforeseen circumstances Protect yourself against such an expensive crisis by planning and sticking to a backup schedule Backing up Data Files Back up your General Ledger data files whenever they change every day or every week and before you run these functions e Account Mask e Post to Master e Create Last Year Data e Clear and Close Last Year e Update Current Year Month End Maintenance e Consolidate Master Files Use the Backup function on the Resource Manager Data File Maintenance menu to back up files General Ledger Setup Functions Setup CHAPTER 3 You must back up all the files in the data path for a particular list of companies at once to ensure that you have up to date copies of the system files Do not try to use operating system commands to back up only a few files that have been changed if you do your system may not work after you restore them The Backup function backs up all the data files for a specified company in a data path at one time Backing up Programs Once a month or so back up your programs Even though these files do not change backup media can be damaged or deteriorate so it pays to have a fresh copy in storage in case you need it Media We recommend keeping one or more sets of backup media in case one set is bad or damaged Rotate the sets of backup m
127. e You cannot use this function in period 1 The Chg and Chg functions use the balance of the previous period to calculate the balance of the next period After you select the function enter the appropriate dollar amount or percentage Enter a positive value to increase budgets or a negative value to decrease them The balances for the current period and the remaining periods of the column are adjusted accordingly that 1s all the periods from the cursor position down are affected The ending actual budget last year and forecast figures appear Use the Proceed OK command to use the command buttons at the bottom of the screen to view further accounts Use the commands to work with the information on the screen e Press F to view the first account budget in the list of accounts General Ledger 8 23 CHAPTER 8 File Maintenance Account Budgets e Press L to view the last account budget in the list of accounts e Press N to view the next account budget in the list of accounts e Press P to view the previous account budget in the list of accounts e Press E to edit the currently highlighted account e Press A to return to the header and enter a new account to view When you finish adjusting account budgets use the Exit F7 command to return to the File Maintenance menu 8 24 General Ledger Budget Import o MM Use the Budget Import function to import data from a file directly into General Ledger budgets
128. e Description field the text you enter is indented from the left margin by the number of spaces you specify in the Desc Tab field The balances and sums stored in any or all of the nine Totals fields see the Totals 1 9 field below print on the statement To print the amounts that are in a total column enter Tn n is the total column 1 9 For example enter T1 to print the amounts in the Total 1 column Text that you enter in the Description field prints in the Description column To print the result of a formula in a formula column enter the first total in the formula that is where the answer is stored For example to print the result of the formula T8B T9B enter T8 Enter UD to print a double underline Enter US to print a single underline 9 27 CHAPTER 9 Statement Maintenance Statement Contents Field Description Print Row If you want to print the accounts or headings specified on the line select the box or enter Y in text mode if not clear the box or enter N in text mode You might not want to print a line for example if you were using it to store a total used in a calculation that appears somewhere else Inquiry Company You usually specify the company in the statement layout or when you print statements so that you can use the same statement content to print statements for several companies Leave this field blank to specify the company ID at print time If you always want to use a partic
129. e GL Accounts After you have set up accounts do not change the actual balances If you do you will put the ledger out of balance without leaving an audit trail Instead enter and post journal transactions to make the necessary changes Use the Proceed OK command to save your entries The cursor returns to the Account field Enter the next account you want to work with or use the Exit F7 command to return to the File Maintenance menu Making Corrections If you approve an account with incorrect information enter the company ID and account number then enter the record Do not change actual or last year balances If you enter an incorrect account number reenter the account under the correct number Then delete the old account If you change an account type a debit credit switch or actual or last year figures the system creates an audit log that you must print 8 20 General Ledger Account Budgets o M Use the Account Budgets function to enter and adjust budget and forecast balances for a company s accounts You can adjust budget balances manually or by using one of the special functions Account Budgets Screen Select Account Budgets from the File Maintenance menu This screen appears EN 2010 Account Budgets tol o Es Commands Edit Modes Other Help xalmelmo e ee OK Abandon Account 101 4 Account Type 020 Accounts Receivable Description ACCOUNTS RECEIVABLE DB CR or Memo Debit Manual Entry Alt
130. e Text ol 0 0 Transaction Date Date 0 0 B Transaction Day Number 0 0 B Line No 000001 of 000013 Enter edit LayoutID Delete layout Go to Company H 08 19 2010 Terminal T000 OVR Enter or select an ID in the Layout ID field to identify the layout definition you want to work with Enter or edit the Description of the import definition Select GL Transactions or GL Budgets in the Import Type field Select Comma Delimited Quote Comma Delimited or Fixed Field Width in the File Type field Enter or edit the Record Length only available for fixed field width file types General Ledger Import Definition File Maintenance CHAPTER 8 6 Enter or browse to the File Name if editing an imported definition Scroll to the field you would like to edit Use the following commands to edit the import definition fields e Press Enter to use the Edit Field Information dialog box to edit the field e Press L to choose a different Layout ID e Press Dto delete the current layout e Press Gto go to a specific field e Press F7 when finished editing the import definition to return to the File Maintenance menu General Ledger 8 57 CHAPTER 9 Statement Layout 9 1 Statement Contents 9 21 Batch Statements 9 35 Cash Flow Contents 9 45 Financial Statement Verification 9 49 General Ledger Statement Maintenance Statement Layout Use the Statement Layout function in conjunction with the Statement Conte
131. e account type you want assigned to this range General Ledger 8 47 CHAPTER 8 File Maintenance Assign Account Types 8 48 When you assign an account type to a range of account numbers the code for the default balance type is also assigned to the range If an account s balance type is changed when you use this function the activity amount for that account is multiplied by 1 For example if you assign an account type with a debit code to a range of account numbers that includes an account with a credit balance the activity amount for that account is multiplied by 1 to produce a debit activity amount Instead of including the account in the range when you use the Assign Account Types function use the GL Accounts function see page 7 15 to edit the account When you are editing the account type in the GL Accounts function you can override the default code for the balance type After you use the Proceed OK command to assign account types the File Maintenance menu appears General Ledger Change Fields MM Use the Change Fields function on the File Maintenance menu to change any code used from one value to another The Change Fields function can change codes within this application as well as in other applications To produce a list of fields changed use the Print Log feature A sample of the log is page 8 53 When you select Change Fields from the File Maintenance menu the Change Fields screen appears
132. e and investigate later select No or enter N in text mode General Ledger Conversion Installation and Conversion CHAPTER 2 12 When the process is finished the files are converted Select the output device for the error log After conversion is finished and the error log is produced the main menu with General Ledger added appears General Ledger 2 7 CHAPTER 3 Setup Considerations Setup Checklist Setup Functions General Ledger 3 1 3 5 3 7 Setup Setup Considerations After you have installed the software for the first time or after you have upgraded the software you must set up the system Follow the setup procedures carefully the choices you make determine how the system operates Codes and IDs When you set up the system you assign codes and IDs to tell the system how to identify each item on file The system uses these identifiers to organize the information in reports and inquiry windows The system arranges code characters in a particular order In the following list codes and IDs are sorted from lowest to highest and dashes represent spaces ent 0 Dia 1 A Z a Se 01 Sy 000000 000001 1 3 1 CHAPTER 3 Setup 3 2 The organization of these codes illustrates the following principles e The system reads codes from left to right until it finds something other than a blank space e Items that make up a code are always listed alphabetically The items are l
133. e balance type at both the Copy Account Balances In and the Copy Account Balances To fields Invalid entry The Department overlaps the Division The starting position and length of the department segment makes it overlap the division segment you defined Change the starting position or length of the department segment or the division segment Invalid entry The Department overlaps the Main Account Number The starting position and length of the department segment makes it overlap the main account number segment you defined Change the starting position or length of the department segment or the main account number segment Invalid entry The Division overlaps the Main Account number The starting position and length of the division segment makes it overlap the main account number segment you defined Change the starting position or length of the division segment or the main account number segment Invalid entry The Subaccount overlaps the Department The starting position and length of the subaccount segment makes it overlap the department segment you defined Change the starting position or length of the subaccount segment or the department segment Invalid entry The Subaccount overlaps the Division The starting position and length of the subaccount segment makes it overlap the division segment you defined Change the starting position or length of the subaccount segment or the division segment General Ledger A 5 APPENDIX A System M
134. e format is updated as you enter the segment positions and lengths General Ledger Account Mask General Ledger File Maintenance CHAPTER 8 Use the Proceed OK command to save the format Use the up arrow key to change an account mask If you change an account mask this message appears Warning Mask has changed existing accounts may be in error If you want to change your account masks you must do so before you convert your files If you do not your other application masks will not match In addition make sure that transactions have been written to the GL Journal before using this function Before the system begins changing the masks this prompt appears Do you want to let the system adjust the new accounts automatically If you select Yes or enter Y in text mode the system begins changing masks prompting you only if it encounters a conflict between two account numbers If you select No or enter N in text mode the system changes the masks one at a time each time waiting for you to approve the change to the mask If you change the mask the system removes the sort keys from files You cannot change the mask and sort keys at the same time Changing the mask updates General Ledger files but not statement contents or transaction work files and it does not affect files from other applications If you have already entered the company s chart of accounts the accounts might not be in the correct format so they will no
135. e log e Press Gto go to a particular entry This option is only available when there is more than one page of entries e Press F to choose a new field ID this abandons any field changes you entered but have not yet saved 12 When you have tagged the files you want to change press B to begin the change process When the changes are complete the log prints if you elected to produce it 13 Enter a new Field ID to change or use the Exit F7 command to return to the File Maintenance menu 8 52 General Ledger Change Fields File Maintenance CHAPTER 8 Change Fields Log 08 19 2007 Builders Supply Page 3 9 50 AM Change Field Log File Name Records Read Records Converted Original Total Record New Total Records GLREH 6 o 6 6 GLSCF 315 o 322 322 GLSCF 315 0 322 322 INCTH o o o 0 INGLH Z o Z 2 INGLH 2 0 2 2 INGLH 2 o zZ 2 INGLH 2 0 2 2 INGLH E 0 2 2 INGLH 2 o 2 2 INGLH 2 o 2 2 INGLH 2 0 2 2 INGLH 2 o zZ 2 INRQH 0 0 o o INTRH 0 0 0 0 PADDH 11 o 11 11 PADPH 2 o 97 97 PAECH 2 0 11 pan PAWIH zZ o 11 11 PAWIH 11 o 11 11 POORH 1 0 24 24 POPQH 54 0 54 54 SOKHH 186 o 186 186 SOKTH 18 0 18 18 SORLH 20 o 20 20 SORLH 20 o 20 z0 SORLH 20 0 20 zo SOTDH 39 o 39 39 SOTDH 39 0 39 39 SOTDH 39 o 39 39 JOBSH Zz 0 25 25 Field ID GL ACCOUNT Original Value New Value 100100 100001 200100 200001 General Ledger 8 53 Import Definition o MM Use the Import Definition function to create a format for importing bu
136. e printing the statement for is inserted The table below details the available print time inserts Insert PBDN PBDW Pbdw PBDM Pbdm PEDN PEDW Pedw PEDM Pedm PERN COID CONA SCID Prints Period Beginning Date Numbers Period Beginning Date Words Period Beginning Date Words Period Beginning Date Military Period Beginning Date Military Period Ending Date Numbers Period Ending Date Words Period Ending Date Words Period Ending Date Military Period Ending Date Military Period Number Company ID Company Name Statement Content ID Example 11 01 00 NOV 1 2000 Nov 1 2000 1 NOV 2000 1 Nov 2000 11 30 00 NOV 30 2000 Nov 30 2000 30 NOV 2000 30 Nov 2000 11 H Builders Supply BALI General Ledger Statement Maintenance CHAPTER 9 Copy Statement Layout Screen General Ledger Use the Copy Statement Layout option to modify an existing statement layout You may find it easier to copy a layout than to create one from scratch When you select Copy Statement Layout from the Statement Layout selection screen the Copy Statement Layout screen appears A 2007 Copy Statement Layout le Commands Edit Modes Other Help 2xt malma l ee OK Abandon From Statement Layout ID BALA a To Statement Layout ID BALH a Company H 11 9 2007 Terminal TODO OVR 1 Enter the ID of the statement layout you want to copy 2 Enter an
137. e run with nnnn files only appears where nnnn is the current General Ledger fiscal year 1 Enter the number of the clearing step you want to perform 2 Press Enter if you want to clear the journal entries to period 13 the one you are probably using for your fiscal year end entries or enter a different period If there are unposted transactions in the prior year GLURxxx Ynn file the following prompt appears Warning There are unposted transactions Do you want to continue Either continue with the Clear and Close Last Year function or exit and then post the unposted transactions 7 13 CHAPTER 7 Periodic Processing Clear and Close Last Year Make sure that no one else is using the GLURxxx file Then use the Proceed OK command to begin clearing and closing the accounts in this step After Each Step When you finish each step follow this procedure 1 Print the GL Journal page 5 19 and the GL Activity Report page 5 23 for period 13 source code CL Make sure that all the closing entries are there If entries are missing check the account record the account may not be set up to clear and close When everything is correct save the two reports as part of the audit trail 2 Post the journal to the GLMAxxx file page 5 31 for the company whose accounts you cleared and closed using period 13 Posting updates the account balances with the transactions just entered 3 Print an Audit Trial Balance page 6 7 and ma
138. e the situations in which this could happen e The current period is 13 and the As Of When field in the statement layout specifies Previous Quarter Because period 13 is not part of a quarter the system does not know what the previous quarter is e The current period is 13 and the How Far Back field in the statement layout specifies Quarter To Date Because period 13 is not part of a quarter there cannot be any quarter to date information for period 13 e The current period is 1 the As Of When field in the statement layout specifies Previous Period and the What Is In The Column field specifies Not Actual This situation asks for budget and last year balances for the previous year which the system no longer has available General Ledger A 3 APPENDIX A System Messages e The current period is 1 2 or 3 the As Of When field in the statement layout specifies Previous Quarter and the What Is In The Column field specifies Not Actual Again this situation asks for budget and last year balances for the previous year which the system no longer has available Use a different statement layout ID for printing the statement Chart of Accounts for company xxx not found The GLMAxxx Master file does not exist for the company that is shown in the message You cannot print statements for the company until you have set up its chart of accounts Company xxx Account Mask is not compatible with Content xxxx Account Mask The company s a
139. e to the capital and subtract the dividends since dividends paid is a debit account General Ledger B 5 APPENDIX B Common Questions Closing Why didn t the income statements clear when I ran the Clear and Close Last Year function You have to use the GL Accounts function page 8 15 to enter the clearing account and step for every revenue and expense account before you run the Clear and Close Last Year function Why were the transaction entry numbers not reset when I closed the books When you used the Create Last Year Data function you did not elect to reset the current year journal entry numbers to one Can update the current year account balances with last year s adjusting entries without clearing and closing You can update the current year account balances only by using the Update Current Year function see page 7 15 Accounts How do I close a single account to another one Can I use the Clear and Close Last Year function Use the Clear and Close Last Year function only when you are ready to close the books at the end of the year To close a single account to another account enter a transaction that offsets the balance and enter the offsetting transaction to the account to which you want to close it Can change an account number You can change an account number using the Change Fields function page 8 49 on the File Maintenance menu have a new company that uses the same chart of accounts as a co
140. ead of ACE 1 and ACE 11 or ACE 01 e Ifyou use letters in IDs use either all uppercase or all lowercase letters so that the IDs can be sorted correctly General Ledger General Ledger Setup CHAPTER 3 Use descriptive IDs For example WIN001 and WIN002 are more descriptive IDs than 000001 and 000002 If you already use a numbered system you might want to stick with it If you want to sort items by a particular attribute name or group put the attribute in the ID For example use the first two characters of a recurring entry reference ID to indicate the division or department the entry is for To ensure that you can insert new items into a sequence use a combination of letters and numbers that leaves room in the sequence for later additions For example setting up two consecutive general ledger account IDs of 3001 and 3005 leaves room for three items in between 3 3 Setup Checklist MM Follow the steps in the checklist below to set up your system Each step is explained in this section 1 Set up the options 2 Build the CNVTxxx table 3 Define the account mask 4 Build the GLSExxx Account Segments file 5 Define the account types 6 Build the chart of accounts 7 Build the GLALxxx Allocations file 8 Build the GLRExxx Recurring Entries file 9 Set up the financial statements 10 Enter the initial balances 11 Set up roles 12 Set up a backup schedule General Ledger 3 5 Setup Func
141. ed for your user ID in the Users function in Resource Manager Check the Change Password box to change your password upon logging in You will be prompted to enter and confirm your new password Finally press Enter or click OK to log in This screen appears only after you have set up the system including setting up users See the Resource Manager User s Guide for information on setting up users and roles General Ledger Starting OSAS Roles Introduction e CHAPTER 1 Roles limit use of the system and protect sensitive information Each role allows access to specific applications menus and functions If you cannot select amenu or function your assigned role is not authorized for it Use the Roles function in Resource Manager to set up roles Workstation Date General Ledger To change the workstation date select Workstation date from the File menu click the Change Date button on the toolbar or press F6 gt EN Set Workstation Date ee Commands Edit Modes Other Help 0 Ran Workstation Date 12 28 2007 Fs When the Workstation Date box appears use the button or your keyboard to enter the date and press Enter Navigating OSAS MM OSAS menus and functions are available in two modes graphical and text The graphical mode allows both keyboard and mouse commands and uses data entry fields and buttons similar to those found in any graphical software program The text mode presents informati
142. edger 10 11 Recurring Entries List o MM After you finish setting up the recurring entries list them to make sure that everything is correct and to use as a reference when you copy recurring entries to the GLJRxxx Journal file Print a new list each time you add or change recurring entries Notes on the Recurring Entries List The source code for each entry is RE This code is automatically assigned to all recurring entries Each entry has a unique reference number All entries have the same run code which means that the company has only one group of recurring entries Sample List 12 19 2007 Builders Supply Page 10 33 AM Recurring Entries List Reference Description Source i Credit 10000001 DEPRECIATION FURN amp FIX 153500 10000002 DEPRECIATION FURN amp FIX 521000 10000003 DEPRECIATION AUTOS 154500 10000004 DEPRECIATION AUTOS 521000 10000005 AMORTIZATION GOODWILL 181000 10000006 AMORTIZATION GOODWILL 531000 4 405 77 2 621 07 Y Y Y Y Y Y End of Report General Ledger 10 13 Statement Layout List To make sure that everything in a statement layout is correct produce a hard copy of each new statement layout Sample List 12 13 2007 10 33 AM Statement ID BALA Title Heading Format Heading Format Heading Company Format Heading Company Format General Ledger 1 CONA 2 Builders Supply Statement Layout List 3 BALANCE SHEET WITH BUDGET COMPARISON 4 A
143. edia keeping one set off site General Ledger 3 23 CHAPTER 4 Chart of Accounts Inquiry 4 3 Accounts Inquiry Transaction Inquiry General Ledger 4 5 4 7 Information Inquiry Use the Information Inquiry functions to look up information about your GL accounts Since you cannot change or add information with these functions these functions provide a safe and convenient way to view data without printing reports 4 1 Chart of Accounts Inquiry MM Select Chart of Accounts Inquiry from the Information Inquiry menu The Chart of Accounts Inquiry screen appears hart of Accounts Inquiry Fe ES Commands Edit Modes Other Scroll Commands Help xe ae m 2 8 8 OF Abandon Balance as of Period 12 GL Account Description a ACH Debit Credit CASH IN BANK 1st NATIONAL 4840 66 Ej 100100 CASH IN BANK 2nd NATIONAL 100 00 a 100500 PETTY CASH 200 00 a 101000 ACCOUNTS RECEIVABLE 157620 48 102000 ALLOWANCE FOR BAD DEBT 100 01 104000 INVENTORY RAW MATERIALS 1104883 61 104200 INVENTORY WORK IN PROCESS 1130773 73 104400 INVENTORY FINISHED GOODS 917406 54 105000 PREPAID EXPENSES 00 106000 MARKETABLE SECURITIES 666436 77 151000 LAND 507250 00 152000 MACHINERY amp EQUIPMENT 1569152 36 152500 ACCUM DEPR MACHINERY amp EQUIP 669377 45 amp 153000 OFFICE MACHINES 533179 21 E 153500 ACCUM DEPR OFFICE MACHINES 306685 16 Toggle Values account De
144. een lists all installed applications currently interfaced with general ledger Use the commands to add or remove applications from the audit report e Press Enter to toggle a selected application between Include and Exclude General Ledger 10 25 CHAPTER 10 Master File Lists GL Account Audit Report e Press A to include all applications in the GL account audit report e Press Nto set all applications back to Exclude status e Press D to run the GL account audit report GL Account Audit Report List The GL Account Audit Report List shows tables and data files with invalid or missing GL account numbers 09 26 2007 Builders Supply Page 1 4 08 PM GL Account Audit Report Application Description Interfaced to GL AP Accounts Payable Yes File File Description Record Description Field Name GL Account Reason APPYH Methods of Payment Pymt Method Code CH2 GL Account 400010 Not Found APPYH Methods of Payment Pymt Method Code CHK GL Account 100010 Not Found APVEH Vendors Vendor ID CLEOO1 GL Account Missing APVEH Vendors Vendor ID ELLOO1 GL Account Missing APVEH Vendors Vendor ID JONOO1 GL Account Missing APVEH Vendors Vendor ID TELOO1 GL Account Missing Application Description Interfaced to GL GL General Ledger Yes File File Description Record Description Field Name GL Account Reason GLJRH Journal Entries Unposted Entry 001404 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001406 GL Account 1010 Not Found GLJRH Journa
145. eet 08 19 2007 Builders Supply 12 05 PM BALANCE SHEET WITH BUDGET COMPARISON AS OF AUG 31 2007 DESCRIPTION CURRENT ASSETS CURRENT ASSETS CASH IN BANK lst NATIONAL 311990 90 CASH IN BANK Znd NATIONAL 273 90 PETTY CASH 383 90 ACCOUNTS RECEIVABLE 172285 77 ALLOWANCE FOR BAD DEBT 138 10 INVENTORY RAW MATERIALS 1094790 06 INVENTORY WORK IN PROCESS 1133770 67 INVENTORY FINISHED GOODS 912086 31 MARKETABLE SECURITIES 653091 75 TOTAL CURRENT ASSETS 3654005 56 LONG TEPM ASSETS LAND 507250 00 MACHINERY amp EQUIPMENT 1569152 36 ACCUM DEPR MACHINERY amp EQUIP 630148 64 OFFICE MACHINES 527155 72 ACCUM DEPR OFFICE MACHINES 293484 02 AUTOMOBILES 94358 61 ACCUM DEPR AUTOMOBILES 52417 57 TOTAL LONG TEPM ASSETS 1721866 46 OTHER ASSETS GOODWILL 25000 00 ACCUM AMORTIZATION 6294 64 TOTAL OTHER ASSETS TOTAL ASSETS General Ledger Reports CHAPTER 6 4824 26 00 180 00 12396 40 247 91 1042397 44 1123511 18 920533 47 641371 43 3745466 27 507250 00 1569152 36 631327 62 527155 72 293743 67 94358 61 52677 63 1720167 77 25000 00 6294 64 6 19 CHAPTER 6 Reports Ratio Analysis 08 19 2007 Builders Supply 12 05 PM RATIO ANALYSIS AS OF AUG 31 2007 CURRENT YEAR LIQUIDITY RATIOS CURRENT RATIO QUICK RATIO PROFITABILITY PATIOS NET PROFIT MARCIN RETURN ON ASSETS RETURN ON EQUITY EARNINGS PER SHARE ACTIVITY RATIOS INVENTORY TURNOVER COGS I
146. en General Ledger 9 41 CHAPTER 9 Statement Maintenance Pretest Batch Statements 9 42 Batch Statements Test batch statements records to make sure that the statements will be executed properly The Pretest Batch Statements option simulates the Statements function but instead of producing the statements it produces a Batch Error List 1f problems are found The Batch Error List messages are listed in appendix A When you select Pretest Batch Statements from the Batch Statements selection screen the Pretest Batch Statements screen appears A 2007 Pretest Batch Statements el Commands Edit Modes Other Help 2xaelaelmo e ee OK Abandon Batch ID BATCH Monthly Financials Pick Statement Layout ID A Statement Content ID 4 Period 12 Beginning Date 12012007 El Ending Date 12312007 E Company ID H ation Date and Time Line Statement Titles gt upa Pick Active Financials Division From Thru Department From Thru Subaccount From Thru Segment Sort nge Footers 12345678901234567890123456789012345678901234567890 Alaior isis 2 B Company H 11 19 2007 Terminal T000 OVR Field Description Batch ID Enter the ID of the batch statements record you want to test Pick Statement Nothing appears in these fields because a batch Layout Content ID statements record consists of several combinations of statement layouts and contents P
147. en halves of a report Using Report Pick Screen Criteria You can save the pick criteria from any report screen to make it easier to run reports without redefining the criteria each time The RM option to Use Report Defaults must be set to Yes to use this functionality After you choose to print a report the Save Report Criteria screen appears EN Save Report Criteria flo Es Commands Edit Modes Other Help RX ty Se ma 98 90a OK Abandon Status Bar Save as Personal Report Picks M Save as Global Report Picks Y Description Northeast Region Requisition Report Set as Personal Default Y Set as Global Default Company H 10 20 2010 Terminal T000 OVR General Ledger 1 37 CHAPTER 1 Introduction Reports 1 38 e Check the Save as Personal Report Picks box save the pick criteria for use at a later time on your workstation e Check the Save as Global Report Picks box to save the pick criteria for use by anyone in your organization who has access to this report Enter a Description for these report defaults for identification e Ifyou check the Set as Personal Default box or enter Y in text mode these pick criteria will be automatically applied on the report screen the next time you run the report from the menu e Ifyou check the Set as Global Default box on enter Y in text mode these pick criteria will be automatically applied on the report screen whenever
148. ent to a different content ID and specify that the lines should be resequenced sequence Ol is created and the ID appears in the inquiry window Period End When should I run the Month End Maintenance function GL Journal entries do not have to be cleared at the end of each month If you have the disk space you can keep a fiscal year s worth of entries which lets you make additional entries and adjustments to any period at any time in a fiscal year Run the Month End Maintenance function only if you are so short of disk space that you cannot keep a journal for the whole year In this case back up the GLJRxxx Journal file and then erase the Journal for the periods you no longer need Then use the Resource Manager File Rebuild Verify function to reduce the size of the GLJRxxx file like to see how my capital is growing every period Do I have to close the books to retained earnings every month You should not close the books except at the end of the fiscal year or quarter if your accounting period is one week instead of one month Use the statement content to see the current position of your retained earnings or other capital account in your monthly Balance Sheet Set up the statement content to accumulate the net income and dividends paid with the retained earnings in one of the Total fields say Total 7 Then you can use the T7 function to print the latest retained earnings on a separate line The effect will be to add the incom
149. er 7 15 CHAPTER 7 Periodic Processing Update Current Year Updating Beginning Balances Only You can use this function to update only the beginning balances of the accounts in the current year files without actually clearing and closing For example closing the previous year takes you into the second month of the current year You are making adjusting entries daily You need to produce the financial reports for the first month of the current year You need the latest information so you use the Update Current Year function to update only the current year s beginning balances Update Current Year Screen 7 16 Select Update Current Year from the Periodic Processing menu The Update Current Year screen appears fE 2007 Update Current Year Sa Commands Edit Modes Other Help 2xt malma l2 ee OK Abandon Have You Printed All Reports for Last Year and Backed Up Your Current Year Files Y Retained Earnings Account 304000 2 Company H 1118 2007 Terminal TODO INS If you have not used the Setup F9 command to access last year files the message This function can be run with nnnn files only appears where nnnn is the current General Ledger fiscal year General Ledger Update Current Year Periodic Processing CHAPTER 7 1 Ifyou have not printed all the last year reports and backed up the current year files clear the box or enter N in text mode When you have completed
150. er up to 999 99 with the letters CR next to the right of credits in debit accounts 00 Print a number up to 9 999 99 including the comma If the number is a credit in a debit account or a debit in a credit account enclose it in parentheses Addn Trailing Enter the number of spaces to insert between this Spaces column and the next one Enter 0 to run the headings together for example to print one heading across several columns Press Enter to accept the default which is 2 spaces Print This Column If you want to suppress a column from printing for example to clear an account number column clear the box or enter N in text mode if not select the box or enter Y in text mode When you save the column the cursor returns to the Column ID field Enter the next column ID to work with or exit to the first Maintain Statement Layout screen After you add a statement layout produce the Statement Layout List to make sure that everything is correct Then go on to set up the statement contents General Ledger 9 15 CHAPTER 9 Statement Maintenance 9 16 Print Time Inserts If you want part of the title or footer to change each time you print the report either change the title each time you use the Statements function or use print time inserts to have the system change the titles For example when you print income statements for several companies enter CONA as the title so that the name of the company you ar
151. eriod 1 13 Enter the period for which you want to test the record General Ledger Batch Statements Field Beginning Ending Date Company ID nauiry Inquiry Pick Division Department Subaccount From Thru Segment Sort Statement Titles 1 4 Statement Maintenance CHAPTER 9 Description The beginning and ending dates for the period you entered appear from the CNVTxxx Period Conversion table in Resource Manager Press Enter to accept the dates or enter different dates For the statements to which you did not assign company IDs you can enter up to 20 companies for which to test the statements When you are finished assigning company IDs press Enter at a blank Company ID field The division department and subaccount ranges assigned to each statement in the batch statements record appear The account segment sort you assigned to each statement in the batch statements record appears The titles you assigned to each statement in the batch statements record appear Use the Proceed OK command to begin testing the batch statements record If no errors are found the Batch Statements selection screen appears If errors are found they are printed in the Batch Error List After the Batch Error List is produced the Statement Maintenance menu appears General Ledger 9 43 Cash Flow Contents o MM Use the Cash Flow Contents function to maintain the statement of cash flow contents You can specify
152. ernate Budget Forecast Period Actual CY Budget Last Year Forecast Begin 12155 50 12155 50 18067 76 12155 50 1 4078 90 10111 75 2088 80 4078 90 2 2250 76 8550 50 8005 60 2250 75 3 148628 58 1268 20 1600 00 3990 65 4 10111 76 2088 80 2260 76 10111 75 5 8550 560 8005 50 4078 90 8550 50 6 1268 20 1500 00 3990 65 1268 20 7 8005 60 4078 90 8550 50 8005 50 8 2088 80 2250 75 10111 76 2088 80 9 1500 00 3990 65 1268 20 1500 00 10 4400 00 995 50 2260 76 4400 00 1 995 50 1268 20 4078 90 995 50 12 00 4400 00 3990 65 00 13 00 00 00 00 End 157620 48 6269 45 12155 50 5001 25 Company H 12 29 2010 Terminal T000 OVR Field Description Inquiry Account Enter the account number with which you want to work General Ledger 8 21 CHAPTER 8 File Maintenance 8 22 Field Account Type Description DB CR or Memo Manual Entry Alternate Budget Begin Actual CY Budget Last Year Forecast Period 1 13 Actual CY Budget Last Year Forecast Account Budgets Description The account type description and type of balance debit credit or memo appear If you want to use the special functions to calculate budget amounts clear the box or enter N in text mode If you want to enter the budget amounts manually select the box or enter Y in text mode If you elect to use the special functions you can still enter amounts manually see below To enter or adjust forecast balances press F To enter or
153. ers for each statement you want to print However you can use the Batch Statements function to set up printing parameters for a group of statements in a single record that can be executed through the Statements function For example if you print a balance sheet and an income statement for companies A B and C every month instead of entering the printing parameters for each statement you can set up the parameters for each statement in a batch statements record Then when you use the Statements function simply enter the batch ID of the group of statements you want to print the printing parameters appear automatically Default Values The values you enter for each parameter are used when you print statements If you leave a field blank you can assign the parameter when you print statements General Ledger 9 35 CHAPTER 9 Statement Maintenance Batch Statements Batch Statements Selection Screen Select Batch Statements from the Statement Maintenance menu The Batch Statements selection screen appears a 2007 Batch Statements le Ex Commands Edit Modes Other Help 2xeaemo e ee OK Abandon Select Maintain Batch Statements Copy Batch Statements Delete Batch Statements Pretest Batch Statements Company H 11192007 Terminal To00 OVR Select the function you want to perform You can maintain or create batch statements records copy a batch statements record to another record del
154. es and so on Use the same ranges of main account numbers for the same account categories for all companies It simplifies setting up the system and you can use the same sets of statement layouts and contents for all companies when you print financial statements When assigning account numbers skip numbers between accounts to leave room for future accounts For example you might assign asset account numbers in the following series 1000 1010 1020 1030 Memo Accounts Memo accounts track miscellaneous figures that may be useful in preparing financial statements For example you might set up a memo account to track the number of shares of stock outstanding Copying the Chart of Accounts If you use the same account numbering structure for several companies you can save time by building one company s chart of accounts and then copying it to each of the other companies You can copy budget last year balances forecast amounts and the account mask from one company to another and you can copy from one division or department to another within the same company 8 16 General Ledger GL Accounts GL Accounts Screen General Ledger File Maintenance CHAPTER 8 Select GL Accounts from the File Maintenance menu This screen appears EN GL Accounts fla Es Commands Edit Modes Other Help 2xe ae ma l e o ok J Abandon Acct 100500 a Desc PETTY CASH Status Active y Type 005 a Desc Cash On Ha
155. es enter and post any required adjustments print financial statements and run the Update Current Year function see page 7 15 to update the beginning balances for the current year Repeat this step as many times as necessary to complete the year adjustments for last year e Back up your data files e Use the Setup F9 command on any General Ledger menu screen to access the last year files General Ledger 7 9 CHAPTER 7 Periodic Processing Clear and Close Last Year When You Clear and Close When you create last year files the system creates last year GLMAxxx GLMKxxx and GLJRxxx files with the extension Ynn where nn represents a two digit year These files provide information for multiyear reports statements and so on When you clear and close by step the system enters a matching debit in the GLJRxxx Ynn last year Journal file for the actual balance of each revenue account Then it enters an offsetting credit for posting to a capital account For expense accounts the opposite happens The system enters a matching credit for the actual balance of each expense account Then it enters an offsetting debit to the capital account The net balance posted to the capital account is the difference between the total revenues and the total expenses that is the profit ifit is a credit balance or the loss if it is a debit balance for that year The Clear and Close Last Year function has no effect on budget and last year bala
156. essages Invalid entry The Subaccount overlaps the Main Account number The starting position and length of the subaccount segment makes it overlap the main account number segment you defined Change the starting position or length of the subaccount segment or the main account number segment Invalid Period Conversion table The CNVTxxx table is not built properly Use the Period Setup function in Resource Manager to make adjustments Layout ID xxxxxx is not on file The statement layout ID is not on file Enter a different ID or use the Inquiry F2 command to look up and select an ID from the list that appears Leave blank for print time substitution Leave this field blank if you want the system to insert the information entered at print time Maximum number of lines has been reached You cannot insert You cannot insert a line item because the transaction already has 998 line items Missing period conversion table You must set up the CNVTxxx table before you can print statements See the Resource Manager User s Guide Must use each of these characters only once 1 2 and 3 When you select the sequence to sort the account segments you can enter each account segment character only once Note You must Post to Master for period xx after Clear and Close After you finish clearing and closing accounts you must post the closing entries No transactions are on file No transactions are on file for the account for this perio
157. ete batch statements records or pretest batch statements records Each of these functions is explained in this section Maintain Batch Statements Use the Maintain Batch Statements option to add or change batch statements records 9 36 General Ledger Batch Statements When you select Maintain Batch Statements from the Batch Statements selection screen the Maintain Batch Statements screen appears Statement Maintenance CHAPTER 9 EN 2007 Maintain Batch Statements el Commands Edit Modes Other Help 2xea ae mo e ee OK Abandon Batch ID BATCH Sequence 01 Descr Finan Pick Statement Layout ID BALA a Pick Division From q Statement Content ID BAL1 a Thru a Department From 4 Period Thru q Beginning Date 5 Subaccount From 4 Ending Date El Thru 4 Company ID Print Segment Detail 7 Segment Sort Print Accounts With Zero Balances E Print Workstation Date and Time E Line Statement Titles 12345678901234567890123456789012345678901234567890 1 CONA 2 3 BALANCE SHEET WITH BUDGET COMPARISON 4 AS OF PEDU Company H 11 19 2007 Terminal T000 OVR Field Batch ID Sequence Desc Pick Statement Layout Content ID General Ledger Description Enter the batch statement ID you want to view edit or create The sequence code identifies the order in which the set of printing parameters are executed when you print statements Enter the sequence code for thi
158. ettings for selected lines or select output devices The commands that are available depend upon the function you are using and are analogous to the command buttons available on graphical screens Press the highlighted key to use a command Messages Messages appear at the bottom of the screen when a command is unavailable or when OSAS needs information to continue Verification Press lt PgDn gt to proceed Address Mapping When you are working with a screen that contains an address you can use the Address Mapping command menu to view a map of that address This command combines address information with the URL and search variables in the Resource Manager Web Setup function and the Map Lookup ID in the Company Setup function to direct your web browser to a mapping website and generate the map 1 27 CHAPTER 1 Introduction Navigating OSAS The Address Mapping command is available when the Map flag appears at the bottom of the screen To view a map of the first address on the screen press Shift F4 To view a map of the second address if present press Shift F5 The second command is not available when there is only one address Note Before you can view maps you must set up mapping website information in the Resource Manager Web Setup function select the Map Lookup ID to use in the Resource Manager Company Information function and enter the path to your workstation s web browser in the Resource Manager Defaults function
159. evenue is divided by the number of shares outstanding stored in amemo account to get the earnings per share To use the numbers from memo accounts in a formula you must use the statement content line to put the appropriate balances in a Total field Then use the total in the formula as directed above You can enter numbers in two ways Enter a number in the beginning balance and use the ending year to date balance in calculations like in the sample shares outstanding account Enter a different number in each period For example to print the average sales per day enter the number of days in the month in each period balance and use that memo account in a day formula The total sales would be divided by the number of days in each period Scaling Use the scaling factor to round off dollar amounts to the nearest hundred or thousand dollars Enter 1 to divide by 1 no scaling 100 to divide by 100 or 1000 to divide by 1000 9 12 General Ledger Statement Maintenance CHAPTER 9 Setting up the Column Format General Ledger If the column contains information to print enter this information Field Heading No 1 3 Format Description Enter the heading for the column you can use three lines of text If you want the heading to be centered you must center it manually above the column You can have part of the column heading change each time the report is produced See Print Time Inserts on page 9 16 for in
160. exit from the function Produce the Recurring Entries List see page 8 35 to find the source of the problem Then use the Recurring Entries function to fix the out of balance situation before you copy the recurring entries If you want to copy the recurring entries anyway enter the force balance password for this company General Ledger 5 17 CHAPTER 5 Journal Transactions Copy Recurring Entries Editing and Writing Transactions If you copied the recurring entries to the GtttxxxW Transaction Work file use the Transactions function page 5 3 to edit or delete the entries that were copied Then use the function s Write command to write the entries to the Journal file If you copied the recurring entries to the GLJRxxx GJ Journal file use the Edit Transactions function see on page 4 27 to edit or delete the entries that were copied Copy Recurring Entries Log 12 19 2007 Copy Recurring Entries Page 1 Period 12 Credit H COMPANY TOTAL GRAND TOTAL 7 032 42 7 032 42 End of Report 5 18 General Ledger GL Journal o M The GL Journal is the main written record of the GLJRxxx Journal file It lists the transactions for the periods and source codes you specify and is part of your audit trail Print the GL Journal every time you make journal entries or copy and write recurring entries so that you have a written record of that day s work Print the journal at the end of each accounting period and store it in
161. f the business A journal entry you make to cancel a previous entry It consists of an equal credit to the account previously debited and a corresponding debit to the account previously credited A number that identifies the group a recurring entry belongs to A code that identifies the source of a journal entry Records that control the appearance and contents of the statements and reports you print through the Statements function The standard financial statements such as the balance sheet the income statement and the cash flow statement you produce at the end of each accounting period which detail the company s financial performance You can also produce the Ratio Analysis and other reports such as sales reports A grid that holds records and is visible See also file A credit or debit made to an account Each journal entry consists of at least one debit and one credit transaction GI 5 GLOSSARY trial balance A report that shows the balance of each account in the general ledger The total credits must equal the total debits variance The difference between two balances for the same account for example between the balance of this year and last year GI 6 General Ledger INDEX General Ledger Symbols WKS files 6 15 A account balances 3 13 beginning 3 13 in Statement Contents 9 26 in Statement Layout 9 9 class 3 11 8 13 code 3 11 information storage 1 5 numbers changing B 6 changing du
162. fied by a letter Columns are arranged in alphabetical order across the report If columns are already set up they are displayed in the lower third of the screen Enter the ID of the column you want to work with it must be a letter Begin a new statement layout with column A If you want to leave a blank column for shifting column totals to the left margin begin with column B Then continue through the alphabet To leave blank columns between columns skip a letter Then you can shift column totals or replace blank columns with new columns without reconstructing the layout A blank column does not appear in the report unless you shift column totals into it Copy From This field appears if the column ID you entered has not been set up Enter the letter of the column you want to copy into the column or press Enter to skip this field Inquiry What Is In The Select what you want to appear in the column If you Column select 0 1 or 2 skip ahead to Setting up the Column Format on page 9 13 If you select 3 4 5 8 or 9 refer to Account Balances on page 9 9 If you select 6 or 7 skip ahead to Calculations on page 9 11 9 8 General Ledger Account Balances Statement Maintenance CHAPTER 9 If the column contains actual budget or last year balances enter this information Field As Of When How Far Back Year General Ledger Description Select the most recent period to put in
163. formation about inserting current data into headings for example printing the period beginning and ending dates The length of each line of the column heading is the greater of either the header characters or the format length If you plan to shorten the format make sure that the column heading will fit The format determines how the column information appears in print Press Enter to use the default format for the column you are using or design your own Each character in the format represents the space for one printed character The type of printed character allowed depends on the column type Column types 1 and 2 are text columns where X represents any character and XXXX creates a column 4 characters wide For column type 1 account number the standard format is 12 characters for column type 2 description it is 30 characters You can alter the format to suit your needs Account numbers or descriptions longer than the format you define for the column are truncated Column types 3 9 are numeric columns 9 13 CHAPTER 9 Statement Maintenance Field Description represents a number 0 9 0 represents a decimal place represents a decimal point Tepresents a comma The standard format for these column types is HHHHHHHHH OO This format can hold the largest possible balances If you shorten the format to gain space make sure that none of the balances you print will exceed this limit if some do an error mes
164. ger Q o H je je pe pe pe pe pe p e H e Beginning Account Type 020 100 165 130 045 060 z200 210 230 240 245 065 400 415 300 005 Builders Supply Cash Flow Contents List Mask MMMM11 ozs 125 165 130 oss 060 200 210 230 240 245 065 405 415 308 010 Key to Section Adjustments to Operating Activities c Cash Ending Account Type Description Changes in receivables Net purch sale of property Amortization Depreciation Changes in inventory Changes in prepaid expenses Changes in accounts payable Income taxes payable Changes in payroll taxes payab Changes in deductions payable Changes in pension fund payabl Marketable securities Proceeds from stock issue Payment of dividends Changes in bonds amp notes paybl Cash accounts 10 21 Tables List o MM The Tables List shows the number of columns column length and type and data for General Ledger tables Use the Tables List to keep records and verify the contents of the General Ledger tables you are using General Ledger 10 23 CHAPTER 10 Master File Lists Sample List 12 19 2007 Builders Supply 10 34 AM Tables List General Ledger Table ID PASS Description No of Columns 2 Column Length 12 Type FUNCTION PASSWORD FORCED BAL OVERRIDE Table ID GLAUDH Description No of Columns l Column Length 30 Builders Supply AUDIT TRIAL BALANCE December 31 2005 Table ID GLCHAH Description No of Columns l
165. ger A 7 APPENDIX A System Messages There are no unposted entries to edit No unposted entries are on file to edit Unable to create sort file The segment is unable to create the sort file for sorting account segments Get help from a support technician Use account format MMMM112233 You must enter general ledger accounts in the format shown Warning Changing this code may result in inaccurate financial reports If you change an account type make sure that you have closed the balances of the credit or debit account to another account If you have not the ledger will get out of balance Warning Current journal entries do not balance The balance of the credits and debits in the GLJRxxx Journal file does not equal zero Enter or edit the necessary offsetting transaction s to reduce the balance to zero or enter the forced balance password exit and find out what went wrong as soon as possible Warning This is not a Manual Recurring or Reversing entry You should not edit a transaction that has been posted to the GLJRxxx Journal file from another application such as Accounts Payable Purchase Order If you do not have the correct transaction change the entry number If you want to edit the transaction ignore the message Wildcards are only valid when using an Account Mask You can use wildcard characters only if you assigned an account mask to the statement content A 8 General Ledger System Messages APPENDIX
166. he balance of the debit and credit entries 1s zero However if the ledger is out of balance and you cannot figure out what went wrong you can enter the forced balance password to exit from the function Use the forced balance password only as a temporary emergency measure Find out the source of the problem and correct it as soon as possible Do not post to the GLMAxxx Master file until the Journal is in balance General Ledger 8 41 CHAPTER 8 File Maintenance Tables Screen Tables Select Tables from the File Maintenance menu When the blank Tables screen Inquiry appears enter PASS in the Table ID field to list the contents of the table E cis EN Commands Edit Modes Other Help OK Jl Abandon Table ID P 4 Number of Cols 2 FUNCTION PASSWORD FORCED BAL OVERRIDE 2xt mealma e Description Column Length Type A Company H 1119 2007 Terminal T000 OVR Field Description Function FORCED BAL appears in the first column to describe the function of the password Do not change this field Press Enter to proceed to the next column Password The default forced balance password that is established when you install your software is OVERRIDE It is the same for all companies If you like change it for additional protection You can have only one forced balance password on your system Use the Proceed OK command to save the PASS table Then enter the next table ID or
167. he dollar amount of profit per share of stock A self contained list of executable code written and implemented to do a task Most programs are represented by a function on a menu See also function To remove from the system See also restore The system you use if your basic accounting period is one week and you close the books at the end of every quarter 13 weeks You can also use a fiscal year system with a basic accounting period of one month General Ledger ratio analysis record recurring entries restore retained earnings reversing entry run code source code statement layouts and contents statements table transaction General Ledger GLOSSARY A financial report you can use to assess aspects of financial performance There are activity leverage liquidity and profitability ratios A unit of information that has other pieces of information assigned to it Each record is assigned an ID so that the file can sort information in terms of record IDs Journal entries you make regularly in the same amounts for example depreciation entries You can set up recurring entries in the GLRExxx Recurring Entries file and copy them all at once at the appropriate times To bring information back to its original place and condition See also purge Income earned by a company during the year but not yet distributed as dividends to the owners stockholders Retained earnings form part of the equity o
168. he last fiscal year 8 Back up your data files for storage see the Resource Manager User s Guide 9 Clear and close the revenue and expense accounts see page 7 9 General Ledger Month End General Ledger Periodic Processing CHAPTER 7 10 Use the Update Current Year function see page 7 15 to update the current year GLMAxxx file with the final balances from the last fiscal year Maintenance Use the Month End Maintenance function only when you must make room in the GLJRxxx file because disk space is limited If you have enough disk space you can keep an entire year s journal entries on file For information about month end processing refer to page 7 19 7 3 Create Last Year Data o MM Use the Create Last Year Data function at the end of a company s fiscal year to prepare the data files for the new year and to create last year GLMAxxx Master and GLJRxxx Journal files Then you can make adjusting entries to last year files while you begin processing data for the new year You cannot use the Create Last Year Data function if you are working with last year files If your companies use different fiscal years you can use the Create Last Year Data function as each company s fiscal year ends These things happen when you create last year data for a company e The system creates last year GLMAxxx GLMKxxx Master Key and GLJRxxx files with the extension Ynn nn represents the last two digits of the
169. he total enter one of these values increases the totals field by the balances or total amounts calculated from the current line decreases the totals field by the balances or total amounts calculated from the current line 0 sets the total to zero so that you can use the total again later in the statement content Print Debit Credit or To use only debit accounts enter D To use only credit Both accounts enter C To use all the accounts specified in the range enter B Reverse Sign to Normally a negative sign prints for all credit Print balances regardless of whether the account is a debit or a credit account If the accounts on this line are normally credit accounts select the box or enter Y in text mode so that the debit balances show a negative sign instead If this line holds debit accounts clear the box or enter N in text mode Print Dollar Signs If you want to print dollar signs next to the dollar amounts on this line select the box or enter Yin text mode Dollar signs will not be printed unless they are also specified in the numeric format in the statement layout for example 00 If you clear the box or enter N in text mode dollar signs will not print even if the statement layout calls for them unless the format is 00 9 30 General Ledger Statement Contents Statement Maintenance CHAPTER 9 Field Description Number of Chars to If you specified a CL or CR function enter the
170. heck the Trial Balances for errors and make sure that the amounts balance For more information about charts of accounts see page 8 15 Allocations If you enter transactions against one major account and then distribute them to several other accounts you can set up an allocation record for the major account In that record specify each account to which transactions are allocated up to 45 accounts and the percentage that each account receives The sum of the percentages must equal 100 percent Once allocations records are established you can enter journal transactions against the major account and by selecting the Allocate box or entering Y in text mode in the Transactions and Edit Transactions functions indicate that the transaction should be allocated When you post the system creates entries according to the allocation record For more information about allocations see Allocations on page 8 31 3 14 General Ledger Setup Functions Setup CHAPTER 3 Recurring Entries Journal entries made regularly every week every month and so on are called recurring entries To set up groups of recurring entries use the Recurring Entries function When you want to copy the recurring entries to the GLJRxxx Journal file use the Copy Recurring Entries function page 5 15 If General Ledger interfaces with other OPEN SYSTEMS Accounting Software applications some recurring entries may be better tracked through those applicat
171. hical Main Menu Navigating OSAS Main Menu If you use BBj in graphical mode the main menu is available in two flavors graphical and MDI To switch between the two styles press Shift F5 If you use Visual PRO 5 the graphical main menu is the only graphical menu available The graphical main menu is shown below EN 1000 OPEN SYSTEMS R Accounting Software foja A e aM OSAS H Builders Supply Bank Reconciliation Transactions Bills of Materials Kitting Reconciliation Void and Stop Payments Fixed Assets Productivity Reports BR Journal General Ledger File Maintenance Bank Account Register General Report Writer Master File Lists Post Transactions Inventory Job Cost Payroll with Direct Deposit Purchase Order with Landed Cost Resource Manager Sales Order Company H Terminal T000 10 12 2010 4 27 PM You can move around the graphical menu in these ways Click an application to view that application s menu Click a menu item to view its functions Double click a function name to enter that function To exit from the graphical menu click a different application or menu name or press Tab to return to the main menu To exit from OSAS click the Close box in the upper right corner of the screen press F7 or select Exit from the File menu General Ledger Navigating OSAS Introduction CHAPTER 1 MDI Main The MDI menu centralizes all OSAS functionality in one location applications Menu appear as ta
172. his function also increases the year value in the GLPDxxx table by 1 Use the Clear and Close Last Year function to clear and close the income and expense accounts for specified capital accounts By using this function you prevent possible conflicts because of erased files whose unposted transactions have an effect on this year s balances The system checks for such transactions warns you of all occurrences and moves the transactions from the previous year s GLJRxxx Y nn file to the current year s GLJRxxx file period 1 General Ledger 1 9 CHAPTER 1 Introduction The General Ledger System When you are finished working with last year s information use the Update Current Year function to update the account balances for this year This function like the Clear and Close Last Year function updates information in the current year s GLJRxxx file period 1 However it copies the information instead of moving it this function does not affect last year s information To clear journal entries from previous periods in this year use the Month End Maintenance function This function removes transactions from the GLJRxxx files for the specified periods Use the Consolidate Master Files function to consolidate account balances from different files or different computers into the GLMAxxx file of one company This function is useful if you want to store all historical information in one place and produce consolidated financial reports fr
173. iated hot keys Not all commands are available for every function or field when a command is available a flag appears at the bottom of the function screen Common flags include Quick Info Maint Inquiry and Verify e The Quick flag reminds you that you are using the Quick Entry mode to skip fields that are not required Press Ctrl F to toggle quick entry on and off When the Info flag appears press Shift F2 to access the Information menu to access additional information about a customer vendor item job bill of material or employee See page 1 19 for more information on this menu General Ledger Navigating OSAS Introduction CHAPTER 1 General Ledger When the Maint flag appears press F6 to launch the appropriate File Maintenance function to edit a master file record or enter a new one on the fly When you finish press F7 to return to the function you were using e When the Inquiry flag appears press F2 to use the Inquiry command to look up additional information and select valid entries for the field you are in e The Verify flag reminds you that you are using verification When this flag appears you must provide verification when you press Page Down or use the Proceed OK command Press Ctrl V to toggle verification on and off Command Bar The command bar appears at the bottom of function screen and gives you access to commands that allow you to move around the screen add or edit information change s
174. ice for the Unwritten Transactions Report An example of the Unwritten Transactions Report is on page 4 11 Press G to go directly to a particular transaction This command is available only when there is more than one screen of entries 5 7 CHAPTER 5 Journal Transactions Transactions Append Edit Line Screen The Append Edit Line Screen appears when you add or edit a transaction on the Transactions screen The only differences between the Append Line screen and the Edit Line screen are the title and the fact that data appears in the Edit Line screen A Append Line a Commands Edit Modes Other Help Cash Flow Transaction 2xtulmealaal lee oK Abandon Entry 0001 GL Account 105000 a Debit Credit PREPAID EXPENSES gt 00 1000 00 Trans Desc Allocate prepaid insuranc Reference M6366 Trans Date 12 18 2007 E GL Period 12 Source M1 Allocate Y Field GL Account Debit Credit Trans Desc Reference Trans Date GL Period Description Enter the number of the account to which to post the transaction The GL account s description appears beneath the account number for verification Use the Maintenance F6 command to open the GL Accounts function to add or edit a GL account For a debit transaction enter the dollar amount in the Debit field For a credit transaction skip the Debit field and enter the amount in the Credit field Enter a description of the transaction f
175. ide Comparison Divisional Side by Side Comparison Company Side by Side Comparison Six Month Comparison Ratio Analysis Year to date YTD statements use 13 accounting periods quarter to date QTD statements use 3 periods If you use a quarterly system that is each of the 13 periods equals one week in the quarter print a current YTD report to get QTD information Use a sample layout as it is copy a sample layout and modify it or use the samples as guides for creating your own layouts Print one of the samples to use for reference while you read this section General Ledger 9 3 CHAPTER 9 Statement Maintenance Previous Year Files The current year and the last year files access the same GLSLF Statement Layout file Changes made to statement layouts while working with previous year files also affect current year files and changes made to statement layouts while working with current year files also affect previous year files Statement Layout Selection Screen Select Statement Layout from the Statement Maintenance menu The Statement Layout selection screen appears a 2007 Statement Layout ua Commands Edit Modes Other Help 2xt malma l2 ee Select Maintain Statement Layout Copy Statement Layout Delete Statement Layout Company H 11 19 2007 Terminal T000 OVR Select the task you want to perform You can maintain or create statement layouts copy statement layouts or delete
176. ies Net cash provided by financing activities Net decrease in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period 6 24 Cash Flow Statement Cash Flow for Year 2007 General Ledger CHAPTER 7 Introduction 7 1 Create Last Year Data 7 5 Clear and Close Last Year 7 9 Update Current Year 7 15 Month End Maintenance 7 19 Consolidate Master Files 7 21 Remove Prior Year Files 7 27 General Ledger Periodic Processing Introduction Use the functions on the Periodic Processing menu to process period end and year end information The year end process involves the conversion and use of last year data which is also handled through the Periodic Processing menu When to Close the Books Although you can use the statement contents and layouts to produce financial statements for a particular period without closing the books you can store only 13 periods of current balances in the GLMAxxx Master file After period 12 13 for quarterly systems you must close out the balances in the income statement accounts to clear them for the next year Business however does not end when your fiscal year does and you cannot put the new year s data on hold while you finish closing the old year Therefore use the Create Last Year Data function see page 7 5 to copy your data to last year files Then you can process both the old year and the new year If your company
177. iew F ile S creen e Mail find Print the Report Follow these steps to print a report 1 Select Printer in graphical screens or enter P in text screens 2 If multiple printers are available for the terminal either select the printer from the list or enter the appropriate code for the printer and press Enter Use the Devices function in Resource Manager to add printers to the terminal 3 When available select either Standard or enter S to print the report in standard width or Compressed or enter C to print it in compressed width 4 Click OK or press Enter to begin printing the report 5 If you want to stop printing after it has begun press Ctrl Break 6 Click OK or press Enter to continue 1 31 CHAPTER 1 Introduction Reports 1 32 Preview the Report The Print Preview option is only available for graphical workstations However before Print Preview will work in Windows you must add a sysprint device line in the config bbx file for that workstation Use the Devices function on the Resource Manager User Setup menu to add this line Follow these steps to view a report using Print Preview 1 Select Print Preview in graphical screens 2 If multiple printers are available for the terminal either select the printer from the list or enter the appropriate code for the printer and press Enter Use the Devices function on the Resource Manager Installation and Configuration menu to add printers to the terminal
178. ile Maintenance CHAPTER 8 Run Code Balances If you try to exit from the Recurring Entries function before the balance of the offsetting amounts is zero a warning message appears and the Run Code Balances window appears You must enter the password to exit a Recurring Entries Commands Edit Modes Other Help gt X ta lao a 28 lee OK Abandon Enter Password to Continue Without Balancing Ed If you enter an incorrect password the Recurring Entries screen appears Edit or add transactions until the balance at the bottom of the screen is zero then use the Exit F7 command to return to the File Maintenance screen When you finish entering recurring entries exit to the File Maintenance menu General Ledger 8 39 Tables oo MM Use the Tables function to set up and maintain the PASS Forced Balance Password table The CNVTxxx table in Resource Manager must be set up before you can begin using the General Ledger system see the Resource Manager User s Guide for information about the Period Setup function and the CNVTxxx table The General Ledger system has several company specific internal tables GLAUDxxx GLCHAxxx GLPRAxxx GLPRJxxx and GLTRLxxx Do not tamper with these tables The PASS Table To ensure that the general ledger remains in balance you cannot exit from a journal entry function Transactions Edit Transactions Copy Recurring Entries or Recurring Entries unless t
179. iles manually on a new system or you can convert your old files when you upgrade from an earlier version To create files on a new system use the Data File Creation function on the Company Setup menu in Resource Manager see the Resource Manager User s Guide For instructions on converting your files see the Conversion section later in this chapter If you plan to use other OSAS applications with General Ledger you must install and set up General Ledger before you set up the other applications 2 2 General Ledger Conversion MM If you use an earlier version of OSAS General Ledger you can convert your files from the older version to the current version When you are ready to convert files use the Data File Conversion function on the Company Setup menu in Resource Manager see the Resource Manager User s Guide to upgrade General Ledger data files You can upgrade from version 3 2 4 xx 5 xx 6 xx or 7 0x If you want to convert to version 7 6 from a version earlier than 3 2 contact a client support representative You must install the new version of General Ledger before you convert files You can replace and update the programs properly only by using the Install Applications function in Resource Manager Before you convert an application s files make note of the version number of the application from which you are converting The Data File Conversion function has no way of determining the information from within the fun
180. in Account Account Numb Number umber General Ledger Account Mask File Maintenance CHAPTER 8 Previous Year Files The current year and previous year files access the same GLMSK Account Mask file Changes made to the account mask while working with previous year files also affect current year files and vice versa Account Mask Screen Select Account Mask from the File Maintenance menu This screen appears f 2007 Account Mask ajen Commands Edit Modes Other Help 2z2xe ee ma e ee OK Abandon Main Account Position 1 Length 4 Division Position 5 Length 3 Department Position 0 Length 0 Subaccount Position O Length 0 Fill Character User Defined Account Sort 1 User Defined Account Sort 2 Account Number Mask MMMM11 M Main Account 1 Division 2 Department 3 Subaccount Company H 11 19 2007 Terminal T000 OVR Field Description Main Account Enter the position in the account number where the Position Length main account number begins Then enter the length of the main account number the length must be 3 characters or more For example if the main account number takes up the first four positions in your account numbers enter 1 in the Main Account Position field and 4 in the Length field General Ledger 8 5 CHAPTER 8 File Maintenance Field Division Department Subaccount Position Length Fill Character User Defined Account Sort 1 2 Account Number Mask
181. ing in steps e Clear and close all income revenue and expense statement accounts in one step which is the fastest way Then use the Statement Layout and Statement Contents functions to calculate the year end figures you need e Close all divisions departments or subaccounts to main account numbers Then print the Trial Balance and financial statements to show the total amounts for income statement accounts rather than a breakdown by division department and subaccount e Audit automatic closing by closing the accounts in one to nine steps For example if you close the operating expenses in one step the income statement at this point will show the total gross profit or operating margin If you close the COGS accounts in the next step the income statement will show your gross income When you clear the revenue accounts in the next step the income statement accounts revenues and expenses will be ready for the new year s transactions You are ready to distribute the net income Distributing Net Income The closing procedure you use depends on how your business is organized General Ledger 7 11 CHAPTER 7 Periodic Processing Clear and Close Last Year Builders Supply the sample data company closes its divisions to main account numbers and then its income statement accounts to retained earnings The balance in this account is the portion of the year s income retained by the company to increase its capital If you want t
182. inning balances in Statement Contents 9 26 updating 7 10 7 16 Browse 1 22 budget balance setup 3 13 C calculations in Statement Layout 9 11 capital accounts clearing and closing to 7 10 Cash Flow Contents file 1 7 function 9 45 General Ledger Cash Flow Contents List function 10 21 sample 10 21 Cash Flow Statement 1 9 after conversion 2 4 function 1 9 6 21 Change Fields sample log 8 53 screen 8 49 chart of accounts 8 16 copying 3 12 8 16 setup 3 5 3 11 8 15 Chart of Accounts List accounts out of order 10 9 printing before clearing and closing last year 7 9 before creating last year data 7 6 sample 10 10 class 3 11 Clear and Close Last Year backing up files before using 3 22 before updating current year 7 15 checklist 7 9 function 1 9 7 8 7 9 B 6 protecting with roles 3 22 unposted transactions 7 13 clearing and closing accounts at year end 7 2 Clearing Log sample 7 8 closing in steps 7 11 the books 7 1 CNVTxxx table 6 11 6 22 7 17 8 41 9 38 9 43 setup 3 5 3 9 codes establishing a format 3 2 setting up 3 1 sorting 1 30 3 1 column format setting up in Statement Layout 9 13 commands flags 1 26 hot keys 1 26 Proceed OK 1 2 company General Ledger INDEX assigning roles 3 21 Consolidate Master Files after consolidation 7 25 backing up files before using 3 22 checklist 7 22 7 23 function 1 10 7 21 B 4 methods 7 21 protecting with ro
183. int the results If you use T9 you will get only the number stored in that total If this is not the problem make sure that the formula is correct And remember that you must use the AS function to calculate total revenues sales and so on for percentages on a line before the first one that contains account balances see sample statement content INC1 Why do all the credit balances in my Balance Sheet show up negative even for credit accounts In OPEN SYSTEMS Accounting Software debit balances are always positive and credit balances are always negative and credit balances are printed with minus signs If you want credit balances to be printed without the minus signs set the Reverse Sign to Print flag in the statement content for those accounts In the Income Statements with variance the deviation is the actual balance minus the budget or last year balance which means that favorable deviations for revenues are positive while favorable deviations for expenses are negative Likewise percentages above 100 are favorable for revenues and unfavorable for expenses B 4 General Ledger Common Questions APPENDIX B Why does one of my statement content IDs not appear in the inquiry window even though know it exists When you modified the statement content you may have deleted sequence 01 Only contents that have a sequence 01 will appear in the inquiry window Use the Statement Contents function see page 9 21 to copy the cont
184. iod 8 beginning balance Print beginning balance for quarter the specified period is in period 7 beginning balance Ending Balance Detail or Summary Print ending balance for specified period period 8 ending balance Print ending balance for quarter which equals ending balance for specified period period 8 ending balance General Ledger Statement Contents Period or Quarter Current Pd YTD Result Prev Pd This Pd Only Result Prev Pd QTD Result Prev Pd YTD Result Prev Qtr This Pd Only Result Prev Qtr QTD Result Activity Detail or Summary Print YTD balance as of specified period period 8 ending balance Print activity amount for previous period period 7 activity Print QTD activity for the quarter the previous period is in period 7 activity Print balance at the end of the previous period period 7 ending balance Print activity amount for the same relative period in the previous quarter period 5 activity Print QTD activity amount for the same relative period in the previous quarter period 4 5 activity General Ledger Statement Maintenance CHAPTER 9 Balance Detail or Summary Print beginning balance for the year beginning balance Print beginning balance for previous period period 7 beginning balance Print beginning balance for the quarter the previous period is in period 7 beginning balance Print beginning balance for
185. ions For example you can use Accounts Payable to print monthly rent checks and create the proper GL entry The Reference field must be a unique number and cannot be edited later Run Codes Run codes group particular recurring entries together For example you can copy specific run codes and then post all the weekly transactions at the same time Assign run codes with care For example weekly recurring entries can be assigned a run code of 1 biweekly recurring entries a run code of 2 and so on Debits and Credits Each recurring entry must consist of at least one debit and one credit transaction and the total debits must equal the total credits in a run code For each debit or credit assign a unique reference code which identifies the item 1f it needs to be changed or deleted For more information about recurring entries see page 8 35 Financial Statements Before printing financial statements set them up through the Statement Layout and Statement Contents functions General Ledger 3 15 CHAPTER 3 Setup Setup Functions 3 16 A financial statement consists of one statement layout and one statement content The Statement Layout function controls the width and placement of the columns and the type of balances to use The Statement Contents function controls the rows of the report and determines which accounts to include One statement content can be printed with several statement layouts Likewise one statement layou
186. ions through General Ledger Regardless of where the journal transactions originate you will use the Journal Transactions functions to make miscellaneous entries and adjustments The functions on the Journal Transactions menu follow your work cycle First enter transactions and copy recurring transactions Second print the GL Journal and GL Activity Report to make sure that your entries are correct Third edit transactions if necessary Finally post the transactions to the GLMAxxx Master file Each function is explained in this chapter 5 1 Transactions o MM Use the Transactions function to enter GL Journal transactions for revenues expenses asset acquisitions and so on You can make journal entries to any of the 13 periods and to last year data at any time in the financial year or quarter You need not use the Transactions function to enter all GL Journal transactions Other OPEN SYSTEMS Accounting Software applications such as Accounts Payable and Accounts Receivable update the GLJRxxx Journal file with the proper entries if they interface with General Ledger You can also use the Copy Recurring Entries function page 5 15 to copy entries made on a regular schedule to the transaction records If you use other functions to update the GL Journal you still must use the Transactions function to make miscellaneous entries and adjustments Before You Begin Before entering GL Journal transactions obtain a copy
187. isted in this order for each position blank spaces characters and so forth numbers 0 9 uppercase letters A Z lowercase letters a z Alphabetical rules are not intuitive when numbers are involved Numbers are sorted as if they were letters When the first characters of several IDs are compared the ID with the smallest first character is placed first in the list If the first character of the IDs is the same the second characters are compared and the ID with the smallest second character is placed first in the list This comparison is made for each character in the range of IDs until the IDs are in alphabetical order If you use numbers for IDs pad them with zeros so that they are all the same length and numeric rules can hold true For example in alphabetical sorting ID 112 comes before ID 60 since anything that starts with 1 comes before anything that starts with 6 alphabetically If ID 60 were ID 000060 and ID 112 were ID 000112 ID 000060 would be listed first since 060 is less than 112 alphabetically and numerically When you assign IDs and codes establish a format that makes sense for your business and use it consistently These suggestions may help e To prevent organization problems use zeros to make all IDs the same length If IDs are divided into more than one part the parts should be the same length in every ID Do not use spaces to divide IDs into more than one part For example use ACE 01 and ACE 11 inst
188. k to include all values in the list 3 Ifthe screen contains options that control how information is sorted or printed for example in a Print or Print By section select the option you want to use to sort the information You can select only one option 4 Ifthe screen contains check boxes or Yes No fields that control how additional information prints on the list select the check box or enter Y in text mode to use that option when printing the list Clear the check box or enter N in text mode if you do not want to use that option 10 2 General Ledger General Ledger Master File Lists e CHAPTER 10 If the screen contains entry fields such as the Chart of Accounts List screen in the example enter the appropriate information into the field This information is used to print headings or sort information on the list If the field prompts you for information you entered in a File Maintenance function account sorts for example valid entry choices appear at the bottom of the screen Select the output device to begin printing the list See Reports on page 1 29 for more information After the list is produced the Master Codes List menu appears 10 3 Account Segments List o MM After you enter descriptions of all your divisions departments and subaccounts print the Account Segments List to make sure that everything is correct Sample List 12 19 2007 Builders Supply 10 32 AM Account Segments List Company
189. ke place If you enter 0 the account will not be consolidated If you want to consolidate all accounts in one step enter 1 For more information about steps and consolidating accounts during periodic processing see page 7 21 If you want to enter or edit information for the forecast budget press F If you want to enter or edit information for next year press N To enter or edit activity for the account press A To enter or edit the balance of the account press B Enter actual current year budget last year and forecast or next year budget balances Enter beginning balances in the first row Begin Then enter the net change in each balance if you entered A in the Entry Method field or the balance itself if you entered B in the Entry Method field for period 1 in the next row for period 2 in the following row and so on Do not use dollar signs or commas If you enter a negative balance enter a negative sign before the number The system recognizes whether a positive amount is a debit or a credit by your selection in the DB CR or Memo field The Account Budgets function page 8 21 provides formulas that facilitate the entry of budget and forecast amounts You can use the Copy Account Balances function page 8 45 to copy the last year actual current year budget next year budget or forecast balances for a range of accounts to their current year budget or forecast balances 8 19 CHAPTER 8 File Maintenanc
190. ke sure that the accounts closed in that step have a zero balance Repeat this procedure for all your steps After Clearing and Closing When you are finished clearing and closing all the accounts for a company update the current year files see page 7 15 7 14 General Ledger Update Current Year o MM After you have created last year files and cleared and closed the revenue and expense accounts for a company use the Update Current Year function to update the current year GLMAxxx Master file with the adjustments made to the last year files You should also run the function each time you make adjustments and post them in the prior year GL files Before You Begin Before you update the current year GLMAxxx file perform these tasks e Make sure that you have cleared and closed the accounts for the company whose current year GLMAxxx file you want to update e Back up your last year data files e Use the Setup F9 command to access the last year files When You Update Updating the current year produces these results e The actual account balances in the last year GLMAxxx Ynn file are copied to the Last Year column in the current year GLMAxxx file The beginning account balances in the current year GLMAxxx file are updated by the ending balances in the GLMAxxx Y mn file e Ifyou added an account to the last year GLMAxxx Ynn file it is added to the current year GLMAxxx and GLMKxxx Master Key files General Ledg
191. kup 1 22 1 27 address mapping 1 22 1 27 addresses 1 22 1 27 adjustments entering at year end 7 2 Allocations automatic 5 6 file 1 6 function 1 5 last year files 8 32 rounding adjustments 8 33 screen 8 32 setup 3 5 3 14 T accounts 8 32 Allocations List function 10 11 printing after allocating 8 33 sample 10 11 alphabetical sorting 3 2 of numbers 3 2 Assign Account Types function 8 47 screen 8 47 Audit Trial Balance after clearing and closing last year 7 14 function 1 4 6 7 6 9 protecting with roles 3 21 report 1 9 automatic allocations 5 6 automatic reversal of accrual entries 5 5 back up all files at once 3 23 at year end 7 2 before clearing and closing last year 3 22 7 9 consolidating master files 3 22 7 22 IX 2 creating last year data 3 22 7 6 month end maintenance 3 22 7 19 posting 5 31 posting to master 3 22 removing prior year files 7 27 updating current year 3 22 7 15 using Account Mask function 3 22 data files 3 22 programs 3 23 schedule 3 5 3 22 using operating system commands 3 23 using Resource Manager 3 22 3 23 when to 3 22 year end 7 2 balance sheet accounts numbers changed during conversion 2 4 balances 3 13 B 4 actual 3 13 GL Journal 5 21 setup 3 13 Batch Error List 9 42 Batch Statements 3 19 default values 9 35 file 1 6 function 6 9 Pretest Batch Statements screen 9 42 Batch Statements List function 10 19 sample 10 19 beg
192. l Entries Unposted Entry 001408 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001410 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001412 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001414 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001416 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001418 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001420 GL Account 1010 Not Found GLJRH Journal Entries Unposted Entry 001422 GL Account 1010 Not Found End of Report 10 26 General Ledger APPENDIXA System Messages Messages on the screen or in a report indicate an error or tell you how to enter data or what is happening in the function you are using Self explanatory messages are not listed Account xxxxxx is a Memo Account Cannot post to a memo account You cannot post transactions to a memo account Account is not in Master See Account Number is not on file Account Mask File xxxxxx for company xxx is not found The GLMSK Account Mask file is not set up for the company for which you are trying to print a statement Account Mask for company xxx is not found The account mask is not on file for the company you entered Enter a different company ID or exit from the function and set up the mask for the company Then try again to set up the statement content Account Mask is not defined for this company The account mask is not set
193. ld be considerably longer e Produce the report for all periods all source codes and all accounts This form of the report can be quite long You might want to produce such a long report only at the end of the year General Ledger 5 23 CHAPTER 5 Journal Transactions GL Activity Report Screen GL Activity Report Select GL Activity Report from the Journal Transactions menu The GL Activity Report screen appears 5 24 a 2007 GL Activity Report oja Commands Edit Modes Other Help 2xtlmealmal2 lee ok Abandon Pick Period From 1 Account Number Sort M1 Thru 12 Source Code From Print Inactive Accounts Thru Main Account From 4000 a Include Zero Balance Accounts ea Thu 999 a Division From 01 a Date to Print Post Thu 03 a Department From 4 Thru 4 Subaccount From 4 Thru 4 Headings Line 123456789012345678901234567890 a Builders Supply 2 ACTIVITY REPORT 3 GENERAL LEDGER 4 12 31 07 Default Sorts M1 Company H 11 8 2007 Terminal tooo OVR Enter the range of periods you want to include in the report 1 13 Enter the range of source codes you want to include in the report Enter the range of main account numbers you want to include in the report Enter the range of divisions you want to include in the report Enter the range of departments you want to include in the report Enter the range of subaccounts you want to include in the report Select
194. les 3 22 consolidation 3 14 account mask 7 22 at year end 7 2 companies 3 10 financial statements 7 21 methods 7 22 statements 9 28 conversion account masks 2 5 account types 2 4 before converting 2 3 from version 4 10 or lower 2 4 setup considerations 2 4 converting to OSAS version 6 1 2 5 Copy Account Balances function 8 19 8 45 Copy Batch Statements function 9 40 Copy Chart of Accounts 3 12 before creating last year data 7 5 before entering GL Journal transactions 5 3 fields copied 8 27 function 8 27 B 6 protecting with roles 3 21 replacing existing accounts 8 27 Copy Recurring Entries function 1 6 5 3 5 15 8 35 out of balance entries 5 17 protecting with roles 3 21 sample log 5 18 screen 5 16 Copy Statement Layout function 9 17 correcting journal entries B 1 posted entries B 1 Create Last Year Data IX 3 INDEX backing up files before using 3 22 before clearing and closing last year 7 9 checklist 7 5 function 1 4 1 9 7 1 7 5 7 19 8 15 B 6 protecting with roles 3 21 creating last year files at year end 7 2 D data dictionaries 2 1 Data File Conversion function 2 3 2 5 Data File Creation function 2 2 data files backing up 3 22 date fields 1 21 Delete account 8 17 Delete Batch Statements function 9 41 Delete Statement Layout function 9 19 departments 3 11 setting up in Account Segments 8 9 distributing net income 7 11 divisions 3 10 setting up
195. longer be valid Make sure that transactions have been written to the GL Journal before using this function If you do not want to save the new account mask use the Abandon F5 command If you want to save the mask use the Proceed OK command again After you save a mask change to a new company to define an account mask for that company or exit to the File Maintenance menu 8 7 Account Segments o M If you have set up a division department or subaccount segment in the account mask use the Account Segments function to set up a description of each division department or subaccount you use For several General Ledger reports you can select ranges of divisions departments and subaccounts and you can specify the order of the account segments The terms division department and subaccount are only labels Use segments in whatever way is necessary for your numbering structure The descriptions you assign in the GLSExxx Account Segments file appear in the report headers Previous Year Files The current year and previous year files access the same GLSExxx file Changes made to the account mask while working with previous year files also affect current year files and vice versa General Ledger 8 9 CHAPTER 8 File Maintenance Account Segments Screen Account Segments Select Account Segments from the File Maintenance menu This screen appears f 2007 Account Segments lelak Commands Edit Modes Other
196. m into the GLJRxxx file through the Copy Recurring Entries function The GLBAT Batch Statements file stores information about batches and instructions assigned to each batch ID You can use a batch ID to instruct the system to print many GL statements at once Temporary Files The temporary files store information created from an action you perform This information is transferred somewhere else when you perform a different action The GtttxxxW Transaction Work file ttt represents the terminal ID and xxx represents the company ID stores transaction information until you write it to the GLJRxxx file from the Transactions function General Ledger The General Ledger System Introduction CHAPTER 1 The GLJRxxx Journal file stores general ledger transactions You can enter the transactions through the Transactions function or through interfaced OSAS applications This file provides information for the GL Journal and the GL Activity Report When you post the information is sent from this file to the GLMAxxx file Statement Files The statement files store information about the layout and contents of statements These files reflect the fact that you can use General Ledger to tailor statements to fit your needs The GLSLF Statement Layout file stores specifications for the format of your statements column names and widths headings unit symbols and so forth The GLSCF Statement Contents file stores specifications for the
197. mpany already on the system Do I have to enter all the accounts one by one No You can use the Copy Chart of Accounts function page 8 27 to copy from one company to another B 6 General Ledger GLOSSARY account account categories accounting period activity activity ratios amortization application assets General Ledger A storage unit of financial data in accounting usually grouping related information under one account number or account ID In standard accounting practice divisions into which accounts of a business are categorized current assets current liabilities equity revenues expenses and so on A period of time in accounting used to provide distinct units of time you can work with For example you might want a report to include transactions done within a particular accounting period The changes in account balances resulting from transactions sales purchases payments of wages adjustments and other journal entries within the business or between the business and one or more outside parties Ratios that show the sales activity of the business in relation to its inventory and other assets for example the rate of return on fixed assets is the ratio of sales to fixed assets Depreciation applied to intangible assets such as goodwill and leasehold improvements A software package made up of several related programs functions and files Usually an application is named after a commo
198. mplifies setting up the system and you will be able to use the same sets of statement layouts and contents for all companies when you print financial statements When assigning account numbers skip numbers between accounts to leave room for future accounts For example you might assign asset account numbers in the following series 1000 1010 1020 1030 General Ledger Setup Functions Setup CHAPTER 3 Memo Accounts Memo accounts track miscellaneous figures that may be useful in preparing financial statements For example you might set up a memo account to track the number of shares of stock outstanding For more information about memo accounts see GL Accounts on page 8 15 Account Balances The beginning account balance is the balance at the start ofthe current fiscal year or quarter Each of the 13 period balances is the net change in that balance caused by the transactions posted to that period The balances you enter should be current at the beginning of an accounting period If you start in the middle of a fiscal year use the period that corresponds to the period you start with Do not start with period 1 unless the starting period is the first period in your fiscal year Actual Balances Set up actual balances in either of the following ways e To produce a detailed audit trail of your entries enter only the beginning actual balance when setting up an account Later you will make GL Journal entries to enter
199. n accounting practice or process for example Accounts Payable Accounts Receivable or Payroll The resources such as cash investments manufacturing materials inventory buildings leases fixtures owned by a business Assets are entered as debits in asset accounts Gl 1 GLOSSARY audit trail back up balance balance sheet capital clear and close company compound entry consolidated statements conversion depreciation Gl 2 A detailed record of accounting activity used to account for the source of every dollar in the accounts Even though the most common types of accounting errors are eliminated or greatly reduced when you use the General Ledger system you should always have an audit trail To make acopy of data for archival purposes For example you would want to back up a history file before you purged history so that you could retrieve the data if necessary The difference between the total debit entries and the total credit entries for an account If debits are greater than credits the account has a debit balance if credits are greater than debits the account has a credit balance A standard financial statement that summarizes the financial status of a business at a given time according to the fundamental accounting equation Assets Liabilities Owner s Equity Claims on a company s assets by the owners includes both the funds contributed by the owners and the income earned by
200. nager the foundation of OSAS Consult the Resource Manager User s Guide for more information on basic OSAS functionality and details on how Resource Manager works within the OSAS system About This Guide This guide describes the functions that make up the General Ledger application and gives details on how General Ledger fits into your existing business workflow This guide is divided into these sections e Chapter 1 introduces OSAS and the General Ledger application and describes the basics of the General Ledger system and how to navigate around OSAS 1 1 CHAPTER 1 Introduction Conventions 1 2 Chapter 2 Installation and Conversion details how to install General Ledger using Resource Manager and how to create or convert the data files it requires Chapter 3 Getting Started gives information and checklists on the steps you need to perform to set up General Ledger Chapters 4 through 12 contain function descriptions organized by menu These chapters mirror the order that appears on the General Ledger menu The Appendixes contain supplementary material not directly related to General Ledger functionality The Index is a topical reference to the information in the rest of the chapters and concludes this guide This guide uses the following conventions to present information When the Inquiry or Maintenance commands or both are available for a field the Inquiry and Maint flags appear in the margin See page 1 2
201. nance backing up files before using 3 22 before using 7 19 function 1 10 7 3 7 19 when to use B 5 multiple companies 3 10 account masks for 3 10 N navigating graphical function screens 1 18 graphical main menu 1 16 MDI menu 1 17 text function screens 1 25 text main menu 1 23 to directories and files 1 22 net income distributing at year end 7 11 numbers alphabetical sorting 3 2 numeric formats samples of statement layouts 9 15 O offsetting accounts in GL Journal 5 21 offsetting amounts 8 38 in recurring entries 8 38 Options setting up 3 5 Options and Interfaces function 8 35 OSAS MDI menu 1 17 General Ledger modes 1 15 graphical 1 15 text 1 23 setup considerations 2 4 starting in other operating systems 1 11 starting in Windows 1 11 out of balance during setup 3 20 entries 3 20 5 17 output device e mail 1 34 file 1 33 preview 1 32 printer 1 31 screen 1 33 P password 3 20 5 10 8 39 8 41 forced balance 3 22 period setup B 2 Periodic Processing Clear and Close Last Year 1 9 Consolidate Master Files 1 10 Create Last Year Data 1 4 1 9 functions 1 4 1 9 Month End Maintenance 1 10 Remove Prior Year Files 1 9 Update Current Year 1 10 Post to Master backing up files before using 3 22 function 1 5 1 8 3 20 protecting with roles 3 21 posting 1 8 after clearing and closing last year 7 14 prepost checklist 5 31 Pretest Batch Statements function
202. nces Updating Beginning Balances If you want only to update the beginning balances in the current year files without clearing and closing the files exit from this function Then use the Update Current Year function see page 7 15 Clearing and Closing to Capital Accounts 7 10 Before you use this function for the first time you must use the GL Accounts function page 8 15 to identify the capital account s to which to clear and close the revenue and expense accounts Thereafter you can use the Clear and Close Last Year function to clear and close the accounts automatically Each account in the GLMAxxx file has a Clear To Account field where you can specify the account to close it to In the Step field you can enter the step in which the account is closed see Closing in Steps below General Ledger Clear and Close Last Year Periodic Processing CHAPTER 7 Before you close the books for the first time follow these steps 1 Determine which accounts will be closed to the capital account s in each step 2 Make sure that the account type assigned to each account is correct 3 Enter the capital account number to which each revenue and expense account will be closed Then enter the step number 4 Ifyou have additional accounts to be closed to the capital account s such as dividends paid set them up in the same way This should be the last clearing step Closing in Steps You have three alternatives for clos
203. nd DB CR Memo Debit Clear To Account 3 Step 0 Display Forecast y Consol To Account La Step 0 Ent Method Activity y Period Actual CY Budget Last Y ear Forecast Begin 100 00 100 00 30 00 100 00 1 15 00 45 00 75 00 15 00 2 25 00 50 00 30 00 25 00 3 30 00 60 00 100 00 30 00 4 45 00 75 00 25 00 45 00 5 50 00 30 00 15 00 50 00 6 60 00 100 00 30 00 60 00 7 30 00 15 00 50 00 30 00 8 75 00 25 00 45 00 75 00 9 100 00 30 00 60 00 100 00 10 100 00 10 00 25 00 100 00 11 10 00 60 00 15 00 10 00 12 100 00 100 00 30 00 100 00 13 00 00 00 00 End 200 00 40 00 100 00 200 00 Company H 10 15 2010 Terminal T000 OVR Field Account Description Enter the account number with which you want to work The division department and subaccount descriptions if available appear from the GLSExxx Account Segments file To delete an account use the Delete F3 command If you try to delete an account for which journal transactions have been entered the message Activity on account appears If you try to delete an account for which the year to date balance is not zero the message YTD balance not zero appears In either case you cannot delete the account 8 17 CHAPTER 8 File Maintenance Field Type Description Status DB CR or Memo Clear To Account Step Consol To Account 8 18 GL Accounts Description This field appears if you enter a new account To copy an existing acc
204. ne Headings 123456789012345678901234567890 Builders Supply TRIAL BALANCE December 31 2007 WN Company 1182007 Terminal Tooo OVR 1 Enter the period for which you want to produce the report If you leave this field blank beginning balances will be printed Inquiry 2 Enter the range of main account numbers divisions departments and subaccounts for which you want to produce the report General Ledger 6 3 CHAPTER 6 Reports Trial Balance 6 4 If you want to print by account types select the box or enter Y in text mode if not clear the box or enter N in text mode If you print by account types subtotals are shown after each type of account and the account sort is skipped For more information about account types see Account Types on page 8 13 Select the sort configuration you want to use for the report If you created user defined sorts through the Account Mask function valid entries appear at the bottom of the screen Select the type of balances or amounts you want in the report Enter the title you want on the report four lines of 30 characters each Use the numbers above the fields to help center the text Before you continue make sure that no one else is using the system Select the output device See Reports on page 1 29 for more information on output devices After the report is produced the Reports menu appears General Ledger Trial Balance
205. neral Ledger Copy Chart of Accounts o M If several companies have similar charts of accounts the Copy Chart of Accounts function helps you save time by copying some or all accounts from one company to another or from one department or division to another You can also copy the period budget balances and the last year balances but you cannot copy actual balances When you copy the chart of accounts by company you can use wildcards You cannot use the Copy Chart of Accounts function if you are working with previous year files Copied Fields For each account you copy these fields are copied e General Ledger account number e account description e type of account debit credit or memo e clear to account number e clearing step e consolidate to account number e consolidation step Replacing Existing Accounts If the company to which you are copying has a chart of accounts you can replace accounts with the same numbers or leave the accounts unchanged Be careful in this situation the balances for the existing accounts will be lost if you replace the accounts General Ledger 8 27 CHAPTER 8 File Maintenance Copy Chart of Accounts Copy Chart of Accounts Screen Select Copy Chart of Accounts from the File Maintenance menu The Copy Chart of Accounts screen appears a 2007 Copy Chart of Accounts e Commands Edit Modes Other Help RX te aalmaal ee OK Abandon Copy jm Copy Division From 0
206. ng accounting period for the date The CNVTxxx table is not built correctly Use the Period Setup function in Resource Manager to correct it Remember if you use a one week accounting period you must update the table after you close the books every quarter The general ledger entries from my other accounting applications do not show up in the journal when I post them What happened to them B 2 You do not have the interface switch set to exchange information with General Ledger or you do not have the right general ledger account numbers in the tables or files of the application The posting logs for the other applications should show a Missing Account message for transactions that could not be posted to General ledger Check the options and interfaces for the applications to make sure that they interface with General Ledger see the Resource Manager User s Guide If the applications are interfaced check the posting totals from the other applications to find out which transactions should have been posted to which accounts If any of the transactions were lost use the Transactions function page 5 3 to enter them manually into the GLJRxxx Journal file If a transaction was posted to the wrong account use the Edit Transactions function page 5 27 to enter the correct account number Print the GL Activity Report page 5 23 for the appropriate period and make sure that all the entries have been made and are correct Remember t
207. ning Balance Clearing Log Page 2 12 23 PM GL Account Description i Credit 535002 535003 801000 802000 804000 3805000 806000 851000 852000 999900 INSURANCE EXPENSE DALL 19431 75 INSURANCE EXPENSE OAKL 16283 15 OTHER INCOME 22418 35 FINANCE CHARGES ASSESSED 572 65 DISCOUNTS TAKEN 00 INTEREST EXPENSE 152715 53 OTHER EXPENSES 16826 31 FEDERAL INCOME TAX EXPENSE STATE INCOME TAX EXPENSE SUSPENSE Transferred to Account 304000 365925 25 End of Report General Ledger Clear and Close Last Year MM Use the Clear and Close Last Year function to clear and close the revenue and expense accounts to specified capital accounts This function clears the accounts for all periods you cannot use it to close accounts period by period If you want to see retained earnings at the end of each period set up the statement content to print the necessary account balances in the balance sheet Before You Begin Before you clear and close by step perform these tasks e Print the Chart of Accounts List see page 10 9 and make sure that the correct account type is assigned to each account e Specify the accounts to which the revenue and expense accounts will be closed and the step in which each will be closed e Create last year GLMAxxx Master GLMKxxx Master Key and GLURxxx Journal files These accounts should have the file extension Ynn nn represents the last two digits of the year e Using last year fil
208. noncash flow transaction Incorrect entries can result in an erroneous Cash Flow Statement Use the Proceed OK command to save the entry After you save the entry the transaction appears in the scroll region on the Transactions screen and the cursor returns to the GL Account field in the Append Line screen If the balance of the entries is a debit the offsetting credit amount appears in the Credit field of the next transaction if the remaining balance is a credit the offsetting debit amount appears in the Debit field and the source code and period from the previous transaction appear Continue entering transactions until the balance at the bottom of the screen is zero If the offsetting amount should be split between two or more accounts enter the necessary additional transactions to bring the balance to zero see Double Entry Bookkeeping below 5 9 CHAPTER 5 Journal Transactions Transactions Transactions are not immediately written to the GLJRxxx Journal file They are held in a transaction work GtttxxxW file which is specific to the workstation where the transaction was entered To write the transactions to the GLJRxxx file use the Write command When you are finished entering transactions use the Exit F7 command to return to the Transactions screen Double Entry Bookkeeping Double entry bookkeeping requires an offsetting credit for each debit and vice versa You must continue entering transactions until the
209. nt mask separated by a fill character MMMM 11 222 User Defined Account Sorts Regardless of how you organize your account mask you can specify how you want account information to be sorted when you produce some reports For example your account mask might be MMM112233 but you want account information to be printed in the order 231M in some reports and in the order 31M2 in other reports By entering the correct configuration in the User Defined Account Sort fields you establish the order that information will appear in the reports Multiple Companies If you print consolidated statements for several companies that are on the system assign the same account mask to each company If different account masks are used the consolidated statement might be incorrect since statements do not allow companies with different masks to be consolidated See Account Mask on page 8 3 for more information about account masks Account Segments 3 10 If you set up a division department or subaccount segment in the account mask you can set up a description of each division department or subaccount you use For example if you use divisions 001 002 and 003 you might enter these descriptions General Ledger Setup Functions Setup CHAPTER 3 001Minneapolis 002California 003Texas Likewise if you use departments 10 20 30 and 40 you might enter these descriptions 10Accounting 20Administration 30Sales and Marketing 40Shi
210. ntry Number to 1 Retained Earnings Account For Company H 2 Copy Next Y ear Budget to Current Y ear Budget Do You Want to Zero Next Y ear Budget Balances Copy Inactive Accounts with Zero Balances Your Current GL Year Will be Set to 2011 Company H 12 29 2010 Terminal T000 OVR 1 If you have backed up your current year files select the box or enter Y in text mode if not clear the box or enter N in text mode You should always back up your current year files before you create last year files General Ledger Create Last Year Data Periodic Processing CHAPTER 7 2 If you want to reset the journal entry number for the new year s entries to 1 select the box or enter Y in text mode if not clear the box or enter N in text mode If you elect not to reset the entry number the new year s transactions will begin with the number following the last transaction number from the previous year Inquiry 3 Enter the retained earnings account to which you want to clear income statement account balances The range of account types that represent income statement accounts are cleared to the retained earnings account you specify here 4 If you want to copy next year budget to current year budget select the box or enter Y in text mode if not clear the box or enter N in text mode 5 If you want to zero next year budget balances select the box or enter Y in text mode if not clear the box or ente
211. nts function to create financial statements and reports Several income statements and balance sheets are provided with General Ledger customize them to suit your needs or design your own Financial Statements A financial statement consists of one statement layout and one statement content The Statement Layout function controls the width and placement of the columns and the type of balances to use The Statement Contents function controls the rows of the report and determines which accounts to include One statement content can be printed with several statement layouts Likewise one statement layout can be printed with several statement contents This flexibility allows for a great range of financial statements After statement layouts and contents have been set up use the Statements function page 6 9 to print the statements What Statement Layouts Regulate The statement layout determines 9 1 CHAPTER 9 Statement Maintenance how a statement looks e the types of information that go into the columns account numbers descriptions balances or calculations e the types of account balances that are included actual budget forecast next year budget or last year actual e the length of the reporting period the current period only the previous period only or number of periods relative to the current period calculated for the quarter to date year to date or for specified periods Planning and Examples
212. number The number of shares in that account is used in the ratio analysis to calculate earnings per share Account Masks Assign an account mask to each statement content Each company using a statement content must have the same account mask In addition to print consolidated statements you must assign the same account mask to each company that is included Printing Statements Use the Statements function see page 6 9 to print financial statements After printing a statement for the first time check the figures If you find errors use the Statement Layout and Statement Contents functions to make corrections General Ledger Setup Functions Setup CHAPTER 3 Batch Statements If some statements are routinely produced for the same companies you can set up the group of statements in a batch statements record Then instead of entering printing parameters each time you produce the statements enter the batch ID for the group of statements and the system uses the parameters set up in that record Initial Balances You must enter actual balances for each past period in the current fiscal year e To produce an audit trail of all the entries in the current fiscal year enter the individual transactions in the GL Journal and post them to the appropriate general ledger periods e To produce a less detailed audit trail enter one transaction for each account with activity in each period except the current one representing the total
213. o correct the general ledger account numbers in the other applications tables or files before you post entries again If you do not know an account number when you are setting it up enter the suspense account number instead so that the entries will not get lost You can reverse the transactions in the suspense account and enter them to the proper accounts anytime before you post to the GLMAxxx Master file General Ledger Common Questions APPENDIX B entered manual journal entries and or copied recurring entries but the entries are not listed in the GL Journal or the GL Activity Report Why not You must use the Write command in the Transactions function to write the entries to the GLJRxxx Journal file before they will be listed in the GL Journal or the GL Activity Report Reports and Statements When try to print reports and statements nothing happens Why is the printer not working Make sure that the printer is online the online indicator is lit and loaded with paper If you are still unable to print try these things Make sure that the printer cable is secure in both sockets Reset the printer turn it off and on e Reboot the computer If these things do not work check the OSAS Installation User s Guide to make sure that the printer is properly set up for the computer When try to print statements a message tells me that someone is already printing statements but no one is Why do I get this message
214. o distribute the income to more than one capital account for example if your company is a partnership you can use this procedure 1 Use the GL Accounts function page 8 15 to add an income summary account which will hold the net income temporarily 2 Use the GL Accounts function to enter the income summary account in the Clear To Account field of each revenue and expense account You can clear these accounts to the income summary account in one or several steps 3 When you have finished all the clearing steps the income summary account will have a credit balance showing the net profit for the year or a debit balance showing the net loss Use the Transactions function page 5 3 to credit or debit each capital account for the proper amount Then enter an offsetting debit or credit to the income summary account for the total amount distributed reducing that account s balance to zero General Ledger Clear and Close Last Year Periodic Processing CHAPTER 7 Clear and Close Last Year Screen General Ledger Select Clear and Close Last Year from the Periodic Processing menu The Clear and Close Last Year screen appears a 2007 Clear and Close Last Year Commands Edit Modes Other Help 2xa me mo e ee OK Abandon Clearing Step 1 Use Period 12 Company H 11 8 2007 Terminal Tooo INS If you have not used the Setup F9 command to access last year files the message This function can b
215. o include the workstation date and time select the box or enter Y in text mode if not clear the box or enter N in text mode General Ledger Cash Flow Statement Reports CHAPTER 6 Field Description Change Footers If you do not want to change the footer information clear the box or enter N in text mode If you want to change the footers check the box or enter Y in text mode The Statement Footers window appears The changes you make in the Statement Footers window are not permanent and affect only the statements you are preparing Statement Titles 1 4 Press Enter to use the titles that appear from the cash flow statement layout or enter a title for the statement Changes you make do not change the layout permanently If you entered more than one company ID you might want to use these fields to list the companies that are consolidated in the statement Select the output device to produce the statement See Reports on page 1 29 for more information on output devices After the Cash Flow Statement has been produced the Reports menu appears General Ledger 6 23 CHAPTER 6 Reports Cash Flow Statement Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Total adjustments Net cash provided by operations Cash flows from investing activities Net cash provided by investing activities Cash flows from financing activit
216. ode if not clear the box or enter N in text mode If you want to copy current year budget amounts select the box or enter Y in text mode if not clear the box or enter N in text mode If you want to copy next year budget amounts select the box or enter Yin text mode if not clear the box or enter N in text mode If you want to copy last year amounts select the box or enter Y in text mode if not clear the box or enter N in text mode If you want to copy forecast amounts select the box or enter Y in text mode if not clear the box or enter N in text mode If you want to replace existing accounts select the box or enter Y in text mode if not clear the box or enter N in text mode If you replace existing accounts the balances for those accounts are lost which might put the destination company s general ledger out of balance Making Corrections General Ledger If you copied more accounts than you wanted or if you need to change information in the accounts you copied use the GL Accounts function page 8 15 to change or delete the accounts 8 29 Allocations o MM If you enter transactions against one major account and then distribute them to several other accounts you can use the Allocations function to set up an allocation record for the major account You can specify each account to which transactions are allocated up to 45 and the percentage that each account receives The sum of the
217. of the chart of accounts for each company and a detailed list of the latest entries you need to make for each company You can use original documents check register invoices books of original entry and so on but make sure that you have all of them each company s entries must balance You can enter transactions for only one company at a time Before you select the Transactions function make sure that the menu screen shows the correct company and date see chapter 1 for information on changing the company ID and date General Ledger 5 3 CHAPTER 5 Journal Transactions Transactions Source Codes Each debit or credit has a two character source code which indicates the origin of the transaction You can use the source code to select the types of entries to include in the GL Journal and the GL Activity Report The default source code for entries made through the Transactions function is M1 You can change the second character to any other number or to a letter to distinguish the entry but the first character must be the letter M manual entry You can enter an accrual transaction with source code R1 if you want the system to reverse the transaction automatically see Automatic Reversal of Accrual Entries on page 5 5 for more information in the following GL period Here are some suggestions for assigning source codes e Assign special source codes for special entries for example use MY for year end audit adjustments
218. om one company Productivity Reports General Ledger includes a number of productivity reports in Microsoft Excel format These reports connect directly to your OSAS data via the ODBC JDBC driver included with OSAS 7 6 and allow you to use spreadsheet tools to manipulate the data as you want and produce charts and graphs to visualize trends The spreadsheet reports are listed on the Productivity Reports menu Double click areport name to automatically launch Excel or any other spreadsheet program capable of opening an Excel formatted spreadsheet to open the report Use the selection boxes to filter the information that appears in the report or use the tools within your spreadsheet software to create charts and graphs from the report s data 1 10 General Ledger Starting OSAS MM OSAS runs on an operating system supported by 150 MB of permanent storage and 4 MB of RAM You may need additional space or memory depending on the size of your data files and the operating system you use Consult your reseller for more information In Windows To start OSAS on a computer running Windows double click the OSAS shortcut on the desktop or access the program from the Start menu In Other To start OSAS on an operating system other than Windows enter osas at the Operating Operating system prompt If your operating system has graphical capabilities you Systems can also use the OSAS shortcut to start OSAS Using You can use the u c and t
219. on in a simpler text format and uses keyboard commands to access functions and move around the screen If you use an operating system that does not have graphical capabilities the text mode is the only mode available You can use either text or graphical function screens independently of the main menu For example you can use text function screens while using the graphical main menu and vice versa Select GUI Functions from the Modes menu or press Shift F6 to toggle between the text and graphical modes for function screens When available press Shift F5 to switch between graphical and text menu modes or press Shift F6 to switch between modes on function screens You can also use the Resource Manager Defaults function to select the default mode to use for the main menu and function screens In text mode use the Page Up Page Down arrow and Enter keys to move between menus select and enter functions and move around function screens When a list of commands appears at the bottom of a function screen press the highlighted letter to use acommand These methods also work in graphical mode or you can use the mouse to click on fields and command buttons Graphical Mode If you re familiar with other graphical software programs you ll find it easy to navigate around the OSAS graphical mode which uses buttons toolbars text entry boxes and menus to help you move through your tasks General Ledger 1 15 CHAPTER 1 Introduction Grap
220. on to change actual balances If you do you will put the ledger out of balance without leaving an audit trail Instead enter and post journal transactions to make the necessary changes Likewise do not use this function to change last year balances they are updated by the Create Last Year Data and Update Current Year functions The Edit current and last year balances in file maintenance option in the General Ledger Options and Interfaces controls your ability to edit current and last year actual balancesin this function See Options and Interfaces on page 3 7 for information about changing that option Prerequisites You must set up the account mask see Account Mask on page 8 3 before you can set up a company s chart of accounts You should also set up the account segment descriptions see Account Segments on page 8 9 before you enter General Ledger accounts General Ledger 8 15 CHAPTER 8 File Maintenance GL Accounts Account Number Structure Account numbers can consist of any combination of numbers letters and dashes but the account numbers must conform to the account mask To ensure that the accounts are organized correctly in reports and statements all the account numbers should be the same length Main account numbers should indicate significant groups assets liabilities equity revenues and expenses For example main account numbers 1000 to 1999 could be assets 2000 to 2999 could be liabiliti
221. or example Gas and Oil Expense Enter a reference to identify the type of transaction For example you might use GAS OIL to identify entries for gas and oil expenses Press Enter to accept the current date or enter a different date for the transaction The accounting period that corresponds to the transaction date appears Press Enter to post the transaction to that period or enter a different period General Ledger Transactions General Ledger Journal Transactions e CHAPTER 5 Field Description Source The source from the previous transaction appears Press Enter to accept it or enter a different source code The system uses R1 if R1 is not balanced The first character of the source code must be M except for automatically reversing accrual entries which must have source code R1 For more information see Source Codes on page 5 4 Allocate If you want the transaction to be allocated when it is posted select the box or enter Y in text mode if not clear the box or enter N in text mode The transaction is allocated only if an allocation record exists for the account you entered above Cash Flow If you want the transaction to be included in the Cash Transaction Flow Statement select the box or enter Y If you want the transaction to be excluded from the statement for example in the case of a correcting entry clear the box or enter N Exclude the transaction only if you are sure that itis a
222. ories current assets current liabilities and so on Print the sample statements to find which ones you can use You can produce both summary and detailed versions of each balance sheet and income statement by producing each layout ID with both content IDs General Ledger Statement Contents Statement Maintenance CHAPTER 9 When selecting layouts to use set up the contents so they use the appropriate account numbers Account numbers can be suppressed in the layouts to prevent them from appearing on statements To print consolidated statements for more than one company you may want to set up additional statement contents for that purpose To use the ratio analysis content RATI set up a special memo account in the chart of accounts to hold the number of shares of stock outstanding Then modify the content of RATI to identify the memo account number The number of shares in that account is used in the ratio analysis to calculate earnings per share Use a sample content as it is copy a sample content and modify it or use the samples as guides for creating your own contents Print one of the samples to use for reference while you read this section Previous Year Files The current year and the previous year files access the same GLSCF Statement Contents file Changes made to statement contents while working with previous year files also affect current year files and changes made to statement contents while working with current year
223. ort the statement into a text or CSV file choose Export to Text File from the Viewer menu e Click the printer tool button to print the statement e Press F5 to abandon the statement viewer and return to the Statements menu Press F7 to exit back to the main menu Statement Notes General Ledger A sample income statement balance sheet and ratio analysis are on the next pages The income statement balance sheet and ratio analysis are not consolidated statements The company could have been specified on the Statements screen or in the statement content If a statement or report is consolidated for several companies CONSOLIDATED prints in the position normally holding the company name The ratio analysis contains earnings per share information For this calculation to be performed the company s chart of accounts has a memo account that contains the number of shares outstanding That account must be identified in the statement contents so that a formula can be used in the content to divide net earnings by the number of shares in the account 6 17 CHAPTER 6 Reports Statements Income Statement 11 19 2007 12 05 PM FOR THE PERIOD FROM AUG 1 DESCRIPTION REVENUE RETAIL SALES INC FROM COMPLETED CONTRACTS DISCOUNTS ALLOWED FREIGHT OUT TOTAL REVENUE COST OF GOODS SOLD COST OF GOODS SOLD RETAIL COST OF GOODS SOLD CONTRACTS FREIGHT IN INVENTORY VARIANCE TOTAL COST OF GOODS SOLD GROSS PROFIT
224. ost status e cash flow status e the account s balance for unposted transactions e the account s beginning balance for the specified period e the account s balance for posted transactions e account s ending balance for the specified period e Press O to go to a specific transaction e Press T to view the totals information for the selected GL account For more information about the fields See Transactions on page 5 3 You can press Shift F3 or double click on any line in which amounts appear in blue to drill down for more information When you drill down from a drillable transaction in the Transaction Inquiry screen you ll see the associated historical information from the source application When you are finished looking at the GL Transaction Inquiry screen use the Exit F7 command to return to the main menu 4 8 General Ledger CHAPTER5 Transactions Import Transactions Copy Recurring Entries GL Journal GL Activity Report Edit Transactions Post to Master General Ledger 5 3 5 13 5 15 5 19 5 23 5 27 5 31 Journal Transactions Introduction The functions explained in this chapter constitute the daily work portion of General Ledger You might or might not enter allthe General Ledger Journal transactions through the Journal Transactions functions other applications such as Accounts Payable and Accounts Receivable can update the General Ledger system eliminating the need to enter transact
225. other application the application initials appears for example if the transaction was posted from Fixed Assets FA appears If the transaction will be allocated when it is posted the box is selected or Y appears in text mode if not the box is cleared or N appears in text mode If the transaction will be included in the Cash Flow Statement the box is selected or Y appears in text mode If the transaction that affects cash flow will be excluded from the Cash Flow Statement for example in the case of a correcting entry the box is cleared or N appears in text mode Use the Proceed OK command to save your changes and return to the Edit Transactions screen Continue editing transactions if necessary then use the Exit F7 command to return to the Journal Transactions menu when you are finished 5 30 General Ledger Post to Master ooo MW Use the Post to Master function to post the transactions in the GLJRxxx Journal file to the specified account in the GLMAxxx Master file for a range of periods Post the transactions before you produce financial statements or reports You can post as often as you like the system never posts the same transaction twice For each transaction you have allocated the system distributes the transaction to the accounts in the allocation record according to the percentages specified Before Posting Before you post complete these tasks e Ifyou have a multiuser system make
226. ou enter a different description in the Description field Enter AS to add balances of the specified accounts and print the total balances in the appropriate columns Then enter a description of the line to print in the Description field Enter BB to print the beginning balances for individual accounts for the year Enter BD to list individually the account number and its beginning balance in the specified range The beginning balance is determined by the As Of When and How Far Back fields in the statement layout Enter BS to add and print the total beginning balances for the specified accounts Enter CR to shift numeric columns of the following lines to the right Enter CL to shift the columns back to the left 9 26 General Ledger Statement Contents General Ledger Field Statement Maintenance CHAPTER 9 Description Enter the number of spaces to shift the columns in the Number of Chars to Shift field Because columns are shifted only if the statement layout allows it you can use the same statement content with or without the column shift Enter ED to print the individual account numbers and the ending balances in the specified range Enter ES to add and print the total ending balances of the specified accounts Enter HC to center a line of text between the report s margins The cursor moves to the Description field Enter HP to print text in the row specified by the sequence number The cursor goes to th
227. ou want to delete Then use the Proceed OK command to begin deletion When the deletion is finished the Periodic Processing menu appears 7 28 General Ledger CHAPTER 8 Account Mask Account Segments Account Types GL Accounts Account Budgets Budget Import Copy Chart of Accounts Allocations Recurring Entries Tables Copy Account Balances Assign Account Types Change Fields Import Definition General Ledger 8 3 8 13 8 15 8 21 8 25 8 27 8 31 8 35 8 41 8 45 8 47 8 49 8 55 File Maintenance 8 1 Account Mask o M Use the Account Mask function to define or change a company s account numbering structure An account mask can consist of four segments main account number division department and subaccount The main account number segment is required the other segments are optional The segments can be arranged in any order Uses of Masks Account segments simplify financial reporting and statement setup For example you can use segments to show information in financial statements for individual divisions departments and subaccounts or you can combine account segments into a main account You can produce a financial statement for only one division or a side by side statement for two or more divisions Mask Formats For each segment you use specify its starting position in the account number and its length For example if the first four characters in the account number are the main account
228. ount enter the number of the account you want to copy Enter the account type Enter the description of the account as you want it to appear in reports and on statements Select Inactive to make the account unable to accept new entries For a debit account enter D For a credit account enter C For a memo account enter M If the account will not be cleared at the end of the year make sure that this field is blank Then press Enter to skip it For a revenue or an expense account enter the number of the account you will clear the account to during year end closing see page 7 9 for more information If you did not enter an account to clear this one to press Enter to skip this field If you entered an account to clear the account to at the end of the year enter the step in which you want to close the account If the account will be consolidated with an account that is on a different computer see page 7 21 enter the account number with which this account will be consolidated If the account numbers are the same or if this account will not be consolidated with another make sure that this field is blank then press Enter General Ledger GL Accounts General Ledger Field Step Alternate Budget Entry Method Period Begin 1 13 File Maintenance CHAPTER 8 Description If the account will be consolidated with an account that is on a different computer enter the step in which the consolidation will ta
229. ount masks blank Then you can produce a financial statement that uses this layout for any company If you want to use the layout for all companies and accounts press Enter If you want to select a company or all companies when you produce a financial statement that uses this layout enter a question mark If you want to assign the layout to one company enter the company ID If you enter or a company ID you must enter at least one of six account masks allowed for the companies that use the layout When you print a side by side financial statement for all companies or for all companies specified in the layout s Company field all the companies whose account masks match one of the masks assigned to the layout are combined in the statement You can use question marks as wildcard characters to match specific characters in an account mask For example you might enter 02 to match all six character account numbers with 02 in the fifth and sixth character positions 9 10 General Ledger Calculations General Ledger Statement Maintenance CHAPTER 9 If the column contains formulas enter this information Field Formula Description The amount printed in a formula column type 6 or 7 is calculated from amounts in previous columns or in totals according to the formula you enter here You can enter only numbers and symbols that specify arithmetic operations You can use four operations add subtract
230. ource Manager Press Enter to use those dates or enter different dates The system uses the most recent account balances for the selected period regardless of the dates you enter If you enter different dates they appear in the statement title and footers if you elected to print dates in the statement layout You can enter 20 company IDs After you have entered the ID of the last company press Enter To print a consolidated statement for the companies set up in the statement content press Enter to skip this field If you enter a company ID the statement content ID you use must not have company IDs specified in it If you leave this field blank the statement content you use must have a company ID specified in it 6 11 CHAPTER 6 Reports 6 12 Field Pick Division Department Subaccount From Thru Print Segment Detail Segment Sort Print Accounts With Zero Balances Print Workstation Date and Time Statements Description If your account mask does not include one or more of these segments the appropriate fields are skipped Enter the range of account segments you want in the report To include all the account segments leave the From and Thru fields blank If you are not printing consolidated statements select the box or enter Y in text mode to break the information down for each account segment Clear the box or enter N in text mode to summarize the information for all segments of an ac
231. parameters in OSAS shortcut properties or after the Parameters osas command so that the system automatically uses the appropriate user ID and company ID to save time logging in In Windows open the OSAS shortcut s properties and enter these parameters after the path in the Target field as in the example below be sure to use the correct directories for your system C basis bin bbj exe osasstrt txt q tT00 cD osas70 progrm config bbx uSam cH Note In Windows the u and c parameters must follow the separation dash In other operating systems enter the parameters after the osas command as in this example osas t T2 c B apple Note You can enter these parameters in any order but you must leave a space between the parameter mark t or c and the parameter itself General Ledger 1 11 CHAPTER 1 Introduction Starting OSAS Logging In Refer to the Resource Manager User s Guide for more information on these parameters After you start OSAS the login screen appears version 7 6 Copyright 1982 2010 This program is protected by U S and International copyright laws To log in to OSAS enter your User ID the Company ID you want to work with and your Password If you want to save your password so that you do not need to enter it again select the Save Password check box or enter Y in text mode to save your information This check box appears only if the Remember Password option is select
232. phical or text function screens in certain applications and gives you access to additional information about a customer vendor item job bill of material or employee The commands available on the Information menu are determined by the applications you have installed and can include CHAPTER 1 Introduction Navigating OSAS Favorites Menu 1 20 e General Information Comments e History e Documents e Address Lookup Not all of the commands above appear on every Information menu instead commands are available only as they are relevant to the task you are performing For example if you are entering a transaction in Accounts Receivable you can access comments or documents about items or customers but not about employees or vendors Consult Appendix A in the Resource Manager User s Guide for more information on how to use the functions on the Information menu The Favorites menu gives you quick access to the OSAS functions you use most by allowing you to add selections for entire menus or particular functions to a custom menu After you ve set up the menu select Change to Favorites from the graphical Favorites menu or press F2 to access the functions The Favorites menu saves you time by eliminating the need to switch between applications You can add functions from several different applications to the Favorites menu and access them all there rather than switching between applications on the main menu to access the fun
233. pping and Receiving For several General Ledger reports you can select ranges of divisions departments and subaccounts and you can specify the order of the account segments The descriptions you assign in the GLSExxx file appear in the report headers See Account Segments on page 8 9 for more information about account segments Account Types Account types are used to group accounts together for the purpose of producing statements such as cash flow and trial balance Each account type has an account class and code associated with it The class is the general category an account type fits into for example long term asset current asset or long term liability The code denotes whether the account is a credit debit or memo account See Account Types on page 8 13 for more information about account types Chart of Accounts Before processing data in General Ledger set up the chart of accounts A well planned chart of accounts makes the General Ledger system easy to use requires little maintenance and can be expanded as a business grows Take time to figure out the best account structure for your present and future needs General Ledger 3 11 CHAPTER 3 Setup Setup Functions 3 12 If you interface General Ledger with other OPEN SYSTEMS Accounting Software applications see the appropriate user s manual for information about the accounts you will need to post entries from Make sure that the General Ledger tables
234. r N in text mode 6 If you want to copy inactive accounts with zero balances select the box or enter Y in text mode if not clear the box or enter N in text mode 7 The year that the current GL year will be after the Create Last Year Data procedure is complete is displayed on the bottom of the screen Be sure this 1s the year you want before you proceed 8 Select the output device to print the Clearing Log See Reports on page 1 29 for more information on output devices This log shows all changes made to the income statement account balances Check the log to make sure that everything is correct After Creating Last Year Data After you have created the last year files for a company you can begin processing the new year s data while you finish processing the old year s data General Ledger 7 7 CHAPTER 7 Periodic Processing Create Last Year Data To access prior year files for acompany use the Setup F9 command at any General Ledger menu and select the year you want to access For last year data you can use any General Ledger function except Create Last Year Data and Copy Chart of Accounts For any year before last year you can produce reports and statements but you cannot change any data When you are finished entering and posting last year transactions and printing statements and reports you are ready to use the Clear and Close Last Year function see page 7 9 Clearing Log 7 8 12 31 2007 Begin
235. r applications against the GL Journal to make sure that every debit and credit gets posted General Ledger Journal 08 19 2007 Builders Supply Period 01 Thru 12 11 19 AM GENERAL LEDGER JOURNAL Company H 12 19 07 Post Date GL Account Description Cflow Ref 12 18 2007 806000 Tax loc CA cls 03 12 18 2007 806000 Tax loc CA cls 03 12 18 2007 806000 Tax loc CA cls 03 12 18 2007 200000 AD 12 18 2007 104400 GOODS RCVD IN Accrual 12 18 2007 200000 GOODS RCVD AP Accrual 12 18 2007 806000 GOODS RCVD Exp Accrual 12 18 2007 104400 INV RCVD IN Accrual 12 18 2007 200000 INV RCVD AP Accrual ENDING BALANCE PERIOD 12 BALANCE End of Report General Ledger 5 21 GL Activity Report o MM The GL Activity Report lists the transactions under the accounts they belong to and the ending period balances of each account If you print the report at the end of each period or for a range of periods you can see how much activity an account has had during that time how much the balance has changed and which transactions have affected it How to Use This Report The GL Activity Report can serve several purposes e Produce the report for information pertaining only to accounts that showed activity for one period or a range of periods in this case the report will be short e Produce the report for all accounts for one period or a range of periods regardless of whether or not some of the accounts showed activity in this case the report cou
236. r the report is produced the Reports menu appears Audit Trial Balance Worksheet 11 19 2007 Builders Supply 11 59 AM Company H AUDIT TRIAL BALANCE August 19 2007 Adjustments GL Account Description Last Year Current Year Credit Ending Balance 535000 INSURANCE EXPENSE 535001 INSURANCE EXPENSE 535002 INSURANCE EXPENSE 19 431 535003 INSURANCE EXPENSE 16 283 801000 OTHER INCOME 22 418 802000 FINANCE CHARGES ASSESSED 572 804000 DISCOUNTS TAKEN s Do 805000 INTEREST EXPENSE 152 715 806000 OTHER EXPENSES x 16 826 851000 FEDERAL INCOME TAX EXPENSE X Do 852000 STATE INCOME TAX EXPENSE 999800 SHARES OUTSTANDING 999900 SUSPENSE BALANCE End of Report 6 8 General Ledger Statements o MM Use the Statements function to produce balance sheets income statements and ratio analyses You will probably want to produce statements every period for every company You can use the Statements function to produce consolidated statements for 20 companies If you frequently print the same statements for the same company use the Batch Statements function to set up the printing parameters for the group of statements in a batch statements record Then when you print statements you simply enter the batch statement ID the system prints the statements set up in the batch statements record Before You Begin Before you use the Statements function for the
237. ransactions After you establish the valid codes and IDs through the File Maintenance functions use the Journal Transactions functions to do daily work entering transactions producing daily reports and so forth These functions update account information in the system but the automatic updates from interfaced applications may render these functions unnecessary The functions are here so that you can always update General Ledger information manually or through other applications If General Ledger interfaces with other applications be wary when you enter information in these functions Entering duplicate information in General Ledger that has been posted from another application can throw the system out of balance For example when you receive 100 for a sale enter the transaction in Accounts Receivable which is interfaced with General Ledger assign a GL account and then post it in Accounts Receivable the balance of the account you specified is updated in General Ledger Then if the same 100 debit is entered in the Transactions function and posted the system debits the 100 twice Reports Use the Reports functions to produce summarized information about cash flow trial balances and other financial reports Periodic Processing After doing daily work and producing reports you can use the Periodic Processing functions to create last year data consolidate information in the GLMAxxx Master file and remove information from a
238. ransactions To fix an incorrect transaction that has not been posted to the GLMAxxx file use the Edit Transactions function To fix a transaction that has been posted to the GLMAxxx file reverse the transaction and reenter it correctly through the Transactions function page 5 3 When you edit transactions the GL Journal is the only audit trail of the changes You may prefer to enter reversing transactions rather than editing transactions so that your actions have a permanent record in the GLMAxxx file Printing the GL Journal Print the GL Journal before and after you edit transactions so that you have an audit trail of the transactions you changed You also need the GL Journal to find the entry numbers of the transactions you want to edit General Ledger 5 27 CHAPTER 5 Journal Transactions Edit Transactions Edit Transactions Screen Select Edit Transactions from the Journal Transactions menu This screen appears FEN 2007 Edit Transactions eel Commands Edit Modes Other Scroll Commands Help RX Xx tu u a E 28 e OK Abandon GL Account Debit Credit Reference Pd Cflw Description Date Src Allc 11838 80 A R B SALES 12 03 2007 AR m le 501000 6934 94 AIR 12 m COST OF SALES 12 03 2007 AR Ww 100000 12388 25 AIR 12 W CASH SALES 12 03 2007 AR v 203800 549 45 WR 12 El SALES TAX 12 03 2007 AR
239. ring conversion 2 4 fill characters 3 10 format 3 10 main 3 12 structure 3 12 8 16 sorts 8 6 user defined 3 10 Account Budgets function 3 14 8 21 Account Mask assigning to Statement Contents 9 31 backing up files before using 3 22 before conversion 2 5 changing 2 5 8 7 examples 3 10 8 4 file 1 6 fill characters 8 4 for consolidation 7 22 for previous year files 8 5 formats 8 3 function 5 20 5 24 6 4 6 7 8 3 in Statement Contents 9 23 9 29 in Statement Layout 9 10 protecting with roles 3 21 reassigning in Statement Contents 9 31 segments in 8 3 setup 3 5 3 9 3 18 8 15 structure 3 12 Account Segments deleting 8 11 file 1 6 fill characters 3 10 function 1 5 1 6 8 9 in account masks 3 9 8 3 previous year files 8 9 setup 3 5 3 10 8 15 Account Segments List function 10 5 Account Types account class 8 13 after conversion 2 4 changed during conversion 2 4 changing 2 4 changing memo account types 2 4 file 1 6 function 1 5 6 4 8 13 setup 3 5 3 11 Account Types List function 10 7 accounts out of order Chart of Accounts List 10 9 Accounts Payable 3 15 5 3 8 35 Accounts Receivable 1 8 5 3 interface with General Ledger 1 4 1 8 accrual entries automatic reversal of 5 5 IX 1 INDEX Active Financial Statements 6 10 Active Financials Statement Viewer 6 16 6 18 Activity and Balance Results example 9 32 actual balances 3 13 setup 3 19 Address Loo
240. roles on your system You can set up roles for the General Ledger system itself for menus in the system and for individual functions To control users access to menus and functions you can set up an roles for each user or group of users that performs the same functions Different Roles for Each Company Roles are company specific When you set up arole the role is assigned the company you are in Because the roles are company specific you must set up roles for each company a user needs to access What Should Be Protected Because of the sensitive nature of the GLJRxxx file the GLMAxxx file and the information available through the statements you should limit access to the following functions e Account Mask e GL Accounts e Copy Chart of Accounts e Transactions e Copy Recurring Entries e Edit Transactions e Post to Master e Trial Balance e Audit Trial Balance e Statements e Create Last Year Data 3 21 CHAPTER 3 Setup Setup Functions Clear and Close Last Year e Update Current Year e Consolidate Master Files For more information about roles see the Resource Manager User s Guide Forced Balance Password The system also provides a forced balance password which lets you exit from transaction entry functions in out of balance situations You can exit from out of balance transactions without the password but you cannot write transactions to the journal Backup Schedule 3 22 Plan a backup sche
241. rs in account segments you cannot use question marks in your account numbers BASIC ERROR nn LINE nnnn PROGRAM xxxxxx A 2 A serious error has occurred Write down the information that appears and get help from a support technician General Ledger System Messages APPENDIX A Batch ID xxxxxx exists Do you want to overwrite it The batch ID to which you are copying a batch statement record already exists If you want to overwrite the existing record select Yes or enter Y in text mode If you do not want to overwrite it select No or enter N in text mode then enter a different batch ID Batch ID xxxxxx is not on file The batch ID is not on file Enter a different ID or use the Inquiry F2 command to look up and select an ID from the list that appears Cannot find xxxxxx files for this company No files for the year are specified for this company Use the Create Last Year Data function see on page 7 5 to create last year files for the company or use the Setup F9 command to access available year files Cannot find last year Master file for Company xxx A last year GLMAxxx Master file does not exist for the company You cannot use this function for the company until you have created last year data files Cannot print this Report Definition for this period The system cannot print the statement because the statement layout you selected specifies information that conflicts with the current period Here ar
242. rs next to fields to navigate to directories and files and automatically enter file paths into that field Click the Browse button to open the Select Directory File screen then navigate to the directory or file and click Open to automatically enter the file path in the field Inquiry The Inquiry command helps you look up and select valid entries for fields that are connected to master file records For example when you use the Inquiry command in a Batch ID field OSAS lists all batches you have set up so that you can select the one you want to enter in that field When the Inquiry button appears next to a field you can either click the button or press F2 to open the Inquiry screen and search for valid entries Maintenance The Maintenance command allows you to enter or edit master file records on the fly from within functions For example you can use the Maintenance command to add a new customer or item from within the Transactions function The Maintenance command is available when the Maintenance button appears on the toolbar Click the button or press F6 to open the File Maintenance function associated with that field and enter or edit a new master file record Address Mapping When you are working with a screen that contains an address you can use the Address Mapping command to view a map of that address This command combines address information with the URL and search variables in the Resource Manager Web Setup function and the Map
243. s cls cls cls cls cls cls cls cls cls cls cls cls GOODS RCVD Exp INV RCVD Exp Accrual SUSPEN SE Credit Union Dues 00 03 00 00 00 00 00 00 00 00 00 00 00 00 Accrual Builders Supply ACTIVITY REPORT GENERAL LEDGER 12 19 07 Sorted by Main Account Number Entry Per Srce Cflow Ref 1374 1375 06 Ml Yes ENDING BALANCE PERIOD 06 07 Ml Yes ENDING BALANCE PERIOD 07 Period 08 Adjusting Entry 1376 1389 1390 1391 1392 1393 1394 1673 1674 1675 1676 1677 1678 1679 1680 1684 1687 08 Ml 08 AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP os AP AP ENDING BALANCE PERIOD ENDING BALANCE PERIOD ENDING BALANCE PERIOD 08 PA Yes PAYROLL os PA Yes PAYROLL ENDING BALANCE PERIOD 08 ACTIVITY BALANCE GL BALANCE 7 721 65 1 210 67 8 932 32 1 305 69 10 238 01 1 842 10 72 70 525 83 20 00 8 00 2 13 8 00 20 00 8 00 2 00 950 00 12 776 64 0 00 0 00 0 00 4 006 192 53 13 619 549 83 Credit 60 00 15 00 75 00 4 006 192 56 13 619 549 86 General Ledger Edit Transactions MM Use the Edit Transactions function to change transactions that have not been posted to the GLMAxxx Master file You can change any field except the source code Because you cannot edit entries that have been posted only unposted entries appear Editing vs Reversing T
244. s an asterisk in the From Thru fields after the selection General Ledger 1 29 CHAPTER 1 Introduction Reports Sorting Each field where you enter information on a report screen usually restricts the overall output of the report For example if you leave the Vendor ID From and Thru fields blank the report contains information about all the vendors But if you enter invoice 100 in the Invoice Number From and Thru fields and invoice 100 is assigned only to vendor ACE001 the report includes information only about vendor ACE0O1 Information for reports is sorted first by a space _ then by special characters then by digits then by uppercase letters and finally by lowercase letters No matter what you enter in the From and Thru fields however your entries are sorted in alphabetical order unless the function provides an option to sort the information differently Sorting by alphabetical codes or IDs is easy For example the ID ACL comes before the ID BB because A comes before B Use caution when you enter codes or IDs consisting of characters other than letters the order might not be what you expect For example if 20 items are labeled 1 through 20 and all are included in a report you might enter 1 at From and 20 at Thru expecting them to be listed 1 2 3 19 20 However since OSAS sorts in alphabetical order rather than numerical order the numbers are listed in this order 1 10 19 2 20 In this example numbers 3
245. s set of parameters or 1f you are working with an existing record enter the sequence code you want to work with Enter a description of the batch statement record Enter the ID of the statement layout and statement contents for which you want to set up printing parameters 9 37 CHAPTER 9 Statement Maintenance Batch Statements Field Description Period 1 13 If you want to specify the period when you print the statement leave this field blank If you want to print the statement for only one period enter the period Beginning Ending If you did not enter a period these fields are skipped Date If you entered a period the beginning and ending dates for that period appear from the CNVTxxx Period Conversion table in Resource Manager Press Enter to accept the dates or enter different dates The system uses the most recent account balances for the selected period regardless of the dates you enter If you enter different dates they will appear in the statement title and footers Inquiry Company ID If you want to specify the company ID s when you print the statement enter a question mark If you want to assign company IDs to the statement up to 10 enter each company ID When you are finished assigning company IDs press Enter at a blank Company ID field Inquiry Pick Division If you are not using one or more of these account Department number segments the fields for the unused Subaccount From segment
246. sage will appear At the end of the statement values that exceed this limit are marked with asterisks in the statement printout You can print signs in five ways depending on the sign characters you use in the format Print a dollar sign to the left of the farthest numeric placeholder If you place the dollar sign outside the parentheses you can choose to print the dollar sign or not as defined in the statement content If you place the sign inside the parentheses it always prints with the value Print a negative sign next to credit balances in debit accounts and debit balances in credit accounts You can enter the sign to the left or the right of the number format Print a negative sign as described above and print a positive sign next to credit balances in credit accounts and debit balances in debit accounts left or right Print parentheses around debit balances in credit accounts and credit balances in debit accounts CR Print the letters CR to the right of credit balances in debit accounts 9 14 General Ledger Statement Maintenance CHAPTER 9 Field Description Here are some examples of numeric formats 00 Print a number up to 9999 99 with a dollar sign to the left If the number is a credit in a debit account or a debit in a credit account print a negative sign to the right 00 Print a number up to 999 99 with a positive sign or a negative sign to the left 00CR Print a numb
247. sk for a statement content a new account mask record 1s created for the content ID and all the sequences in the content are updated to use the mask General Ledger 9 31 CHAPTER 9 Statement Maintenance Period or Quarter Current Pd This Pd Only Result Current Pd QTD Result 9 32 Statement Contents For example if content ABC is assigned to mask MMMM four characters in the main account segment and you reassign mask MMMM11 four characters in the main account segment and two characters in the division segment to it the account numbers in the appropriate sequences will be changed from XXXX where X represents each position in the main account segment to XXXX where X represents each position in the main account segment and represents each position in the division segment Notes on Activity and Balance Results In the following chart period 8 is used as an example The result is printed at the bottom of each box Activity is defined as the amounts that each period or quarter have It represents the total transactions for a specified period or quarter Balance is defined as the beginning balance plus activity It represents cumulative transactions at a particular time Activity Detail or Summary Print activity for specified period period 8 activity Print QTD activity for specified period period 7 8 activity Balance Detail or Summary Print beginning balance for specified period per
248. sure that no one else is using the GLJRxxx or GLMAxxx files e Ifyou are going to print the GL Posting Log make sure that the printer is online e Print the GL Journal and the GL Activity Report and check them to make sure that everything is correct and that the debits and credits are in balance e Back up the data files in case unforeseen problems such as a power surge or failure interrupt the post and result in the loss of data General Ledger 5 31 CHAPTER 5 Journal Transactions Post to Master Post to Master Screen Select Post to Master from the Journal Transactions menu This screen appears TIEN 2007 Post to Master casy Commands Edit Modes Other Help 2 gt xtu oa ma 0 e6 Pick Period From 9 Thru 12 Source Code From Thru Are You Posting Allocated Transactions Y Do You Want To Print Totals For Each Period v Do You Want To Print Detail Y Company H 1118 2007 Terminal T000 OVR 1 Enter the range of periods to which you want to post transactions 2 Enter the range of source codes to which you want to post transactions 3 If you are posting allocated transactions select the box or enter Y in text mode if not clear the box or enter N in text mode If you elect to post allocations the post takes longer because the system checks every unposted transaction in the range of periods you selected to see whether it is allocated If you elect not to post allocations and there are
249. t If you want to use the footer information as specified in the statement layout clear the box or enter N in text mode If you want to change the footers select the box or enter Y in text mode The Statement Footers window appears The changes you make in the Statement Footers window are not permanent and affect only the statements you are preparing If you display the statement on the screen the footer prints only on the last page Select the output device to begin printing the statements See Reports on page 1 29 for more information on output devices After the statements are produced the Reports menu appears Comma Separated Text File General Ledger If you are printing a statement not a group of statements set up in a batch statements record you can elect to export the report to a comma separated text file You can then open this file directly using Microsoft Excel or import the file into other productivity software packages 6 13 CHAPTER 6 Reports Statements To export the statement to a comma separated text file select text as the output device then enter the output destination and file name If you use commas as the separator character do not add an extension General Ledger creates the file and adds a CSV extension The extension stands for Comma Separated Variables and 1s recognized by Microsoft Excel and other productivity software packages If you do not use commas as separator characters Gener
250. t Reverse Sign select the box or enter Y in text mode if not clear Printing the box or enter N in text mode Select the output device for the report See Reports on page 1 29 for more information on output devices After the report is produced the Statement Maintenance menu appears General Ledger Financial Statement Verification Statement Maintenance CHAPTER 9 Financial Statement Verification Report 08 23 2007 12 36 PM Account Account Account Account Account Number Number Number Number Number End of Report General Ledger 100000 100100 100500 999800 999900 Builders Supply Financial Statement Content ID company H company H company H company H company H Verification BALL duplicated 2 time s duplicated 2 time s duplicated 2 time s excluded from the report excluded from the report 9 51 CHAPTER 10 Printing a Master File List 10 1 Account Segments List 10 5 Account Types List 10 7 Chart of Accounts List 10 9 Allocations List 10 11 Recurring Entries List 10 13 Statement Layout List 10 15 Statement Contents List 10 17 Batch Statements List 10 19 Cash Flow Contents List 10 21 Tables List 10 23 GL Account Audit Report 10 25 General Ledger Master File Lists Printing a Master File List The functions on the Master File Lists menu let you print lists of the information you entered using the File Maintenance menu These lists do not contain any calc
251. t can be printed with several statement contents For example a company s balance sheet statement content BAL1 can be printed with statement layouts BALA and BALF This flexibility allows for a great range of financial statements Layouts Use the Statement Layouts function to control the width and placement of the columns and to determine the type of balances to use The General Ledger application contains the following sample statement layouts Layout ID Description Balance Sheets BALA Budget Comparison BALB Last Year Comparison BALC Budget and Last Year Comparison BALD Change from Last Year BALE Balance Sheet BALF Balance Sheet BALG Six Month Comparison Layout ID Description Income Statements INCA Budget Comparison current Y TD INCB Last Year Comparison current Y TD INCC Budget Comparison current QTD YTD INCD Last Year Comparison current QTD YTD General Ledger Setup Functions Setup CHAPTER 3 INCE Budget Last Year Comparison current YTD INCF Budget Variance current YTD INCG Last Year Variance current YTD INCH Budget Variance current QTD YTD INCI Last Year Variance current VQTD YTD INCJ Current Period Previous Period YTD INCK Current Period YTD INCL Current Period QTD YTD INCM YTD Divisional Side by Side Comparison INCN Divisional Side by Side Comparison INCO Companies Side by Side INCP Six Month Comparison RATA Ratio Analysis Year to date YTD statements use 13 accounting periods qu
252. t layout you want to delete 2 Select Yes or use the Delete F3 command to confirm that you want to delete the statement layout The message Press any key to continue appears after the layout is deleted Press any key to return to the Delete Statement Layout ID field 3 Enter the next statement layout ID you want to delete or exit to the Statement Layout menu General Ledger 9 19 Statement Contents o MM Use the Statement Contents function in conjunction with the Statement Layout function to create financial statements and reports Several income statements and balance sheets are provided with General Ledger customize them to suit your needs or design your own Financial Statements A financial statement consists of one statement layout and one statement content The Statement Layout function controls the width and placement of the columns and the type of balances to use The Statement Contents function controls the rows of the report and determines which accounts to include One statement content can be printed with several statement layouts Likewise one statement layout can be printed with several statement contents This flexibility allows for a great range of financial statements After statement layouts and contents have been set up use the Statements function page 6 9 to print the statements What Statement Contents Regulate In the statement contents you can e specify the account mask to use e specify the ac
253. tail Goto Company H 127232007 TerminalTooo OVR Select the period as of which you would like to see the account balances Use these commands to view transaction information or change the account e Press T to toggle between the Actual Budget Last Year s LY Balance Forecast and Next Year s NY Balance account views e Press Dto view specific account detail for the highlighted account e Press Gto highlight a specific account by entering its GL Account number General Ledger 4 3 CHAPTER 4 Information Inquiry Chart of Accounts Inquiry 4 4 You can press Shift F3 or double click on any line in which amounts appear in blue to drill down for more information When you drill down from the Chart of Accounts Inquiry screen you ll see the period balances for the associated account When you are finished looking at the GL Chart of Accounts Inquiry screen use the Exit F7 command to return to the main menu General Ledger Accounts Inquiry o M General Ledger Select Accounts Inquiry from the Information Inquiry menu The Accounts Inquiry screen appears Baene a In gt gt Commands Edit Modes Other Scroll Commands Help 2xo ma mo 206 ee OK GL Account 101000 4 ACCOUNTS RECEIVABLE Status Active Acct Type 020 Accounts Receivable DB CR Memo Debit GL Pd Actual Budget Last Year Forecast 1215
254. ter 9 Statement Maintenance Statement Contents Batch Statements oooo o o Cash Flow ContentS Financial Statement Verification Chapter 10 Master File Lists Account Segments List Account Types List Chart of Accounts List Allocations LiSt o o ooo Recurring Entries List General Ledger CONTENTS Statement Layout LiSt o ooo ooooooooooo o 10 15 Statement Contents List ooooo o oo 10 17 Batch Statements LiSt o oooo o 10 19 Cash Flow Contents LisSt 10 21 Tables asta ra area 10 23 GL Account Audit Report o o oo o oo 10 25 General Ledger v CHAPTER 1 Welcome to OSAS 1 1 The General Ledger System 1 3 Starting OSAS 1 11 Navigating OSAS 1 15 Reports 1 29 General Ledger Introduction Welcome to OSAS Welcome to the General Ledger application for OPEN SYSTEMS Accounting Software OSAS General Ledger helps you set up accounts and produce statements to track your company s debit and credit information While you can use General Ledger alone it works best when you interface it with other OSAS applications When you interface General Ledger with other applications those applications automatically create entries in the appropriate accounts to track debits and credits to track cash flow General Ledger plugs into Resource Ma
255. th or monospaced font Courier Letter Gothic or Lucida Console for example View the Report on Screen Text Screens Only If you use text screens you can view selected reports directly in the OSAS screen Keep in mind that this option displays the report one page at a time storing previously viewed pages in the workstation s memory Use the Preferences function on the Resource Manager User Setup menu to limit the number of screen pages you can view to conserve memory resources Follow these steps to view the report on screen 1 Enter S to select S creen 2 When available enter S if you want to view the report in standard width or C 1f you want to view it in compressed width 3 When the report appears press Enter to view the next page or Page Up to view previous pages General Ledger 1 33 CHAPTER 1 Introduction Reports 1 34 E mail the Report Before you can e mail reports you must enter details about your e mail system using the E Mail Setup function on the Resource Manager Installation and Configuration menu You can e mail only selected reports In general any report or form that makes up part of your audit trail cannot be e mailed Follow these steps to e mail a report 1 Select E mail or enter M The E Mail Information screen appears EN E Mail Information Gleo w Commands Edit Modes Other Scroll Commands Help RX tz em 2 amp OK Abandon E Mail From samd builders_supply com
256. the column e current period e previous period e previous quarter e current activity relative to the period e year to date relative to the printed period e selected at print time e year end balances If you entered 1 2 or 3 in the As Of When field select one of these values e use the balance for the selected period only e use the quarter to date balance e use the year to date balance The year to date balance is the sum of the changes in the balances in every period through the one specified in the As Of When field plus the beginning balance If you entered a relative balance in the As Of When field select one of these values e use the balance for the selected period only e use the quarter to date balance e use the year to date balance Enter the year for the data you want printed in this column If you leave this field blank the system uses the current year 9 9 CHAPTER 9 Statement Maintenance Field Description Company If you entered 3 4 5 8 or 9 in the What Is In The Column field you can specify the company whose account balances will appear in the column This feature enables you to show different companies or divisions departments or subaccounts accounts in a side by side format You can also combine accounts from more than one company on the statement If the layout you are defining will not show companies and account segments in side by side columns leave this field and the acc
257. the period balances see Initial Balances below and then post them to the GLMAxxx file e Ifyou want to save time and if you do not need a complete audit trail of your entries enter the beginning balance and all the account balances If you print the GL Activity Report after you enter these balances the message Missing Entries is printed for each account that has a period balance different from the beginning balance You can ignore the message Budget and Last Year Balances After you enter or skip each period actual balance you can enter the period budget balance for the current year budget if any Then after you enter or skip the period budget balance you can enter the period last year balance General Ledger 3 13 CHAPTER 3 Setup Setup Functions Use the Account Budgets function see page 8 21 to enter budget and forecast balances using special formulas To print comparative income statements or balance sheets you must enter the last year beginning and period balances Consolidation Use the Consol To Account and Step fields to print consolidated statements for companies that are on different computers or to combine multiple companies on the same computer system into one company for reporting purposes Trial Balances After entering all the account balances print five Trial Balances one for actual balances one for current year budget one for last year balances one for next year budget and one for forecast amounts C
258. the sort configuration you want to use for the report If you created user defined sorts through the Account Mask function they appear at the bottom of the screen General Ledger GL Activity Report Journal Transactions CHAPTER 5 8 If you want the report to show ending balances for every account for each specified period regardless of whether or not an account showed activity in a period select the box or enter Y if not clear the box or enter N If you elect not to show ending balances nothing is printed for accounts that have no activity in the periods you select 9 If you elected not to print inactive accounts the Include Zero Balance Accounts field is skipped If you elected to print inactive accounts and you want to include accounts with zero beginning balances for the selected periods select the box or enter Y if not clear the box or enter N 10 Select the date you want printed on the report 11 Enter the title you want on the report four lines of 30 characters each Use the numbers above the fields to help center the text The system does not use different heading lines for last year and current year files If you created last year files and you frequently switch between the last year and current year files check the heading lines to make sure that the displayed information is correct Before you go on make sure that no one else is using the GLJRxxx file 12 Select the output device See Reports
259. there is more than one screen of entries The command bar does not appear for the first recurring entry you add Adding or Editing a Line Item When you press Enter or A on the Recurring Entries screen the Edit Line or Append Line window appears The only difference between the two windows is the title and the fact that data appears in the Edit Line window If you are editing an item you cannot edit the Reference field This field must be unique and it is the key to this record EN Edit Line camz Commands Edit Modes Other Help R gt a dae moa 206 eS OK Abandon GL Account 153500 a Debit Credit ACCUM DEPR OFFICE MACHINES 00 4405 77 Trans Desc DEPRECIATION FURN 8 FIX Reference 0 Run Code 1 Cash Flow Transaction v Source Allocate Field Description GL Account Enter the general ledger account number you will post the transaction to Use the Maintenance F6 command to open the GL Accounts function page 8 15 and add or edit a General Ledger account Debit Credit Enter the debit or credit amount of the recurring entry Trans Desc Enter a description of the recurring entry Once a recurring entry has been copied to the GLJRxxx file the description prints on the GL Journal and the GL Activity Report Reference Enter the reference number for the transaction You must enter a unique reference for each debit or credit General Ledger 8 37 CHAPTER 8 File Maintenance Recurring Entries
260. these tasks select the box or enter Y in text mode to continue Inquiry 2 Enter the number of your company s retained earnings account 3 Make sure that no one else is using the last year GLURxxx or GLMAxxx files or the current year GLMAxxx file Then use the Proceed OK command to begin processing If there are unposted transactions in the prior year GLJRxxx file the following prompt appears Warning There are unposted entries Do you want to continue You can either continue with the Update Current Year function or exit to the Periodic Processing menu and go back and post these transactions When the current year GLMAxxx file for the company has been updated the Periodic Processing menu appears Quarterly Systems If you use a quarterly system remember to update the CNVTxxx table see the Resource Manager User s Guide so that the right period appears on the screen in the next quarter General Ledger 7 17 Month End Maintenance o MM Use the Month End Maintenance function to erase transactions in the GLJRxxx Journal file for periods you specify without resetting the account balances Use this function only when you must make room in the GLJRxxx file because disk space is limited If you have enough disk space you can keep an entire year s journal entries on file You can also use this function to delete journal entries in a particular year After you erase journal records from the GLJRxxx file you can use
261. tion 1 8 3 13 3 19 3 20 3 21 5 4 5 10 5 27 8 37 B 3 B 5 offsetting accounts 5 21 printing 5 19 after clearing and closing 7 14 before editing transactions 5 27 before posting 5 31 sample 5 21 GLALxxx file 1 6 5 6 8 31 8 32 setup 3 5 GLAT file 1 6 8 13 GLAUDxxx table 8 41 GLBAT file 1 6 GLCFC file 1 7 GLCGxxx file 2 4 GLCHAxxx table 8 41 GLJRxxx file 1 6 1 7 1 8 1 9 3 15 3 21 5 3 5 10 5 15 5 19 5 20 5 25 5 31 5 32 7 2 7 3 7 5 7 9 7 10 7 14 7 17 7 19 7 20 7 27 7 28 8 6 8 35 8 37 10 13 B 2 B 3 B 5 GLJRxxx Ynn file 1 9 7 13 GLMAxxx file 1 4 1 5 1 7 1 9 1 10 3 12 3 13 3 20 3 21 4 5 5 25 5 27 5 31 6 9 7 1 7 2 7 3 7 5 7 9 7 10 7 14 7 15 7 17 7 19 7 20 7 21 7 22 7 23 7 24 7 27 8 15 8 41 B 1 B 2 GLMAxxx Ynn file 7 15 GLMKxxx file 7 5 7 9 7 10 7 15 7 27 8 6 GLMSK file 1 6 8 5 GLPDxxx table 1 9 GLPRAxxx table 8 41 GLPRJxxx table 8 41 GLRExxx file 1 6 1 8 5 15 8 35 setup 3 5 GLSCF file 1 7 1 9 9 23 GLSExxx file 1 6 3 11 8 9 8 17 setup 3 5 GLSLF file 1 7 1 9 9 4 GLSTRLxxx table 8 41 graphical mode drop down menus 1 19 General Ledger INDEX function screens 1 18 graphical main menu 1 16 Inquiry button 1 22 Maintenance icon 1 22 MDI menu 1 17 shortcut menu 1 19 toolbars 1 20 GtttxxxW file 1 6 3 20 5 10 5 15 5 18 8 35 H hot keys 1 26 IDs establishing a format 3 2 setting up 3 1 sorting
262. tions o MM Options and Interfaces To interface other applications with General Ledger see the user s manuals for those applications for instructions Options Screen To set up the options for General Ledger select Options and Interfaces from the Resource Manager Company Setup menu The Options and Interfaces screen appears General Ledger 3 7 CHAPTER 3 Setup Setup Functions 3 8 The name of the company you are working with appears Specify whether the Options table is shared or owned See the Resource Manager User s Guide for information about Options tables Then enter GL as the application ID The General Ledger Options screen appears N General Ledger Options ola Es Commands Edit Modes Other Scroll Commands Help xe ae 5202 OK Abandon Description Value Copy recurring entries directly to the GL Journal YES B Is Period 13 used for normal processing NO 2 Allow transaction entry in period 13 NO 4 Do you want to use allocations YES Edit current and last year balances in file maintenance NO hz B Enter Toggle Goto Company H 12 29 2010 Terminal T000 OVR 1 Press Enter to toggle between YES or NO to indicate whether you want recurring entries copied directly to the GL Journal If you select YES recurring entries are copied directly to the GL Journal Use the Edit Transactions function to
263. ts 9 46 2 If you are adding a new cash flow content ID the Copy From field appears Enter the ID you want to copy from or press Enter to skip this field 3 Enter the company ID that contains the account mask you want to use 4 Enter or edit the description 5 Use the commands to work with the information in the scroll region e Press Enter to edit the current line The Edit Cash Flow Contents screen appears e Press A to add a line The Append Cash Flow Contents screen appears e Press H to return to the header section of the screen Append Edit Cash Flow Contents A Edit Cash Flow Contents kl Commands Edit Modes Other Help 2xamelmoa e ee OK Abandon Seq No 000001 Sec A X Beginning Acct Type 020 fa Ending Acct Type 025 a Description Changes in receivables The Append Cash Flow Contents screen appears when you add a new line to a cash flow contents record The Edit Cash Flow Contents screen appears when you edit an existing line Other than the title these two screens are identical Field Description Seq No The sequence number appears Sec Select the section for the current line Press A for adjustment to operations I for investing activities F for financial activities or C for cash General Ledger Cash Flow Contents Statement Maintenance CHAPTER 9 Field Description Beginning Acct Type Enter the account type you want for the beginning of the statement range Ending Acct
264. u appears General Ledger Copy Recurring Entries o MM Journal entries made regularly every week every month are called recurring entries Use the Recurring Entries function page 8 35 to set up groups of recurring entries Then use the Copy Recurring Entries function to copy the recurring entries either to the GtttxxxW Transaction Work file or directly to the GLJRxxx Journal file depending on your selection in the Options and Interfaces function in Resource Manager See Options and Interfaces on page 3 7 for more information on copying recurring entries to one of the two files Before You Begin Before you use this function make sure that you have set up all the entries in the GLRExxx Recurring Entries file In addition make sure that you have not already copied the current set of entries so that you do not end up with a double set of entries General Ledger 5 15 CHAPTER 5 Journal Transactions Copy Recurring Entries Copy Recurring Entries Screen Select Copy Recurring Entries from the Journal Transactions menu The Copy Recurring Entries screen appears A 2007 Copy Recurring Entries Sis Commands Edit Modes Other Help 2xt malma l2 ee ox abandon Run Code From 4 Thru 9 Copy Date 1218 2007 El Copy to Period 12 Company H 111812007 Terminal tooo OVR 1 Select the range of run codes you want to copy 0 9 Each run code identifies a group of recurring
265. ular company s balances on this line enter the company s ID Then do not specify a company ID at print time See Statements on page 6 9 for more information You can produce consolidated statements for several companies in one of these ways e Specify two or more company IDs when you print statements In this case do not specify any company IDs in the statement content e Set up totals in the statement content For example on one line you could put the summaries for a range of accounts for company A and on the next line the summaries for a range of accounts for company B On the third line you could total summaries for the companies using total 3 You can also specify not to print each company summary line so that only the consolidated totals print If you set up the statement content to consolidate the totals of several companies do not specify a company ID when you print the statements See Statements on page 6 9 for more information 9 28 General Ledger Statement Contents General Ledger Field Beginning Ending Account No Statement Maintenance CHAPTER 9 Description For functions AD BD ED AS BS and ES specify a range of accounts You can also specify arange of account types instead of account numbers You must use an account mask for the content and you can use question marks as wildcards to select all account segments of an account number for functions AD and AS For example if
266. ulations formulas or transaction amounts but rather list only the basic file information used in the system If any of the information on a master file list is incorrect use the appropriate function on the File Maintenance menu to correct it then reprint the list All master file lists are produced in the same way Use the instructions below to print a master file list modifying the procedure as necessary for the list you are printing For example ifthe screen for the list you want to print does not contain check box options ignore that step and continue to the next 10 1 CHAPTER 10 Master File Lists 1 Select the list you want to print from the Master File Lists menu The selection screen for that list appears The Chart of Accounts List screen is shown below as an example 132007 Chart of Accounts List too Es Commands Edit Modes Other Help xa ne mo 2e 9es ok _ Abandon Pick GL Account Number From 100000 Thru 181000 2 la Ej Print Clear Consolidate Account Number Sort M1 Line Headings 123456789012345678901234567890 Builders Supply CHART OF ACCOUNTS DECEMBER 31 2007 AUN CompanyH 07 30 2007 Terminaitooo OvR Inquiry 2 Select the range of information to include in the list in the From and Thru fields The Inquiry F2 command is usually available for these fields to let you select beginning and end range values from the list that appears Leave these fields blan
267. urrent Assets D 080 Other Current Assets D 100 Land Fixed Assets D 7 105 Buildings Fixed Assets D B 110 Machinery and Equipment Fixed Assets D 8 Enter Edit Goto Company H 111972007 Terminai T000 OVR The account type account class and account code appear The account code is the default code and includes credit debit and memo types To edit an account type description press Enter To go directly to another account type press G When you are finished editing account descriptions use the Exit F7 command to return to the File Maintenance menu 8 14 General Ledger GL Accounts o M Use the GL Accounts function to set up and maintain the master chart of accounts A well planned chart of accounts makes the General Ledger system easy to use requires little maintenance and can be expanded as a business grows If General Ledger interfaces with other OPEN SYSTEMS Accounting Software applications see the appropriate user s manual for information about the accounts from which you need to post entries Make sure that the General Ledger tables and records in the other applications match the appropriate accounts in the GLMAxxx Master file If they do not match the journal entries from the other applications will not be posted properly Use this function only to set up initial balances and enter annual budget and forecast balances When you have finished setting up the accounts do not use this functi
268. use the Exit F7 command to return to the File Maintenance menu 8 42 General Ledger Tables File Maintenance CHAPTER 8 Further Protection After you have set up the forced balance password use the Resource Manager roles function to protect the Tables function in General Ledger For additional security remove this section from this manual General Ledger 8 43 Copy Account Balances MM Use the Copy Account Balances function to copy the actual current year budget last year or forecast balances of a range of accounts to the current year budget next year budget or forecast balances Copy Account Balances Screen Select Copy Account Balances from the File Maintenance menu The Copy Account Balances screen appears A 2007 Copy Account Balances tel Commands Edit Modes Other Help 2xt malma l ee OK Abandon This function lets you copy Account Balances from one column to another The balances in the destination column will be overwritten Main Account From 1000 q Copy Account Balances In Actual v Thu 3999 al To NY Budget y Division From la Thru a Percent Increase 12 00 Department From q Thru q Subaccount From x Thru a Company H 11 9 2007 Terminal TODO OVR Inquiry 1 Enter the range of main account division department and subaccount segments for which you want to copy account balances If your company s account mask does not include one or more of the ac
269. verse the accrual entries When the wages were paid you would enter transactions for the full amount An Ri accrual transaction entered in the last period will be reversed in period 1 of the next fiscal year General Ledger 5 5 CHAPTER 5 Journal Transactions Transactions Automatic Allocations You can make automatic allocations page 8 31 by simply entering an account number that is set up in the GLALxxx Allocations file and then selecting the Allocate box or entering Y in text mode Then when you post transactions in which the allocation flag is set for valid allocation accounts they are automatically distributed to the accounts specified in the allocation record Transactions Screen Select Transactions from the Journal Transactions menu This screen appears a 2007 Transactions le Commands Edit Modes Other Scroll Commands Help 2x tu Aa a E ee OK Abandon GL Account Debit Credit Reference Pd Cflow Description Date Sre Alloc 1000 00 M6366 E Allocate prepaid insuranc 12 18 2007 M1 v a 535001 500 00 M6366 12 Y 2 Allocate prepaid insuranc 12 18 2007 M1 Ww 535002 300 00 M6366 12 Mm Allocate prepaid insuranc_ _ 12 18 2007 Mi CE 535003 i 200 00 M6366 12 T Allocate prepaid insuranc 12 18 2007 M1 El al Iw Entry 0001 of 0004 Total Debits Total Credits me Balance 1000 00 1000 00 00 Enter

General Ledger

Contents

Download Pdf Manuals

Related Search

Related Contents