Consolidate Lot items with the same expiration date into a single lot?
Hello and thanks in advance for reading.
I use NetSuite to sell on Amazon, my new product requires to keep track of the expiration dates and Amazon requires to know as well, when we receive inventory we plan to use Lot Items to keep track of it but before Outbounding to amazon, we would like to consolidate the lots into 1 (we will only do it with items with the same expiration date) because amazon location is virtual and we don’t really need to keep track of lots at this point. Consolidating lots into 1 would make it posible to keep inventory up to date as once the items go to amazon we lose all visiblity and would have to randomly decrease inventory if we had multuple lots at that point.
Is there any way to accomplish this?
Yes, for existing lots you would need to process an inventory adjustment, adjusting out the lots with the same exp. date, and then back in the single consolidated lot.
If the actual inventory (batch/lot) number doesn’t matter to you at any stage, might I suggest you consider receipting these lots with an ‘expiration-based’ number? I.e. all lots expiring in January 2022 are receipted as lot number “Jan2022”, “202201” or similar.
If you do need to know the actual lot number right up until “outbounding to Amazon” you’ll need to go down the inventory adjustments route