Re: General Ledger Loading

["Pete" <peteo@xxxxxxxx>]

Rusty,
Here is a print screen of the SYSCTL CONOxx record that keeps the status of
each period.
RECORD CODE                                  2    'CZ'
SYSTEM CONTROL FILE KEY                      6    'CONOnn'  nn = COMPANY
NUMB
COMPANY NAME                                15
MAPICS, INC. RESERVED                        2
FIRST FISCAL PERIOD                          2
FIRST PROCESSING PERIOD                      2
*************************************************
GENERAL LEDGER ARRAY                        13    13 1 - BYTE ELEMENTS
                                                  0 = NO TRANSACTIONS EXIST
                                                  1 = TRANSACTIONS ENTERED
                                                  2 = TRANSACTIONS POSTED
                                                  3 = PERIOD CLOSED
                                                  4 = YEAR-END AUDIT
SUCCESSF
GL FILE MAINT ALLOWED                        1    0 = NOT ALLOWED   1 =
ALLOW
FIRST FISCAL SALES ANALYSIS M/P NO.          2
CURRENT SALES ANALYSIS MONTH OR PD. NO.      2
LAST MONTH CLOSED BY SALES ANALYSIS          2
To get this go CAS ... opt #3 (maint) opt #13 (work with logic) opt #5
(print sysctl layouts)

Pete Olshavsky
Ind mapics programmer/Systems Analyst









----- Original Message -----
From: Rusty Jackson <rustyjackson@xxxxxxxxxxx>
To: 'MAPICS ERP System Discussion' <mapics-l@xxxxxxxxxxxx>
Sent: Tuesday, April 08, 2003 9:21 AM
Subject: General Ledger Loading


> I am doing some work for a client that is converting from PRMS to MAPICS.
We
> are currently working on converting the General Ledger application.  I
plan on
> using the General Ledger Master offline file load through Cross Apps to
load
> GELMAS with the basic account information for the type 1 record as well as
the
> debit and credit amounts for each period that have been closed.  We will
also
> load the budget and last year information with this process.  However,
they
> want to do the conversion multiple times, once to check out the conversion
and
> to be able to "play" in MAPICS and once when they are ready to go live.  I
> envision a problem doing this since MAPICS keeps up with status
(closed/trans
> in TEMGEN, etc.) of each period in the SYSCTL file.  Years ago, I knew how
to
> "massage" the period fields but it has been a while.  Does anyone have any
> experience with the SYSCTL fields and, if so, would you share it?
>
> Thanks,
>
> Rusty Jackson
> Rusty Jackson And Associates
> P.O. Box 20193
> Knoxville, TN  37940
>
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>
>