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
midrange.com
