Inventory Find - by other field data

Interprise Suite Community

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Inventory Find - by other field data

Rate Topic

Display Mode

Topic Options

Message

Posted 8/20/2009 12:55:08 PM

Post #243

ise_user

Lets say you want to find a stock item by a fields contents other than Item Name or Description how do you set this up?

i.e. 4.1.1. Inventory Item Find....Enter search criteria...Hoping it searchs the commodity code contents.

Even if you add the Commodity Code to the data dictionary as a searchable field - it is still not searched.

What am I missing - I know this i9s suppose to be easy to do.

Cheers

Posted 8/20/2009 1:58:44 PM

Post #244

NAYLARD

Check to see if the field is searchable and 'on list' in the InventoryItemView.

Posted 8/21/2009 2:05:54 AM

Post #247

ise_user

Hi

Thanks for your input.

I had tried that already i.e.
In Data Dictionary...Views...System Views....InventoryItemView
Commodity: Check Searchable, Check Show On List

The records - do not show up on 4.1.1. or items list when entering an Invoice item line.

Cheers,

Posted 8/21/2009 7:06:55 AM

Post #248

NAYLARD

For the item list when entering invoices, that is controlled by the saleitemview.

For finding items in inventory, I believe that is controlled by the inventoryitemmenuview.

I will check on both though.

Posted 8/21/2009 7:20:01 AM

Post #249

ise_user

Spot on - you are a star Smile

Now I should be able to figure out how to scan in bar codes into a sales Invoice (for a simple EPOS). Looks like a join to the table holding the UPC data.

Many thanks for your assistance on this.

« Prev Topic | Next Topic »