Al
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
increased.
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:
IM
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
field?
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
Period:
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
field?
I suggest that this should be an option offered by the IM Mapics Infor
Questionnaire.
I look forward to your comments on this matter.
Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR
aldg3@xxxxxxxxx
al.gershen@xxxxxxxxxxxx
_______________________________________________
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,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
midrange.com
