The GL was never intended to do product or customer level profitability
analysis; maybe down to a profit center level (plant or subsidiary) is about
as far as you should go. I suspect you find yourself right now with a HUGE
number of GL accounts and GLI rules. Ideally you could use XA's sales
history and standard/actual costs to create a data base (SQL?) of data that
represents invoice line items and special charges +
commission/rebate/promotion date. At that point you use SQL Reporting
Services or INFOR PM10 or Cognos (via INFOR) to provide the reports you
need.
Best Regards
Richard (Dick) Stover
Consulting Manager
GUIDE TECHNOLOGIES LLC
INFOR GOLD LEVEL CHANNEL PARTNER
www.guidetechnologies.com
rstover@xxxxxxxxxxxxxxxxxxxxx
215-499-8530
SAVE THE DATE - System i User Conference 2011 - Gaylord Opryland; Nashville,
TN; October 2-5
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Shirley Lu
Sent: Tuesday, March 22, 2011 9:27 AM
To: 'mapics-l@xxxxxxxxxxxx'
Subject: [MAPICS-L] Mapics's GL Accounting Code Structure
Hi there,
Our company's current GL accounting code was designed to conduct product PL
analysis. Product ID is part of GL code, one of the segments.
If we like to analyze customer PL, would that be possible to do? We
consider two options, leave current GL codes intact, create
another set of GL code for customer only. We have three companies right
now, each company has its own set of GL. We can create company 4
for customer oriented GL entries.
Another option is to modify current GL code, add customer ID as part of GL
segment. Problem of this option is GL code exceeded 15 digits, secondly
Can product and customer GL coexist in Mapics?
I do not know whether this is feasible to do, any implications to existing
GL interfaces with other Mapics applications like COM, AR, AP, IM etc.
Any feedback would be highly appreciated. Any Mapics GL consultant is
welcomed to explore potential consulting project with us
The purpose of this project is to make creation of our company's product PL
and customer PL before contribution margin line possible
Thank you so much
Shirley Lu
Manager, Financial Planning
Apple & Eve LLC
2 Seaview Boulevard
Port Washington, NY 11050
516.621.1122 x 241
shirley.lu@xxxxxxxxxxxxxxx
_______________________________________________
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
