Shortcut to making your inventory only have the active items you use

Shortcut to making your inventory only have the active items you use

Step 1 Go to Inventory and browse all your inventory


Step 2 make sure that the Active Item field is in your column headings 

If the Active Item is not listed, Right click on the column headings and choose field chooser to then drag the active item to your column headings 


Step 3 Go To Functions menu and Export choose xls as the export
Make sure you know where you save the file and then open the file in Excel

You can then change the active item to false in Excel for items you no longer want to put on invoices,
This will not clear your commits but going forward you won't have all those items you no longer carry or are old model/makes that are not needed 

The last step to update is to tools data import into TSS and choose your updated Excel file with the false on any items you no longer need and that will allow you to have easier way to create accurate invoices.  

The other thing you can is to do a physical count adjustment for those items and make them zero for all the old unnecessary items 



    • Related Articles

    • Removing inventory items

      If needed to remove large amounts of inventory that were added possibly in error the physical count adjustment is a useful function to accomplish that task. The physical count adjustment can be found from the Functions menu once in Inventory or in ...
    • How do I add inventory in TSS XP and definition of fields in inventory items

      To add a new inventory item in TSS go to the inventory section and then click New. Make and Model: These are required fields and must be a unique combination to identify this item in the system. TSS also reserves specific makes for non-standard ...
    • Inventory Overview choices for inventory management

      TSS PLUS How do I keep track of inventory that is on demo display. Keeping track of inventory that you have on demo in a store display is as easy as writing an invoice. Invoicing quantities are unlimited and since invoices 'commit' inventory, the ...
    • Special Order Items Demo

      When using the Special Order items feature it is usually best to force serial number for better tracking (although not required). Be sure the item has no inventory on-hand Create a new invoice, add the item to the Materials tab and Save the Invoice ...
    • How do I handle selling Items that are not in stock?

      There are multiple ways to handle putting items that are not in stock on an invoice, use the method that suits your business the best. Option 1: Restrict sales to available inventory items only If you turn on the option in application settings to ...