Re: MAPICS-L Digest, Vol 1, Issue 765

Mark,
In case you're into reading the books - in the IM User's Guide Appendix E 
there are transaction update tables.  So the table will show you which 
transactions update which fields in a series of files (Item Balance, MO 
Master, MO Detail, Location Quantity, and Allocation Quantity.  You need 
an eye chart to read them - but they can be valuable.  Also it helps to 
know that this field is used to get to an "available" quantity.  So I can 
take on hand (MOHTQ)for a production item,  plus on order production 
(MPRPQ)  plus on order purchase (MPUPQ) minus manufacturing allocations 
(MALQT - production allocations from upper level MO's) minus customer 
allocations (PLREQ) to get to "available".  The customer order allocations 
("on order" for COM) are stored in the pick list requirements field 
(PLREQ). The PLREQ is the field that increases when a customer order is 
allocated and decreases (along with on hand) when it is shipped.

Dee A. Sondergard
Information Systems International, Inc.
A Global ERP Consulting Firm

815-398-1670 ext 21

ISI consultants ensure consistently top quality implementation services at 
all levels of your organization.
We make MAPICS work.
Check our website at www.ISIinternet.com for more information.

God Bless our troops and our President and God Bless America



-----Original Message-----
From: Taylor, Mark W [mailto:MarkWTaylor@xxxxxxxxx] 
Sent: Wednesday, September 24, 2003 1:48 PM
To: 'MAPICS-L@xxxxxxxxxxxx'
Subject: On Order Production field in ITEMBL

How/When does the On Order Production field (MPRPQ) in the ITEMBL file
get
updated?
Does the quantity increase when a CO is created and decrease when a
shipment
is made?

Mark Taylor
IT Consultant
Columbus, OH