× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.