Do any of you know how to look up items in an inve...
# inventory
t
Do any of you know how to look up items in an inventory adjustment by scanning the UPC / barcode? My warehouse guys work with UPCs and scanning, not with item sku and product names.
j
Can you give a little more detail around what exactly you mean?
t
when we perform inventory adjustments in NetSuite, our warehouse team is much more accustomed to looking up items using their UPC, not their name(itemid), or product title (displayname/description). The item they want to adjust usually has a UPC on its packaging, and UPCs are precise unlike product titles which may have various spellings.
j
Ah, I gotcha. NetSuite does have an Inventory adjustment form, and it does not accept UPC, only accepts item name part numbers.
t
Yep. I'm hoping that I can use UPC as a lookup in addition to those fields. Thanks anyways.
a
No easy/native way to get this done in the standard NetSuite transaction screens. It'd probably involve a customization that consists of a "mapping" custom record (UPC to Item), a custom line level field to hold that custom record, and then a client script to populate the associated item in the native field. If you want to help them find them items on the transaction, and do not have access to a developer, then you could use something like SuiteAnswer 78744. Alternatively, and seemingly not what you are looking for, if you simply want to global search by UPC then you should be able to do that by using a custom item field and enabling the "global search" attribute for that field.
It looks like you can actually implement my first suggestion using a workflow (sublist action group > line action) instead of a client script. So that's another option.
wait.. no, that won't work. It doesn't look like it can trigger line actions on client side events. 🙁
t
Thanks anyway @Automatech