Extended Item Lookup & Bulk Changes

Top  Previous  Next

Go to Stock > Extended Item Lookup

Display your items-, age, days since last sold, stock groups, cost price, price lists etc.

Use this form for global changes across the database.

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

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

Stock AdjustmentFilter In OperationOn Hand WarehouseStock TakeDays Last SoldAverage Cost ExtendedOn OrderReservedUncomiitedSelect VisibleCheckboxRow SelectorAverage Cost PriceAvailableShortageDemandOn HandGroupSummary BarBinSearch RowCreate New ItemOrder ItemView on WebQuick OpenShow Purchase OrderOpen EnquiriesWarehouse LevelsOpen Inventory FormStock GroupFixesSet PricesBulk Price ChangeBulk Change 2Bulk Change SelectedGrid ReportEdit FilterSelect VisibleWarehouse Stock LevelsFiltersExportPrintSelect BetweenShow Web ItemsClear FilterRefreshStock_Extended_Lookup

 

The Extended Lookup form has so many columns that we have broken it up into a few forms. See the rest of the columns below.

Supplier Item CodeSupplier List Price ExtendedMark UpPrice ListSupplier List PriceWeb FeaturedWebOn SaleStock_Extended_Lookup 2

 

Price MethodValuation MethodGroup PricingDiscount ItemTrade InGift VoucherRecipeBOMLabourService ItemNon Stock ItemStock_Extended_Lookup 3

 

Reorder LevelDiscontinuedDate AddedQuick SellSerial Number TrackingSpecialWeightStock NumberAverage SalesBrandStatus WebLot TrackingCommissionConsignmentStock_Extended_Lookup 4

ConditionMinimum Order QuantitySales Set CountItem or Master WebMaster Is WebLinked To Master Items CountMaster Item CodeBest Before DaysIs Web MasterVolume DiscountSell WholeStock_Extended_Lookup 5

 

Columns on the form

Description



Bin

Location of the item in the shop. Set the Bin Location in the Stock Main form

Bin locations are displayed amongst other in the Stock Take, Extended Item Lookup, Invoice Stock Collection Lookup and Job Card Lookup





DLS

Days since last sold.

DLB

Days since last bought.



Last bought.

Date the item was last bought.

Last sold.

Date the item was last sold..



 

Slow Movers - Look for the column "Months of Stock"

Slow movers are also shown in the Dashboard

See also Inventory Statistics

 

Keywords: Bulk Inventory changes,DLB: Days Last Bought,DLS: Days Last Sold,Extended Item Lookup,Global Inventory Changes,Set selected average cost to the suppliers list price.,Slow Movers,Stock Take - Last,Stock Take & Adjustment,Stock Value - Extended Item Lookup,View on Web,Web Items Not Ready - Filters