If you are using lot number then add the date at the end of the lot number you received the inventory lot number 12345 can become lot number 12345-011526 indica...
They also requested this report to be with customer name... I do not see this as part of the solution... the report requested remains unresolved.... am I missin...
