<< Click to Display Table of Contents >> Navigation:  Inventory / Parts List > BrowseParts

This is your inventory table for parts. You can lookup these parts later to add to a work order. Whether or not you care to track the inventory, this makes it much more convenient to add frequently used parts to work orders.

 

 

As most tables, you simply click on the Tab at the top to lookup the items in that particular order. For some lookups, you will need to select a category or vendor. After that you can type in the part#, or description (depending on how you are looking it up). Simply start typing and the program will help you find the item as you type.

 

Click on Add to Add, Change to Change, and Delete to delete the part. We don't recommend deleting parts as there may be reports you can get later.

 

 

Notice at the bottom of the inventory screen on the right there are two tabs. This is so we don't have too much clutter on the screen. Whichever tab you select it will be remembered the next time you come into this screen.

 

 

This button allows you to directly receive and update the highlighted part.

 

You can type in the quantity and the cost. If there is a stored markup, the program will automatically update the Retail price from the cost. If there is no stored markup, you will be allowed to type in the new retail price. There is no history stored this way. If you want parts receiving history, use the Purchase Order system.

 

This button clones the highlighted inventory item. The new item will have an asterisk (*) in front of the part number which puts it at the top of the parts list, and also prevents duplicate part numbers (which are not allowed).

 

This exports the highlighted record to a CSV (Comma Separated Values) file so you can further import it or use it in your own personal barcode printing software that comes with your barcode printer. The fields that are exported are Part#, Description, UPC, and Retail. The file is named invent.csv and should be in the wrench folder.

 

This isn't really a button, but a toggle switch. If it is on (depressed), then when you add inventory items, the part will save to the Inventory Utility list, so you may then print out barcodes, export all selected to a CSV file so you can use them in your own barcode printing program. If you are to use this, you should NOT say YES when the program asks if you want to add another (at this time).

 

Clicking on this button takes you to the Parts History Graph.

 

This takes you to the Cross Reference table so you can look up alternate part numbers.

HX is the Huggins query if you subscribe to the Huggins Cross Reference. This is usually used for Marine Repair Shops.

 

This lets you use the SendTo Function to create reports and files for the current browse. Remember you can right click on the browse screen and use List Formats to change the order of the fields, and what fields display.

 

 

Query lets you create a custom query for your parts. You can base it on any fields in the parts. Here are some sample queries:

 

You can copy the below queries and enter them in manual mode...

 

Items that are low in stock:

LSTP:mininstock > 0 AND LSTP:QTY < LSTP:mininstock

 

Items that are low in stock and consider items that are currently on order.

LSTP:mininstock > 0 AND LSTP:QTY + LSTP:onorder < LSTP:mininstock