× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Jon,

California here... actually not too far away from you (with offices in
Windsor and Ukiah). Can I get a site tour sometime? ;-)

-Jim

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Le Roi
Sent: Thursday, June 07, 2007 1:17 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] INVTXN question...

We modified our procedure to include a step just before creating the
ledger entries. This new step copies the file to a history file so we
can go back and review the transactions. Amazing how many times
accounting has found problems during the close and needed to review the
transaction records to locate the individual record in error.

By the way, how many of us on this list are in California? We have
offices in Petaluma and in San Jose.

Regards,
Jon Le Roi
Dirctor of I.T.
Tegal Corporation
Petaluma, Ca

-----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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.