Re: INVTXN question...

Yes, I can see where it would be useful, we just did not know about
this little feature, found out after 7 years! No one ever asked the
right questions in the Accounting Department.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Rusty Jackson
Sent: Thursday, June 07, 2007 9:00 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] INVTXN question...


That is something that has "bit" MAPICS users for many years. It allows
you to have multiple costs for a single item.

I have some clients that have multiple remote locations where the cost
for an item is different for each one. They load the cost that is
applicable for each warehouse in the Item Balance file record which
results in the transactions amounts being calculated correctly,

Rusty Jackson
Rusty Jackson & Assoc.
Knoxville, TN



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Lloyd Degnon
Sent: Thursday, June 07, 2007 11: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