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