Olga,
If you have used the account assignment function and you still don't have
account numbers in INVTXN it could be for 2 reasons - either the criteria
in the rules you have created don't match the data in the transactions -
or you have not assigned priorities to the rules. You must have a rule
and a priority in order for account assignment to be successful.
It's always a good idea to print out the Account Assignment report
(AMIGZRP). You will see any error messages that result from account
assignment.
Dee A. Sondergard
Information Systems International, Inc.
A Global ERP Consulting Firm
815-398-1670 ext 21
ISI consultants ensure consistently top quality implementation services at
all levels of your organization.
"We should be known by what we belong to - not by what belongs to us." -
Unknown
mapics-l-request@xxxxxxxxxxxx
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/07/2007 12:00 PM
Please respond to mapics-l
To: mapics-l@xxxxxxxxxxxx
cc:
Subject: MAPICS-L Digest, Vol 5, Issue 111
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."
Today's Topics:
1. Re: INVTXN question... (Dave Lauderdale)
----------------------------------------------------------------------
message: 1
date: Thu, 7 Jun 2007 11:56:32 -0500
from: "Dave Lauderdale" <DLAUDERDALE@xxxxxxxxxxx>
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
