Thanks Charley, you taught me well on that subject - that's why I always check
to make sure no costs are in Item Balance. Things are going well - but you know
how Murphy (or Robert Goulet) likes to stick around here.
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [
mailto:mapics-l-bounces@xxxxxxxxxxxx] On
Behalf Of Charley Simpson
Sent: Thursday, June 07, 2007 1:03 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Hi, Olga.
I have not read through all the mail on this subject (man, there is lots of
it) but be careful about going down the road of using costs in item balance
records. If you start doing that, it greatly magnifies the administrative time
of managing costs and you know how difficult it is to do what we set up in our
project.
Hope all is well with you and eeveryone at Juanita's.
Charley
Olga Gunther <OGunther@xxxxxxxxxxxxxxxxx> wrote:
Absolutely! And maybe some pozole, menudo and albondiga - they have some
great licuados too - strawberry, strawberry/banana, banana and yummy piña
colada.
I think we should have a MAPICS-L get together for those of you who are lucky
enough to go!
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [
mailto:mapics-l-bounces@xxxxxxxxxxxx] On
Behalf Of ARojas@xxxxxxxxxxxxxxxxxxx
Sent: Thursday, June 07, 2007 12:30 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Yes, we will attend the Infor Conference.... if you are coming could you
bring some nachos?...
Antonio.
"Olga Gunther"
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/07/07 12:26 PM
Please respond to
MAPICS ERP System Discussion
To
"MAPICS ERP System Discussion"
cc
Subject
Re: [MAPICS-L] INVTXN question...
If you like nachos, we just came out with individual micro-waveable
nacho cheese cups - is anyone planning on attending the Infor user
conference this year?
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
ARojas@xxxxxxxxxxxxxxxxxxx
Sent: Thursday, June 07, 2007 12:21 PM
To: MAPICS ERP System Discussion
Cc: MAPICS ERP System Discussion; mapics-l-bounces@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] INVTXN question...
Pozole is the best one!.. I'm Mexican and totally approve Juanitas'
products!!... yummy!
Antonio Rojas
I.T. Manager
Senior Aerospace, SSP
Burbank, CA
(818) 260-2218
"Olga Gunther"
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/07/07 11:49 AM
Please respond to
MAPICS ERP System Discussion
To
"MAPICS ERP System Discussion"
cc
Subject
Re: [MAPICS-L] INVTXN question...
Vanessa, you are my HERO! That's what I was missing...talk about the
accounting department totally missing this one...THANK YOU to everyone!
And for those menudo lovers out there - we prepare every type of menudo
- hot & spicy, blanco (white) and all of our other products from SCRATCH
- we cook the bones for the broth and do it like your grandma would...
Website is www.juanitasfoods.com
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Vanessa King
Sent: Thursday, June 07, 2007 11:40 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] INVTXN question...
There are two steps - account assignment and creating the ledger entry.
When
you do the account assignment the accounts are in INVTXN and remain
there
until you create the ledger entries. You can assign accounts many times
until you are ready to book it to the general ledger. Once you create
the
ledger entry, the records get deleted.
Vanessa King
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Olga Gunther
Sent: Thursday, June 07, 2007 2:31 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Okay, when the assigning takes place, the records get deleted from
INVTXN. I have all the rules and priorities set up. Why are the darn
fields in INVTXN when they are never captured?
Sincerely,
Olga Gunther
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Lauderdale
Sent: Thursday, June 07, 2007 9:57 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...
Olga,
Maybe I am misunderstanding this whole conversation, but I thought your
question was why the account numbers were blank while the amount fields
have values. If this is the question, then the answer has to do with
the account assignment tasks.
If you select to track IM/GL transactions, the amounts get loaded every
time there is a transaction. The transaction amount comes from the
fields that Lloyd talked about. However, the account numbers do NOT get
applied until you go through the step to assign accounts. This does not
occur automatically. In general, we only do this at month-end, but it
can be done as often as you want. Are you aware of the account
assignment process and setting up the rules and so forth?
Have I totally misunderstood the question?
David Lauderdale
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Olga Gunther
Sent: Thursday, June 07, 2007 10: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
