RE: COM/IFM Question -- MAPICS-L

Bob,
I agree that IMHIST does have separate SA records for each item on the invoice 
and each item has the same order number. But the transaction amount field for 
each SA record is zero (as we process a zero dollar invoice for warranty 
customers by selecting 'Y' for no charge item). So this does not give me a 
break down of the transaction amount (avg cost*qty) for each line item.

For instance (for warranty customer and CO has 2 items on it), 

COM History
============
CO 5885 
Customer #: 1452556
Invoice Amount: $0.00

IM History
==========
1.
Item: 733655
W/h: XXX
Loc: YYY
Qty: 1
Amount: $0.00
Average Cost: $25.00

2.
Item: 733656
W/h: XXX
Loc: YYY
Qty: 1
Amount: $0.00
Average Cost: $15.00 

GL Lines
========
Transaction #: 003232
Unit: 12323
Nature: 34322
Value: $38.00
Narrative: CO 5885 Customer Order

Using your approach (YAA7REP-->YAARREP-->IMHIST), my query returns:

UNIT  NATURE  CO/CM  G/L VALUE   ITEM   AMOUNT           
12323 34322   5885    38.00        733655   0   
12323 34322   5885    38.00        733666   0   

So the G/L value ($38) is the sum of the avg costs of both items. Is there any 
other field that I should be looking at in IMHIST? Let me know. I have a 
feeling I'm missing something!!!! 

How did you set up the G/L Rules so they distinguish between warranty and 
non-warranty items when
they assign accounts???

We use item accounting class for this. So for a given customer class and 
turbine, the nature used will be different depending on what item accounting 
class has been used. For instance, item accounting class 005 assigns it to 
warranty account.

Thanks,
Nandu




-----Original Message-----
From: Bob Tenney [mailto:bobtenney@xxxxxxxxxxxxx]
Sent: Tuesday, August 19, 2003 11:18 AM
To: MAPICS ERP System Discussion
Subject: Re: COM/IFM Question


Nandu, IMHIST has a separate SA record for each item on the invoice and each
has the order number. If one GL Line summarizes three items, then it will
link to three IMHIST records.

When I reread your first posting I found a loose end. How did you set up the
G/L Rules so they distinguish between warranty and non-warranty items when
they assign accounts??? Answer this question might give you a bullet-proof
way to filter out non-warranty items from your query.


Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Presence - Crystal Reports
828-526-8976

Visit www.tenneypubs.com for books about
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting,
FRx, and PRESENCE
----- Original Message ----- 
From: "Nandagopal Padmanabhan" <npadmanabhan@xxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Tuesday, August 19, 2003 1:30 PM
Subject: RE: COM/IFM Question


> Bob,
> Thanks for your reply. I tried your first approach
(YAA7REP-->YAARREP-->IMHIST). The query does its job of returning the unit,
nature (warranty), CO/CM#, value, etc. But again the problem is, if a CO/CM
has more than 1 item, the value on the G/L lines is the sum of the (average
costs*qty) of all items on that CO/CM. Basically, the total value associated
with a CO/CM hits the G/L as a single value. Or am I missing something here?
Please correct me if I'm wrong.
>
> Based on our reporting needs and business practices, this query should be
ok for most part. This is because, all big dollar items are entered on CO/CM
in isolation i.e. no other items are added to the CO/CM.
>
> Thanks,
> Nandu
>
> -----Original Message-----
> From: Bob Tenney [mailto:bobtenney@xxxxxxxxxxxxx]
> Sent: Tuesday, August 19, 2003 6:50 AM
> To: MAPICS ERP System Discussion
> Subject: Re: COM/IFM Question
>
>
> Nandu, You can construct a query to get to the IM History this way:
>   a.. Start with the GL Line (YAA7REP) file and select records that have
the warranty account.
>   b.. Use the Admin Div / Transaction ID to link to the G/L Line to its
Transaction Header (YAARREP). Isolate the order number on the left side of
the Transaction Header field.
>   c.. Use the order number to link to underlying SA transactions in
IMHIST.
> If you were using G/L there is no native drilldown to IMHIST. I have
helped clients workaround this limitation by using this approach:
>
>   a.. When the COM/GL interface creates ledger entries, there is an exit
that lets you capture the OEITXN file and save it under a different name.
When you do this, reformat the OEITXN record so there are separate records
for the charge and offset accounts.
>   b.. Because of summarization, you cannot link your reformatted OEITXN
records to individual CURHIS and TEMGEN records. But, you can use the GELMAS
Account and Period to link to the reformatted OEITXN records.
>   c.. The reformatted OEITXT records have a token (TKEN) field that lets
you link to the IMHIST token (TKEN) field.
>
>
> Bob Tenney
> Bob Tenney Solutions, LLC
> MAPICS - FRx - Presence - Crystal Reports
> 828-526-8976
>
> Visit www.tenneypubs.com for books about
> IFM, COM, G/L Interfaces
> Info WorkPlace, Cost Accounting,
> FRx, and PRESENCE
> ----- Original Message ----- 
> From: "Nandagopal Padmanabhan" <npadmanabhan@xxxxxxxxxxxxxx>
> To: <mapics-l@xxxxxxxxxxxx>
> Sent: Friday, August 15, 2003 6:07 PM
> Subject: COM/IFM Question
>
>
> > Hello Group,
> > I have a question about customer orders and credit memos. Is there any
AS/400 file that keeps track of the value (average unit cost * qty) that
hits the GL?
> >
> > To give you some background information, we have a lot of customers that
have warranty with us. So every time items are shipped to customers under
warranty, we process a zero dollar invoice in COM. Basically, the value
(average unit cost * qty) hits the nature setup for warranty account on the
GL. If a CO has more than one item, the value for all items is summed up and
that's what hits the GL. Is there anyway I can get the values (average unit
cost * qty) that hit the GL, on an item-by-item basis?
> >
> > I've been asked to generate a report on the actual average costs that
was used on the GL for some of our big dollar items. I have a query that
gives me a list of COs/CMs for which I would like to have the GL values. How
do I proceed?
> >
> > Since we are on average costing, it's not appropriate to assume that the
current average cost is what would have been used at the time of the
transaction. We have some big dollar items (> $30,000) for which the average
costs change significantly over a period of time. Hence, it is important for
us to find out the average cost used at the time of the transaction. Let me
know if you need more information. Look forward to responses.
> >
> > Thanks,
> > Nandu
> > Nandagopal Padmanabhan
> > Data Analyst | Vestas-AWT
> >
> >
> >
> > _______________________________________________
> > 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 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.