Hello everyone
I would like to know if it is possible to perform inventory count for items by bin.
Our inventory is arranged by bin and when we count items we count them by bins.
Both Create Inventory count and Enter Inventor Count does not provide the possibility to sort the items by BIN; as we count the items by bin, we need to enter them by bin (enter inv count) or see the list ordered by Bin (create inv count)
As ordering the items by bin does not seem to be possible, we chose the Enter Inventory Count option, beacose we could enter the items in the order of the bin.
But we noticed that when we input the counted items, Lot Information can be entered but there is NO field to enter the Expiry date.As a result if the Lot number of the item counted is different than the one physically found in store, NetSuite adjusts the stock and there is no Expiry Date information recorded for the item with this Lot number.
I created a case for the Expiry date information being blank for the items adjusted by Stock take and I was told this is a limitation.
My Big question is now, how could we have proceeded so that we could have our items sorted by bin, and for the adjusted stock, how could we have kept the Expiry date.
It does does not seem normal that when NetSutie adjusts the stock for Lot Controlled item, it does not request the Expirate Date, and what is worst, and at least as it is not requesting the Expiry Date info, it should have pulled the expiry date from the existing Lot Number and used it for the new Lot Number of the item(better than it being blank)
Any ideas, suggestions are welcomed as this is a big issue for us and we will need to perform a stock take this year again
Thanks in advance
Best regards