Here is the info provided by the support site:
Here is the solution: IW and RW update usage, USEMO in the same warehouse
If you key in or offline load individual IW and RW transactions instead of
using a TW, the IW will increase USEMO (usage month-to-date) and USEYR
(usage year-to-date) in the Item Balance file. The rule for TWs is that if
the transfer is between two locations within same warehouse, usage is not
Here is the problem or goal:
Transfer material in the same warehouse using IW and RW, not TW
Usage in the Item Balance increase after an intrawarehouse transfer
IW and RW update usage, USEMO in the same warehouse
Are you using TW's or using IW's either keyed or offline load?
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Al Gershen
Sent: Thursday, August 21, 2008 8:57 AM
To: Mapics Mailing List
Cc: Al Gershen
Subject: [MAPICS-L] Why do Interwarehouse Issues (IW) increment the USEMO
A person in our Purchase Department inquired of me why the EAANU (Estimated
Annual Usage) of a particular Inventory Item Number was so high?
I looked at the Item Number's IM (Inventory Management) Transaction History
Inquiry Screen and found the the following had occurred during one recent
1. There was only one purchase of the item;
2. All that was purchased was transferred from our company's main warehouse
to the main warehouse at our other plant; and
3. At the other plant's main warehouse, approximately 5% of the inventory
was used in manufacturing.
The EAANU calculation includes the usages reported by the USEMO field and
this field's usages include IW transfers.
In this situation the large IW transfer distorted our main warehouse's EAANU
calculation such that our Purchasing Department might end up ordering too
much of the Inventory Item Number in the future.
On the other side of the coin, the RW (Interwarehouse Receipt) by the
receiving warehouse has no offsetting affect on the USEMO field.
What is the basis for including the IW transfer as an "Issue" in the USEMO
I suggest that this should be an option offered by the IM Mapics Infor
I look forward to your comments on this matter.
Cost Accountant Lead
Grants Pass, OR
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
As an Amazon Associate we earn from qualifying purchases.