Turn Off Lot Tracking For All Parts

Yahoo Archive
1
I avoid messing with the raw data at all costs, but sometimes it is necessary. In your case, I would do it the hard way and not mess with trying to do it through the back door. Too many things could go wrong. If you do decide to go this route, do it on a test database and test it thoroughly to make sure nothing has been corrupted.




________________________________
From: adam.whipp <adam.whipp@...>
To: vantage@yahoogroups.com
Sent: Mon, January 25, 2010 5:36:36 PM
Subject: [Vantage] Re: Turn Off Lot Tracking For All Parts

Â
It might help to know that we are on 8.03.408B progress database. Thanks!!

--- In vantage@yahoogroups .com, "adam.whipp" <adam.whipp@ ...> wrote:
>
> We are considering backflushing all materials to all jobs. Currently we track lots for most materials. Obviously we have to turn that off if we want to backflush those materials. It is a tedious process to qty adjust out, uncheck the box, and qty adjust in. Is there any better way to "mass" turn off lot tracking?
>
> I can get at the raw data to write a query to uncheck that box from the Part table as well as update the PartBin.LotNum to be an empty string. I think I also would need to update the corresponding PartLot table records to show none on hand. However, I don't know the implications of this, and I don't feel very good about it. What are everyone's thoughts about going at it in this fashion? Thanks in advance!
>
> -Adam
>







[Non-text portions of this message have been removed]
2
We are considering backflushing all materials to all jobs. Currently we track lots for most materials. Obviously we have to turn that off if we want to backflush those materials. It is a tedious process to qty adjust out, uncheck the box, and qty adjust in. Is there any better way to "mass" turn off lot tracking?

I can get at the raw data to write a query to uncheck that box from the Part table as well as update the PartBin.LotNum to be an empty string. I think I also would need to update the corresponding PartLot table records to show none on hand. However, I don't know the implications of this, and I don't feel very good about it. What are everyone's thoughts about going at it in this fashion? Thanks in advance!

-Adam
3
It might help to know that we are on 8.03.408B progress database. Thanks!!

--- In vantage@yahoogroups.com, "adam.whipp" <adam.whipp@...> wrote:
>
> We are considering backflushing all materials to all jobs. Currently we track lots for most materials. Obviously we have to turn that off if we want to backflush those materials. It is a tedious process to qty adjust out, uncheck the box, and qty adjust in. Is there any better way to "mass" turn off lot tracking?
>
> I can get at the raw data to write a query to uncheck that box from the Part table as well as update the PartBin.LotNum to be an empty string. I think I also would need to update the corresponding PartLot table records to show none on hand. However, I don't know the implications of this, and I don't feel very good about it. What are everyone's thoughts about going at it in this fashion? Thanks in advance!
>
> -Adam
>