https://netsuiteprofessionals.com logo
j

J-Mack

03/29/2022, 5:27 PM
Is it possible to use a CSV to update Lot Number Records? Need to update Expiration Dates.
j

James Morris

03/30/2022, 1:30 PM
@J-Mack Yep. If you do an inventory adjustment, you should be able to hit the expiration date. Although maybe you have to do one location at a time if you have bins and this article is still valid? "CSV Import > Inventory Adjustment for Lot Numbered Items for Multiple Location" SuiteAnswer Id: 72167. This is a good (if old) article too "Inventory Adjustment Import" SuiteAnswer Id: 51417
j

J-Mack

03/30/2022, 1:31 PM
Gotcha. I wish there were a more direct way to reaching them, but I'll see how this works!
j

James Morris

03/30/2022, 1:35 PM
Yeah, it sorta makes sense that stuff that lives in the inventory detail is only adjustable through transactions affecting the inventory detail though. If people would just stop screwing up inventory we wouldn't need a more powerful magic wand to clean it up 😁
j

J-Mack

03/30/2022, 1:35 PM
Well, in this case, the initial uploads were done a few months ago and they put very short expiration dates on items that can't expire. XD So yeah!
2 Views