× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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