Below are some notes I have from April 22, 1999. I was 11 years old at the time. It looks like some of this requires Crystal reports for tracing.
Lot Number Tracking Using Bill of Materials1. Determine the BOM Production Entry number of the affected lot. Create a Crystal report to prompt the user for the vendor lot number to obtain the production entry number. This will be used to find the parent bill and corresponding finished good lot number. 2. Create a Crystal report to get the lot number of the components used by prompting for the production entry number obtained in step 1. The result will display the bill# and lot number assigned. 3. Obtain the invoice number for the affected lot numbers that were sold. Using the finished good lot number obtained in step 2 run a Crystal report to find the invoice # using the finished good lot number.
Lot Number tracking from the Customer to the VendorBegin with the finished good lot number. Obtain the vendor lot number by printing the bill of materials, production history report. A custom report can be used to obtain the vendor lot number by entering the finished good lot number. The production histpry report will display the component raw material lot number that was assigned to the vendor. The purchase order receipt history report can be used to track from the raw material lot number to the vendor name.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------