Your issue with this approach of a formatted account number is that it is
limited and takes constant maintenance because you are trying to do
something the GL was not designed to do.
You say you have purchased F9 which is fine, but it too (like another
product called SpreadSheet server) is limited again by the intent of the GL
structure. FRx was the same. So will any of the other software up the food
chain such as Infor PM10.
My recommendation is to let the ledger do company, division, and profit
center reporting. As I mentioned before, spin off XA's sales history data
(invoice line items) along with any other data such as commissions to a
separate database, then lay a reporting tool such as SQL Reporting Services
(which now has a nice web interface) or Cognos (lite) through INFOR.
Regardless of the database approach, it must reconcile daily to the ledger
sales accounts and the invoices or it is worthless.
Have you had any contact with your affiliate on this matter?
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 12:59 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Mapics's GL Accounting Code Structure
Our current GL structure in Mapics is XXXX(account)-XXX(product
code)-XXX(department). We have Mapics item accounting class setup.
I am able to join OEXITN (GL interface) with MBDDREP (shipment release file)
to find out which product group's revenue and cost got recorded to which GL
account. I am able to produce product PL down to contribute margin line.
We have about 400 customers (customer ID was stratified further by
geographic locations such as Kroger, Kroger-Atlanta), ideal situation is
that we can produce major customer PL, if one customer's profitability is
poor, we like to know which product results in poor profitability.
To achieve that, we think about modifying our current GL code. We just
implemented F9 for financial reporting purpose, at this point, I am not sure
we like to implement another reporting tool.
Thank you
Shirley
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Karl H. Touset
Sent: Tuesday, March 22, 2011 12:44 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Mapics's GL Accounting Code Structure
There is a possibility that the ControllerVision application may be able
to get you the results that you need .
I is dependent on how your structure is currently defined.
Give me a call and we can discuss your exact requirement.
Karl H. Touset
ktouset@xxxxxxxxxx
+1 770 578 6771 Ext 101
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Stover -
Guide
Sent: Tuesday, March 22, 2011 12:15 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Mapics's GL Accounting Code Structure
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.
_______________________________________________
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 EMail message has been checked for viruses and spam by McAfee's
Security-as-a-Service Email Protection.
_______________________________________________
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.
midrange.com
