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

Problem Environment:
Offline load

Are you using TW's or using IW's either keyed or offline load?

Kevin Fox

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

Hi group:

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.

Al Gershen
Cost Accountant Lead
ECS Composites
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.

This thread ...


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

This mailing list archive is Copyright 1997-2022 by 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.