Lot Tracking

Yahoo Archive
1
Does anyone have a procedure for lot tracking? We are on Progress .408 and have
been approached by a customer of medical equipment who requires us to lot track
all of the components for his assemblies. I have tried getting info from the
help desk and from my CAM, all to no avail. Time to go to the 'A-Team'. Any and
all help would be appreciated. Pitfalls, shortfalls in the software, bugs,
workarounds, etc all welcome!

Thanks,
-Karl




[Non-text portions of this message have been removed]
2
Is anyone using the lot tracking capability in Vantage and if so how
would you rate its functionality?


Paul H. Smith
Vantage 6.0
3
We use it and it works fine for us. The only problem we had was that once a lot of material was used up it left the lot number in the system. I wrote a procedure that deletes all unused lots. Makes it easier to find what you want.
Jeremy


-----Original Message-----
From: p_ksmith [mailto:psmith@...]
Sent: Friday, April 02, 2004 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking


Is anyone using the lot tracking capability in Vantage and if so how
would you rate its functionality?


Paul H. Smith
Vantage 6.0





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/links
Yahoo! Groups Links
4
It works. It does everything we need it to.

Bob Bruton
Entek Corp.

-----Original Message-----
From: p_ksmith [mailto:psmith@...]
Sent: Friday, April 02, 2004 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking


Is anyone using the lot tracking capability in Vantage and if so how
would you rate its functionality?


Paul H. Smith
Vantage 6.0








[Non-text portions of this message have been removed]
5
I have been using it since it first became available on version 2.7, works
great for me.


Patrick Winter


-----Original Message-----
From: p_ksmith [mailto:psmith@...]
Sent: Friday, April 02, 2004 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking

Is anyone using the lot tracking capability in Vantage and if so how would
you rate its functionality?


Paul H. Smith
Vantage 6.0





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/links
Yahoo! Groups Links
6
Jeremy,

Any chance you could fire that off to me? Love to take a
look at that!

Thanks!
Lorne Rogers

Aria Consulting & Implementers Ltd.

Epicor Vista/Vantage Authorized Re-Seller and Consulting

<http://www.ariaconsulting.net/>

Add this card to your
<http://ariaconsulting.net/vcf/aria.vcf> OutlookT Contacts

-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Friday, April 02, 2004 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Lot Tracking


We use it and it works fine for us. The only problem we had
was that once a lot of material was used up it left the lot
number in the system. I wrote a procedure that deletes all
unused lots. Makes it easier to find what you want.
Jeremy


-----Original Message-----
From: p_ksmith [mailto:psmith@...]
Sent: Friday, April 02, 2004 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking


Is anyone using the lot tracking capability in Vantage and
if so how
would you rate its functionality?


Paul H. Smith
Vantage 6.0





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/links
Yahoo! Groups Links







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/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c43gm62/M=291630.4786521.5933964.
1261774/D=egroupweb/S=1705007183:HM/EXP=1081023212/A=2072415
/R=0/SIG=11thh7ako/*http://www.netflix.com/Default?mqso=6017
8432&partid=4786521> click here

<http://us.adserver.yahoo.com/l?M=291630.4786521.5933964.126
1774/D=egroupweb/S=:HM/A=2072415/rand=330148485>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>


* Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
7
Sure,
Its in MSAccess.

You will need to rename the program LotClear.mdb.
Then relink the tables to Progress via an ODBC connection with the issolation level set to Read Committed.
That shoud do it. We have been running it for two years with no problem. Normally takes 3-10 min to run.
If you have any questions, feel free to call. 1317-398-6684
Thanks
Jeremy


-----Original Message-----
From: Aria Consulting & Implementers Ltd.
[mailto:lrogers@...]
Sent: Friday, April 02, 2004 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Lot Tracking


Jeremy,

Any chance you could fire that off to me? Love to take a
look at that!

Thanks!
Lorne Rogers

Aria Consulting & Implementers Ltd.

Epicor Vista/Vantage Authorized Re-Seller and Consulting

<http://www.ariaconsulting.net/>

Add this card to your
<http://ariaconsulting.net/vcf/aria.vcf> OutlookT Contacts

-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Friday, April 02, 2004 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Lot Tracking


We use it and it works fine for us. The only problem we had
was that once a lot of material was used up it left the lot
number in the system. I wrote a procedure that deletes all
unused lots. Makes it easier to find what you want.
Jeremy


-----Original Message-----
From: p_ksmith [mailto:psmith@...]
Sent: Friday, April 02, 2004 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking


Is anyone using the lot tracking capability in Vantage and
if so how
would you rate its functionality?


Paul H. Smith
Vantage 6.0





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/links
Yahoo! Groups Links







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/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c43gm62/M=291630.4786521.5933964.
1261774/D=egroupweb/S=1705007183:HM/EXP=1081023212/A=2072415
/R=0/SIG=11thh7ako/*http://www.netflix.com/Default?mqso=6017
8432&partid=4786521> click here

<http://us.adserver.yahoo.com/l?M=291630.4786521.5933964.126
1774/D=egroupweb/S=:HM/A=2072415/rand=330148485>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>


* Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service <http://docs.yahoo.com/info/terms/> .




[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/links
Yahoo! Groups Links







[Non-text portions of this message have been removed]
8
Vantage Expert(s)

We are looking into using Vantage Lot Tracking. The challenge we
have is that we need to use lot tracking for multi-level assemblies
(approximately 4 levels) where sub assemblies can be used on
different finished products. Each sub assembly has its own job
number. We do not see a good way to tie everything together. Does
anyone have any experience in this area?

Any help would be greatly appreciated.

Thanks
9
Why not use projects?
-----Original Message-----
From: hollis55555 [mailto:heather@...]
Sent: Tuesday, February 22, 2005 2:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking



Vantage Expert(s)

We are looking into using Vantage Lot Tracking. The challenge we
have is that we need to use lot tracking for multi-level assemblies
(approximately 4 levels) where sub assemblies can be used on
different finished products. Each sub assembly has its own job
number. We do not see a good way to tie everything together. Does
anyone have any experience in this area?

Any help would be greatly appreciated.

Thanks





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/links



----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005


[Non-text portions of this message have been removed]
10
We track lots on every item in the house -- if it is manufactured, it is
stocked using the job number as the lot number, if it is purchased, it is
stocked using the PO number as the lot number. We have complete visibility
on what came from where, fifo, and what went where. We have quite a few
multi-level assemblies and it seems to work fine. Course, we may not be as
big as you are, we have one guy who handles raw materials and one inventory
person for everything else.

Hope this helps,
Lydia

-----Original Message-----
From: hollis55555 [mailto:heather@...]
Sent: Tuesday, February 22, 2005 12:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking




Vantage Expert(s)

We are looking into using Vantage Lot Tracking. The challenge we
have is that we need to use lot tracking for multi-level assemblies
(approximately 4 levels) where sub assemblies can be used on
different finished products. Each sub assembly has its own job
number. We do not see a good way to tie everything together. Does
anyone have any experience in this area?

Any help would be greatly appreciated.

Thanks





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/links
Yahoo! Groups Links
11
We do basically the same as Lydia described, using the job number as the
lot number for manufacturing products, only our purchased materials get a
sequential 7 digit number.

In reality, we really do something slightly more complex than this, and I'm
not sure if it is a residual of another era, or if we really need it (what
Lydia describes will work for most people).

If you routinely issue more than one subassembly lot to a higher level job
and need to keep the subassembly lot numbers separate throughout the
manufacturing process--we do the following---keep adding the subassembly
jobs numbers as the lot numbers as below.

You can then see if Job X was used to Job A somewhere else.
Level Lot Number
===========================
Level 0 JobZ JobY JobX JobW
Level 1 JobY JobX JobW
Level 2 JobX JobW
Level 3 JobW

Level 0 JobA JobB JobX JobW
Level 1 JobB JobX JobW
Level 2 JobX JobW
Level 3 JobW



But regardless of how difficult you make it, lot tracking in Vantage works
well for us.

An example: A few months ago, one of our inspectors found a lot number
error on one of our subassembly part numbers, and I was able to easily
track down all 12,000 parts in 6 different top level assembly jobs with
several different finished good part numbers (thankfully none had shipped),
and repair the lot number.

Hope this helps more than it confuses :-)
Amy O'Malley
Synovis IS
Lino Lakes, MN
omall004@...

On 22 Feb 2005, Lydia Coffman wrote:
>
> We track lots on every item in the house -- if it is manufactured, it is
> stocked using the job number as the lot number, if it is purchased, it is
> stocked using the PO number as the lot number. We have complete
visibility
> on what came from where, fifo, and what went where. We have quite a few
> multi-level assemblies and it seems to work fine. Course, we may not be
as
> big as you are, we have one guy who handles raw materials and one
inventory
> person for everything else.
>
> Hope this helps,
> Lydia
>
> -----Original Message-----
> From: hollis55555 [mailto:heather@...]
> Sent: Tuesday, February 22, 2005 12:49 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Lot Tracking
>
>
>
>
> Vantage Expert(s)
>
> We are looking into using Vantage Lot Tracking. The challenge we
> have is that we need to use lot tracking for multi-level assemblies
> (approximately 4 levels) where sub assemblies can be used on
> different finished products. Each sub assembly has its own job
> number. We do not see a good way to tie everything together. Does
> anyone have any experience in this area?
>
> Any help would be greatly appreciated.
>
12
Thanks for the idea. I will think about how this may help.
13
Lou, We also have the exact same situation and we have more like 50 items or more per job. I concur with you on the time consuming, manual entry problem that is prone to errors occasionally.Currently we are heat tracking in a legacy SQL Server based PC standalone system where we capture the supplier's lot and heat info and scan the certs with reference pointers to pull up in Adobe reader using the lot#, heat# reference. We generate our own Lot# within this system to enter into Vantage. I'm testing adding a UD field to add the heat# and the supplier provided lot# as well. We haven't used the backflushing mechanism yet since just about every part is lot/heat/serial number tracked.
RSN



----- Original Message ----
From: Lou Laird <loulrd@...>
To: vantage@yahoogroups.com
Sent: Thursday, June 28, 2007 9:17:17 AM
Subject: Re: [Vantage] Re: Lot Tracking

We are required to track the heat number of incoming steel for raw material and hardware.
We could have up to 30 items on a job to issue and all of them are currently lot tracked and could have multiple heat lot numbers. Very time consuming even with mass issue because of the multiple heat numbers per component.
What I would like to do is backflush the inventory when we report the picking operation complete, but currently can't bacause of lot tracking.
So our idea is to find some other way to track the supplier heat number. A UD field was one of our thoughts.


Michael McWilliams <mmcwilliams22@ yahoo.com> wrote:
Can you explain a little more about what info you are trying to
accomplish. You might be able to just use a UD table in Vantage
--- In vantage@yahoogroups .com, Lou Laird <loulrd@...> wrote:
>
> We currently lot track purchased parts and we are a make to order
company.
>
> Michael McWilliams <mmcwilliams22@ ...> wrote: --- In
vantage@yahoogroups .com, Lou Laird <loulrd@> wrote:
> Do you lot track both purchased & Manufactured Parts? Are you make
to
> Order?
> >
> > Looking for any companies doing lot tracking outside of Vantage.
> > We current use Vantage lot tracking and want to stop in some
areas
> so we can backflush inventory and we are looking for alternative
> methods to track.
> >
> >
> >
> >
> > ------------ --------- --------- ---
> > Be a PS3 game guru.
> > Get your game face on with the latest PS3 news and previews at
> Yahoo! Games.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ------------ --------- --------- ---
> Ready for the edge of your seat? Check out tonight's top picks on
Yahoo! TV.
>
> [Non-text portions of this message have been removed]
>

------------ --------- --------- ---
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.

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






____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

[Non-text portions of this message have been removed]
14
I'm curious. Whether it's in Vantage or an external tracking system, if
you have multiple heat numbers being issued to a single job how do you
trace the heat numbers to a specific finished part?

Mike Lowe
Corporate I.T. Manager
Connor Manufacturing Services
Direct: (949) 713-3328
Fax: (949) 666-5268
Cell: (949) 973-7621
Skype: Mike.Lowe
Email: MLowe@... <mailto:MLowe@...>
Web: www.connorms.com <http://www.connorms.com/>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RSN
Sent: Thursday, June 28, 2007 10:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Lot Tracking



Lou, We also have the exact same situation and we have more like 50
items or more per job. I concur with you on the time consuming, manual
entry problem that is prone to errors occasionally.Currently we are heat
tracking in a legacy SQL Server based PC standalone system where we
capture the supplier's lot and heat info and scan the certs with
reference pointers to pull up in Adobe reader using the lot#, heat#
reference. We generate our own Lot# within this system to enter into
Vantage. I'm testing adding a UD field to add the heat# and the supplier
provided lot# as well. We haven't used the backflushing mechanism yet
since just about every part is lot/heat/serial number tracked.
RSN

----- Original Message ----
From: Lou Laird <loulrd@... <mailto:loulrd%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, June 28, 2007 9:17:17 AM
Subject: Re: [Vantage] Re: Lot Tracking

We are required to track the heat number of incoming steel for raw
material and hardware.
We could have up to 30 items on a job to issue and all of them are
currently lot tracked and could have multiple heat lot numbers. Very
time consuming even with mass issue because of the multiple heat numbers
per component.
What I would like to do is backflush the inventory when we report the
picking operation complete, but currently can't bacause of lot tracking.

So our idea is to find some other way to track the supplier heat number.
A UD field was one of our thoughts.

Michael McWilliams <mmcwilliams22@ yahoo.com> wrote:
Can you explain a little more about what info you are trying to
accomplish. You might be able to just use a UD table in Vantage
--- In vantage@yahoogroups .com, Lou Laird <loulrd@...> wrote:
>
> We currently lot track purchased parts and we are a make to order
company.
>
> Michael McWilliams <mmcwilliams22@ ...> wrote: --- In
vantage@yahoogroups .com, Lou Laird <loulrd@> wrote:
> Do you lot track both purchased & Manufactured Parts? Are you make
to
> Order?
> >
> > Looking for any companies doing lot tracking outside of Vantage.
> > We current use Vantage lot tracking and want to stop in some
areas
> so we can backflush inventory and we are looking for alternative
> methods to track.
> >
> >
> >
> >
> > ------------ --------- --------- ---
> > Be a PS3 game guru.
> > Get your game face on with the latest PS3 news and previews at
> Yahoo! Games.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ------------ --------- --------- ---
> Ready for the edge of your seat? Check out tonight's top picks on
Yahoo! TV.
>
> [Non-text portions of this message have been removed]
>

------------ --------- --------- ---
Choose the right car based on your needs. Check out Yahoo! Autos new Car
Finder tool.

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

__________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who
knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
<http://answers.yahoo.com/dir/?link=list&sid=396545469>

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




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



[Non-text portions of this message have been removed]
15
I created one UDTable to hold the Raw Material Lots. In our case
every line is a new lot so I create a new record for every line. At
receipt time they put in the Heat and any other info for the lot,
and it copies that info to the UDTable. We use a report that prints
tags from the UDtable to use for labeling and scanning.
When they report production they scan the lot that they are using.
When they do that it creates a record In a second UD table that is a
unique record for the manufactured lot/serial whatever you want to
call it. In our case it is a bundle of items that need to be
identified as unique. That UD record holds the Job Number the
quanity and a bunch of other info as well as the lot
used to create it. When they pack a lot in shipping it goes out to
the second UDTable and Marks a checkbox and puts in the date it was
packed. It also puts the packing slip number on the Manufactured
Lot Record.
When we print our packing slip using crystal we pull all the heat
and chemistry info from the UD table by linking the Pack to the Tags
that shipped. The customer can see every item we shipped with what
heat/lot was used as well as the mechanical and chemical composition
of that heat.

All of our programs that deal with inventory make calls to the
UDtables to update various records or pull data if needed.

--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> I'm curious. Whether it's in Vantage or an external tracking
system, if
> you have multiple heat numbers being issued to a single job how do
you
> trace the heat numbers to a specific finished part?
>
> Mike Lowe
> Corporate I.T. Manager
> Connor Manufacturing Services
> Direct: (949) 713-3328
> Fax: (949) 666-5268
> Cell: (949) 973-7621
> Skype: Mike.Lowe
> Email: MLowe@... <mailto:MLowe@...>
> Web: www.connorms.com <http://www.connorms.com/>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of RSN
> Sent: Thursday, June 28, 2007 10:27 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Lot Tracking
>
>
>
> Lou, We also have the exact same situation and we have more like 50
> items or more per job. I concur with you on the time consuming,
manual
> entry problem that is prone to errors occasionally.Currently we
are heat
> tracking in a legacy SQL Server based PC standalone system where we
> capture the supplier's lot and heat info and scan the certs with
> reference pointers to pull up in Adobe reader using the lot#, heat#
> reference. We generate our own Lot# within this system to enter
into
> Vantage. I'm testing adding a UD field to add the heat# and the
supplier
> provided lot# as well. We haven't used the backflushing mechanism
yet
> since just about every part is lot/heat/serial number tracked.
> RSN
>
> ----- Original Message ----
> From: Lou Laird <loulrd@... <mailto:loulrd%40yahoo.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Thursday, June 28, 2007 9:17:17 AM
> Subject: Re: [Vantage] Re: Lot Tracking
>
> We are required to track the heat number of incoming steel for raw
> material and hardware.
> We could have up to 30 items on a job to issue and all of them are
> currently lot tracked and could have multiple heat lot numbers.
Very
> time consuming even with mass issue because of the multiple heat
numbers
> per component.
> What I would like to do is backflush the inventory when we report
the
> picking operation complete, but currently can't bacause of lot
tracking.
>
> So our idea is to find some other way to track the supplier heat
number.
> A UD field was one of our thoughts.
>
> Michael McWilliams <mmcwilliams22@ yahoo.com> wrote:
> Can you explain a little more about what info you are trying to
> accomplish. You might be able to just use a UD table in Vantage
> --- In vantage@yahoogroups .com, Lou Laird <loulrd@> wrote:
> >
> > We currently lot track purchased parts and we are a make to
order
> company.
> >
> > Michael McWilliams <mmcwilliams22@ ...> wrote: --- In
> vantage@yahoogroups .com, Lou Laird <loulrd@> wrote:
> > Do you lot track both purchased & Manufactured Parts? Are you
make
> to
> > Order?
> > >
> > > Looking for any companies doing lot tracking outside of
Vantage.
> > > We current use Vantage lot tracking and want to stop in some
> areas
> > so we can backflush inventory and we are looking for alternative
> > methods to track.
> > >
> > >
> > >
> > >
> > > ------------ --------- --------- ---
> > > Be a PS3 game guru.
> > > Get your game face on with the latest PS3 news and previews at
> > Yahoo! Games.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > ------------ --------- --------- ---
> > Ready for the edge of your seat? Check out tonight's top picks
on
> Yahoo! TV.
> >
> > [Non-text portions of this message have been removed]
> >
>
> ------------ --------- --------- ---
> Choose the right car based on your needs. Check out Yahoo! Autos
new Car
> Finder tool.
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________________
> Be a better Globetrotter. Get better travel answers from someone
who
> knows. Yahoo! Answers - Check it out.
> http://answers.yahoo.com/dir/?link=list&sid=396545469
> <http://answers.yahoo.com/dir/?link=list&sid=396545469>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
_____________________________________________________________________
_
> This email has been scanned by the MessageLabs Email Security
System.
> For more information please visit http://www.messagelabs.com/email
>
_____________________________________________________________________
_
>
>
>
> [Non-text portions of this message have been removed]
>
16
Mr. McWilliams,

How are you entering all of the Physical and Chemical properties into
Vantage? Are you just dumping the information into a text field, or
are you taking that information and verifying it against a material
specification? Also, are you required to have a serial number on your
shipping tags? We are currently implementing Vantage and are looking
for a way to use a serial number to track individual baskets of parts
shipped to our customer. The serial number would be a self
populating, unique, sequential number. Thanks for any information in
advance.

Eric


--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> I created one UDTable to hold the Raw Material Lots. In our case
> every line is a new lot so I create a new record for every line. At
> receipt time they put in the Heat and any other info for the lot,
> and it copies that info to the UDTable. We use a report that prints
> tags from the UDtable to use for labeling and scanning.
> When they report production they scan the lot that they are using.
> When they do that it creates a record In a second UD table that is a
> unique record for the manufactured lot/serial whatever you want to
> call it. In our case it is a bundle of items that need to be
> identified as unique. That UD record holds the Job Number the
> quanity and a bunch of other info as well as the lot
> used to create it. When they pack a lot in shipping it goes out to
> the second UDTable and Marks a checkbox and puts in the date it was
> packed. It also puts the packing slip number on the Manufactured
> Lot Record.
> When we print our packing slip using crystal we pull all the heat
> and chemistry info from the UD table by linking the Pack to the Tags
> that shipped. The customer can see every item we shipped with what
> heat/lot was used as well as the mechanical and chemical composition
> of that heat.
>
> All of our programs that deal with inventory make calls to the
> UDtables to update various records or pull data if needed.
17
Right now they are in Numeric fields. Every receipt line is a
new "Lot" basically serial but not exactly. That number is generated
by getting the next number from a UD table & creating a
corresponding UD record. It then takes the numbers that you entered
and pushes them into the UD table. I am working on a verification
that will only allow you to enter if the properties are within
acceptable values.

We are required to have a "Bundle" number on our shipping tags.
Every bundle gets a unique number. Since you are creating baskets
of parts I do not belive that the Vantage serialization will work.
It wants you to give a uniqe number to every unit that is created.
I have a question about your creation of baskets. Do you use MES to
do this or will it be done in the office?
--- In vantage@yahoogroups.com, "Arnulfo Mora" <amora@...> wrote:
>
> Mr. McWilliams,
>
> How are you entering all of the Physical and Chemical properties
into
> Vantage? Are you just dumping the information into a text field,
or
> are you taking that information and verifying it against a material
> specification? Also, are you required to have a serial number on
your
> shipping tags? We are currently implementing Vantage and are
looking
> for a way to use a serial number to track individual baskets of
parts
> shipped to our customer. The serial number would be a self
> populating, unique, sequential number. Thanks for any information
in
> advance.
>
> Eric
>
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > I created one UDTable to hold the Raw Material Lots. In our case
> > every line is a new lot so I create a new record for every
line. At
> > receipt time they put in the Heat and any other info for the
lot,
> > and it copies that info to the UDTable. We use a report that
prints
> > tags from the UDtable to use for labeling and scanning.
> > When they report production they scan the lot that they are
using.
> > When they do that it creates a record In a second UD table that
is a
> > unique record for the manufactured lot/serial whatever you want
to
> > call it. In our case it is a bundle of items that need to be
> > identified as unique. That UD record holds the Job Number the
> > quanity and a bunch of other info as well as the lot
> > used to create it. When they pack a lot in shipping it goes out
to
> > the second UDTable and Marks a checkbox and puts in the date it
was
> > packed. It also puts the packing slip number on the
Manufactured
> > Lot Record.
> > When we print our packing slip using crystal we pull all the
heat
> > and chemistry info from the UD table by linking the Pack to the
Tags
> > that shipped. The customer can see every item we shipped with
what
> > heat/lot was used as well as the mechanical and chemical
composition
> > of that heat.
> >
> > All of our programs that deal with inventory make calls to the
> > UDtables to update various records or pull data if needed.
>
18
What we are currently planning is to use MES to report quantities in
the basket. When the operator finish a basket they will hit report
quantity in MES, print tag, and send it on to the next operation or to
shipping. For ASN's, we are required to have a unique number on each
shipment. With what we can currently tell, we will not be able to put
a unique number on the shipping tag for traceability. This is a
requirement for many automotive companies. This unique number is used
to track back to the exact time, date, steel coil, operator, etc. when
a customer calls in with a concern/rejection. We would use the serial
number for containment of all baskets created under a certain steel
tag number, after a certain number of hits, or any other items that
may be suspect. The unique number is the trigger for all
correspondence with our customer. In essence, we need to serialize
every container (basket), but not every part. If you have any
additional questions, please let me know.

Thanks in Advance,

Eric


--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> Right now they are in Numeric fields. Every receipt line is a
> new "Lot" basically serial but not exactly. That number is generated
> by getting the next number from a UD table & creating a
> corresponding UD record. It then takes the numbers that you entered
> and pushes them into the UD table. I am working on a verification
> that will only allow you to enter if the properties are within
> acceptable values.
>
> We are required to have a "Bundle" number on our shipping tags.
> Every bundle gets a unique number. Since you are creating baskets
> of parts I do not belive that the Vantage serialization will work.
> It wants you to give a uniqe number to every unit that is created.
> I have a question about your creation of baskets. Do you use MES to
> do this or will it be done in the office?
> --- In vantage@yahoogroups.com, "Arnulfo Mora" <amora@> wrote:
> >
> > Mr. McWilliams,
> >
> > How are you entering all of the Physical and Chemical properties
> into
> > Vantage? Are you just dumping the information into a text field,
> or
> > are you taking that information and verifying it against a material
> > specification? Also, are you required to have a serial number on
> your
> > shipping tags? We are currently implementing Vantage and are
> looking
> > for a way to use a serial number to track individual baskets of
> parts
> > shipped to our customer. The serial number would be a self
> > populating, unique, sequential number. Thanks for any information
> in
> > advance.
> >
> > Eric
19
Each labor detail record has a unique number...maybe you can use that
field on the shipment somehow as your traceability.



Something to look at maybe....?????







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Arnulfo Mora
Sent: Tuesday, November 13, 2007 10:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lot Tracking



What we are currently planning is to use MES to report quantities in
the basket. When the operator finish a basket they will hit report
quantity in MES, print tag, and send it on to the next operation or to
shipping. For ASN's, we are required to have a unique number on each
shipment. With what we can currently tell, we will not be able to put
a unique number on the shipping tag for traceability. This is a
requirement for many automotive companies. This unique number is used
to track back to the exact time, date, steel coil, operator, etc. when
a customer calls in with a concern/rejection. We would use the serial
number for containment of all baskets created under a certain steel
tag number, after a certain number of hits, or any other items that
may be suspect. The unique number is the trigger for all
correspondence with our customer. In essence, we need to serialize
every container (basket), but not every part. If you have any
additional questions, please let me know.

Thanks in Advance,

Eric


--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> Right now they are in Numeric fields. Every receipt line is a
> new "Lot" basically serial but not exactly. That number is generated
> by getting the next number from a UD table & creating a
> corresponding UD record. It then takes the numbers that you entered
> and pushes them into the UD table. I am working on a verification
> that will only allow you to enter if the properties are within
> acceptable values.
>
> We are required to have a "Bundle" number on our shipping tags.
> Every bundle gets a unique number. Since you are creating baskets
> of parts I do not belive that the Vantage serialization will work.
> It wants you to give a uniqe number to every unit that is created.
> I have a question about your creation of baskets. Do you use MES to
> do this or will it be done in the office?
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Arnulfo Mora" <amora@> wrote:
> >
> > Mr. McWilliams,
> >
> > How are you entering all of the Physical and Chemical properties
> into
> > Vantage? Are you just dumping the information into a text field,
> or
> > are you taking that information and verifying it against a material
> > specification? Also, are you required to have a serial number on
> your
> > shipping tags? We are currently implementing Vantage and are
> looking
> > for a way to use a serial number to track individual baskets of
> parts
> > shipped to our customer. The serial number would be a self
> > populating, unique, sequential number. Thanks for any information
> in
> > advance.
> >
> > Eric





[Non-text portions of this message have been removed]
20
Hi, I've been thinking about Lot Tracking in Vantage too.

Someone mentioned they use Job Number as lot number, let's say i have
a Job 000090 which runs for a month, during the course of the
production, I've received 2 different lot of the same materials, lot A
56,000 and lot B 44,000.

If I saved the finished good under Lot 000090, and 1 month down the
road the supplier called and said Lot A is problematic, seems like
I'll have to recall the entire batch of 000090?

How would we be able to best handle this then?
I was thinking of using 000090-1, 000090-2, 000090-3 and so on until
the last run.

Of course, there may be a possibility that a part of the job will be
taking in 2 lots of materials, but at least we would've kept it down
to a minimum, instead of recalling the entire batch of 100,000 in job
000090?


--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Each labor detail record has a unique number...maybe you can use that
> field on the shipment somehow as your traceability.
>
>
>
> Something to look at maybe....?????
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> P: 630-806-2000
>
> F: 630-806-2001
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Arnulfo Mora
> Sent: Tuesday, November 13, 2007 10:45 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Lot Tracking
>
>
>
> What we are currently planning is to use MES to report quantities in
> the basket. When the operator finish a basket they will hit report
> quantity in MES, print tag, and send it on to the next operation or to
> shipping. For ASN's, we are required to have a unique number on each
> shipment. With what we can currently tell, we will not be able to put
> a unique number on the shipping tag for traceability. This is a
> requirement for many automotive companies. This unique number is used
> to track back to the exact time, date, steel coil, operator, etc. when
> a customer calls in with a concern/rejection. We would use the serial
> number for containment of all baskets created under a certain steel
> tag number, after a certain number of hits, or any other items that
> may be suspect. The unique number is the trigger for all
> correspondence with our customer. In essence, we need to serialize
> every container (basket), but not every part. If you have any
> additional questions, please let me know.
>
> Thanks in Advance,
>
> Eric
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > Right now they are in Numeric fields. Every receipt line is a
> > new "Lot" basically serial but not exactly. That number is generated
> > by getting the next number from a UD table & creating a
> > corresponding UD record. It then takes the numbers that you entered
> > and pushes them into the UD table. I am working on a verification
> > that will only allow you to enter if the properties are within
> > acceptable values.
> >
> > We are required to have a "Bundle" number on our shipping tags.
> > Every bundle gets a unique number. Since you are creating baskets
> > of parts I do not belive that the Vantage serialization will work.
> > It wants you to give a uniqe number to every unit that is created.
> > I have a question about your creation of baskets. Do you use MES to
> > do this or will it be done in the office?
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Arnulfo Mora" <amora@> wrote:
> > >
> > > Mr. McWilliams,
> > >
> > > How are you entering all of the Physical and Chemical properties
> > into
> > > Vantage? Are you just dumping the information into a text field,
> > or
> > > are you taking that information and verifying it against a material
> > > specification? Also, are you required to have a serial number on
> > your
> > > shipping tags? We are currently implementing Vantage and are
> > looking
> > > for a way to use a serial number to track individual baskets of
> > parts
> > > shipped to our customer. The serial number would be a self
> > > populating, unique, sequential number. Thanks for any information
> > in
> > > advance.
> > >
> > > Eric
>
>
>
>
>
> [Non-text portions of this message have been removed]
>