The World of Computer Software

home *** CD-ROM | disk | FTP | other *** search

/ The World of Computer Software / World_Of_Computer_Software-02-387-Vol-3of3.iso / s / sbt25gl.zip / ZIPGLC01.EXE / GLRLOG._XP (.txt) < prev next >

Wrap

MS Visual FoxPro App | 1993-02-11 | 102KB | 2,986 lines

o_segidf o_period2f The Beginning Period/Year can't be later than the Ending Period/Year. Income Statement for Period to Date Period Income Statement Period through Period IS_SEGTPRN1 Group: For Account Group: IS_SEGTPRN1 All Accounts For All Accounts in IS_COMPPRN1 Group: For Account Group: For All Accounts Level of Detail: Sorted by IS_SEGTPRN1 Zero Balance Accounts lc_rwsort LC_RWLOAD2 Account Type GLIT1S GLIT1N8 GLIS1S GLIS1N8 LL_PTDREPTLL_YTDREPTLL_PRDRANGLL_SEGMENTLL_PCTSLS LL_CONT CLC_STRING O_PCTSLS O_YEAR1 NGO_PERIOD1 O_YEAR2 O_PERIOD2 G_DSPALT GC_OSEOL LL_LOGOK LL_OPTOK YLN_CNUM ENLN_GNUM LN_PWID EAL_RWARRY L_HDRVARS LC_TITLE TO_YEAR O_ACNTGRP LC_RWCOD GA_SEGDES O_SEGID O_SEGVAL O_ROWLEVELO_ORDER O_ROUND O_ZEROBAL G_FMTSTR LA_RWDHEADL_DETDSC WO_ROWHEAD LC_RWRKEY L_LVLKEY JL_RPTVAR LLC_RWSORT L_SRTORD LC_RWLOAD2L_LODMAP ELC_RWFRM LGC_ADRVPRG a_rwwblke/ lc_colpict lc_totpict ln_pearn ln_totpsls ln_ptotpct lc_pctdpct lc_pcttpct 99999.99 99999.99 LL_PCTSLS LN_TOTPCLSO_PCTSLS G_OPNFL NTGC_IDRVTMPGC_TMPF5 CGC_EXTDBF L_SETCHT L_RPTVAR GLN_CWID LC_COLPICTL_PICFMT LC_CFORMATO_DECM LC_TOTPICTLC_GFORMATAMOUNT01 NLN_PEARN LN_TOTPSLSLN_PTOTPCTLC_PCTDPCTLC_PCTTPCTA_GLTYPE SGLTYPE OTPSLSAMOUNT02 TA_GLACNT a_gltyp2 a_gltyp2/e gltype ln_lastrec EXCLUDE L_SETCHT G_OPNFL LSGF_GLTYPEFA_GLTYP2 TA_RWWBLK PL_RPTVAR CLN_LASTRECO_ZEROBAL AMOUNT01 a_gltyp2 a_gltyp2/e gltype EXCLUDE L_SETCHT G_OPNFL LSGF_GLTYPEFA_GLTYP2 TA_RWWBLK PO_ZEROBAL AMOUNT01 CAMOUNT03 a_gltyp2 a_gltyp2/e gltype EXCLUDE L_SETCHT G_OPNFL LSGF_GLTYPEFA_GLTYP2 TA_RWWBLK PO_ZEROBAL AMOUNT01 CAMOUNT02 ln_errors ln_trncnt a_glacnt// glacnte a_glhunp// batchno1e a_gldunp// batchno1e a_glbtch// batchnoe sycdfis a_sycdfi// compid1e General Journal For period 000001 999999 All batches (FF Cancelled/Deleted Batches; Cancelled/Deleted Transactions) Batch No. through Batch No. Cancelled/Deleted Batches; Cancelled/Deleted Transactions) Batch No. Cancelled/Deleted Batches; Cancelled/Deleted Transactions) For all Journals Limited to Source Journal: a_glhunp->yearprd = o_year + o_period1 .AND. a_gldunp->batchno >= o_bbatch .AND. a_gldunp->batchno <= o_ebatch Exclude .AND. .NOT. a_glbtch->bstat $ "CD" Exclude .AND. .NOT. a_glhunp->status $ "PCD" .AND. .NOT. a_glhunp->status = "P" .AND. a_glhunp->glmodule = TRIM(o_srcjrnl) SET FILTER TO &lc_filt L_RPTVAR LN_ERRORS LN_TRNCNT LN_PWID TG_OPNFL PGF_GLACNTFGF_GLHUNPFGF_GLDUNPFGF_GLBTCHFGC_IDRVDBFA_GLDUNP TGLACNT A_GLACNT TBATCHNO GLSEQNO CTA_GLHUNP TA_GLBTCH NL_HDRVARS LC_TITLE SLC_HEAD1 TO_PERIOD1 O_YEAR PCTO_BBATCH SO_EBATCH LC_HEAD2 SO_BATSTAT O_TRNSTAT LC_HEAD3 O_SRCJRNL LC_FILT 000001 999999 The Beginning Transaction number can't be greater than the Ending Transaction number. O_TRAN1 O_TRAN2 G_DSPALT GC_OSEOL TLL_LOGOK PLL_OPTOK a_glhunp// batchno1e a_glbtch// batchnoe sycdfis a_sycdfi// compid1e Unposted Transaction Summary 000001 999999 All Transactions Transaction No. through Transaction No. Transaction No. Cancelled and Deleted Batches For all Journals Limited to Source Journal: a_glhunp->glseqno >= o_tran1 .AND. a_glhunp->glseqno <= o_tran2 Exclude .AND. .NOT. a_glhunp->status $ "PCD" .AND. .NOT. a_glhunp->status = "P" .AND. a_glhunp->glmodule = TRIM(o_srcjrnl) SET FILTER TO &lc_filt G_OPNFL GF_GLHUNPFGF_GLBTCHFGC_IDRVDBFA_GLHUNP PBATCHNO FA_GLBTCH FL_HDRVARS LC_TITLE FO_TRAN1 BFO_TRAN2 TLC_HEAD1 LC_HEAD2 TO_DELETED LC_HEAD3 TO_SRCJRNL LC_FILT TB_COMPPTD1 Invalid year entered. Invalid period entered. TB_DEPTPTD1 Invalid year entered. Invalid period entered. Invalid Segment ID entered. Invalid Segment Value entered. TB_COMPWKS1 TB_COMPWKS1 GLTRB3 GLTRB2 GLTRB1 o_segstrf o_segstr TB_COMPPTD1 TB_COMPWKS1 Trial BalanceF TB_COMPPTD1 Worksheet8 For period Include Include Including Inactive Accounts and Accounts with zero balance Exclude Include Including Inactive Accounts Excluding accounts with zero balance Include Exclude Including accounts with zero balance Excluding Inactive Accounts Excluding Inactive Accounts and Accounts with zero balance TB_DEPTPTD1 Trial Balance - Single Segment Only For period For Segment: Segment Value: Include Include Including Inactive Accounts and Accounts with zero balance Exclude Include Including Inactive Accounts, Excluding accounts with zero balance Include Exclude Including accounts with zero balance Excluding Inactive Accounts Excluding Inactive Accounts and Accounts with zero balance LC_MSG LL_CONT PFLC_RWCOD FO_YEAR DBFO_PERIOD1 LL_LOGOK FLL_OPTOK FG_DSPALT O_SEGID GN_TOTSEGSO_SEGVAL TO_BEBALS SLN_PWID TLC_RWFRM GC_ADRVPRGL_HDRVARS L_RPTVAR O_SEGSTR LC_TITLE SLC_HEAD1 TO_ZEROBAL O_INACTIV LC_HEAD2 SLC_HEAD3 lc_colpict lc_totpict L_RPTVAR LN_CWID FO_BEBALS FLC_COLPICTL_PICFMT LC_CFORMATLC_TOTPICTLC_GFORMATO a_gltyp2 a_gltyp2/e gltype EXCLUDE .AND. .NOT. (amount01 + amount02 - amount03 = 0.00) EXCLUDE .AND. a_glacnt->glstat = "A" SET FILTER TO &lc_filt L_SETCHT G_OPNFL FGF_GLTYPEFA_GLTYP2 TA_RWWBLK LC_FILT TO_ZEROBAL O_INACTIV TP_COMPPRN1 The Beginning Period/Year can't be later than the Ending Period/Year. LC_RWCOD O_YEAR FO_PERIOD1 O_YEAR2 TO_PERIOD2 G_DSPALT TGC_OSEOL LL_LOGOK LL_OPTOK o_orderf 000001 999999 000001 999999 General Journal TP_COMPPTD1 For period TP_COMPYTD1 through period TP_COMPPRN1 For period through period 000001 999999 All batches Batches through Batch No. 000001 999999 All transactions Transactions through Transaction No. All Journals Limited to Source Journal: Sorted by ln_errors a_glacnt// glacnte a_glhent// batchno1e a_gldent// batchno1e a_glbtch// batchnoe sycdfis a_sycdfi// compid1e POSTING PERIOD yearprd a_gldent->batchno >= o_bbatch .AND. a_gldent->batchno <= o_ebatch .AND. a_gldent->glseqno >= o_btranno .AND. a_gldent->glseqno <= o_etranno TP_COMPPTD1 .AND. a_glhent->yearprd = o_year + o_period1 TP_COMPYTD1 .AND. LEFT(a_glhent->yearprd, 4) = o_year .AND. RIGHT(a_glhent->yearprd, 2) <= o_period1 TP_COMPPRN1 .AND. a_glhent->yearprd >= o_year + o_period1 .AND. a_glhent->yearprd <= o_year2 + o_period2 .AND. a_glhent->glmodule = TRIM(o_srcjrnl) SET FILTER TO &lc_filt LN_PWID O_ORDER FO_BBATCH O_EBATCH TO_BTRANNO O_ETRANNO L_HDRVARS LC_TITLE LC_RWCOD LC_HEAD1 SO_PERIOD1 O_YEAR SO_PERIOD2 O_YEAR2 LC_HEAD2 GLC_HEAD3 O_SRCJRNL L_RPTVAR LN_ERRORS G_OPNFL TGF_GLACNTFGF_GLHENTFGF_GLDENTFGF_GLBTCHFGC_IDRVDBFA_GLDENT YEARPRD GLACNT A_GLACNT BATCHNO GLSEQNO A_GLHENT A_GLBTCH LC_FILT o_segidf Account Type GLIS2S GLIS2N8 GLIT2S GLIT2N8 Income Statement for Period and Year-to-Date Period For Account Group: For All Accounts in For Account Group: For All Accounts Level of Detail: Sorted by Zero Balance Accounts LC_RWSORT lc_rwload2 LL_PCTSLS LL_SEGMENTLC_STRING O_PCTSLS O_ROWLEVELLC_RWFRM GC_ADRVPRGLN_CNUM LN_GNUM LN_PWID SL_RWARRY L_HDRVARS LC_TITLE O_PERIOD1 O_YEAR GO_ACNTGRP GA_SEGDES O_SEGID O_SEGVAL O_ORDER O_ZEROBAL O_ROUND G_FMTSTR FLA_RWDHEADL_DETDSC FO_ROWHEAD LC_RWRKEY L_LVLKEY L_RPTVAR LLC_RWSORT L_SRTORD LC_RWLOAD2L_LODMAP a_rwwblke/ lc_colpict lc_totpict ln_pearn ln_yearn lc_pctdpct lc_pcttpct 99999.99 99999.99 ln_totpsls ln_totysls LL_PCTSLS O_PCTSLS G_OPNFL GC_IDRVTMPGC_TMPF5 LGC_EXTDBF L_SETCHT GL_RPTVAR LN_CWID LC_COLPICTL_PICFMT LC_CFORMATO_DECM LC_TOTPICTLC_GFORMATAMOUNT01 AMOUNT03 LN_PEARN LN_YEARN A_GLACNT GLTYPE FLC_PCTDPCTLC_PCTTPCTLN_TOTPSLSLN_TOTYSLSA_GLTYPE AMOUNT02 SAMOUNT04 lc_colhd1 lc_colhd2 Income Statement Period Actual vs. Period Actual For Account Group: For All Accounts in For Account Group: For All Accounts Level of Detail: Sorted by Zero Balance Accounts Actual Actual lc_rwsort lc_rwload2 Account Type GLIT2V GLIS2V LL_PRIORYRLC_STRING LL_SEGMENTO_SEGID NTO_VARIANC LN_CNUM LN_PWID LN_DWID LN_HWID LN_GNUM CTL_RWARRY L_HDRVARS L_RPTVAR LC_TITLE TO_PERIOD1 O_YEAR1 O_PERIOD2 O_YEAR2 O_ACNTGRP GA_SEGDES O_SEGVAL O_ROWLEVELO_ORDER O_ZEROBAL O_ROUND G_FMTSTR SLC_COLHD1 LC_COLHD2 LA_RWDHEADL_DETDSC SO_ROWHEAD LC_RWRKEY L_LVLKEY LC_RWSORT L_SRTORD LC_RWLOAD2L_LODMAP LC_RWFRM LGC_ADRVPRG a_rwwblke/ lc_colpict lc_totpict ln_pearn1 ln_pearn2 lc_pctdpct lc_pcttpct 999999999999.99 999999999999.99 ln_tvarnce DOLLARS G_OPNFL YRGC_IDRVTMPGC_TMPF5 TGC_EXTDBF L_SETCHT L_RPTVAR LN_CWID LC_COLPICTL_PICFMT LC_CFORMATO_DECM LC_TOTPICTLC_GFORMATAMOUNT01 TAMOUNT02 LN_PEARN1 LN_PEARN2 A_GLACNT GLTYPE O_VARIANC LC_PCTDPCTLC_PCTTPCTLN_TVARNCEAMOUNT03 o_variancf lc_colhd1 lc_colhd2 Income Statement IC_ABSPSP01 Period Actual vs. Budget Actual Budget Account Type GLIT2V GLIS2V IC_BBSPPY01 Budget Version Period Budget vs. Period Budget Budget Budget Account Type GLIT2V GLIS2V IC_BBSPSP01 Budget Version: F vs. Budget Version: Period for for Account Type GLIT2V GLIS2V IC_AAAPPP01 lc_lastprd lc_curyear lc_lastyr Period vs. Period vs. Period Actuals Account Type GLIT3N GLIS3N IC_ABSPYP01 lc_lastyr Period Actual and Budget vs. Period Actuals Account Type GLIT3V GLIS3V For Account Group: For All Accounts in For Account Group: For All Accounts Level of Detail: Sorted by Zero Balance Accounts lc_rwsort lc_rwload2 LC_STRING LL_SEGMENTO_SEGID NTO_VARIANC LN_CNUM LN_GNUM LN_PWID O_SEGVAL TL_RWARRY L_HDRVARS L_RPTVAR LC_TITLE TLC_RWCOD TO_PERIOD1 O_YEAR LC_COLHD1 LC_COLHD2 O_ROWLEVELLC_RWFRM GC_ADRVPRGO_YEAR1 O_PERIOD2 O_YEAR2 CTO_BCODE O_BCODE2 ELC_LASTPRDGN_FCPRDS LC_CURYEARLC_LASTYR O_ACNTGRP GA_SEGDES O_ORDER O_ZEROBAL O_ROUND G_FMTSTR LA_RWDHEADL_DETDSC O_ROWHEAD LC_RWRKEY L_LVLKEY GLC_RWSORT L_SRTORD 2LC_RWLOAD2L_LODMAP Beginning Account Number may not be greater than Ending Account Number. Detail GLCHTW Summary GLACNT Consolidation GLCHTC lc_colhead Chart of Accounts Account Group: FF [none] Account Status: ALL|ACTIVE ONLY|INACTIVE ONLY [none]8 For All Accounts For Account F through Detail Detail Listing Summary Summary Listing Account Number Description Status LLLCA Consolidation Mapping of Consolidation Accounts Account Number Description Consolidation Account Consolidation Percent LLLCA LC_MSG LL_CONT NTO_GLACNT1 O_GLACNT2 LL_LOGOK LL_OPTOK G_DSPALT GC_OSEOL TLN_CNUM O_ROWHEAD LC_RWFRM GC_ADRVPRGLN_PWID TL_RWARRY GL_HDRVARS L_RPTVAR LC_TITLE LC_HEAD2 LO_ACNTGRP O_STATUS LC_HEAD3 LC_HEAD1 LC_COLHEADLA_RWDHEADL_PIKCLS a_gltype// gltypee a_glacnt// glacnte a_glacnt// glacnte a_gldgrp// grpcode1e .AND. .NOT. EOF("a_gldgrp") ACTIVE ONLY .AND. a_glacnt.glstat = "A" INACTIVE ONLY .AND. a_glacnt.glstat = "I" .AND. a_glacnt->glacnt >= o_glacnt1 .AND. a_glacnt->glacnt <= o_glacnt2 .AND. .NOT. DELETED() SET FILTER TO &lc_filt Detail sycrlst a_sycrls// compid1e a_sycrls2 sycrlst a_sycrls2/e compid1e @@FASB95 @@RATIOS LC_FILT G_OPNFL NTGF_GLTYPEFO_ACNTGRP GF_GLACNTFGF_GLDGRPFA_GLACNT GLACNT A_GLDGRP O_STATUS O_GLACNT1 O_GLACNT2 GLTYPE TA_GLTYPE GO_ROWHEAD GC_IDRVDBFA_SYCRLS2 GLFASB95 A_SYCRLS GLRATIO Account Number Structure LN_PWID LN_CNUM NTLN_DWID EFLN_HWID LN_GNUM TFL_RWARRY FL_HDRVARS LC_TITLE a_glstru// segide lc_segdes1 lc_segdes2 lc_segdes3 lc_segdes4 lc_segdes5 lc_segdes6 G_OPNFL GF_GLSTRUFA_GLSTRU FL_RPTVAR SEGID FLC_SEGDES1LSEGDES LC_SEGDES2LC_SEGDES3LC_SEGDES4LC_SEGDES5LC_SEGDES6e Summary Beginning Segment Value may not be greater than Ending Segment Value. Summary GLSEGS Detail GLSEGD lc_colhead Segment Value Account Number Segments For All Segments For Segment: through Starting at Through For All Detail Detail Listing Summary Summary Listing Short Desc. Long Description LLLCB LC_MSG LL_CONT UFLC_DESVAL O_SEGID O_ROWHEAD O_SEGVAL1 O_SEGVAL2 LL_LOGOK LL_OPTOK 3G_DSPALT 4GC_OSEOL 5LN_CNUM S6LN_DWID TLN_PWID GLN_HWID LN_GNUM BFLC_RWFRM GC_ADRVPRGL_RWARRY GL_HDRVARS L_RPTVAR GA_SEGDES LC_TITLE DLC_HEAD2 DLC_HEAD3 LC_HEAD1 LC_COLHEADLA_RWDHEADL_PIKCLS a_glsegs// segid1e .AND. a_glsegs->segid = o_segid .AND. a_glsegs->segval >= o_segval1 .AND. a_glsegs->segval <= o_segval2 .AND. .NOT. DELETED() SET FILTER TO &lc_filt a_gltype// gltypee a_glstru// segide Detail sycrlst a_sycrls// compid1e a_sycrls2 sycrlst a_sycrls2/e compid1e @@FASB95 @@RATIOS Summary LC_FILT G_OPNFL UFGF_GLSEGSFO_SEGID O_SEGVAL1 O_SEGVAL2 A_GLSEGS GF_GLTYPEFGF_GLSTRUFGLTYPE 4A_GLTYPE 5SEGID 6A_GLSTRU TO_ROWHEAD GC_IDRVDBFA_SYCRLS2 GLFASB95 A_SYCRLS GGLRATIO Summary lc_colhead Account Types and Ranges Detail Detail Listing GLTYPE Summary Summary Listing GLTYP1 LN_PWID O_ROWHEAD LN_CNUM SFLN_DWID LN_HWID LN_GNUM L_RWARRY L_HDRVARS L_RPTVAR FLC_TITLE 4LC_HEAD1 LC_RWFRM 6GC_ADRVPRG a_gltype// gltype Types: All Types ASSETS Types: Assets Only LIABILITIES Types: Liabilities Only EQUITY Types: Equity Only SALES Types: Sales Only COST OF GOODS Types: Cost of Goods Only EXPENSES Types: Expenses Only OTHER INCOME Types: Other Income Only TAXES Types: Taxes Only STATISTICAL Types: Statistical Only G_OPNFL GF_GLTYPEFO_STATUS FLC_HEAD2 A_GLTYPE GLTYPE Detail GLGRP1 Summary GLGRUP lc_colhead Account Groups For All Groups For Group: F Detail Detail Listing Summary Summary Listing Group Code Description Short Descript LLLCD LC_MSG LL_CONT EFO_ROWHEAD LC_RWFRM GC_ADRVPRGLN_PWID L_RWARRY GL_HDRVARS L_RPTVAR FLC_TITLE 4LC_HEAD2 O_ACNTGRP LC_HEAD3 LC_HEAD1 LC_COLHEADLA_RWDHEADL_PIKCLS a_glhgrp// grpcode Detail a_gldgrp// grpcode1 a_glacnt// glacnt GRPCODE INTO A_GLHGRPF RELATIONz GLACNT INTO A_GLACNTF RELATIONz G_OPNFL GF_GLHGRPFA_GLHGRP O_ROWHEAD GF_GLDGRPFGF_GLACNTFA_GLDGRP GGRPCODE GLACNT FA_GLACNT 4O_ACNTGRP Detail STANDARD GLAUT1 GLAUT2 RECURRING GLAUT3 ALLOCATION GLAUT4 Summary GLAUTO lc_colhead Automatic Entries Listing For FFFF Automatic Distribution Entries Detail Detail Listing Summary Summary Listing STANDARD Description Reference $ or % LLLCF Description Reference LLLCFF RECURRING Description Reference Start Date Next Date Termination Date Last Generated Frequency LLLCF ALLOCATION Description Reference $ or % Allocation Account LLLCF LC_MSG LL_CONT PFLN_CNUM LN_GNUM O_ROWHEAD O_AUTOTYP LC_RWFRM GGC_ADRVPRGLN_PWID RGL_RWARRY GL_HDRVARS L_RPTVAR LC_TITLE LC_HEAD2 LC_HEAD3 LC_HEAD1 LC_COLHEADLA_RWDHEADL_PIKCLS lc_colpict a_glhaut// auttype1 STANDARD RECURRING ALLOCATION Detail a_gldaut// auttype1 a_glacnt// glacnt a_glacnt2 a_glacnt2/e glacnt AUTTYPE + AUTONO INTO A_GLHAUTF RELATIONz GLACNT INTO A_GLACNTF RELATIONz ALCACNT INTO A_GLACNTF RELATIONz STANDARD RECURRING ALLOCATION ALLOCATION a_glacnt// glacnt ALCACNT INTO A_GLACNTF RELATIONz L_RPTVAR LN_CWID PFLC_COLPICTL_PICFMT LC_CFORMATLC_TOTPICTLC_GFORMATG_OPNFL RGGF_GLHAUTFA_GLHAUT GO_AUTOTYP AUTTYPE O_ROWHEAD GF_GLDAUTFGF_GLACNTFA_GLDAUT FAUTONO DGLACNT DA_GLACNT GALCACNT A_GLACNT2 a_glhbud// bcode1 a_glhbud Budget F not found. a_glhbud Detail You must enter a year when specifying a budget. Beginning Account Number may not be greater than Ending Account Number. Detail GLBDGD Summary GLBDGS lc_colhead Detail Detail Budget Listing For Budget: FF All Budgets For Year: FF All Years For All Accounts For Account F through Summary Summary Budget Listing Description Comment LLLCG LC_MSG LL_CONT PFG_OPNFL CTGF_GLHBUDFO_BCODE ATLL_LOGOK TLL_OPTOK TG_DSPALT GA_GLHBUD FO_ROWHEAD O_YEAR O_GLACNT1 O_GLACNT2 GC_OSEOL LN_CNUM TFLN_DWID FLN_PWID DLN_HWID DLN_GNUM GLC_RWFRM GC_ADRVPRGL_RWARRY GL_HDRVARS L_RPTVAR DLC_TITLE LC_HEAD1 LC_HEAD2 DLC_HEAD3 DLC_COLHEADLA_RWDHEADL_PIKCLS lc_colpict a_glhbud// bcode1 Detail a_gldbud// bcode2 a_glacnt// glacnt AUTTYPE + AUTONO INTO A_GLHAUTF RELATIONz GLACNT INTO A_GLACNTF RELATIONz .AND. LEFT(a_gldbud.yearprd,4) = o_year .AND. a_gldbud.bcode = o_bcode .AND. a_gldbud.glacnt >= o_glacnt1 .AND. a_gldbud.glacnt <= o_glacnt2 .AND. .NOT. DELETED() SET FILTER TO &lc_filt LC_FILT L_RPTVAR FLN_CWID CTLC_COLPICTL_PICFMT TLC_CFORMATG_OPNFL TGF_GLHBUDFA_GLHBUD FO_ROWHEAD GF_GLDBUDFGF_GLACNTFA_GLDBUD BCODE YEARPRD TFGLACNT FA_GLACNT DO_YEAR DO_BCODE GO_GLACNT1 O_GLACNT2 syrpset a_syrpse// itmcode No Preference Sets found. lc_colhead User Preference Sets LC_MSG LL_CONT FG_OPNFL CTGC_IDRVDBFLL_LOGOK TLL_OPTOK TG_DSPALT TLN_CNUM DFLN_DWID FLN_PWID LN_HWID DFLN_GNUM TFL_RWARRY L_HDRVARS L_RPTVAR FLC_TITLE a_tmpf1// itmcode/ syroptn a_syropt// rptopt syrcatg a_syrcat// itmcode a_syrcat2 syrcatg a_syrcat2/e itmcodee syroptn a_syropt// rptopt itmcode la_classf Searching for preference sets for reports itmclas1 a_syrcat2' rptopt *** Option missing a_syrcat2 a_syrcat LC_RPTCLASLC_TRANSFRLC_ITMCLASLC_ITMCODELC_MENUITMLC_RPTOPT LC_SETVARSLL_SUBCLASLC_DETVAR LC_DETDES LC_DETVAL LN_START FO_RPTCLAS GC_IDRVTMPGC_TMPF1 FITMCODE FRPTCLAS DMENUITM DPSETNAME GPSETDESC PSETVALU RPTOPT GDETDES DETVAL DG_OPNFL GC_IDRVDBFITMCLAS ASA_SYRCAT2 A_SYRCAT MTRANSFR RLL_ABORT RPTCODE LA_CLASS G_DSPPRC SITMCLAS1 A_SYRPSE SETVARS LN_CNT RSA_SYROPT SDETVAR DETWHEN A_TMPF1 Invalid account number selected. lc_colpict lc_totpict o_period1 o_acctstrf o_acctstr a_glacnt// glacnte Account picklist is locked for maintenance. lc_reg1ln1 lc_reg1ln2 lc_reg1ln3 lc_reg2ln2 lc_reg2ln3 Period-to-Date Year-to-Date8 Account Reconciliation for Period Batch Trans. Date Number Number Posting DescriptionF Debit Credit Balance ======== ====== ====== F =============== =============== =============== Date Number Number Account NumberF Account Description Debit Credit Balance ======== ====== ====== F =============== =============== =============== <:ROWKEY::"1"+P|TRANYMD+P|TRANSET:> O_ACCOUNT LL_LOGOK RLL_OPTOK SG_DSPALT ELN_CNUM TMLN_CWID L_RPTVAR SLC_COLPICTL_PICFMT LC_CFORMATLC_TOTPICTLC_GFORMATL_RWARRY LL_PTD TMPLC_RWCOD FO_PERIOD1 O_PERIOD2 O_ACCTSTR LN_OPNACNTG_OPNFL GF_GLACNTFA_GLACNT GLACNT GLDESC DL_HDRVARS LC_TITLE FO_YEAR LC_HEAD1 LC_REG1LN1LC_REG1LN2LC_REG1LN3LC_REG2LN2LC_REG2LN3LC_RWRKEY a_rwwblke/ rowkey/ a_gldent// Posting all account lines for selected transactions a_rwwblkR Retrieving transaction descriptions TRNYMD TRNBAT TRNSEQ TRNDESC TRNYMD TRNBAT TRNSEQ CODLDESC Validating reported balances a_glbals// glacnt1e o_begbal o_endbal LL_PTD LC_RWCOD RG_OPNFL SGC_IDRVTMPGC_TMPF5 MGC_EXTDBF GF_GLDENTFG_DSPPRC TA_RWWBLK LN_BOTREC REGION ICTLN_BLKREC LC_BLKKEY TRANSET PLC_BLKTAG BLOCKTAG A_GLDENT BATCHNO GLSEQNO TAMOUNT01 CREDIT FGLAMNT AMOUNT02 DGLACNT L_SETCHT L_SETTRN DETAILS L_GLSTR N1FOR N2GF_GLBALSFL_RPTVAR 2O_BEGBAL 3O_ENDBAL A_GLBALS O_ACCOUNT O_YEAR O_PERIOD1 FYBGBAL SYTDDR YTDCR PTDDR PTDCR O_PERIOD2 LN_RUNBAL LN_SCANRECLC_SCANKEYAMOUNT03 Account Type GLBT01 GLBT02 GLBS01 GLBS02 GLBS01 GLBT01 lc_rwsort lc_rwload2 As of As of Period Ending Balance Sheet For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Closing Entry Closing Entry LC_RPTDATELC_STRING LL_WIDERPTLN_CNUM MPO_ROWLEVELLC_RWFRM GC_ADRVPRGLN_PWID RGL_RWARRY TLA_RWDHEADL_DETDSC TO_ROWHEAD LC_RWRKEY L_LVLKEY PL_RPTVAR LLC_RWSORT L_SRTORD O_ORDER LC_RWLOAD2L_LODMAP O_ACNTGRP L_HDRVARS GD_SDATE O_YEAR DO_PERIOD1 LC_DATESTRC_RETFD TEGC_COMPID LC_TITLE RO_ZEROBAL O_YECLOSE O_ROUND G_FMTSTR a_rwwblke/ o_yeclosef o_yeclose lc_colpict lc_totpict ln_netincm BS_DEP SUBSTR(glacnt, ga_segbeg[VAL(o_segid)], ga_seglen[VAL(o_segid)]) = o_segval INCLUDE ln_balance LC_COND TEG_OPNFL GC_IDRVTMPGC_TMPF5 PGC_EXTDBF L_SETCHT L_RPTVAR GO_YECLOSE LN_CWID TLC_COLPICTL_PICFMT TLC_CFORMATO_DECM LC_TOTPICTLC_GFORMATLC_RWCOD LN_NETINCML_NETINC O_YEAR AD2O_PERIOD1 AMOUNT01 LN_BALANCEA_GLACNT GLTYPE ETINCMFOR lc_rwsort lc_rwload2 As of As of Period Ending Balance Sheet Showing FF Period Year 8 to Date Activity For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Closing Entry Account Type GLBT03 GLBS03 LC_RPTDATELC_STRING LN_CNUM MPLN_PWID PL_RWARRY LA_RWDHEADL_DETDSC GO_ROWHEAD O_ROWLEVELLC_RWRKEY L_LVLKEY TL_RPTVAR LLC_RWSORT L_SRTORD TO_ORDER ATLC_RWLOAD2L_LODMAP MO_ACNTGRP L_HDRVARS GD_SDATE O_YEAR O_PERIOD1 LC_DATESTRC_RETFD TEGC_COMPID LC_TITLE RLC_RWCOD EO_ZEROBAL O_YECLOSE O_ROUND G_FMTSTR LC_RWFRM LGC_ADRVPRG o_yeclosef o_yeclose a_rwwblke/ lc_colpict lc_totpict ln_am01net ln_am04net ln_am05net BS_DEP SUBSTR(glacnt, ga_segbeg[VAL(o_segid)], ga_seglen[VAL(o_segid)]) = o_segval INCLUDE INCLUDE ln_am01bal ln_am04bal ln_am05bal LC_COND TEL_RPTVAR O_YECLOSE G_OPNFL PGC_IDRVTMPGC_TMPF5 DGC_EXTDBF L_SETCHT LN_CWID LLC_COLPICTL_PICFMT TLC_CFORMATO_DECM LC_TOTPICTLC_GFORMATLC_RWCOD 2LN_AM04NETL_NETINC O_YEAR O_PERIOD1 LN_AM01NETLN_AM05NETAMOUNT01 TAMOUNT04 EAMOUNT05 LN_AM01BALLN_AM04BALLN_AM05BALA_GLACNT GLTYPE M05NETFOR a_gltyp2 a_gltyp2/e gltype ln_lastrec EXCLUDE L_SETCHT EG_OPNFL GF_GLTYPEFA_GLTYP2 PA_RWWBLK PL_RPTVAR DLN_LASTRECO_ZEROBAL AMOUNT02 LAMOUNT03 TAMOUNT04 TAMOUNT05 a_glhbud// bcode1 a_glhbud Budget F for not found. a_glhbud a_glhbud Invalid year entered! Invalid period entered! lc_rwsort lc_rwload2 o_bdgstrf o_bdgstr Comparative Balance Sheet - Actual vs Budget As of As of Period Ending Selected Budget: o_bdgstrf No budget selected8 For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Account Type GLBT11 GLBS11 LC_STRING LC_RPTDATELC_DATESTRG_OPNFL PGF_GLHBUDFO_BCODE DO_YEAR RECLL_LOGOK LL_OPTOK LG_DSPALT TA_GLHBUD TO_PERIOD1 LC_MSG CLN_CNUM LN_PWID ATL_RWARRY 2LA_RWDHEADL_DETDSC O_ROWHEAD O_ROWLEVELLC_RWRKEY L_LVLKEY TL_RPTVAR LLC_RWSORT L_SRTORD O_ORDER ALLC_RWLOAD2L_LODMAP LO_ACNTGRP O_BDGSTR L_HDRVARS LC_TITLE LGD_SDATE GC_RETFD TEGC_COMPID O_ZEROBAL O_ROUND G_FMTSTR LC_RWFRM LGC_ADRVPRG a_rwwblke/ lc_colpict lc_totpict ln_netincm ln_bdgincm BS_COMPACT1 BS_COMPBDG1 BS_BUDGBDG1 BS_COMPACT1|BS_BUDGBDG1|BS_COMPBDG1 lc_pctdpct lc_pcttpct @( 9999999999999999.99 999999999999999999.99 @( 9999999999999999.99 999999999999999999.99 ln_balance ln_bdgbal G_OPNFL GC_IDRVTMPGC_TMPF5 RGC_EXTDBF L_SETCHT FL_RPTVAR DLN_CWID CLC_COLPICTL_PICFMT LLC_CFORMATO_DECM TLC_TOTPICTLC_GFORMATLC_RWCOD LN_NETINCML_NETINC 2O_YEAR1 ADO_PERIOD1 LN_BDGINCMO_YEAR2 LO_PERIOD2 O_YEAR ML_BDGINC MO_BCODE O_BCODE1 MO_PERIOD LO_BCODE2 MLC_PCTDPCTLC_PCTTPCTAMOUNT01 TAMOUNT02 LN_BALANCELN_BDGBAL A_GLACNT EGLTYPE DGINCMFOR a_gltyp2 a_gltyp2/e gltype ln_lastrec EXCLUDE L_SETCHT G_OPNFL MPGF_GLTYPEFA_GLTYP2 A_RWWBLK FL_RPTVAR DLN_LASTRECO_ZEROBAL AMOUNT01 LAMOUNT02 Invalid year entered for column 1! Invalid year entered for column 2! Invalid period entered for column 1! Invalid period entered for column 2! lc_rwsort lc_rwload2 Comparative Balance Sheet - Actual vs Actual As of As of Period Ending vs As of vs Period Ending For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Account Type GLBT12 GLBS12 LC_MSG LC_STRING LC_DATESTRLC_DATEST2O_YEAR1 FO_YEAR2 DO_PERIOD1 O_PERIOD2 LL_LOGOK LLL_OPTOK TG_DSPALT LN_CNUM CTLN_PWID ATL_RWARRY LA_RWDHEADL_DETDSC 2O_ROWHEAD O_ROWLEVELLC_RWRKEY L_LVLKEY LL_RPTVAR LLC_RWSORT L_SRTORD MO_ORDER LC_RWLOAD2L_LODMAP LO_ACNTGRP L_HDRVARS LC_TITLE TGD_SDATE TLC_DATE1 C_RETFD RGC_COMPID LC_DATE2 O_ZEROBAL O_ROUND G_FMTSTR LC_RWFRM LGC_ADRVPRG lc_rwsort lc_rwload2 o_bdgstrf o_bcodef o_bdgstr As of As of Period Ending BS_COMPACT2 Comparative Balance Sheet - Actual vs Prior Period vs Prior Year Account Type GLBT13 GLBS13 BS_COMPACT3 Comparative Balance Sheet - Actual vs Budget vs Prior Year Account Type GLBT14 GLBS14 BS_COMPACT4 Comparative Balance Sheet - Actual vs Budget vs Prior Period Account Type GLBT14 GLBS14 For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts BS_COMPACT2 BS_COMPACT2 Closing Entry lc_lastprd lc_curyear lc_lastyr LC_STRING LC_RPTDATELC_DATESTRLN_CNUM T2LN_PWID FL_RWARRY DLA_RWDHEADL_DETDSC O_ROWHEAD O_ROWLEVELLC_RWRKEY L_LVLKEY TL_RPTVAR LLC_RWSORT L_SRTORD DO_ORDER 2LC_RWLOAD2L_LODMAP LO_ACNTGRP O_BDGSTR LO_BCODE LL_HDRVARS GD_SDATE MO_YEAR O_PERIOD1 C_RETFD TEGC_COMPID LC_RWCOD RLC_TITLE TLC_RWFRM LGC_ADRVPRGO_ZEROBAL O_ROUND O_YECLOSE G_FMTSTR LC_LASTPRDGN_FCPRDS LC_CURYEARLC_LASTYR o_yeclosef o_yeclose a_rwwblke/ lc_colpict lc_totpict ln_am01ni ln_am02ni ln_am03ni BS_COMPACT2 INCLUDE INCLUDE INCLUDE BS_COMPACT3 INCLUDE INCLUDE BS_COMPACT4 INCLUDE INCLUDE ln_am01bal ln_am02bal ln_am03bal L_RPTVAR O_YECLOSE G_OPNFL TRGC_IDRVTMPGC_TMPF5 FGC_EXTDBF L_SETCHT DLN_CWID LC_COLPICTL_PICFMT LLC_CFORMATO_DECM TLC_TOTPICTLC_GFORMATLC_RWCOD DLN_AM01NI L_NETINC 2O_YEAR LO_PERIOD1 LC_LASTPRDLN_AM02NI LC_CURYEARLN_AM03NI L_BDGINC O_BCODE AMOUNT01 AMOUNT02 AMOUNT03 RLN_AM01BALLN_AM02BALLN_AM03BALA_GLACNT GLTYPE M03NI a_gltyp2 a_gltyp2/e gltype ln_lastrec EXCLUDE L_SETCHT G_OPNFL GF_GLTYPEFA_GLTYP2 PA_RWWBLK FL_RPTVAR LN_LASTRECO_ZEROBAL AMOUNT01 TAMOUNT02 LAMOUNT03 lc_lastyr Invalid year entered! Invalid period entered! Invalid Budget ID entered Invalid Budget ID entered for a_glhbud// bcode1 a_glhbud a_glhbud a_glhbud Budget F for not found. a_glhbud Budget F for not found. a_glhbud a_glhbud Budget vs Same Period Budget Prior Year As of As of Period Ending Selected Budget for - Selected Budget for Level of Detail: Zero Balance Accounts Account Type GLBT15 GLBS15 LC_RPTDATELC_STRING LC_DATESTRO_YEAR PL_RPTVAR FLC_LASTYR O_PERIOD O_BCODE1 O_BCODE2 TLL_LOGOK LLL_OPTOK TLC_MSG G_DSPALT G_OPNFL ATGF_GLHBUDFA_GLHBUD LN_CNUM 2LN_PWID LL_RWARRY LA_RWDHEADL_DETDSC O_ROWHEAD O_ROWLEVELLC_RWRKEY L_LVLKEY L_HDRVARS LC_TITLE GD_SDATE RC_RETFD TEGC_COMPID O_ZEROBAL O_ROUND G_FMTSTR LC_RWFRM LGC_ADRVPRG Invalid Year entered! Invalid Period entered! Invalid Segment ID entered! Invalid Segment Value entered! o_rowlevelf o_rowlevel lc_rwsort lc_rwload2 o_segstrf o_segstr Single Segment Balance Sheet As of As of Period Ending For Segment: Segment Value: For All Accounts Account Group: F Level of Detail: Closing Entry Account Type GLBT01 GLBS01 LC_STRING LC_RPTDATEO_YEAR STRO_PERIOD1 O_SEGID FGN_TOTSEGSO_SEGVAL LL_LOGOK LL_OPTOK TLC_MSG LG_DSPALT SLN_CNUM LN_PWID L_RPTVAR TO_ROWLEVELL_RWARRY LA_RWDHEADL_DETDSC LO_ROWHEAD LC_RWRKEY L_LVLKEY LC_RWSORT L_SRTORD LO_ORDER LC_RWLOAD2L_LODMAP O_ACNTGRP L_HDRVARS O_SEGSTR ELC_TITLE GD_SDATE LC_DATESTRC_RETFD TEGC_COMPID LC_SEGDESCO_YECLOSE O_ROUND G_FMTSTR RLC_RWFRM LGC_ADRVPRG Invalid Year entered! Invalid Period entered! Invalid Segment ID entered! Invalid Segment Value entered! o_rowlevelf o_rowlevel lc_rwsort lc_rwload2 o_segstrf o_segstr Single Segment Balance Sheet Showing FF BS_DEPTPTD2 Period Year 8 to Date Activity As of As of Period Ending For Segment: Segment Value: For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Closing Entry Account Type GLBT03 GLBS03 LC_STRING LC_RPTDATEO_YEAR STRO_PERIOD1 O_SEGID FGN_TOTSEGSO_SEGVAL LL_LOGOK LL_OPTOK TLC_MSG LG_DSPALT SLN_CNUM LN_PWID L_RPTVAR TO_ROWLEVELL_RWARRY LA_RWDHEADL_DETDSC LO_ROWHEAD LC_RWRKEY L_LVLKEY LC_RWSORT L_SRTORD LO_ORDER LC_RWLOAD2L_LODMAP O_ACNTGRP L_HDRVARS O_SEGSTR ELC_TITLE LC_RWCOD GD_SDATE RLC_DATESTRC_RETFD TEGC_COMPID LC_SEGDESCO_ZEROBAL O_YECLOSE O_ROUND G_FMTSTR GLC_RWFRM LGC_ADRVPRG Invalid Year entered! Invalid Period entered! Invalid Segment ID entered! Invalid Segment Value entered! o_rowlevelf o_rowlevel Account Type GLBT04 GLBS04 lc_rwsort lc_rwload2 o_segstrf o_segstr Balance Sheet - Single Segment Breakout As of As of Period Ending For Breakout Segment: Breakout Segment Value: For All Accounts For Account Group: F Level of Detail: Sorted by Zero Balance Accounts Closing Entry LN_SETCNT LC_STRING LC_RPTDATEO_YEAR O_PERIOD1 O_SEGID GSGN_TOTSEGSO_SEGVAL LL_LOGOK TLL_OPTOK LLC_MSG SG_DSPALT SLN_CNUM LN_PWID TL_RPTVAR LO_ROWLEVELL_RWARRY DLA_RWDHEADL_DETDSC O_ROWHEAD LC_RWRKEY L_LVLKEY LC_RWFRM LGC_ADRVPRGLC_RWSORT L_SRTORD O_ORDER LC_RWLOAD2L_LODMAP EO_ACNTGRP L_HDRVARS O_SEGSTR RLC_TITLE RGD_SDATE ELC_DATESTRC_RETFD TEGC_COMPID LC_SEGDESCO_ZEROBAL O_YECLOSE O_ROUND G_FMTSTR o_yeclosef o_yeclose a_rwwblke/ lc_colpict lc_totpict ln_am01ni ln_am02ni SUBSTR(glacnt, ga_segbeg[VAL(o_segid)], ga_seglen[VAL(o_segid)]) = o_segval INCLUDE INCLUDE ln_am01bal ln_am02bal L_RPTVAR O_YECLOSE G_OPNFL TEGC_IDRVTMPGC_TMPF5 GC_EXTDBF L_SETCHT SLN_CWID LC_COLPICTL_PICFMT LLC_CFORMATO_DECM SLC_TOTPICTLC_GFORMATLN_AM01NI L_NETINC LO_YEAR DO_PERIOD1 LN_AM02NI AMOUNT01 AMOUNT02 LN_AM01BALLN_AM02BALA_GLACNT GGLTYPE M02NI IS_DEPBYTD1 IS_DEPBPTD1 The Beginning Period/Year can't be later than the Ending Period/Year. lc_colpict lc_totpict a_glstru// segide Income Statement: Single Segment vs Rest of Company for Year to Date For year: through Period Income Statement: Single Segment vs Rest of Company for Period to Date Period Income Statement: Single Segment vs Rest of Company for Range of Periods Period through Period For Account Group: For Accounts in Sorted by Zero Balance Accounts TRIM(l_glstr("SEG1LDESC") TRIM(l_glstr("SEG1SDESC") <:ROWKEY::C|SEG1 + " " + l_glstr("SEG SDESC") + C|SEG lc_rwsort lc_rwload2 LL_PTDREPTLL_YTDREPTLL_PRDRANGLL_SEGMENTLL_PCTSLS LL_CONT LC_STRING LC_RWCOD GO_YEAR1 NGO_PERIOD1 O_YEAR2 ATO_PERIOD2 G_DSPALT TGC_OSEOL TLL_LOGOK LL_OPTOK LLN_CNUM DLN_GNUM LN_PWID L_RWARRY L_HDRVARS L_RPTVAR LLN_CWID LLC_COLPICTL_PICFMT LC_CFORMATO_DECM LC_TOTPICTLC_GFORMATG_OPNFL GF_GLSTRUFO_SEGID RLC_TITLE TO_YEAR O_ACNTGRP GA_SEGDES O_SEGVAL A_GLSTRU LSEGDES O_ORDER O_ZEROBAL O_ROUND G_FMTSTR O_ROWHEAD LA_RWDHEADLC_RWRKEY LN_SEGCNT GN_TOTSEGSLC_SEGCNT LC_RWSORT L_SRTORD ELC_RWLOAD2L_LODMAP a_rwwblke/ ln_pearns ln_pearnc LN_TOTPCLSG_OPNFL PTGC_IDRVTMPGC_TMPF5 TGC_EXTDBF L_SETCHT L_RPTVAR AMOUNT01 GLN_PEARNS AMOUNT02 LN_PEARNC RIOD2 TA_GLACNT TGLTYPE a_gltyp2 a_gltyp2/e gltype EXCLUDE L_SETCHT SA_GLSTRU TO_SEGID PA_RWWBLK TG_OPNFL GF_GLTYPEFA_GLTYP2 O_ZEROBAL AMOUNT01 AMOUNT02 a_rwwblke/ lc_colpict lc_totpict ln_pearn1 ln_pearn2 ln_pearn3 LN_TOTPCLSG_OPNFL TGC_IDRVTMPGC_TMPF5 TGC_EXTDBF L_SETCHT FL_RPTVAR LN_CWID LC_COLPICTL_PICFMT LC_CFORMATO_DECM LC_TOTPICTLC_GFORMATAMOUNT01 AMOUNT02 LAMOUNT03 DLN_PEARN1 LN_PEARN2 LN_PEARN3 RVARS LA_GLACNT LGLTYPE a_gltyp2 a_gltyp2/e gltype EXCLUDE L_SETCHT SG_OPNFL TGF_GLTYPEFA_GLTYP2 TA_RWWBLK O_ZEROBAL AMOUNT01 AMOUNT02 AMOUNT03 Beginning Period may not be greater than Ending Period. AL_COMPPTD1 Invalid year entered! Invalid period entered! Beginning Account may not be greater than Ending Account. AL_DEPTPTD1 Invalid year entered. Invalid period entered. Invalid Segment ID entered. Invalid Segment Value entered. o_scale <:ROWKEY::P|CODE+P|TRANSET:><:LENKEY::36:> o_segstrf o_segstr AL_COMPPTD1 General Ledger Detail Report For period From period For ALL Accounts For Account F through Zero Activity Accounts , Summarized by AL_DEPTPTD1 General Ledger Detail Report - Single Segment Only For period From period For Segment: Segment Value: .... Zero Activity Accounts , Summarized by LC_MSG SLL_CONT TO_PERIOD1 O_PERIOD2 LL_LOGOK LL_OPTOK G_DSPALT LC_RWCOD O_YEAR TO_GLACNT1 O_GLACNT2 O_SEGID GN_TOTSEGSO_SEGVAL TL_RPTVAR O_SCALE LLN_CNUM DLN_GNUM LN_PWID L_RWARRY LC_RWRKEY L_HDRVARS O_SEGSTR LLC_TITLE TLC_HEAD1 LC_HEAD2 LC_HEAD3 O_ZEROBAL O_SUMMBY lc_colpict lc_totpict L_RPTVAR SLC_COLPICTL_PICFMT LC_CFORMATLC_TOTPICTLC_GFORMAT a_glhent// batchno1e a_glacnt// glacnte a_glbals// glacnt1e ACCOUNT NUMBER a_rwwblk a_rwwblk a_rwwblke/ Summarized for this account INCLUDE a_rwwblke/ DATE + SOURCE JOURNAL a_rwwblk a_rwwblk a_rwwblke/ Summarized by date + source journal INCLUDE a_rwwblke/ INCLUDE AL_COMPPTD1 AL_DEPTPTD1 lc_totbbal G_OPNFL SGF_GLHENTFGF_GLACNTFGF_GLBALSFO_SUMMBY TA_RWWBLK TBLOCKTAG AMOUNT01 AMOUNT02 TTRDATE YEARPRD SOURCE COMMENT GSTRANNO TCODE GC_IDRVTMPGC_TMPF1 DGC_EXTDBF XTDBF O_ZEROBAL GC_EXTNDX GC_TMPF5 PLC_RWCOD A_GLACNT TO_GLACNT1 GLACNT O_GLACNT2 LC_GLACNT GA_SEGBEG O_SEGID GA_SEGLEN O_SEGVAL RL_RPTVAR LC_TOTBBALA_GLBALS O_YEAR O_PERIOD1 FYBGBAL LYTDDR YTDCR PTDDR PTDCR A_GLHENT lc_colpict lc_totpict LN_PWID SL_RPTVAR FLC_COLPICTL_PICFMT FLC_CFORMATLC_TOTPICTLC_GFORMATX 000001 999999 a_glbtch// BR_POSTSUM1 a_glhent// a_glbtch a_glhent a_glbtch' a_tmpf1 Posted Batch Summary For Batch through For all Journals Limited to Source Journal: BR_UPSTSUM1 a_glhunp// batchno1e a_glbtch EXCLUDE UHEAO UHEAOCD a_glbtch' a_tmpf1e/ Unposted Batch Summary For Batch through For all Journals Limited to Source Journal: Cancelled and Deleted Batches BR_DETLREG1 a_glhent// batchno1e a_glhunp// batchno1e batchno EXCLUDE PLSYCD EXCLUDE PLSYCD Batch Transaction Details For Batch through For all Journals Limited to Source Journal: Cancelled and Deleted Batches O_BATCH1 SO_BATCH2 FL_HDRVARS G_OPNFL FGF_GLBTCHFA_GLBTCH TLC_RWCOD TGF_GLHENTFA_GLHENT TDISTINCT GLMODULE BATCHNO BSTAT SO_SRCJRNL A_TMPF1 LC_TITLE PLC_HEAD1 DLC_HEAD2 GF_GLHUNPFO_DELETED GC_IDRVTMPGC_TMPF1 PGC_EXTDBF A_GLHUNP LC_BATCHNOLC_HEAD3 sycdfis a_sycdfi// compid1/ The Beginning Period/Year can't be later than the Ending Period/Year. a_sycdfi ln_pearn lc_per lc_per &lc_perc = a_sycdfi->yearprd &lc_perc = "999999" lc_per 999999 999999 There are fewer than 13 periods defined following the Beginning Period Ending Period does not exist in the fiscal calendar. The Income Statement will report through Period the last period in the fiscal calendar. The Income Statement will report through Period Period not found in the fiscal calendar. Please reenter. LL_CONT SLC_MSG FLN_TOTPRDSLN_LASTPRDG_OPNFL HFGC_IDRVDBFCOMPID TGC_COMPID O_PERIOD2 O_YEAR2 O_YEAR1 O_PERIOD1 GC_OSEOL GN_FCPRDS LN_PER LC_PER PL_RPTVAR DLC_PERC A_SYCDFI FYEARPRD LN_PWID RDLC_PER13 DG_DSPALT LL_LOGOK LL_OPTOK Income Statement Comparison Period through Period For All Accounts For Account Group: F Level of Detail: Zero Balance Accounts lc_colpict lc_totpict Thousands Account Type GLIT13 GLIS13 a_gltype// gllowe gltype a_glbals// glacnt1e a_glacnt// glacnte Account Number a_glacnt->glacnt SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[2], ga_seglen[2]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[3], ga_seglen[3]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[4], ga_seglen[4]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[5], ga_seglen[5]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[6], ga_seglen[6]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) Account Type a_glacnt->gltype a_tmpf1// glacnt/ SICXT INCLUDE LOCATE FOR rowkey = &lc_keyval. REPLACE glacnt WITH a_glbals->glacnt, rowkey WITH &lc_keyval. EXCLUDE LOCATE FOR rowkey = &lc_keyval. REPLACE glacnt WITH a_glbals->glacnt, rowkey WITH &lc_keyval. EXCLUDE INCLUDE amount ln_pearn REPLACE &lc_amountc WITH &lc_amountc. + IIF(LEFT(a_gltype->gltype, 1) $ "SI", a_glbals->ptdcr - a_glbals->ptddr, a_glbals->ptddr - a_glbals->ptdcr) &lc_pearnc = &lc_pearnc - a_glbals->ptddr + a_glbals->ptdcr SICXT a_gltyp2 a_gltyp2/e gltype LN_PER SLC_PER FLC_PERC DSLC_LOW PRDLC_AMOUNTCLC_PEARNC LC_STRING LC_ORIENT L_HDRVARS LC_TITLE O_PERIOD1 O_YEAR1 O_PERIOD2 O_YEAR2 O_ACNTGRP O_ROWLEVELO_ZEROBAL O_ROUND G_FMTSTR FLN_PWID L_RPTVAR LC_COLPICTL_PICFMT LC_CFORMATO_DECM OLC_TOTPICTLC_GFORMATLN_ROUND LC_RWFRM LGC_ADRVPRGLA_RWDHEADL_DETDSC RO_ROWHEAD G_OPNFL ELGF_GLTYPEFGLTYPE GLLOW A_GLTYPE LGF_GLBALSFGF_GLACNTFA_GLBALS GLACNT A_GLACNT LC_KEYVAL GA_SEGDES GC_IDRVTMPGC_TMPF1 AMOUNT01 SAMOUNT02 AMOUNT03 AMOUNT04 EAMOUNT05 2AMOUNT06 AMOUNT07 AMOUNT08 CAMOUNT09 CAMOUNT10 AMOUNT11 SAMOUNT12 AMOUNT13 RROWKEY B95YEARPRD PLC_GLACNT A_TMPF1 PTDDR PTDCR A_GLTYP2 99999999 99999999 99999999 99999999 99999999 99999999 99999999 99999999 No segment values have been selected. Returning to Option Grid. o_segidf o_segid o_decmf o_decm lc_lsegdesf a_glstru// segide lc_lsegdes Income Statement Comparison As of For All Accounts in Selected Segments Level of Detail: Zero Balance Accounts lc_colpict lc_totpict o_rowhead LN_SELCNT LC_SEGLEN LL_CONT DSLC_STRING LC_RPTDATELC_SELCNT LC_SEG1 LC_SEG2 LC_SEG3 LC_SEG4 LC_SEG5 LC_SEG6 LC_SEG7 LC_SEG8 LL_LOGOK LL_BLKOK LLL_OPTOK G_DSPALT GC_OSEOL FL_RPTVAR O_SEGID O_DECM TLN_PWID L_HDRVARS G_OPNFL OGF_GLSTRUFLC_LSEGDESA_GLSTRU LSEGDES LLC_TITLE GGD_SDATE SO_YEAR RO_PERIOD C_RETFD TEGC_COMPID O_ROWLEVELO_ZEROBAL G_FMTSTR LLC_COLPICTL_PICFMT FLC_CFORMATLC_TOTPICTLC_GFORMATLL_PRTOK LL_DOCOK O_ROWHEAD LA_RWDHEADL_DETDSC a_gltype// gllowe No Income or Expense accounts defined.; Returning to Report Catalog. gltype a_gltyp2 a_gltyp2/e gltype a_tmpf1// lc_seg lc_segnam ln_pearn0 &lc_pearnc = 0.00 99999999 ln_pearn0 &lc_pearnc = 0.00 a_tmpf1// segval/ a_glsegs// segid1e a_glbals// glacnt1e a_glacnt// glacnte GLTYPE INTO A_GLTYPEF RELATIONz GLACNT INTO A_GLACNTF RELATIONz SUBSTR(GLACNT, GA_SEGBEG[LN_SEGID], GA_SEGLEN[LN_SEGID]) INTO A_TMPF1 RELATIONz Account Number a_glacnt->glacnt SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[2], ga_seglen[2]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[3], ga_seglen[3]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[4], ga_seglen[4]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[5], ga_seglen[5]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) + SUBSTR(a_glacnt->glacnt, ga_segbeg[6], ga_seglen[6]) SUBSTR(a_glacnt->glacnt, ga_segbeg[1], ga_seglen[1]) Account Type a_glacnt->gltype a_tmpf2// glacnt/ SICXT a_tmpf1, SICXT LOCATE FOR rowkey = &lc_keyval. INCLUDE EXCLUDE REPLACE gldesc WITH lc_glsdesc, glacnt WITH lc_glacnt, gltype WITH a_gltype->gltype, gltdesc WITH a_gltype->gldesc, glmtyp WITH LEFT(a_gltype->gltype, 1), glmtdes WITH IIF(SEEK(LEFT(a_gltype->gltype, 1) + "00", "a_gltyp2"), a_gltyp2->gldesc, IIF(LEFT(a_gltype->gltype, 1) = "S", "Sales", IIF(LEFT(a_gltype->gltype, 1) = "I", "Other Income", IIF(LEFT(a_gltype->gltype, 1) = "X", "Expenses", IIF(LEFT(a_gltype->gltype, 1) = "C", "Cost of Goods", IIF(LEFT(a_gltype->gltype, 1) = "T", "Taxes", "")))))), rowkey WITH &lc_keyval. EXCLUDE INCLUDE amount0 ln_pearn0 REPLACE &lc_amountc WITH &lc_amountc + IIF(LEFT(a_gltype->gltype, 1) $ "SI", a_glbals->ptdcr - a_glbals->ptddr, a_glbals->ptddr - a_glbals->ptdcr) &lc_pearnc = &lc_pearnc - a_glbals->ptddr + a_glbals->ptdcr Account Type Account Type GLIT8S GLIS8S LN_PER LC_PER LC_PERC DSLC_LOW LC_GLDESC LN_SEGCNT LC_AMOUNTCLC_PEARNC LN_SEGID O_SEGID G_OPNFL GF_GLTYPEFGLTYPE GLLOW LL_LOGOK LL_BLKOK LLL_OPTOK G_DSPALT A_GLTYPE FA_GLTYP2 FGC_IDRVTMPGC_TMPF1 TGC_EXTDBF SEGID SEGVAL OGLDESC RUFGLSDESC ESSEGPIK SEGNUM LGA_SEGLEN LN_CNT SLC_CNT RLC_SEGC LC_SEGNAMCL_RPTVAR A_TMPF1 GS_251 MCGF_GLSEGSFGF_GLBALSFGF_GLACNTFA_GLBALS TGLACNT TA_GLACNT TGA_SEGBEG O_ROWLEVELLC_KEYVAL GA_SEGDES GC_TMPF2 PAMOUNT01 LAMOUNT02 AMOUNT03 EAMOUNT04 2AMOUNT05 AMOUNT06 AMOUNT07 CAMOUNT08 CGLTDESC GLMTYP SGLMTDES ROWKEY RYEARPRD PO_YEAR PO_PERIOD LC_GLACNT A_TMPF2 O_ZEROBAL PTDDR PTDCR A_GLSEGS LC_GLSDESCGN_TOTSEGSLC_SEGNUM LC_RWFRM LGC_ADRVPRGP Financial Ratios Report Fiscal Year through Period ln_per1 ln_per2 ln_daysyr ln_dayslp ln_earn sychfis a_sychfi// compid1/ sycdfis a_sycdfi// compid1/ a_glbals LN_PWID L_HDRVARS LC_TITLE SLC_HEAD1 O_YEAR1 LC_HEAD2 O_PERIOD1 L_RPTVAR LN_PER1 G_OPNFL GC_IDRVDBFGC_COMPID COMPID DBFLN_PER2 A_SYCDFI YEARPRD LLN_DAYSYR EDATE A_SYCHFI FYBDATE FLN_DAYSLP BDATE TA_GLBALS a_glacnt// glacnt/ a_glbals// yearprd/ SCITX glacnt1 G_OPNFL GF_GLACNTFGF_GLBALSFGLACNT A_GLACNT O_YEAR1 O_PERIOD1 LN_EARN A_GLBALS YEARPRD GLTYPE PTDDR PTDCR FGLACNT1 Summary GLCFLS GLCFLO8 Statement of Cash Flows (Indirect Method) Statement Period Year to Date FF ln_netinc ln_begcash ln_endcash lc_cflodsc lc_catgdsc LC_RWFRM GC_ADRVPRGO_ROWHEAD LN_PWID L_HDRVARS LC_TITLE LC_HEAD1 LC_HEAD2 O_PTDYTD O_PERIOD1 O_YEAR C_RETFD GC_COMPID L_RPTVAR LN_NETINC L_NETINC lc_colpict lc_totpict a_rwwblke/ sort/ a_tmpf3e/ L_RPTVAR LN_CWID GLC_COLPICTL_PICFMT LC_CFORMATLC_TOTPICTLC_GFORMATG_OPNFL GC_IDRVTMPGC_TMPF5 GC_EXTDBF O_PTDYTD FYBGBAL YTDBAL PTDBAL GLCFLO LLN_BEGCASHLN_ENDCASHGC_TMPF3 XTDBF A_TMPF3 A_RWWBLK TWHILE a_glacnt// glacnt/ G_OPNFL GF_GLACNTFA_RWWBLK TGLACNT A_GLACNT TGLCFLO TL_IS1000_D L_IS1000_L L_XX1000_V L_IS1102_V L_IC1000_V L_TU1000_V L_TU2000_D L_TU2000_V L_TB1000_D L_TB1000_L L_TB1000_V L_TP1000_D L_TP1000_V L_IS1102_D L_IS1102_L L_IC1000_D L_IC1000_L L_IC1200_D L_GLACNT_D L_GLACNT_V L_GLSTRU_D L_GLSTRU_L L_GLSTRU_V L_GLSEGS_D L_GLSEGS_V L_GLTYPE_D L_GLTYPE_V L_GLGRUP_D L_GLGRUP_V L_GLAUTO_D L_GLAUTO_V L_GLBUDG_D L_GLBUDG_V L_SYRPRF_D L_SYRPRF_V L_AR1000_D L_AR1000_L L_BS100_D L_BS100_L L_BS101_D L_BS101_L L_BS101_V L_BS110_D L_BS110_L L_BS110_V L_BS111_D L_BS112_D L_BS112_L L_BS112_V L_BS113_D L_BS102_D L_BS103_D L_BS104_D L_BS104_L L_IS3000_D L_IS3000_L L_IS3000_V L_IS3100_L L_IS3100_V L_AL001D L_AL001L L_AL001V L_BR001L L_BR001V L_IS13P_D L_IS13P_V L_IS8S_D L_IS8S_V L_RATIOD L_RATIOV L_CFLOD L_CFLOL L_CFLOV C:\GLDISK\ C:\GLDISK\GLRLOG.PRG GLRLOG.FXP