Hi community,
My client is a beauty product manufacturer and would like to have their oldest lots used in the manufacturing process. The FEFO module works for the Sales orders, but, is there a way to do that on the workorder or the assemblies? I was thinking changing the costing to FIFO, but I still run into the issue that 1. that is not the costing method that they would like to use and 2. that they need the lots assigned by oldest no matter what as things expire, but it is a nightmare to try to find the oldest purchased as they have to add the inventory detail every time they used certain products on the line. I would like to make it automatic if possible -reducing human error by having the system pick the lot number and add it to the inventory detail automatically if possible.-.
Any help or guidance would be greatly appreciated.
Thank you very much!