Lot Tracking and Serial Number Tracking in Vantage 6.10

Just a quick idea Matt.... I don't know how you report Production (Qty-Only, Time-Qty, etc) but, why don't you report quantities completed in batches (number of batches is equal to number of lots), so you would report 50 units (111) for Lot A and then 50 units for Lot B.

Depending at what point you assign Serial Numbers to your Finished Assemblies, you can enter the LOT in a UDF for each batch at Labor entry time.....

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

[cid:image003.jpg@01CB2A5C.A742C5C0]

Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the recipient.



[Non-text portions of this message have been removed]
Could someone offer some advice on how this is suppose to work.

We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
How does vantage track what lot went to what serial number on the job?

If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.


Thank you for any help you can provide.
You need to split the job and then issue the materials each lot to a separate job. This way you have Lot A going to Job XYZ-A and Lot B going to Job XYZ-B

Charlie Smith
Smith Business Services / 2W Technologies LLC
www.vistaconsultant.com/ www.2WTech.com




From: msturm
Sent: Fri 7/23/2010 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Lot Tracking and Serial Number Tracking in Vantage 6.10



Could someone offer some advice on how this is suppose to work.

We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
How does vantage track what lot went to what serial number on the job?

If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.

Thank you for any help you can provide.





[Non-text portions of this message have been removed]
Generally the decision on what lot to use will not be made until the job is released and in the final assembly stage. Splitting the job at that time would be a nightmare for productivity.

If that is the only way to do it, Serial numbering and lot tracking will be worthless to us.

Anyone on E9, how is this handled that version. We might be upgrading in the next 12 months.

Thanks for your help.


--- In vantage@yahoogroups.com, CharlieSmith <CSmith@...> wrote:
>
> You need to split the job and then issue the materials each lot to a separate job. This way you have Lot A going to Job XYZ-A and Lot B going to Job XYZ-B
>
> Charlie Smith
> Smith Business Services / 2W Technologies LLC
> www.vistaconsultant.com/ www.2WTech.com
>
>
>
>
> From: msturm
> Sent: Fri 7/23/2010 9:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Lot Tracking and Serial Number Tracking in Vantage 6.10
>
>
>
> Could someone offer some advice on how this is suppose to work.
>
> We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
> How does vantage track what lot went to what serial number on the job?
>
> If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.
>
> Thank you for any help you can provide.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Never used 6.1, but on 8 4XX, if native lot trace tools are that weak (wouldn't know as we don't want or need lot tracking), I don't see why you couldn't (fairly easily) write a report or dashboard joining jobhead, jobasy, jobmtl to parttran to document what lots were issued & when.

That's all you're trying to do (lot track doc for the job) - right?

Rob

--- Original Message ---
From:"msturm" <msturm@...>
Sent:Fri 7/23/10 11:03 am
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Lot Tracking and Serial Number Tracking in Vantage 6.10

Generally the decision on what lot to use will not be made until the job is released and in the final assembly stage. Splitting the job at that time would be a nightmare for productivity.

If that is the only way to do it, Serial numbering and lot tracking will be worthless to us.

Anyone on E9, how is this handled that version. We might be upgrading in the next 12 months.

Thanks for your help.


--- In vantage@yahoogroups.com, CharlieSmith <CSmith@...> wrote:
>
> You need to split the job and then issue the materials each lot to a separate job. This way you have Lot A going to Job XYZ-A and Lot B going to Job XYZ-B
>
> Charlie Smith
> Smith Business Services / 2W Technologies LLC
> www.vistaconsultant.com/ www.2WTech.com
>
>
>
>
> From: msturm
> Sent: Fri 7/23/2010 9:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Lot Tracking and Serial Number Tracking in Vantage 6.10
>
>
>
> Could someone offer some advice on how this is suppose to work.
>
> We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
> How does vantage track what lot went to what serial number on the job?
>
> If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.
>
> Thank you for any help you can provide.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
We will need traceability of the Lot to the specific Serial Number.

We can currently trace the S/N to the Job and the Lot to the Job (and vice versa) but not a Lot to a specific S/N. If more that one lot is used to complete the job, you don't know what lot went to what S/N. You can only tell that Job 123 used Lots A,B,C.

I agree that job splitting will accomplish this but only indirectly.

Matt

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Never used 6.1, but on 8 4XX, if native lot trace tools are that weak (wouldn't know as we don't want or need lot tracking), I don't see why you couldn't (fairly easily) write a report or dashboard joining jobhead, jobasy, jobmtl to parttran to document what lots were issued & when.
>
> That's all you're trying to do (lot track doc for the job) - right?
>
> Rob
>
> --- Original Message ---
> From:"msturm" <msturm@...>
> Sent:Fri 7/23/10 11:03 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Lot Tracking and Serial Number Tracking in Vantage 6.10
>
> Generally the decision on what lot to use will not be made until the job is released and in the final assembly stage. Splitting the job at that time would be a nightmare for productivity.
>
> If that is the only way to do it, Serial numbering and lot tracking will be worthless to us.
>
> Anyone on E9, how is this handled that version. We might be upgrading in the next 12 months.
>
> Thanks for your help.
>
>
> --- In vantage@yahoogroups.com, CharlieSmith <CSmith@> wrote:
> >
> > You need to split the job and then issue the materials each lot to a separate job. This way you have Lot A going to Job XYZ-A and Lot B going to Job XYZ-B
> >
> > Charlie Smith
> > Smith Business Services / 2W Technologies LLC
> > www.vistaconsultant.com/ www.2WTech.com
> >
> >
> >
> >
> > From: msturm
> > Sent: Fri 7/23/2010 9:38 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Lot Tracking and Serial Number Tracking in Vantage 6.10
> >
> >
> >
> > Could someone offer some advice on how this is suppose to work.
> >
> > We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
> > How does vantage track what lot went to what serial number on the job?
> >
> > If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.
> >
> > Thank you for any help you can provide.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Matt, you are not going to be able to link a specific lot to a specific serial number, you can only view the independent transactions for each. Has not changed in 9.0x either. You can try adding a UD serial number field and writing a BPM to update that field on the lot record, but otherwise there is no table relationship between lot and serial

--- On Fri, 7/23/10, msturm <msturm@...> wrote:


From: msturm <msturm@...>
Subject: [Vantage] Re: Lot Tracking and Serial Number Tracking in Vantage 6.10
To: vantage@yahoogroups.com
Date: Friday, July 23, 2010, 11:34 AM


Â



We will need traceability of the Lot to the specific Serial Number.

We can currently trace the S/N to the Job and the Lot to the Job (and vice versa) but not a Lot to a specific S/N. If more that one lot is used to complete the job, you don't know what lot went to what S/N. You can only tell that Job 123 used Lots A,B,C.

I agree that job splitting will accomplish this but only indirectly.

Matt

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Never used 6.1, but on 8 4XX, if native lot trace tools are that weak (wouldn't know as we don't want or need lot tracking), I don't see why you couldn't (fairly easily) write a report or dashboard joining jobhead, jobasy, jobmtl to parttran to document what lots were issued & when.
>
> That's all you're trying to do (lot track doc for the job) - right?
>
> Rob
>
> --- Original Message ---
> From:"msturm" <msturm@...>
> Sent:Fri 7/23/10 11:03 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Lot Tracking and Serial Number Tracking in Vantage 6.10
>
> Generally the decision on what lot to use will not be made until the job is released and in the final assembly stage. Splitting the job at that time would be a nightmare for productivity.
>
> If that is the only way to do it, Serial numbering and lot tracking will be worthless to us.
>
> Anyone on E9, how is this handled that version. We might be upgrading in the next 12 months.
>
> Thanks for your help.
>
>
> --- In vantage@yahoogroups.com, CharlieSmith <CSmith@> wrote:
> >
> > You need to split the job and then issue the materials each lot to a separate job. This way you have Lot A going to Job XYZ-A and Lot B going to Job XYZ-B
> >
> > Charlie Smith
> > Smith Business Services / 2W Technologies LLC
> > www.vistaconsultant.com/ www.2WTech.com
> >
> >
> >
> >
> > From: msturm
> > Sent: Fri 7/23/2010 9:38 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Lot Tracking and Serial Number Tracking in Vantage 6.10
> >
> >
> >
> > Could someone offer some advice on how this is suppose to work.
> >
> > We have a series of finished assemblies with part numbers(p/n 111) that we serial number. One component of that assembly is lot tracked (p/n 999). When the 999 part is issued to the job we specify the lot to pull from. When the need for a job is larger than one of the lots on hand, we need to pull from more that one lot, naturally.
> > How does vantage track what lot went to what serial number on the job?
> >
> > If the job qty calls for 100 part 111. We have 50 of 999 in lot A and 50 in lot B. Serial numbers start at 1000 and go to 1099. I need to know what lot was used for 1055.
> >
> > Thank you for any help you can provide.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>











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