Re: COM/IFM Question -- MAPICS-L

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