Re: INVTXN question...

Invtxn has all of that information. You could create a query on that
file for Transaction Type, Date, Item Charge Amount Offset amount, Unit
and Nature for Charge, Unit and Nature for Offset, Unit and Nature for
Variance.

If you have questions call me at 408.360.4365. I will help you for a
can of your delicious Albondigas soup! (just kidding!) Feel free to
call...

Lloyd H. Degnon
Ampro Computers, Inc.
5215 Hellyer Ave. Building 110
San Jose, CA 95138
408.360.4365
www.ampro.com



-----Original Message-----
From: mapics-l-bounces+ldegnon=ampro.com@xxxxxxxxxxxx
[mailto:mapics-l-bounces+ldegnon=ampro.com@xxxxxxxxxxxx] On Behalf Of
Olga Gunther
Sent: Thursday, June 07, 2007 8:58 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...

Lloyd, our standard cost in the Item Balance file is 0.
This problem has been a thorn in my side for almost 4 months now...I
can't believe that MAPICS does not have any option that allows inquiry
on inventory transactions (IMHIST information) with the general ledger
entry record that was created.
I have been trying to do this manually but I have been working on it for
5 days and I don't have the time to do it...

Olga

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Thursday, June 07, 2007 8:52 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...

What is the Standard cost in the Item Balance File? We just
'Discovered' that the Cost in the Item Balance file is check first,
then, if blank, uses unit cost default in the Item master File for the
Transaction amount. We had been trying to figure out where all of these
'strange' amounts were coming from, then we discovered that we had
hundreds of items with standard costs in the item balance file.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Olga Gunther
Sent: Thursday, June 07, 2007 8:42 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] INVTXN question...

Hello!
Does anyone know why the GLI interface file for IM transactions, INVTXN,
does not capture the charge, offset & variance GL account numbers in the
INVTXN record even though the amounts are there?
Specifically, what I am looking for, is a way to reconcile and track
inventory transactions with the ledger entries. Our accounting staff
spends days trying to reconcile the inventory with the general ledger
and always come up short on the inventory side. Any ideas?

Sincerely,
Olga Gunther
AS 400 Ops - Programmer/Mgr
Juanita's Foods
Wilmington, CA