Floor stock that needs to be lot traced

Rob has a good point, validate the business case for the lot control.
That said, one other direction that you could go, would be to issue the
material to the job based on the labels/markups on the traveler when the
assemblies are received to stock, the next job, or shipped. You can issue
material after you have done the work. Mass issue could also be done at the
work center.

A "non-lot" control method would be to backflush the material and keep tabs
on when each new lot was issued to the floor thru a kanban approach. Only
having one lot on the floor at a time. If someone wanted to know what was
used, you would have to go back to some transaction log of transferring the
material from the warehouse to the floor. The comments field could hold
your lot information.

HTH.

Bruce
bruce@...




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Tuesday, August 04, 2009 5:13 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Floor stock that needs to be lot traced

Not possible (natively) to have it both ways (backflushing AND serial# or
Lot control). You could probably put some complex custom solution together
but is it worth it?

Perhaps a physical control system (using part source labels of what
PO/Line/Release & receipt date parts came from) that could be pre-printed
when stock is moved to your floor for eventual use and backflush. As long as
you are using printed travelers with parts lists included, it would not be
horrific to ask production to peel off a label from the floor bin & attach
it to the hardcopy traveler (thus showing the source as long as you retain
the papwerwork).

If that is unworkable, try setting up an scan based process that writes the
backflushed material source (again from the segragated floor bin 'lot') &
have it imbed the part lot source data right into a UD field in the JobMtl
table.

In the end, you are still relying on people to not only do the physical or
scan enabled tracking, but to also be doing true receiving & stocking FIFO
control so as not to mix 'lots'.

Frankly, if it is that critical, you probably SHOULD make them lot
controlled (which still relies on people doing the right thing) and Issuing
the parts to the jobs.

I'd make QC put forward a VERY compelling business case need before going
down any of those roads.

Rob Brown




________________________________
From: cajahn <cajahn@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 4, 2009 1:10:12 PM
Subject: [Vantage] Floor stock that needs to be lot traced


Has anyone out there have ideas about how to handle the following situation:

We must lot trace all parts purchased for the product we manufacture. We
have hardware that is stored at the point of consumption that we do not want
to have to pick but must be lot traced. We also want to capture the costs
of the hardware during a cost roll.

The only solution we've been able to come up with is to not lot trace these
items and capture the lot trace information manually on the traveler and
backflush the quantities to keep inventory accurate. This doesn't make our
quality department happy however.

Any ideas?

Thanks

CJ







[Non-text portions of this message have been removed]



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
Has anyone out there have ideas about how to handle the following situation:

We must lot trace all parts purchased for the product we manufacture. We have hardware that is stored at the point of consumption that we do not want to have to pick but must be lot traced. We also want to capture the costs of the hardware during a cost roll.

The only solution we've been able to come up with is to not lot trace these items and capture the lot trace information manually on the traveler and backflush the quantities to keep inventory accurate. This doesn't make our quality department happy however.

Any ideas?

Thanks

CJ
Not possible (natively) to have it both ways (backflushing AND serial# or Lot control). You could probably put some complex custom solution together but is it worth it?

Perhaps a physical control system (using part source labels of what PO/Line/Release & receipt date parts came from) that could be pre-printed when stock is moved to your floor for eventual use and backflush. As long as you are using printed travelers with parts lists included, it would not be horrific to ask production to peel off a label from the floor bin & attach it to the hardcopy traveler (thus showing the source as long as you retain the papwerwork).

If that is unworkable, try setting up an scan based process that writes the backflushed material source (again from the segragated floor bin 'lot') & have it imbed the part lot source data right into a UD field in the JobMtl table.

In the end, you are still relying on people to not only do the physical or scan enabled tracking, but to also be doing true receiving & stocking FIFO control so as not to mix 'lots'.

Frankly, if it is that critical, you probably SHOULD make them lot controlled (which still relies on people doing the right thing) and Issuing the parts to the jobs.

I'd make QC put forward a VERY compelling business case need before going down any of those roads.

Rob Brown




________________________________
From: cajahn <cajahn@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 4, 2009 1:10:12 PM
Subject: [Vantage] Floor stock that needs to be lot traced


Has anyone out there have ideas about how to handle the following situation:

We must lot trace all parts purchased for the product we manufacture. We have hardware that is stored at the point of consumption that we do not want to have to pick but must be lot traced. We also want to capture the costs of the hardware during a cost roll.

The only solution we've been able to come up with is to not lot trace these items and capture the lot trace information manually on the traveler and backflush the quantities to keep inventory accurate. This doesn't make our quality department happy however.

Any ideas?

Thanks

CJ







[Non-text portions of this message have been removed]