Hi Eric,
This looks pretty much like what we were planning on doing.
I forgot about the File Maintenance options to actually put the Batch/Lot
number into the system. That's why I was going to create a quick and
dirty program to populate the Location File.
Thanx for the help and the heads up.
Thanx,
Nick
Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx
Eric Wolf <eric_a_wolf@xxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
03/16/2009 03:43 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
To
<mapics-l@xxxxxxxxxxxx>
cc
Subject
Re: [MAPICS-L] Turning on Batch/Lot control
Nick,
This is what the knowledge base suggests:
Here is the solution: Activating Batch Lot control
Tracking inventory by batch/lot numbers is only possible in a controlled
warehouse. To turn on batch/lot control for items in a controlled
warehouse do the following:
1. Look at IM tailoring question I016 and make sure the environment is
setup to handle batch/lot control. Change the IM tailoring question to
allow batch lot control if it is set to N. This allows you to use the
batch/lot control function.
2. In IM item master file maintenance, change the batch/lot control flag
from 0 to 1 for all items to be batch/lot controlled.
3. In IM inquiry, option 8. Location Detail - By Item/Warehouse, look up
these items and print screens showing all locations and quantities in each
controlled warehouse. If there is nothing on hand for the item then there
are no location quantity records for which you need to do assign batch/lot
numbers.
4. In IM file maintenance, Location Control, option 2. Batch/Lot
Numbers, enter the item number, warehouse, and location. When prompted,
enter the batch/lot number that you want to assign to the quantity in that
location. Do this for each location/quantity record for each item.
If you need to divide the quantity in one location into multiple batch
lots, do the following:
a. Go to IM file maintenance, Location Control, Location Detail,
Location Quantities and zero out the quantity in the location.
b. In the same menu option, add back quantities with batch/lot numbers,
to total the original on-hand quantity for the location.
c. Run Location Quantity Audit -- verifies that the sum of location
quantities in the SLQNTY file matches Item Balance on-hand qty.
This will ensure that any changes to quantities were done correctly.
Note:
For items whose batch/lot control flag has been turned on, inventory will
be tracked by batch lot number. You will be required to enter a batch/lot
number on all receipt transactions. Some issue transactions can use an
existing batch lot number or may require you to specify one. If an item
exists in one location with 20 different batch/lot numbers, one apiece,
you will have to issue 20 IP transactions to issue the material to a
manufacturing order, instead of one IP for 20 pieces.
See hyperlink for information on how to deactivate or turn off batch/lot
control for an item
Here is the problem or goal:
Activating Batch Lot control
Changing to Batch lot control
Ramifications of activating batch lot control
Turn on batch/lot control
We are thinking of turning on Batch/Lot Control for a few selected
Material Items. That is the easy part.
I think all I have to do is write a program that will update SLQNTY with
the Batch/Lot Number of the items we turn on. We don't care about
History
and that kind of stuff.
Does this sound right? Or, are there any other files that I might be
concerned about?
_________________________________________________________________
Express your personality in color! Preview and select themes for Hotmail®.
http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGTX_WL_HM_express_032009#colortheme
_______________________________________________
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
