RE: GL Master Account Numbers

For those users that want to standardize or change their COA structure,
we have a tool called Account Conversion Tool (ACT), that allows you to
restructure your account numbers (Code) through a set of rules. Once the
rules are established, the tool will go through your complete Mapics
data base and replace the old codes with the new account codes, This
includes combining old accounts into one new account, combining balances
of the old accounts.


Karl H. Touset
President/CEO
Advanced Logic Solutions, Inc.
Tel. +01 770 578-6771
Fax +01 770 578-6858



-----Original Message-----
From: Bob Tenney [mailto:bobtenney@earthlink.net]
Sent: Tuesday, September 03, 2002 7:44 PM
To: mapics-l@midrange.com
Subject: Re: GL Master Account Numbers

Bonnie, MAPICS II had a seven-digit numeric account code. This code was
expanded to fifteen digits in MAPICS/DB Release 2 and changed to fifteen
characters in MAPICS XA Release 3 (1992)

Both ControllerVision and FRx allow you to parse the account code to fit
your needs. You can also have AS/400 queries that split the account code
into components. For example, suppose you use seven characters of the
account -- first four characters are the Account and the last three are
the
department.
The following AS/400 query calculations will split the account code into
its
components:

ACCT = Substr(GLANO, 1, 4)
DEPT = Substr (GLANO, 5,3)

One last point. If you are going to split your account code it really
pays
to use the same positions within the account to represent account
components
throughout your COA. For example, suppose you use a six-character
account
for your balance sheet accounts and a four-character account for profit
and
loss accounts. If you use departments with profit and loss accounts, you
should enter the department number in position seven -- not position
five.


Bob Tenney
bob@tenneypubs.com
Bob Tenney Solutions, LLC
MAPICS - FRx - Crystal Reports
1-866-BTENNEY
----- Original Message -----
From: <Bonnie_Lokenvitz@epcmolding.com>
To: <mapics-l@midrange.com>
Sent: Tuesday, September 03, 2002 11:46 AM
Subject: GL Master Account Numbers


>
>
> Was there ever a feature in Mapics GL where one created account
numbers
> with
> decimal points and these could be rolled into a 'master' account?
>
> The Help Desks says not.  but my CFO thinks he did this in Mapics II.
> (before my time).
> We are accomplishing something like this using the custom reports
>
> Is there an add-on reporting package he may have used.
>
> Thanks,
> Bonnie Lokenvitz
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.