Olga,
I am originally from down there, moved to San Jose from L.A. when I was
6. Back then, you still took a dirt road from my parents house to
Downtown where I live now! I am looking at the Data, and you are right!
No Transaction info! They must be storing it somewhere else. I'll keep
digging.. Hopefully I will find something useful. We could use the
info here too!
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@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Olga Gunther
Sent: Thursday, June 07, 2007 9:32 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Lloyd, if I could, I would move back up to your area. LOVE Northern
California! I lived in Vallejo for about a year back in 1997, then in
Pacifica in 1998 and I SO MISS IT!
And yes, our weather here, well, sucks. I can't believe the temps (yes,
we are SO spoiled here!) And I am originally from Canada!
Thanks Lloyd!
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Thursday, June 07, 2007 9:28 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Okay, I will look at my Data and get back to you. Are you having
abnormally crummy weather down there like we are up here? My heater is
still going on in the morning! Oh well, spoiled Californians...
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Olga Gunther
Sent: Thursday, June 07, 2007 9:23 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Lloyd, no problem with the soup...but that's what I am having trouble
with, even though the fields are in INVTXN, in our file, they are all
blank!
Olga
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Thursday, June 07, 2007 9:14 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] 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
midrange.com
