Serial Number problem
i encounter a problem about serial number. In the same plant, the processing is below:
1> when the finished product is receipted and move to the finished stock, we assign a serial number to each one.
2> then we move the product based on serial number from finished stock to sales stock.
3> finally we sell the product based on the serial number from sales stock.
now how can i get the current plant and storage location by the serial number and how can i know if the product related to the serial number is sold or not?
please share your expert idea. thank you in advance.