RE: COM/IFM Question -- MAPICS-L

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.