Re: MAPICS-L Digest, Vol 7, Issue 43 -- MAPICS-L

Also, do not forget the limits on using the Batch/Lot control.

For an example, correct me if I am wrong, I remember that when we activated
batch/lot control because we manufactured medical devices, we had no
problems with batch/lot controls. The only issue we have was Kits.
Sometimes we sell kit items that has maybe from 10 to 80 medical devices in
one product. The Kit/Components does not accept items with batch/lot
control items. That through us a curve ball.

Just to let you know if that still the case or Mapics resolve the 'limits'
on kitting.

Gil

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Tuesday, March 17, 2009 1:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 7, Issue 43

Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."

Today's Topics:

1. Turning on Batch/Lot control (Nick_Radich@xxxxxxxxxxxxxx)
2. Re: Turning on Batch/Lot control (Eric Wolf)
3. Re: Turning on Batch/Lot control (Nick_Radich@xxxxxxxxxxxxxx)
4. XA eWP R7.8 AT PTF 9000 (Kevin Fox)

----------------------------------------------------------------------

message: 1
date: Mon, 16 Mar 2009 14:18:48 -0600
from: Nick_Radich@xxxxxxxxxxxxxx
subject: [MAPICS-L] Turning on Batch/Lot control

Hello everyone,

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?

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

------------------------------

message: 2
date: Mon, 16 Mar 2009 13:40:34 -0700
from: Eric Wolf <eric_a_wolf@xxxxxxxxxxx>
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

------------------------------

message: 3
date: Mon, 16 Mar 2009 14:49:22 -0600
from: Nick_Radich@xxxxxxxxxxxxxx
subject: Re: [MAPICS-L] Turning on Batch/Lot control

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?