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
