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
/
GLCPYA._XP
(
.txt
)
< prev
next >
Wrap
MS Visual FoxPro App
|
1993-02-11
|
30KB
|
758 lines
TYPE("lc_cpytyp") = "C"
Accounts
Account Groups
Auto Distributions
Standard Entries
Allocation Entries
Recurring Entries
Budgets
Account Types
@*IHN
syccomp
a_syccom//
compid
sycdata
a_sycdat//
compid1
sycdfis
a_sycdfis//
compid1
syhhelp
a_syhhel//
a_glsegs//
segid1
a_gltype//
a_gltype5
a_gltype
Account Types
Account types and ranges must be defined
before copying accounts.
a_glacnt//
glacnt
lw_sqlbrow
lw_smbrow
lw_cpybrow
lw_glcpa1
Copy
Copy
Select Company to Copy From
Setting up company
file names
sycpath
a_sycpat//
compid1
sydindx
a_sydind//
tablid2
sydtabl
a_sydtab//
tablid
sydtapp
a_sydtap//
applid1
GLSTRU
GLSEGS
GLTYPE
GLHGRP
GLDGRP
GLHAUT
GLDAUT
GLHBUD
GLDBUD
GLACNT
a_frstru//
Company
has a different account code
structure than Company
. Select another Company?
Select
Cancel
Company
's calendar has
fiscal periods.
Company
has
fiscal periods. Proceed or cancel?
Proceed
Cancel
a_syccom
a_sycdat
a_frsegs//
segid1
a_frtype//
a_frtype//
gltype
a_frhgrp//
grpcode
a_frdgrp//
grpcode
a_glhgrp//
grpcode
a_gldgrp//
grpcode
a_frhaut//
auttype1
a_frdaut//
auttype1
a_glhaut//
auttype1
a_gldaut//
auttype1
a_frhbud//
bcode1
a_frdbud//
bcode1
a_glhbud//
bcode1
a_gldbud//
bcode1
a_fracnt//
glacnt
a_fracnt
a_glacnt
a_acliste/
Company
does not contain any
that are not already in Company
Select another company?
Select
Cancel
a_aclist
a_aclist
gltype
Company
does not contain any
that are not already in Company
Select another company?
Select
Cancel
a_frsegs
a_frtype
a_fracnt
a_aclist
a_frhgrp
a_glhgrp
a_acliste/
Company
does not contain any
that are not already in Company
Select another company?
Select
Cancel
a_aclist
a_frhaut
a_glhaut
a_acliste/
Company
does not contain any
that are not already in Company
Select another company?
Select
Cancel
a_aclist
a_frhbud
a_glhbud
a_acliste/
Company
does not contain any
that are not already in Company
Select another company?
Select
Cancel
a_aclist
a_gltype
GLOPNF
LC_CPYTYP
GN_TRACE
FE_TRACE
TGL_ASSERT
E_ASSRT
TLC_ACCTMSKLC_GLACNT
LC_ACNTLENLN_DESLEN
LC_DESLEN
LC_TITLE
LL_SEGOK
LL_CONT
LC_XFNAME
LL_NOSAVE
LN_TOTSEGSLC_FRSTRUFLC_FRSEGSFLC_FRTYPEFLC_FRHGRPFLC_FRDGRPFLC_FRHAUTFLC_FRDAUTFLC_FRHBUDFLC_FRDBUDFLC_FRACNTFGN_ACCTLENLN_TYPE
LC_GRPPIC
GC_ACCTPICG_OPNFL
SKGC_IDRVDBFGF_GLSEGSFGF_GLTYPEFA_GLTYPE
GLTYPE
G_LCKFL
GN_RETRY
FG_DSPALT
GF_GLACNTFA_SYCCOM
TGC_COMPID
LW_SQLBROWLW_SMBROW
LW_CPYBROWGM_MAIN
OWGU_MANT
GU_MANT3
PLW_GLCPA1
G_PNTBG
L_DSPCO
ELC_FRCOMP
L_SELCO
GK_ESC
G_DSPPRC
CGF_GLSTRUFD_SETFL
GF_GLHGRPFGF_GLDGRPFGF_GLHAUTFGF_GLDAUTFGF_GLHBUDFGF_GLDBUDFA_SYCPAT
A_SYDIND
A_SYDTAB
A_SYDTAP
A_FRSTRU
SLOCKED
GN_TOTSEGSGA_SEGLEN
SEGID
SEGLEN
LGA_SEGBEG
SEGSTRT
GGA_SEGMSK
SEGMASK
EG_GETDLG
GC_OSEOL
FYPERDS
GN_FCPRDS
A_SYCDAT
SEGVAL
GSFGLLOW
PEFGRPCODE
PFAUTTYPE
BCODE
BUDFBYEAR
YEARPRD
DFGLACNT
NTFA_FRACNT
GLDESC
WHYNOT
KEYGC_IDRVTMPGC_TMPF1
GC_EXTDBF
A_ACLIST
GC_EXTNDX
A_FRSEGS
A_FRTYPE
TL_BRWENT
GC_ACCTHDRL_CPYAC
SKLL_ADDTYPELC_GLTYPE
LC_GLLOW
LC_GLUPP
CLTYPEHD
ESTYPEHD
GLUPP
L_CPYGR
A_FRHGRP
GROUP
OGRPDESC
CNDESCRIPT
TA_FRDGRP
A_FRHAUT
AUTONO
GGLTDES
A_FRDAUT
A_FRHBUD
BDESC
A_FRDBUD
GC_ADRVPRGGC_TMPF2
a_gltype
ALL FF
\<Add
\<Tag
\<Save
E\<xit
DO l_cpyacb WITH PAD()
GN_TRACE
E_TRACE
FLN_ADDCNT
LN_CNT
A_GLTYPE
GLTYPE
KGLDESC
LA_TYPES
NLN_CTR
LN_FROMROWLN_TOROW
LB_TYPE
LL_NOSAVE
LM_GLCOPY
LW_GLCPA1
LP_SELECT
LP_TAG
LP_SAVE
LP_EXIT
LW_SQLBROW
TYPE("lc_pad") = "C"
LP_SELECT
Enter account number or press <F2>
to tag accounts
a_glacnt
Account F
already exists in company
Account F
not found in company
Tag Accounts
Reenter
Select Action from Menu
LP_TAG
LP_SAVE
LP_EXIT
Select Action from Menu
LC_PAD
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
LC_PADNAMELC_MSG
G_DSPST
MEGN_MSGLINELW_GLCPA1
LC_GLACNT
GN_ACCTLENLC_ACCTMSKGK_ESC
MSKL_CPYACC
A_ACLIST
GLACNT
GS_251
LN_ADDCNT
L_BRWENT
GC_COMPID
LC_FRCOMP
G_GETDLG
FLL_SAVED
ELL_NOSAVE
GC_APPLID
GC_USERID
L_CPYACD
LM_GLCOPY
ENTER
KEYBOARD CHR(gk_ctlend) PLAIN
RIGHTMOUSE
DO l_putls WITH .f.
SPACEBAR
DO l_putls WITH .t.
CTRL+A
DO l_allact WITH .t.
CTRL+a
DO l_allact WITH .t.
CTRL+U
DO l_allact WITH .f.
CTRL+u
DO l_allact WITH .f.
<Spacebar> toggles one,
<Ctrl-A/U> toggles all, <Enter> saves
BROWSE FIELDS glacnt :H = gc_accthdr &lc_acntlen. :R, add, gldesc :H = "Acct. Description" &lc_deslen. NOAPPEND NODELETE NOEDIT NOMENU TITLE "Available " + lc_title WINDOW lw_sqlbrow COLOR SCHEME 10 FREEZE add
ENTER
RIGHTMOUSE
SPACEBAR
CTRL+A
CTRL+a
CTRL+U
CTRL+u
GN_TRACE
E_TRACE
FENTER
RIGHTMOUSESPACEBAR
DNAMEA
MEG_DSPST
NEGN_MSGLINELL_HOTKEY
GL_HOTKEY
A_ACLIST
Transfer FF
@R 99,999cD
Transfer
Cancel
have been chosen for transfer.
Validating Account Types
a_gltype,
Account Range Doesn't Exist (1)
Account Is Different Type
Account Range Doesn't Exist (2)
All of the selected accounts have
non-matching
GL types and will not be copied.
of the
selected accounts have
non-matching
GL types and will not be copied.
Proceed
Cancel
accounts
have Auto Distribution codes.
Copy codes or leave blank?
Leave Blank
Be sure to copy Auto Distributions
from Company
Adding
Copying
a_glbals//
compid1
a_tmpf3e/
a_glsegs5
a_glsegs
a_glacnt5
a_glacnt
a_glbals5
a_glbals
Validating account segment values
Creating account FF
a_tmpf3R
GN_TRACE
E_TRACE
FLL_TRANSFRLN_N
MOUSELN_PERIODSLN_DLG
AMELN_NOMATCHLC_TMPACNTLN_RESP
NELN_AUTONO
LN_ACLIST
LN_CNTR
LN_ADDCNT
G_GETDLG
RLC_TITLE
G_DSPALT
GK_ESC
SFRG_DSPPRC
A_ACLIST
GS_251
GLACNT
TGA_SEGLEN
A_GLTYPE
FGLLOW
ACNTGLUPP
ACNTWHYNOT
TGLTYPE
HA_FRACNT
HAUTONO
GC_OSEOL
LC_FRCOMP
G_DSPST
SFGC_COMPANYGN_MSGLINEG_OPNFL
GF_GLBALSFA_SYCDFIS
COMPID1
GC_COMPID
GC_FCYR
TCOMPID
LA_PERIODSYEARPRD
A_GLBALS
SLA_GLBALS
GC_IDRVTMPGC_TMPF3
PGC_EXTDBF
G_LCKFL
DSGN_TOTSEGSGA_SEGBEG
GC_TMPF2
PA_GLSEGS
A_FRSEGS
ADDUSER
GC_USERID
ADDDATE
PFADDTIME
PFGF_GLSEGSFGF_GLACNTFA_TMPF3
DFALL
DFA_GLACNT
LL_SAVED
\<Tag
\<Save
E\<xit
DO l_cpygrb WITH PAD()
GN_TRACE
E_TRACE
FLN_ADDCNT
LN_CNT
USELL_NOSAVE
LM_GLCOPY
LW_GLCPA1
LP_TAG
CNTLP_SAVE
LP_EXIT
LW_SQLBROW
TYPE("lc_pad") = "C"
LP_TAG
LP_SAVE
Transfer FF
@R 99,999cD
Transfer
Cancel
Adding
have been chosen for transfer.
LP_EXIT
Select Action from Menu
LC_PAD
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
LC_PADNAMEL_CPYGRC
ELL_SAVED
ELN_ADDCNT
G_GETDLG
LC_TITLE
G_DSPST
GC_COMPANYGN_MSGLINEL_CPYGRD
LM_GLCOPY
LP_EXIT
FRG_DSPALT
A_ACLIST
EL_BRWENT
ENTER
KEYBOARD CHR(gk_ctlend) PLAIN
RIGHTMOUSE
DO l_putls WITH .f.
SPACEBAR
DO l_putls WITH .t.
CTRL+A
DO l_allact WITH .t.
CTRL+a
DO l_allact WITH .t.
CTRL+U
DO l_allact WITH .f.
CTRL+u
DO l_allact WITH .f.
<Spacebar> toggles one,
<Ctrl-A/U> toggles all, <Enter> saves
Type Description
Available
Group
Group Description
Available
ENTER
RIGHTMOUSE
SPACEBAR
CTRL+A
CTRL+a
CTRL+U
CTRL+u
GN_TRACE
E_TRACE
FENTER
RIGHTMOUSESPACEBAR
DNAMEA
CPYGRC
EG_DSPST
GN_MSGLINELL_HOTKEY
GL_HOTKEY
A_ACLIST
LC_CPYTYP
GLTYPE
LCOPY
GLDESC
FRLC_TITLE
LW_SMBROW
GROUP
DESCRIPT
ac_error
ac_error
grpcode = a_aclist->group
grpcode = a_aclist->group
a_frhgrp
a_frdgrp
a_glhgrp
a_gldgrp
auttype + autono = lc_cpytyp + a_aclist->group
auttype + autono = lc_cpytyp + a_aclist->group
a_frhaut
a_frdaut
a_glhaut
a_gldaut
bcode + byear = a_aclist->group
bcode + LEFT(yearprd, 4) = a_aclist->group
a_frhbud
a_frdbud
a_glhbud
a_gldbud
Validating Accounts and Account Types
Group Code
Standard Code
Allocation Code
Recurring Code
Budget Code
88888
Duplicate
in TO Company
&lc_hcond.
&lc_dcond.
Account doesn't exist
in TO Company
GROUP F
Account Type Mismatch
FROM =
TO =
ac_errorQ
Copying
APPEND FROM DBF(lc_fhead) FOR &lc_hcond.
APPEND FROM DBF(lc_fdetail) FOR &lc_dcond.
Validation errors have occured.
Display a report of the errors?
Display
Print
Copy
- Validation Error Report
.t. .AND.
.t.
glcpya
ll_cont = g_cncjob("")
ac_error
GN_TRACE
E_TRACE
FLL_RETURN
LC_HCOND
ELC_DCOND
LC_FHEAD
ELC_FDETAILLC_THEAD
ELC_TDETAILLC_MSGACT
LN_ECOUNT
LL_PRNT
LL_CONT
LN_RPTCOL
LC_XTITLE
LC_FRMFILELC_CPYTYP
AC_ERROR
GLTYPE
REASON
DESCRIPT
GLACNT
EGN_ACCTLENG_DSPPRC
A_ACLIST
TGS_251
TGROUP
LC_ACCOUNTA_GLACNT
A_FRACNT
TGLDESC
LC_TITLE
A_GLTYPE
LTYPEHD
ESTYPEHD
GLLOW
FGLUPP
ADDDATE
ADDTIME
ADDUSER
TGC_USERID
G_LCKFL
GN_RETRY
LM_GLCOPY
LL_NOSAVE
LN_ADDCNT
LN_RESP
G_GETDLG
GC_OSEOL
SGC_IDRVTMPGC_TMPF5
GC_EXTTXT
C_SELPR
LC_HEAD1
LC_HEAD2
LC_COND
LC_FOR
PFGC_ADRVPRGG_PRNRP
FG_DSPRP
TYPE("lc_def") = "C"
TYPE("lc_msg") = "C"
TYPE("lc_applid") = "C"
syccomp
a_syccom//
compid
sycdata
a_sycdat//
compid1
a_sycdat
ENTER
KEYBOARD CHR(gk_ctlend) PLAIN
RIGHTMOUSE
KEYBOARD CHR(gk_ctlend) PLAIN
Number
Company Name
ENTER
RIGHTMOUSE
LC_DEF
LC_MSG
FLC_APPLID
GN_TRACE
EE_TRACE
GL_ASSERT
E_ASSRT
ILLC_RETURN
LL_HOTKEY
LC_TEXT
LC_SALIAS
LL_RESULT
GL_HOTKEY
G_OPNFL
GC_IDRVDBFA_SYCCOM
FCOMPID
GC_COMPID
LW_SELCO
ENTER
RIGHTMOUSECOMPANY
EL_DSPCO
ENGK_ESC
TYPE("ll_space") = "L"
RIGHTMOUSE
SPACEBAR
Available
RIGHTMOUSE
DO l_putls WITH .f.
SPACEBAR
DO l_putls WITH .t.
LL_SPACE
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
RIGHTMOUSESPACEBAR
LLN_RECNO
GS_251
LN_ADDCNT
LL_NOSAVE
TYPE("ll_apprv") = "L"
Available
LL_APPRV
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
LN_RECNO
LLN_ADDCNT
LL_NOSAVE
GS_251
TYPE("lc_wcomp") = "C"
LC_WCOMP
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
GC_COMPID
A_SYCCOM
LCOMPANY
ADDRSS1
STATE
COMPID
TYPE("ll_wait") = "L"
NOWAIT8
ENTER
KEYBOARD CHR(gk_ctlend) PLAIN
BROWSE FIELDS glacnt :H= gc_accthdr &lc_acntlen. :R :W = .f., add :H= "Add" :W = .f. , gldesc :H= "Description" :W = .f. &lc_deslen. NOAPPEND NOMENU NODELETE FOR .NOT. EMPTY(add) TITLE lc_title + " Marked for Copying" WINDOW lw_cpybrow COLOR SCHEME 1 &lc_wait.
BROWSE FIELDS gltype :H= "Type" :4 :R :W = .f., add :H= "Add" :3 :W = .f. , gldesc :H= "Description" :W = .f. :67 NOAPPEND NOMENU NODELETE FOR .NOT. EMPTY(add) TITLE lc_title + " Marked for Copying" WINDOW lw_cpybrow COLOR SCHEME 1 &lc_wait.
GTARBD
BROWSE FIELDS group :H= "Group" :W = .f., add :H= "Add" :W = .f. , descript :H= "Description" :W = .f. &lc_deslen. NOAPPEND NOMENU NODELETE NOEDIT FOR .NOT. EMPTY(add) TITLE lc_title + " Marked for Copying" WINDOW lw_sqlbrow COLOR SCHEME 1 &lc_wait.
ENTER
LL_WAIT
GN_TRACE
FE_TRACE
GL_ASSERT
E_ASSRT
LC_WAIT
ENTER
LLL_HOTKEY
GL_HOTKEY
LC_CPYTYP
L_CPYAC
L_CPYACB
L_CPYACC
L_CPYACD
L_CPYGR
L_CPYGRB
L_CPYGRC
L_CPYGRD
L_SELCO
L_PUTLS
L_ALLACT
L_DSPCO
L_BRWENT
C:\GLDISK\
C:\GLDISK\GLCPYA.PRG
GLCPYA.FXP