Stock (Inventory) Lookup

Top  Previous  Next

Go to Stock Items > Item Lookup

Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

HelpSecurity SetupTabsUnlock MonitorQuick AddCalendardashboardCompanyEmployeeQuoteWorkshopSupplierCustomerLedgerInvoiceFileRTS LookupGoods ReceivingGRN LookupPO LookupNew RTSNew POPurchase PlanningExtraStock GroupsStock TakeStock AdjustmentsStock OptionsStock TurnoverItem LookupExtended Item LookupStock DetailNew ItemStock Main Menu

    Arrow_Blue

Item Lookup

The Item Lookup table allows you to quickly find items using various search criteria. It also displays useful information such as: In Stock quantities, Order quantities, Margins. By right-clicking on the item the context menu will open and you can perform certain functions like editing the item.

Please note that if you hover your mouse over certain parts of the form below, the cursor (Cursor) will change to a hand (Hand). Click to get specific help on that part of the form.

Reorder LevelShortfallOn OrderReservedInstockAvailableCheckboxETAOrder ItemQuick OpenShow Purchase OrderOpen EnquiriesWarehouse LevelsCreate NewOpen InventoryDemandUnitMain Unit OnlyWarehouseStock GroupsSummary BarSearch RowFliter by GroupSelect BetweenEdit FilterGrid ReportPrintMPLUAdd StockClearRefreshStock_Item_Lookup

 

How to Use the Item Lookup Table

Search: Use the blue filter boxes under each column heading for quick filtering, or use the Edit Filter for more advanced search options.

Right-click: Opens a context menu where you can perform actions like editing the selected item.

Double-click: To edit an item, double-click on the item in the coloured column.

 

Additional Features

Colour Codes:

The background colour of rows helps you identify item types at a glance (see image below):

Trade-In

Special Active

Discount Item

BOM (Bill of Materials)

etc.

 

Colour_Codes

 

Grid Reports:

To generate a custom report from the lookup table, see Grid Reports.

Export or Print:

To print or export data from the lookup table, [click here].

Security Settings:

Go to Application > Security Setup to configure user permissions for this form.

Related Help:

For more details on using lookup forms, see: How To Use Lookup Forms.

 

Keywords: Colour Codes,Copy to Clipboard,Item Lookup,Main Unit Only,MPLU Lookup,Selling Prices - Item Lookup