I agree with Rich, we are at R6 (going to R7 soon) and have been using
GLI rules since 05/01/2005 and have over 50,000 transactions. The drill
down in IFM is a great tool and time saver. Once the rules are set up
for the account numbers you wish to post to there are no special task to
perform it becomes an accounting function, I.T. no longer has to get
involved at closing.
R.D. Spears
Unaka Company
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard McCracken
Sent: Monday, March 30, 2009 3:59 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Interfacing Inventory Account with the G/L
Since I have not seen other discussions on this topic, I will give my
(somewhat biased) accounting opinion, whether you use GL or IFM, and
give a suggested solution if you will be using GL.
Advantages to using the GL Interface:
1. The GLI rules and priorities allow you to automatically get the
GL distribution for transactions, such as any sales or cost of sales
determination by available fields for product lines, warehouses, item
class, customer class or order class.
2. Having the GL transactions automatically post allows Accounting
to move some of the month end work back into the month.
3. Posting transactions daily allows daily checking that control
accounts such as Accounts Receivable, Raw Materials, Work In Process,
and Finished Goods are always in balance with the supporting detail such
as item balance values, work order totals, and outstanding AR. This
also eliminates month end tasks.
4. Having the GLI post automatically allows Accounting to have a
more independent control of their tasks without as much dependence on IT
for reports over history files.
Now, if you will be using GL, I suggest inserting a task or process that
will copy the transactions that will be posting from GL work files
INVTXN, PCCTXN, and OIETXN to a history file before the GL entries are
created so there will be history available.
Rich McCracken
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Sansi, Jim
Sent: Monday, March 30, 2009 11:56 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Interfacing Inventory Account with the G/L
Like Rich said... IFM mirrors a lot of the information behind each IM
transaction in file UAQNCPP so you can drill down to the transaction
detail from within IFM's GL inquiry.
-J
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard McCracken
Sent: Monday, March 30, 2009 9:50 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Interfacing Inventory Account with the G/L
Which Accounting system are you planning on using, IFM or GL, because
IFM keeps the detail behind the Interfacing entries?
Rich McCracken
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Gershen
Sent: Monday, March 30, 2009 11:42 AM
To: Mapics Mailing List
Cc: Al Gershen
Subject: [MAPICS-L] Interfacing Inventory Account with the G/L
(Resubmitted with a "Subject" added. Opps!)
Hi group:
Our company is upgrading from Mapics DB/Y2K (Mod 4) to Infor XA (Rel 7).
With Mapics DB, we have not used G/L Interfacing for the Inventory
Accounts (thru the IM, PC&C and OE&I).
The representatives of the company assisting with our upgrading,
Barry-Wehmiller International Resources, have suggested to us that we
interface our G/L with the above modules (COM replaces OE&I).
Our shop has around 20,000 IM Inventory transactions every month.
We apparently can interface in one of two ways:
1. In detail with each entry posting to the G/L; or
2. In summary, where all the entries post at a "net" amount to the G/L;
and their detail is lost.
I am again interfacing for the following reasons:
1. Infor XA does not use a subsidiary ledger to collect the detail of
interfacing entries;
2. The G/L would be very large and probably unprintable or usable
because of the number of entries posted therein due to the interfacing.
If Infor XA had a subsidiary ledger, I probably would support
interfacing with the G/L because the detail journal entries would not be
posted directly in the G/L.
But, I'm open minded and I'd like your suggestions, both pro and con,
about interfacing the inventory accounts with the G/L.
I look forward to your comments on this matter.
Have a good week.
Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR
aldg3@xxxxxxxxx
al.gershen@xxxxxxxxxxxx
_______________________________________________
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.
This electronic mail message is intended exclusively for the
individual(s) or entity to which it is addressed. This message, together
with any attachment, is confidential and may contain privileged
information. Any unauthorized review, use, printing, retaining, copying,
disclosure or distribution is strictly prohibited. If you have received
this message in error, please immediately advise the sender by reply
email message to the sender and delete all copies of this message.
THIS E-MAIL IS NOT AN OFFER OR ACCEPTANCE: Notwithstanding the Uniform
Electronic Transactions Act or any other law of similar import, absent
an express statement to the contrary contained in this e-mail, neither
this e-mail nor any attachments are an offer or acceptance to enter into
a contract, and are not intended to bind the sender, LeTourneau
Technologies, Inc., or any of its subsidiaries, affiliates, or any other
person or entity.
WARNING: Although the company has taken reasonable precautions to ensure
no viruses are present in this email, the company cannot accept
responsibility for any loss or damage arising from the use of this email
or attachments.
_______________________________________________
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.
_______________________________________________
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.
This electronic mail message is intended exclusively for the
individual(s) or entity to which it is addressed. This message, together
with any attachment, is confidential and may contain privileged
information. Any unauthorized review, use, printing, retaining, copying,
disclosure or distribution is strictly prohibited. If you have received
this message in error, please immediately advise the sender by reply
email message to the sender and delete all copies of this message.
THIS E-MAIL IS NOT AN OFFER OR ACCEPTANCE: Notwithstanding the Uniform
Electronic Transactions Act or any other law of similar import, absent
an express statement to the contrary contained in this e-mail, neither
this e-mail nor any attachments are an offer or acceptance to enter into
a contract, and are not intended to bind the sender, LeTourneau
Technologies, Inc., or any of its subsidiaries, affiliates, or any other
person or entity.
WARNING: Although the company has taken reasonable precautions to ensure
no viruses are present in this email, the company cannot accept
responsibility for any loss or damage arising from the use of this email
or attachments.
_______________________________________________
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.
midrange.com
