Re: GL Master Account Numbers

["Bob Tenney" <bobtenney@xxxxxxxxxxxxx>]

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.
>